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
newtobranddetailpageviewclicks
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.
newtobranddetailpageviewrate
Numeric
Calculated by dividing newToBrandDetailPageViews / impressions.
newtobranddetailpageviews
Integer
The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad.
newtobranddetailpageviewviews
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad view
newtobrandecpdetailpageview
Numeric
Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.
attributedordersnewtobrand14d
Integer
The number of first-time orders for products within the brand over a one-year lookback window. Not available for search term report
attributedsalesnewtobrand14d
Numeric
The total sales of new-to-brand orders. Not available for search term report
attributedunitsorderednewtobrand14d
Integer
Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
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
newtobranddetailpageviewclicks
Integer
newtobranddetailpageviewrate
Numeric
newtobranddetailpageviews
Integer
newtobranddetailpageviewviews
Integer
newtobrandecpdetailpageview
Numeric
attributedorderratenewtobrand14d
Integer
attributedordersnewtobrand14d
Integer
attributedsalesnewtobrand14d
Integer
attributedunitsorderednewtobrandpercentage14d
Numeric
attributedunitsorderednewtobrand14d
Integer
attributedordersnewtobrandpercentage14d
Numeric
attributedsalesnewtobrandpercentage14d
Numeric
Advertised Products
Table name: ad_sponsoredproducts_productads
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_productads_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
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
newtobranddetailpageviewclicks
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.
newtobranddetailpageviewrate
Numeric
Calculated by dividing newToBrandDetailPageViews / impressions.
newtobranddetailpageviews
Integer
The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad.
newtobranddetailpageviewviews
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad view
newtobrandecpdetailpageview
Numeric
Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.
attributedordersnewtobrand14d
Integer
The number of first-time orders for products within the brand over a one-year lookback window. Not available for search term report
attributedsalesnewtobrand14d
Numeric
The total sales of new-to-brand orders. Not available for search term report
attributedunitsorderednewtobrand14d
Integer
Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
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
reportdate
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
newtobranddetailpageviewclicks
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.
newtobranddetailpageviewrate
Numeric
Calculated by dividing newToBrandDetailPageViews / impressions.
newtobranddetailpageviews
Integer
The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad.
newtobranddetailpageviewviews
Integer
Number of new-to-brand detail page views for all the brands' products, attributed to an ad view
newtobrandecpdetailpageview
Numeric
Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.
attributedordersnewtobrand14d
Integer
The number of first-time orders for products within the brand over a one-year lookback window. Not available for search term report
attributedsalesnewtobrand14d
Numeric
The total sales of new-to-brand orders. Not available for search term report
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
clickthroughrate
Numeric
Clicks divided by impressions
impressions_b2b
Integer
Total ad impressions (Brand To Brand)
clicks_b2b
Integer
Total ad clicks (Brand To Brand)
cost_b2b
Numeric
Advertising spend (Brand To Brand)
attributedconversions14dsamesku_b2b
Integer
conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised (Brand To Brand)
attributedconversions14d_b2b
Integer
Number of attributed conversion events occurring within 14 days of click on ad (Brand To Brand)
attributedsales14dsamesku_b2b
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 (Brand To Brand)
attributedsales14d_b2b
Numeric
Number of attributed sales occurring within 14 days of click on ad (Brand To Brand)
attributedunitsordered14d_b2b
Integer
Number of attributed units ordered within 14 days of click on ad (Brand To Brand)
bidplus_b2b
Boolean
true or false based on whether premium bid adjustments are enabled for a Sponsored (Brand To Brand)
attributedkindleeditionnormalizedpagesread14d_b2b
Integer
Number of attributed Kindle edition normalized pages read within 14 days of ad click (Brand To Brand)
attributedkindleeditionnormalizedpagesroyalties14d_b2b
Numeric
The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days (Brand To Brand)
clickthroughrate_b2b
Numeric
Clicks divided by impressions (Brand To Brand)
Sponsored Products Ad Purchased Product Report
Table Name: ad_purchased_product_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
region
String
Region
reportdate
Date
Report Date
recordtype
String
Record Type
campaigntype
String
Campaign Type
download_date
Date
Download Date
adgroupid
Integer
Unique numerical ID of the ad group
addtolist
Integer
Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products
addtolistfromclicks
Integer
Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click
addtolistfromviews
Integer
Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view
advertisedasin
String
The ASIN associated to an advertised product
advertisedsku
String
The SKU being advertised. Not available for vendors
asinbrandhalo
String
Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised.
attributiontype
String
Describes whether a purchase is attributed to a promoted product or brand-halo effect
campaignid
Integer
The ID associated with a campaign
conversionsbrandhalo
Integer
For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised
conversionsbrandhaloclicks
Integer
For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
keywordid
Integer
ID associated with a keyword or targeting expression.
keywordtype
String
Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For Sponsored Products reports, keywordType can also contain the type of targeting expressions, one of: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED
kindleeditionnormalizedpagesread14d
Integer
Number of attributed Kindle edition normalized pages read within 14 days of ad click.
kindleeditionnormalizedpagesroyalties14d
Numeric
The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.
matchtype
String
Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For Sponsored Products reports, keywordType can also contain the type of targeting expressions, one of: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED
newtobrandpurchases14d
Integer
The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.
newtobrandpurchasespercentage14d
Numeric
The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.
newtobrandsales14d
Numeric
Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
newtobrandsalespercentage14d
Numeric
Percentage of total sales made up of new-to-brand purchases within 14 days of an ad click. Not available for book vendors. Same as newToBrandSalesPercentage.
newtobrandunitssold14d
Integer
Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors.
newtobrandunitssoldpercentage14d
Numeric
Percentage of total attributed units ordered within 14 days of an ad click that are part of a new-to-brand purchase. Not available for book vendors. Same as newToBrandUnitsSoldPercentage.
orders14d
Integer
Number of orders within the last 14 days. Includes orders attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns.
ordersclicks14d
Integer
Number of orders within the last 14 days attributed to ad clicks.
portfolioid
Integer
The portfolio the campaign is associated with
productcategory
String
The category the product is associated with on Amazon.
promotedasin
String
The ASIN associated to an advertised product.
promotedsku
String
The SKU being advertised. Not available for vendors.
purchasedasin
String
The ASIN of the product that was purchased.
purchases14d
Integer
Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only.
purchases1d
Integer
Number of attributed conversion events occurring within 1 day of an ad click.
purchases30d
Integer
Number of attributed conversion events occurring within 30 days of an ad click.
purchases7d
Integer
Number of attributed conversion events occurring within 7 days of an ad click.
purchasesothersku14d
Integer
Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku1d
Integer
Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku30d
Integer
Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku7d
Integer
Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU.
qualifiedborrows
Integer
Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
qualifiedborrowsfromclicks
Integer
Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
qualifiedborrowsfromviews
Integer
Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
royaltyqualifiedborrows
Integer
Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
royaltyqualifiedborrowsfromclicks
Integer
Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
royaltyqualifiedborrowsfromviews
Integer
Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only.
sales14d
Numeric
Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns.
sales1d
Numeric
Total value of sales occurring within 1 day of an ad click.
sales30d
Numeric
Total value of sales occurring within 30 days of an ad click.
sales7d
Numeric
Total value of sales occurring within 7 days of an ad click.
salesbrandhalo
Numeric
For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised.
salesbrandhaloclicks
Numeric
Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
salesclicks14d
Numeric
Total value of sales occurring within 14 days of an ad click
salesothersku14d
Numeric
Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku1d
Numeric
Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku30d
Numeric
Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku7d
Numeric
Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssold14d
Integer
Number of attributed units sold within 14 days of an click or view.
unitssoldbrandhalo
Integer
For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised. For CPC campaigns, this value is equal to attributedUnitsOrdered14dOtherSKU.
unitssoldbrandhaloclicks
Integer
Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldclicks14d
Integer
Total number of units sold within 14 days of an ad click.
unitssoldclicks1d
Integer
Total number of units ordered within 1 day of an ad click.
unitssoldclicks30d
Integer
Total number of units ordered within 30 days of an ad click.
unitssoldclicks7d
Integer
Total number of units ordered within 7 days of an ad click.
unitssoldothersku14d
Integer
Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku1d
Integer
Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku30d
Integer
Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku7d
Integer
Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
Last updated
Was this helpful?