# Sponsored Products ## Campaign Table name - *ad\_sponsoredproducts\_campaign* *For details on data availability and refresh schedule, please click* [*here*](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/sponsored-ads/..#data-availability-and-refresh-schedule)*.*
Column NameData typeDescription
profile_idIntegerThe identifier of the amazon advertising account
account_idIntegerIntentwise account id
account_nameStringIntentwise account name
campaignidIntegerThe identifier of the campaign
nameStringThe name of the campaign
portfolioidIntegerThe identifier of an existing portfolio to which the campaign is associated.
targetingtypeStringThe type of targeting of the campaign. manual or auto
stateStringThe current campaign state
dailybudgetNumericDaily budget set for the campaign
startdatedateThe starting date of the campaign. The format of the date is YYYY-MM-DD.
enddatedateThe ending date of the campaign to stop running. The format of the date is YYYY-MM-DD.
creationdateDate time The creation date of the campaign. The format of the date time is YYYY-MM-DD hh:mm:ss.
lastupdateddateDate timeThe date that any value associated with the campaign was last changed. The format of the date time is YYYY-MM-DD hh:mm:ss
servingstatusString

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
biddingstrategyString

Bidding strategy

  • autoForSales -> Dynamic bids - up and down
  • legacyForSales -> Dynamic bids - down only
  • manual -> Fixed bid
biddingplacamenttopofsearchpercentageNumericThe bid adjustment percentage value for Top of search
biddingplacamentproductpagepercentageNumericThe 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ----------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------- | -------------- | ---------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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.

| ## AdGroup Report Table name: *ad\_sponsoredproducts\_adgroup\_report* *For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- | | 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* *This metadata is* synced multiple times a day, resulting in accurate data as of the most recent date.\ \ *Note - lastupdatedate* indicates the timestamp of the most recent update made to the ProductAd on Amazon *For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------- | -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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

| ## Advertised Product Report Table name: *ad\_sponsoredproducts\_productads\_report* *For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ----------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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.

