Sponsored Products

Campaign

Table name - ad_sponsoredproducts_campaign

For details on data availability and refresh schedule, please click here.

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

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.

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.

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.

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.

  • 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.

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

For details on data availability and refresh schedule, please click here.

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

  • 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.

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.

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.

  • 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.

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.

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.

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.

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

Table Name: ad_sponsoredproducts_autosearchterm_report

For details on data availability and refresh schedule, please click here.

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

Table Name: ad_sponsoredproducts_keywordsearchterm_report

For details on data availability and refresh schedule, please click here.

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

Table Name: ad_sponsoredproducts_producttargetsearchterm_report

For details on data availability and refresh schedule, please click here.

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

Table Name: ad_sponsoredproducts_campaignplacement_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

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)

Table Name: ad_purchased_product_report

For details on data availability and refresh schedule, please click here.

Column Name
Data Type
Description

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?