Sponsored Products
Campaign
Table name - ad_sponsoredproducts_campaign
For details on data availability and refresh schedule, please click here.
profile_id
Integer
The identifier of the amazon advertising account
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
campaignid
Integer
The identifier of the campaign
name
String
The name of the campaign
portfolioid
Integer
The identifier of an existing portfolio to which the campaign is associated.
targetingtype
String
The type of targeting of the campaign. manual or auto
state
String
The current campaign state
dailybudget
Numeric
Daily budget set for the campaign
startdate
date
The starting date of the campaign. The format of the date is YYYY-MM-DD.
enddate
date
The ending date of the campaign to stop running. The format of the date is YYYY-MM-DD.
creationdate
Date time
The creation date of the campaign. The format of the date time is YYYY-MM-DD hh:mm:ss.
lastupdateddate
Date time
The date that any value associated with the campaign was last changed. The format of the date time is YYYY-MM-DD hh:mm:ss
servingstatus
String
Serving status of the campaign
CAMPAIGN_PAUSED
CAMPAIGN_ARCHIVED
CAMPAIGN_STATUS_ENABLED,
ADVERTISER_PAYMENT_FAILED,
ADVERTISER_PAYMENT_FAILURE,
CAMPAIGN_OUT_OF_BUDGET,
PENDING_START_DATE, CAMPAIGN_INCOMPLETE, ENDED
biddingstrategy
String
Bidding strategy
autoForSales -> Dynamic bids - up and down
legacyForSales -> Dynamic bids - down only
manual -> Fixed bid
biddingplacamenttopofsearchpercentage
Numeric
The bid adjustment percentage value for Top of search
biddingplacamentproductpagepercentage
Numeric
The bid adjustment percentage value for product details page.
Campaign Report
Table name - ad_sponsoredproducts_campaign_report
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
reportdate
date
Report date
campaignid
integer
Campaign id
campaignname
string
Campaign name
campaignstatus
string
Campaign status
campaignbudget
numeric
Campaign budget
impressions
integer
Total ad impressions
clicks
integer
Total ad clicks
cost
numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC.
attributedsales14dsamesku
numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
integer
Number of attributed units ordered within 14 days of click on ad
topofsearchimpressionshare
integer
Percentage Share of top of search impressions
Campaign Negative Keywords
Table name: ad_sponsoredproducts_campaignnegativekeyword
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
keywordid
integer
The identifier of the campaign negative keyword
campaignid
integer
The identifer of the campaign to which the campaign negative keyword is associated
state
string
The campaign negative keyword state
keywordtext
string
The text of the expression to match against a search query
matchtype
string
The type of match. ex: negativeExact, negativePhrase
creationdate
timestamptz(0)
target created date
lastupdateddate
timestamptz(0)
target last updated date
servingstatus
string
The serving status of the campaign negative keyword. TARGETING_CLAUSE_STATUS_LIVE, PENDING_START_DATE
AdGroup
Table name: ad_sponsoredproducts_adgroup
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
adgroupid
integer
The identifier of the adgroup
name
string
The name of the adgroup
campaignid
integer
The identifier of the campaign.
defaultbid
numeric
Default bid set for the adgroup
state
string
The current state of the adgroup
creationdate
timestamptz(0)
The creation date of the adgroup. The format of the date time is YYYY-MM-DD hh:mm:ss.
lastupdateddate
timestamptz(0)
The date that any value associated with the adgroup was last changed. The format of the date time is YYYY-MM-DD hh:mm:ss
servingstatus
string
Serving status of the adgroup.
AD_GROUP_ARCHIVED
AD_GROUP_PAUSED
AD_GROUP_STATUS_ENABLED
AD_POLICING_SUSPENDED
AD_GROUP_INCOMPLETE
CAMPAIGN_OUT_OF_BUDGET
CAMPAIGN_PAUSED
CAMPAIGN_ARCHIVED
CAMPAIGN_INCOMPLETE
ACCOUNT_OUT_OF_BUDGET
PENDING_START_DATE
AdGroup Report
Table name: ad_sponsoredproducts_adgroup_report
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
reportdate
date
Report date
adgroupid
integer
The identifier of the adgroup
adgroupname
string
The name of the adgroup
campaignid
integer
The identifier of the campaign
campaignname
string
The name of the campaign.
impressions
integer
Total ad impressions
clicks
integer
Total ad clicks
cost
numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
integer
Number of attributed units ordered within 14 days of click on ad
Advertised Products
Table name: ad_sponsoredproducts_productad
For details on data availability and refresh schedule, please click here.
profile_id
integer
Amazon advertising account id
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
adid
integer
The identifier of the advertised product
adgroupid
integer
The identifier of the adgroup
campaignid
integer
The identifier of the campaign
asin
string
The ASIN that is being advertised.
sku
string
The SKU that is being advertised. Not available for vendors.
state
string
ASIN state
creationdate
timestamptz(0)
ASIN created date
lastupdateddate
timestamptz(0)
ASIN last updated date
servingstatus
string
Serving status of the Advertised Product
AD_ARCHIVED
AD_PAUSED
AD_STATUS_LIVE
AD_POLICING_SUSPENDED
CAMPAIGN_OUT_OF_BUDGET
AD_GROUP_PAUSED
AD_GROUP_ARCHIVED
CAMPAIGN_PAUSED
CAMPAIGN_ARCHIVED
ACCOUNT_OUT_OF_BUDGET
MISSING_DECORATION, PENDING_START_DATE
Advertised Product Report
Table name: ad_sponsoredproducts_productad_report
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
report_date
date
Report date
adid
integer
The identifier of the advertised product
adgroupid
integer
The identifier of the adgroup
impressions
integer
Total ad impressions
clicks
integer
Total ad clicks
cost
numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
integer
Number of attributed units ordered within 14 days of click on ad
Keyword
Table name: ad_sponsoredproducts_keyword
For details on data availability and refresh schedule, please click here.
profile_id
integer
The identifier of the amazon advertising account
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
keywordid
integer
The identifier of the advertised keyword text
adgroupid
integer
The identifier of the adgroup
campaignid
integer
The identifier of the campaign
state
string
The current status of the keyword text
keywordtext
string
The text of the expression to match against a search query
matchtype
string
The type of match. ex: exact, phrase and broad
bid
numeric
User-set bid value for keyword
creationdate
Date time
Keyword created date
lastupdateddate
Date time
Keyword last updated date
servingstatus
string
The serving status of the keyword.
TARGETING_CLAUSE_ARCHIVED
TARGETING_CLAUSE_PAUSED
TARGETING_CLAUSE_STATUS_LIVE
TARGETING_CLAUSE_POLICING_SUSPENDED
CAMPAIGN_OUT_OF_BUDGET
AD_GROUP_PAUSED
AD_GROUP_ARCHIVED
CAMPAIGN_PAUSED
CAMPAIGN_ARCHIVED
ACCOUNT_OUT_OF_BUDGET
PENDING_START_DATE
Keyword Report
Table name: ad_sponsoredproducts_keyword_report
For details on data availability and refresh schedule, please click here.
region
char
profile_id
integer
Amazon advertising account id
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
report_id
string
Report id
report_date
date
Report date
keywordid
integer
Keyword id
adgroupid
integer
Adgroup id
impressions
integer
Total ad impressions
clicks
integer
Total ad clicks
cost
numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
integer
Number of attributed units ordered within 14 days of click on ad
topofsearchimpressionshare
Numeric
The percentage of top-of-search impressions earned out of all the top-of-search impressions that were eligible for a given date range. Various factors determine the eligibility for an impression including campaign status and targeting status
Negative Keyword
Table name: ad_sponsoredproducts_negativekeyword
For details on data availability and refresh schedule, please click here.
profile_id
integer
Amazon advertising account id
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
keywordid
integer
Keyword id
campaignid
integer
Campaign id
adgroupid
integer
Adgroup id
state
string
Negative keyword status
keywordtext
string
The text of the expression to match against a search query
matchtype
string
The type of match. ex: negativeExact, negativePhrase
creationdate
timestamptz(0)
Negative keyword created date
lastupdateddate
timestamptz(0)
Negative keyword last updated date
servingstatus
string
Serving status of the negative keyword TARGETING_CLAUSE_ARCHIVED, TARGETING_CLAUSE_PAUSED, TARGETING_CLAUSE_STATUS_LIVE, TARGETING_CLAUSE_POLICING_SUSPENDED, CAMPAIGN_OUT_OF_BUDGET, AD_GROUP_PAUSED, AD_GROUP_ARCHIVED, CAMPAIGN_PAUSED, CAMPAIGN_ARCHIVED, ACCOUNT_OUT_OF_BUDGET, PENDING_START_DATE
Product and Auto Target
Table name: ad_sponsoredproducts_target
For details on data availability and refresh schedule, please click here.
profile_id
integer
Amazon advertising account id
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
targetid
integer
Target id
adgroupid
integer
Adgroup id
campaignid
integer
Campaign id
expressiontype
string
state
string
Product target state
bid
numeric
creationdate
timestamptz(0)
Product target created date
lastupdateddate
timestamptz(0)
Product target last updated date
autoexpressionvalue
string
asinpricelessthan
numeric
Target a price that is less than the price expressed
asinpricegreaterthan
numeric
Target a price that is greater than the price expressed
asinreviewratinglessthan
numeric
Target a review rating less than the review rating that is expressed
asinreviewratinggreaterthan
numeric
Target a review rating that is greater than the review rating expressed
asincategorysameas
string
Negatively Target the same category as the category expressed
asinbrandsameas
string
Target the brand that is the same as the brand expressed
asinpricebetween
string
Target a price that is between the prices expressed
asinreviewratingbetween
string
Target a review rating that is between the review ratings expressed
asinsameas
string
Target an ASIN that is the same as the ASIN expressed
asinisprimeshippingeligible
string
Target products that are Prime Shipping Eligible. This refinement can be applied at a category or brand level only
asinagerangesameas
string
Target an age range that is in the expressed range. This refinement can be applied for toys and games categories only
asingenresameas
string
Target products related to the expressed genre. This refinement can be applied for Books and eBooks categories only
servingstatus
string
The status of the target. TARGETING_CLAUSE_ARCHIVED, TARGETING_CLAUSE_PAUSED, TARGETING_CLAUSE_STATUS_LIVE, TARGETING_CLAUSE_POLICING_SUSPENDED, CAMPAIGN_OUT_OF_BUDGET, AD_GROUP_PAUSED, AD_GROUP_ARCHIVED, CAMPAIGN_PAUSED, CAMPAIGN_ARCHIVED, ACCOUNT_OUT_OF_BUDGET, PENDING_START_DATE
Product and Auto Target Report
Table name: ad_sponsoredproducts_target_report
For details on data availability and refresh schedule, please click here.
profile_id
Integer
Amazon advertising account id
account_id
Snteger
Intentwise account id
account_name
String
Intentwise account name
reportdate
Date
Report date
targetid
Integer
Target id
impressions
Integer
Total ad impressions
clicks
Integer
Total ad clicks
cost
Numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
Numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
Numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
Integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
Integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
Integer
Number of attributed units ordered within 14 days of click on ad
viewimpressions
Integer
Total number of ad viewable impressions
viewattributedconversions14d
Integer
Total number of attributed conversion events occurring within 14 days of ad click or view
viewattributedsales14d
Numeric
Total number of attributed sales occurring within 14 days of ad click or view
viewattributedunitsordered14d
Integer
Total number of attributed units ordered occurring within 14 days of ad click or view
Sponsored Products Auto Search Terms Report
Table Name: ad_sponsoredproducts_autosearchterm_report
For details on data availability and refresh schedule, please click here.
profile_id
Integer
Amazon advertising account id
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
targetid
Integer
Target id
targetexpression
String
Target Expression
campaignid
Integer
The identifier of the campaign
adgroupid
Integer
The identifier of the adgroup
reportdate
Date
Report date
query
String
Query
impressions
Integer
Total ad impressions
clicks
Integer
Total ad clicks
cost
Numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
Numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
Numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
Integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
Integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
Integer
Number of attributed units ordered within 14 days of click on ad
Sponsored Product Keyword Search Term Report
Table Name: ad_sponsoredproducts_keywordsearchterm_report
For details on data availability and refresh schedule, please click here.
profile_id
Integer
Amazon advertising account id
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
keywordid
Integer
The identifier of the advertised keyword text
keywordtext
String
The text of the expression to match against a search query
matchtype
String
The type of match. ex: exact, phrase and broad
campaignid
Integer
The identifier of the campaign
adgroupid
Integer
The identifier of the adgroup
reportdate
Date
Report date
query
String
Query
impressions
Integer
Total ad impressions
clicks
Integer
Total ad clicks
cost
Numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
Numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
Numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
Integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
Integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
Integer
Number of attributed units ordered within 14 days of click on ad
Sponsored Product - Product Target Search Term Report
Table Name: ad_sponsoredproducts_producttargetsearchterm_report
For details on data availability and refresh schedule, please click here.
profile_id
Integer
Amazon advertising account id
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
targetid
Integer
Target id
targetexpression
String
Target Expression
campaignid
Integer
The identifier of the campaign
adgroupid
Integer
The identifier of the adgroup
reportdate
Date
Report date
query
String
Query
impressions
Integer
Total ad impressions
clicks
Integer
Total ad clicks
cost
Numeric
Total cost of all clicks. Can be divided by clicks to obtain average CPC
attributedsales14dsamesku
Numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
Numeric
Number of attributed sales occurring within 14 days of click on ad
attributedconversions14dsamesku
Integer
Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
Integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedunitsordered14d
Integer
Number of attributed units ordered within 14 days of click on ad
Sponsored Products Campaign Placement Report
Table Name: ad_sponsoredproducts_campaignplacement_report
For details on data availability and refresh schedule, please click here.
profile_id
Integer
Amazon advertising account id
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
reportdate
Date
Report date
campaignid
Integer
The identifier of the campaign
impressions
Integer
Total ad impressions
clicks
Integer
Total ad clicks
cost
Numeric
Advertising spend
attributedconversions14dsamesku
Integer
conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14d
Integer
Number of attributed conversion events occurring within 14 days of click on ad
attributedsales14dsamesku
Numeric
Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14d
Numeric
Number of attributed sales occurring within 14 days of click on ad
attributedunitsordered14d
Integer
Number of attributed units ordered within 14 days of click on ad
bidplus
Boolean
true or false based on whether premium bid adjustments are enabled for a Sponsored
placement
String
The page location where an ad appeared.
attributedkindleeditionnormalizedpagesread14d
Integer
Number of attributed Kindle edition normalized pages read within 14 days of ad click.
attributedkindleeditionnormalizedpagesroyalties14d
Numeric
The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days
Last updated
Was this helpful?