| ## **Keyword** Report Table name: *ad\_sponsoredproducts\_keyword\_report* *For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ------------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------- | -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | --------------------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ------------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.* | Column Name | Data type | Description | | ------------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------- | | 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*](#data-availability-and-refresh-schedule)*.*
Column NameData typeDescription
profile_idIntegerAmazon advertising account id
account_idIntegerIntentwise account id
account_nameStringIntentwise account name
reportdateDateReport date
campaignidIntegerThe identifier of the campaign
impressionsIntegerTotal ad impressions
clicksIntegerTotal ad clicks
costNumericAdvertising spend
attributedconversions14dsameskuIntegerconversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedconversions14dIntegerNumber of attributed conversion events occurring within 14 days of click on ad
attributedsales14dsameskuNumericAggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised
attributedsales14dNumericNumber of attributed sales occurring within 14 days of click on ad
attributedunitsordered14dIntegerNumber of attributed units ordered within 14 days of click on ad
bidplusBooleantrue or false based on whether premium bid adjustments are enabled for a Sponsored
placementStringThe page location where an ad appeared.
attributedkindleeditionnormalizedpagesread14dIntegerNumber of attributed Kindle edition normalized pages read within 14 days of ad click.
attributedkindleeditionnormalizedpagesroyalties14dNumericThe estimated royalties of attributed estimated Kindle edition normalized pages within 14 days
clickthroughrateNumericClicks divided by impressions
impressions_b2bIntegerTotal ad impressions (Brand To Brand)
clicks_b2bIntegerTotal ad clicks (Brand To Brand)
cost_b2bNumericAdvertising spend (Brand To Brand)
attributedconversions14dsamesku_b2bIntegerconversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised (Brand To Brand)
attributedconversions14d_b2bIntegerNumber of attributed conversion events occurring within 14 days of click on ad (Brand To Brand)
attributedsales14dsamesku_b2bNumericAggregate 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_b2bNumericNumber of attributed sales occurring within 14 days of click on ad (Brand To Brand)
attributedunitsordered14d_b2bIntegerNumber of attributed units ordered within 14 days of click on ad (Brand To Brand)
bidplus_b2bBooleantrue or false based on whether premium bid adjustments are enabled for a Sponsored (Brand To Brand)
attributedkindleeditionnormalizedpagesread14d_b2bIntegerNumber of attributed Kindle edition normalized pages read within 14 days of ad click (Brand To Brand)
attributedkindleeditionnormalizedpagesroyalties14d_b2bNumericThe estimated royalties of attributed estimated Kindle edition normalized pages within 14 days (Brand To Brand)
clickthroughrate_b2bNumericClicks 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*](#data-availability-and-refresh-schedule)*.*
Column NameData TypeDescription
profile_idIntegerAmazon advertising account id
account_idIntegerIntentwise account id
account_nameStringIntentwise account name
regionStringRegion
reportdateDateReport Date
recordtypeStringRecord Type
campaigntypeStringCampaign Type
download_dateDateDownload Date
adgroupidIntegerUnique numerical ID of the ad group
addtolistIntegerNumber 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
addtolistfromclicksIntegerNumber of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click
addtolistfromviewsIntegerNumber of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view
advertisedasinStringThe ASIN associated to an advertised product
advertisedskuStringThe SKU being advertised. Not available for vendors
asinbrandhaloStringRepresents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised.
attributiontypeStringDescribes whether a purchase is attributed to a promoted product or brand-halo effect
campaignidIntegerThe ID associated with a campaign
conversionsbrandhaloIntegerFor 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
conversionsbrandhaloclicksIntegerFor 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
keywordidIntegerID associated with a keyword or targeting expression.
keywordtypeStringType 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
kindleeditionnormalizedpagesread14dIntegerNumber of attributed Kindle edition normalized pages read within 14 days of ad click.
kindleeditionnormalizedpagesroyalties14dNumericThe estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.
matchtypeStringType 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
newtobrandpurchases14dIntegerThe number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.
newtobrandpurchasespercentage14dNumericThe percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.
newtobrandsales14dNumericTotal value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
newtobrandsalespercentage14dNumericPercentage 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.
newtobrandunitssold14dIntegerTotal 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.
newtobrandunitssoldpercentage14dNumericPercentage 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.
orders14dIntegerNumber 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.
ordersclicks14dIntegerNumber of orders within the last 14 days attributed to ad clicks.
portfolioidIntegerThe portfolio the campaign is associated with
productcategoryStringThe category the product is associated with on Amazon.
promotedasinStringThe ASIN associated to an advertised product.
promotedskuStringThe SKU being advertised. Not available for vendors.
purchasedasinStringThe ASIN of the product that was purchased.
purchases14dIntegerNumber of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only.
purchases1dIntegerNumber of attributed conversion events occurring within 1 day of an ad click.
purchases30dIntegerNumber of attributed conversion events occurring within 30 days of an ad click.
purchases7dIntegerNumber of attributed conversion events occurring within 7 days of an ad click.
purchasesothersku14dIntegerNumber of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku1dIntegerNumber of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku30dIntegerNumber of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU.
purchasesothersku7dIntegerNumber of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU.
qualifiedborrowsIntegerNumber 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.
qualifiedborrowsfromclicksIntegerNumber 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.
qualifiedborrowsfromviewsIntegerNumber 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.
royaltyqualifiedborrowsIntegerEstimated 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.
royaltyqualifiedborrowsfromclicksIntegerEstimated 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.
royaltyqualifiedborrowsfromviewsIntegerEstimated 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.
sales14dNumericTotal 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.
sales1dNumericTotal value of sales occurring within 1 day of an ad click.
sales30dNumericTotal value of sales occurring within 30 days of an ad click.
sales7dNumericTotal value of sales occurring within 7 days of an ad click.
salesbrandhaloNumericFor 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.
salesbrandhaloclicksNumericTotal value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised
salesclicks14dNumericTotal value of sales occurring within 14 days of an ad click
salesothersku14dNumericTotal value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku1dNumericTotal value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku30dNumericTotal value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
salesothersku7dNumericTotal value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssold14dIntegerNumber of attributed units sold within 14 days of an click or view.
unitssoldbrandhaloIntegerFor 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.
unitssoldbrandhaloclicksIntegerTotal number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldclicks14dIntegerTotal number of units sold within 14 days of an ad click.
unitssoldclicks1dIntegerTotal number of units ordered within 1 day of an ad click.
unitssoldclicks30dIntegerTotal number of units ordered within 30 days of an ad click.
unitssoldclicks7dIntegerTotal number of units ordered within 7 days of an ad click.
unitssoldothersku14dIntegerTotal number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku1dIntegerTotal number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku30dIntegerTotal number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
unitssoldothersku7dIntegerTotal number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
## Sponsored Products Audience Report Table name: amazon\_source\_data.ad\_sponsoredproducts\_audience\_report
| Column Name | Data type | Description | | ------------------------- | --------- | ------------------------------ | | account\_id | Integer | Intentwise account id | | account\_name | String | Intentwise account name | | profile\_id | Integer | Amazon advertising account id | | report\_date | Date | Report date | | campaign\_type | String | Campaign Type | | campaignid | Integer | The identifier of the campaign | | clickthroughrate | Numeric | | | clicks | Integer | | | cost | Numeric | | | costperclick | Numeric | | | impressions | Integer | | | purchases14d | Integer | | | sales14d | Numeric | | | spend | Numeric | | | attributedsalessamesku14d | Numeric | | | attributedsalessamesku1d | Numeric | | | attributedsalessamesku30d | Numeric | | | attributedsalessamesku7d | Numeric | | | campaignbiddingstrategy | String | | | purchases1d | Integer | | | purchases30d | Integer | | | purchases7d | Integer | | | purchasessamesku14d | Integer | | | purchasessamesku1d | Integer | | | purchasessamesku30d | Integer | | | purchasessamesku7d | Integer | | | sales1d | Numeric | | | sales30d | Numeric | | | sales7d | Numeric | | | salesclicks | Numeric | | | unitssold14d | Integer | | | unitssoldclicks | Integer | | | unitssoldclicks14d | Integer | | | unitssoldclicks1d | Integer | | | unitssoldclicks30d | Integer | | | unitssoldclicks7d | Integer | | | unitssoldsamesku14d | Integer | | | unitssoldsamesku1d | Integer | | | unitssoldsamesku30d | Integer | | | unitssoldsamesku7d | Integer | | | download\_date | Date | | | segmentname | String | | | segmentclasscode | String | |