Fields listing for Amazon Ads

Unique numerical ID of the ad group.

The name of the ad group as entered by the advertiser.

Unique numerical ID of the ad.

Current status of a keyword.

Status of the ad group.

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click.

Number of times shoppers added a brand's products to their cart, attributed to an ad click.

Calculated by divididing addToCart by impressions.

Number of times shoppers added the brands' products to their cart, attributed to an ad view.

The number of searches that included the name of your brand occurring within 14 days of an ad click or view.

The number of searches that included the name of your brand occurring within 14 days of an ad click.

The number of times a branded keyword was searched on Amazon based on the brands associated to the featured ASINs in your campaign, attributed to an ad view.

Total budget allocated to the campaign.

The currency code associated with the campaign.

One of daily or lifetime.

The ID associated with a campaign.

The name associated with a campaign.

The status of a campaign.

Clicks divided by impressions.

Total number of clicks on an ad.

Total cost of ad clicks.

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

Year, month, and day.

Date when the ad activity ocurred in the format YYYY-MM-DD.

Day of the week

Day of the year

Number of detail page views occurring within 14 days of an ad click or view.

Number of detail page views occurring within 14 days of an ad click.

Effect cost per add to cart, calculated by cost divided by add-to-cart.

End date of summary period for a report in the format YYYY-MM-DD.

The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks.

The total number of times the ad was displayed. This includes valid and invalid impressions such as potentially fraudulent, non-human, and other illegitimate impressions.

Hour of the day

Total number of ad impressions.

The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)

Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic.

The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)

The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic.

Text of the keyword or a representation of the targeting expression (for Sponsored Products). For Sponsored Products targeting reports, the same value is returned in the targeting metric.

Bid associated with a keyword or targeting expression.

ID associated with a keyword or targeting expression.

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.

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.

Month and day

Month of the year

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

Calculated by dividing newToBrandDetailPageViews / impressions.

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

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.

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.

The number of first-time orders for brand products over a one-year lookback window resulting from an ad click or view. Not available for book vendors.

The number of first-time orders for brand products over a one-year lookback window resulting from an ad click. Not available for book vendors.

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors.

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.

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.

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.

The page location where an ad appeared.

The portfolio the campaign is associated with.

The ASIN of the product that was purchased.

Number of attributed conversion events occurring within 14 days of an ad click or view.

Number of attributed conversion events occurring within 14 days of an ad click.

Quarter of the year

Total value of sales occurring within 14 days of an ad click or view.

Total value of sales occurring within 14 days of an ad click.

The search term used by the customer. Same as query.

Describes whether a purchase is attributed to a promoted product or brand-halo effect.

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions.

The type of targeting used in the expression.

The percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter). Sponsored Brands video-only metric.

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric.

Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed). Sponsored Brands video-only metric.

Text of the keyword.

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 clicked an ad.

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

The percentage of total orders that are new-to-brand orders. Not available for book vendors.

The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.

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

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.

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.

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

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.

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.

Number of orders within the last 14 days.

The category the product is associated with on Amazon.

The name of the product.

Number of attributed conversion events occurring within 14 days of ad click or view where the purchased SKU was the same as the SKU advertised. Same as purchasesSameSku14d.

Total value of sales occurring within 14 days of ad click or view where the purchased SKU was the same as the SKU advertised. Same as attributedSales14dSameSKU.

Number of attributed units sold within 14 days of click on an ad. Same as unitsSoldClicks14d. Only valid for Sponsored Brands version 3 campaigns, not Sponsored Brands video or multi-ad group (version 4) campaigns.

Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised.

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

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.

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.

Total number of unique users exposed to an ad from either a campaign, ad group, or product ad over the lifetime of the campaign or the past six months, whichever is shorter. This metric is updated daily.

Effective (average) cost to acquire a Branded Search.

Average number of times unique users were exposed to an ad over the lifetime of the campaign.

The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.

The ASIN associated with the product page where a Sponsored Display ad appeared.

The ASIN associated to an advertised product.

The SKU being advertised. Not available for vendors.

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.

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.

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.

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.

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

Advertising cost of sales based on purchases made within 7 days of an ad click.

Advertising cost of sales based on purchases made within 14 days of an ad click.

The ASIN associated to an advertised product.

The SKU being advertised. Not available for vendors.

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised.

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. Sponsored Products only.

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.

The ID associated to the active budget rule for a campaign.

The name associated to the active budget rule for a campaign.

The bidding strategy associated with a campaign.

The value of the rule-based budget for a campaign.

Total cost divided by total number of clicks.

Number of attributed Kindle edition normalized pages read within 14 days of ad click.

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.

Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU.

Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU.

Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU.

Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU.

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised.

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. Sponsored Products only. Same as puchasesPromoted.

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.

Number of attributed conversion events occurring within 1 day of an ad click.

Number of attributed conversion events occurring within 7 days of an ad click.

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only.

Number of attributed conversion events occurring within 30 days of an ad click.

Return on ad spend based on purchases made within 7 days of an ad click.

Return on ad spend based on purchases made within 14 days of an ad click.

Total value of sales occurring within 1 day of an ad click.

Total value of sales occurring within 14 days of an ad click. Sponsored Products only.

Total value of sales occurring within 30 days of an ad click.

Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised.

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised.

Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

Total value of sales occurring within 7 days of an ad click.

Total cost of ad clicks.

A string representation of the expression object used in the targeting clause.

Total number of units ordered within 1 day of an ad click.

Total number of units ordered within 7 days of an ad click.

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

Total number of units ordered within 30 days of an ad click.

Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised.

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised.

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised.

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised.

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised.

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised.

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised.

The cost per thousand impressions.

The number of times a product detail page was viewed attributed to an ad view.

The number of new to branch purchases attributed to an ad view.

Total value of sales by new to brand customers occurring within 14 days of an ad view.

Number of attributed conversion events occurring within 14 days of an ad view.

Return on ad spend.

Total value of sales occurring within 14 days of an ad view.

Number of attributed units sold within 14 days of an ad view.

Start date of summary period for a report in the format YYYY-MM-DD.

A string representation of the expression object used in the targeting clause.

The identifier of the targeting expression.

The text used in the targeting expression.

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.

Number of attributed units sold within 14 days of an ad click or view.

Number of attributed units sold within 14 days of an ad click.

The number of impressions where the video was viewed to 100%.

The number of impressions where the video was viewed to 25%.

The number of impressions where the video was viewed to 50%.

The number of impressions where the video was viewed to 75%.

The number of impressions where a customer unmuted the video.

Click-through rate for views (clicks divided by views).

View-through rate (vtr). Views divided by impressions.

Week of the year

Week of the year (start sunday)

Year such as 2017.

Year and month.

Year and quarter.

Year and week.