Data reference

Introduction

Amazon Ads is Amazon’s retail-media advertising platform, unifying three sponsored ad surfaces — Sponsored Products, Sponsored Brands, and Sponsored Display — for sellers, vendors, and agencies advertising on Amazon’s marketplace and partner properties. The platform supports CPC and vCPM (viewable CPM) payment models across awareness, consideration, and conversion objectives, with bidding tied to keywords, ASINs, audiences, and product categories. The connector imports campaign structure and performance metrics from all three sub-APIs through the Amazon Ads Reporting API v3, normalizing them into a single unified reporting format. As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration. To connect this data source, see How to connect Amazon Ads to Adriel.

Data refresh strategy

Architecture data

Architecture covers ad accounts, campaigns, ad groups (ad sets), ads, and keywords. It refreshes once daily at 5:00 PM UTC. On data source creation, the cache fills with 60 days of historical data for the ad account, campaign, ad set, ad, and keyword levels.

Reports data

Reports include daily performance metrics for ad accounts, campaigns, ad groups, ads, and keywords across Sponsored Products, Sponsored Brands, and Sponsored Display. Cache-only. Report data comes from cached daily performance snapshots — dashboard queries always read from the last snapshot, never live from Amazon Ads. Metrics based on uniqueness (such as reach) can be overvalued when viewed over a date range longer than one day, because uniqueness is computed per snapshot rather than across the full range. Refresh schedule. Reports refresh on three schedules:

1:00 AM UTC daily — syncs the last 9 days for the campaign, ad set, and ad levels
9:00 AM UTC every 2 days — syncs the last 9 days for the keyword level
6:00 PM UTC every 10 days — syncs the last 17 days for the campaign, ad set, ad, and keyword levels

Data is reliable within the cache sync period. Data outside this range may be incomplete or inaccurate due to legacy caching behavior.

Architecture levels

Ad account → Campaign → Ad group (ad set) → Ad → Keyword

Date range limits

Breakdown	Max range
Daily	93 days
Weekly	1 year
Monthly	2 years

Attribution windows

Amazon Ads reports conversions across four click-attribution windows: 1d, 7d, 14d, and 30d. Most conversion and sales metrics are exposed as one variant per window (Amazon Ads Reporting API v3) — for example, purchases exist as purchases1d, purchases7d, purchases14d, and purchases30d. The exact metric set varies by sub-API (see the metric categories below). Because Amazon’s console and the API can default to different attribution windows, match the window when comparing Amazon’s numbers to a dashboard widget for like-for-like results.

Metrics

How to read the columnsData type uses Adriel’s vocabulary — Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. API Key in code style like impressions is the literal Amazon Ads API field; where the same raw field name is shared across objects (Amazon returns name for both the ad group and the campaign), it’s shown qualified as object.field (for example campaign.name) so each row stays unique; italic marks a value Adriel computes or derives. Some raw fields back several metrics — notably landing.url / landingPage.url, which Adriel parses for every UTM row — so the same key can appear on multiple rows; that’s the shared source field, not a duplicated entry. Currency values are reported in each ad account’s configured Amazon currency.

Because Amazon Ads unifies three ad surfaces, the metrics available on a given row depend on which sub-API (Sponsored Products, Sponsored Brands, or Sponsored Display) the ad belongs to. Querying a metric on the wrong sub-API returns empty values.

Basic

Metric	Description	Data type	API Key
Creative Type	Creative format used by the ad, such as image, video, or collection.	Text	`creative.type`, `creativeType`, `adFormat`
Lifetime Budget	Lifetime budget amount set for the campaign when Amazon returns a lifetime budget.	Currency	`budget`, `budgetType`
Result Indicator	The metric used to represent the result for the campaign objective.	Text	Adriel-derived
Results	The results recorded for the campaign’s configured objective.	Text	Adriel-derived

Campaign Attributes

Metric	Description	Data type	API Key
Ad Account Name	Name of the Amazon Ads account.	Text	`accountInfo.name`
Ad Name	Name or headline shown for the ad. This value is inferred from the available creative or product metadata.	Text	Adriel-derived
Ad Set Name	Name of the ad group.	Text	`adGroupName`, `adGroup.name`
Ad Spend	Total advertising spend.	Currency	`cost`
Bid Cap	Maximum bid amount configured for the campaign or ad group.	Currency	Adriel-derived
Bid Strategy	Bidding or budget strategy values associated with the entity when Amazon returns them.	Array	`budgetType`, `campaignBiddingStrategy`, `bidOptimization`
Budget	Budget details returned for the campaign, including amount and budget type when available.	Text	`budget`, `dailyBudget`, `budgetType`
Campaign Name	Name of the campaign.	Text	`campaignName`, `campaign.name`
Creative URL	Creative asset URLs associated with the ad, such as logos, images, or media files.	URL	`creative.brandLogoUrl`, `creative.customImages.url`, `asset.assetVersionList.url`
Daily Budget	Daily budget amount set for the campaign when Amazon returns a daily budget.	Currency	`dailyBudget`
Ends	Campaign end date.	Date	`endDate`
Is Active	Whether the campaign, ad set, or ad is currently active.	Boolean	Adriel-derived
Landing URL	Landing page URLs used by the ad.	URL	`landing.url`, `landingPage.url`
Objective	Campaign objective or Amazon ad product associated with the entity.	Text	`objective`
Starts	Campaign start date.	Date	`startDate`
Status	Current delivery or lifecycle status of the entity.	Text	`state`, `serviceStatus`, `servingStatus`, `adStatus`, `adKeywordStatus`, `campaignStatus`
Status Text	A human-readable label for the current delivery status of the entity.	Text	Adriel-derived
UTM Campaign	UTM campaign value parsed from the ad landing URL when present.	Text	`landing.url`, `landingPage.url`
UTM Content	UTM content value parsed from the ad landing URL when present.	Text	`landing.url`, `landingPage.url`
UTM Medium	UTM medium value parsed from the ad landing URL when present.	Text	`landing.url`, `landingPage.url`
UTM Source	UTM source value parsed from the ad landing URL when present.	Text	`landing.url`, `landingPage.url`
UTM Term	UTM term value parsed from the ad landing URL when present.	Text	`landing.url`, `landingPage.url`

UTM values are parsed by Adriel, not returned by Amazon. Adriel reads the UTM query parameters from each ad’s landing URL and exposes them as both metrics (for rollup) and breakdowns (for grouping).

Campaign Structure

Metric	Description	Data type	API Key
Ad Account ID	Amazon Ads account identifier used by the connector.	Text	`profileId`
Ad ID	Amazon ad identifier.	Text	`adId`
Ad Set ID	Amazon ad group identifier.	Text	`adGroupId`
Campaign ID	Amazon campaign identifier.	Text	`campaignId`
Channel	The advertising channel, a constant label Adriel assigns for cross-connector rollup.	Text	Adriel-assigned
Keyword ID	Amazon keyword identifier.	Text	`keywordId`
Keyword Name	Keyword text associated with the row.	Text	`keywordText`

Computed Metric

These are calculated by Adriel from other metrics; they have no single underlying Amazon Ads field.

Metric	Description	Data type	API Key
ROAS	Return on ad spend — conversion value divided by spend.	Ratio	Adriel-computed

Conversion Performance

Metric	Description	Data type	API Key
Conversion Value	The monetary value of attributed conversions.	Currency	`sales`, `attributedSales14d`, `attributedSales7d`, `attributedSales1d`, `sales14d`, `sales7d`, `sales1d`
Conversions	Attributed conversions using the connector’s primary Amazon conversion mapping.	Number	`attributedConversions14d`, `attributedConversions7d`, `attributedConversions1d`, `purchases`, `purchases14d`, `purchases7d`, `purchases1d`
Revenue	The monetary sales value attributed to the ads.	Currency	`sales`, `attributedSales14d`, `attributedSales7d`, `attributedSales1d`, `sales14d`, `sales7d`, `sales1d`

Conversion events are imported from the connected account. Any conversion event tracked in the Amazon Ads account is imported automatically and appears on a dashboard only while the underlying event is active in the account. For each imported event, Adriel also generates derived metrics such as ROAS, CPA, and conversion rate.

Creative Attributes

Metric	Description	Data type	API Key
Creative Image	The image used in the ad creative.	Text	Adriel-derived

Impression Click Performance

Metric	Description	Data type	API Key
Clicks (All)	Total clicks returned by Amazon for the row.	Number	`clicks`
CPC	Cost per click.	Currency	Adriel-computed
CPM	Cost per thousand impressions.	Currency	Adriel-computed
CTR	Click-through rate — clicks divided by impressions.	Percentage	Adriel-computed
Impressions	Total impressions.	Number	`impressions`
Link Clicks	Total clicks.	Number	`clicks`

Amazon Ads-specific

These metrics exist only for Amazon Ads and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Metric	Description	Data type	API Key
Acos Clicks14d	Advertising cost of sales based on purchases made within 14 days after an ad click.	Percentage	`acosClicks14d`
Acos Clicks7d	Advertising cost of sales based on purchases made within 7 days after an ad click.	Percentage	`acosClicks7d`
Ad Group Id	Unique numerical ID of the ad group.	Text	`adGroupId`
Ad Group Name	The name of the ad group as entered by the advertiser.	Text	`adGroupName`
Ad ID	Unique numerical ID of the ad.	Text	`adId`
Ad Keyword Status	Current status of a keyword.	Text	`adKeywordStatus`
Ad Status	Status of the ad group.	Text	`adStatus`
Add To Cart	Number of times shoppers added products from a brand to their cart, attributed to an ad view or click.	Number	`addToCart`
Add To Cart - ClickThrough Conversions	Number of times shoppers added products from a brand to their cart, attributed to an ad click.	Number	`addToCartClicks`
Add To Cart - ViewThrough Conversions	Number of times shoppers added products from the brand to their cart, attributed to an ad view.	Number	`addToCartViews`
Add To Cart Rate	Calculated by dividing addToCart by impressions.	Percentage	`addToCartRate`
Add To List	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 products from the brand.	Number	`addToList`
Add To List From Clicks	Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click.	Number	`addToListFromClicks`
Add To List From Views	Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view.	Number	`addToListFromViews`
Advertised Sku	The advertised product’s SKU.	Text	`advertisedSku`
Attributed Sales Same Sku14d	Total value of sales recorded within 14 days of an ad click when the purchased SKU matched the advertised SKU.	Currency	`attributedSalesSameSku14d`
Attributed Sales Same Sku1d	Total value of sales recorded within 1 day of an ad click when the purchased SKU matched the advertised SKU.	Currency	`attributedSalesSameSku1d`
Attributed Sales Same Sku30d	Total value of sales recorded within 30 days of an ad click when the purchased SKU matched the advertised SKU.	Currency	`attributedSalesSameSku30d`
Attributed Sales Same Sku7d	Total value of sales recorded within 7 days of an ad click when the purchased SKU matched the advertised SKU.	Currency	`attributedSalesSameSku7d`
Bid Optimization	Bid optimization for Sponsored Display ad groups.	Text	`bidOptimization`
Branded Search Rate	Rate of Branded Searches relative to the number of impressions. (BS/Impressions)	Percentage	`brandedSearchRate`
Branded Searches	Number of searches that included the name of your brand recorded within 14 days after an ad click or view.	Number	`brandedSearches`
Branded Searches Clicks	Number of searches that included the name of your brand recorded within 14 days after an ad click.	Number	`brandedSearchesClicks`
Branded Searches Views	Number of times shoppers searched for a brand promoted in the campaign, attributed to an ad view.	Number	`brandedSearchesViews`
Campaign Bidding Strategy	The bidding strategy associated with a campaign.	Text	`campaignBiddingStrategy`
Campaign Budget Amount	Total budget allocated to the campaign.	Currency	`campaignBudgetAmount`
Campaign Budget Currency Code	The currency code associated with the campaign.	Text	`campaignBudgetCurrencyCode`
Campaign Budget Type	One of daily or lifetime.	Text	`campaignBudgetType`
Campaign ID	The ID associated with a campaign.	Text	`campaignId`
Campaign Status	Status of a campaign.	Text	`campaignStatus`
Click Through Rate	Clicks divided by impressions.	Percentage	`clickThroughRate`
Cost	Total cost of ad clicks.	Currency	`cost`
Cost Per Click	Total cost divided by total number of clicks.	Currency	`costPerClick`
Cost Type	Billing model used by the campaign, such as CPC or vCPM.	Text	`costType`
Cumulative Reach	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.	Number	`cumulativeReach`
Date	Date when the ad activity occurred in the format YYYY-MM-DD.	Date	`date`
Detail Page Views	Number of detail page views recorded within 14 days after an ad click or view.	Number	`detailPageViews`
Detail Page Views Clicks	Number of detail page views recorded within 14 days after an ad click.	Number	`detailPageViewsClicks`
E CPAdd To Cart	Effective cost per add to cart, calculated by cost divided by add-to-cart.	Currency	`eCPAddToCart`
E CPBrand Search	Effective (average) cost to acquire a Branded Search.	Currency	`eCPBrandSearch`
Impressions Frequency Average	Average number of times unique users were exposed to an ad over the lifetime of the campaign.	Number	`impressionsFrequencyAverage`
Impressions Views	The number of viewable impressions.	Number	`impressionsViews`
Keyword Bid	Bid associated with a keyword or targeting expression.	Currency	`keywordBid`
Keyword ID	ID associated with a keyword or targeting expression.	Text	`keywordId`
Keyword Text	Text of the keyword.	Text	`keywordText`
Keyword Type	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: TARGETING	Text	`keywordType`
Kindle Edition Normalized Pages Read14d	Number of attributed Kindle edition normalized pages read within 14 days of ad click.	Number	`kindleEditionNormalizedPagesRead14d`
Kindle Edition Normalized Pages Royalties14d	The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.	Currency	`kindleEditionNormalizedPagesRoyalties14d`
Lead Form Opens	Number of times customers opened a lead form from the ad.	Number	`leadFormOpens`
Leads	Number of leads generated from the ad.	Number	`leads`
Link Outs	Number of times link-outs to landing page were clicked.	Number	`linkOuts`
Match Type	Keyword match type used for the bid. Sponsored Products targeting rows can also show targeting-expression match types.	Text	`matchType`
New To Brand Detail Page View Rate	Calculated by dividing newToBrandDetailPageViews by impressions.	Percentage	`newToBrandDetailPageViewRate`
New To Brand Detail Page Views Clicks	Number of new-to-brand detail page views attributed to an ad click.	Number	`newToBrandDetailPageViewsClicks`
New To Brand ECPDetail Page View	Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.	Currency	`newToBrandECPDetailPageView`
New To Brand Purchases Percentage	Percentage of total orders that are new-to-brand orders within 14 days after an ad click. Not available for book vendors.	Percentage	`newToBrandPurchasesPercentage`
New To Brand Purchases Rate	Percentage of total orders that are new-to-brand orders. Not available for book vendors.	Percentage	`newToBrandPurchasesRate`
New To Brand Sales	Total value of new-to-brand sales recorded within 14 days after an ad click or view. Not available for book vendors.	Currency	`newToBrandSales`
New To Brand Sales Clicks	Total value of new-to-brand sales recorded within 14 days after an ad click. Not available for book vendors.	Currency	`newToBrandSalesClicks`
New To Brand Sales Percentage	Percentage of total sales made up of new-to-brand purchases within 14 days after an ad click. Not available for book vendors. Same as newToBrandSalesPercentage14d.	Percentage	`newToBrandSalesPercentage`
New To Brand Units Sold Clicks	Total number of attributed units ordered as part of new-to-brand sales recorded within 14 days after an ad click. Not available for book vendors.	Number	`newToBrandUnitsSoldClicks`
New To Brand Units Sold Percentage	Percentage of total attributed units ordered within 14 days after an ad click that are part of a new-to-brand purchase. Not available for book vendors. Same as newToBrandUnitsSoldPercentage14d.	Percentage	`newToBrandUnitsSoldPercentage`
New-To-Brand Detail Page View - ClickThrough Conversions	Number of new-to-brand detail page views for all products from the brand, attributed to an ad click.	Number	`newToBrandDetailPageViewClicks`
New-To-Brand Detail Page View - ViewThrough Conversions	Number of new-to-brand detail page views for all products from the brand, attributed to an ad view.	Number	`newToBrandDetailPageViewViews`
New-To-Brand Detail Page Views	Number of new-to-brand detail page views attributed to an ad click or view.	Number	`newToBrandDetailPageViews`
New-To-Brand Purchases	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.	Number	`newToBrandPurchases`
New-To-Brand Purchases - ClickThrough Conversions	Number of first-time orders for brand products over a one-year lookback window resulting from an ad click. Not available for book vendors.	Number	`newToBrandPurchasesClicks`
New-To-Brand Units Sold	Total number of attributed units ordered as part of new-to-brand sales recorded within 14 days after an ad click or view. Not available for book vendors.	Number	`newToBrandUnitsSold`
Placement Classification	The page location where an ad appeared.	Text	`placementClassification`
Promoted Asin	The promoted product’s ASIN.	Text	`promotedAsin`
Promoted Sku	The promoted product’s SKU.	Text	`promotedSku`
Purchases	Number of attributed conversion events recorded within 14 days after an ad click or view.	Number	`purchases`
Purchases - ClickThrough Conversions	Number of attributed purchase conversions recorded within 14 days after an ad click.	Number	`purchasesClicks`
Purchases Promoted	Number of attributed conversion events recorded within 14 days of an ad click or view when the purchased SKU matched the promoted SKU.	Number	`purchasesPromoted`
Purchases Promoted Clicks	Number of attributed conversion events recorded within 14 days after an ad click when the purchased SKU matched the promoted SKU.	Number	`purchasesPromotedClicks`
Purchases Same Sku14d	Number of attributed conversion events recorded within 14 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`purchasesSameSku14d`
Purchases Same Sku1d	Number of attributed conversion events recorded within 1 day of an ad click when the purchased SKU matched the advertised SKU.	Number	`purchasesSameSku1d`
Purchases Same Sku30d	Number of attributed conversion events recorded within 30 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`purchasesSameSku30d`
Purchases Same Sku7d	Number of attributed conversion events recorded within 7 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`purchasesSameSku7d`
Purchases14d	Purchases attributed within 14 days after an ad click.	Number	`purchases14d`
Purchases14d: CPA	Average advertising cost for each purchase attributed within 14 days after an ad click.	Currency	`cost`, `purchases14d`
Purchases14d: CVR	Conversion rate based on purchases attributed within 14 days after an ad click.	Percentage	`clicks`, `purchases14d`
Purchases1d	Number of attributed conversion events recorded within 1 day after an ad click.	Number	`purchases1d`
Purchases1d: CPA	Average advertising cost for each purchase attributed within 1 day after an ad click.	Currency	`cost`, `purchases1d`
Purchases1d: CVR	Conversion rate based on purchases attributed within 1 day after an ad click.	Percentage	`clicks`, `purchases1d`
Purchases30d	Number of attributed conversion events recorded within 30 days after an ad click.	Number	`purchases30d`
Purchases7d	Number of attributed conversion events recorded within 7 days after an ad click.	Number	`purchases7d`
Purchases7d: CPA	Average advertising cost for each purchase attributed within 7 days after an ad click.	Currency	`cost`, `purchases7d`
Purchases7d: CVR	Conversion rate based on purchases attributed within 7 days after an ad click.	Percentage	`clicks`, `purchases7d`
Qualified Borrows	Number of qualified Kindle Unlimited borrows attributed to the ad. Relevant to book advertisers only.	Number	`qualifiedBorrows`
Qualified Borrows From Clicks	Number of qualified Kindle Unlimited borrows attributed to an ad click. Relevant to book advertisers only.	Number	`qualifiedBorrowsFromClicks`
Qualified Borrows From Views	Number of qualified Kindle Unlimited borrows attributed to an ad view. Relevant to book advertisers only.	Number	`qualifiedBorrowsFromViews`
Roas Clicks14d	Return on ad spend based on purchases made within 14 days after an ad click.	Ratio	`roasClicks14d`
Roas Clicks7d	Return on ad spend based on purchases made within 7 days after an ad click.	Ratio	`roasClicks7d`
Royalty Qualified Borrows	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.	Currency	`royaltyQualifiedBorrows`
Royalty Qualified Borrows From Clicks	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.	Currency	`royaltyQualifiedBorrowsFromClicks`
Royalty Qualified Borrows From Views	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.	Currency	`royaltyQualifiedBorrowsFromViews`
Sales	Total value of sales recorded within 14 days after an ad click or view.	Currency	`sales`
Sales Clicks	Total value of sales recorded within 14 days after an ad click.	Currency	`salesClicks`
Sales Other Sku7d	Total value of sales recorded within 7 days after an ad click when the purchased SKU differed from the advertised SKU.	Currency	`salesOtherSku7d`
Sales Promoted	Total value of sales recorded within 14 days of an ad click or view when the purchased SKU matched the promoted SKU.	Currency	`salesPromoted`
Sales Promoted Clicks	Total value of promoted-product sales recorded within 14 days after an ad click.	Currency	`salesPromotedClicks`
Sales14d	Total value of sales recorded within 14 days after an ad click. Includes sales attributed to both clicks and views.	Currency	`sales14d`
Sales1d	Total value of sales recorded within 1 day after an ad click.	Currency	`sales1d`
Sales30d	Total value of sales recorded within 30 days after an ad click.	Currency	`sales30d`
Sales7d	Total value of sales recorded within 7 days after an ad click.	Currency	`sales7d`
Search Term	The search term used by the customer. Same as query.	Text	`searchTerm`
Targeting	A string representation of the expression object used in the targeting clause.	Text	`targeting`
Top Of Search Impression Share	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.	Percentage	`topOfSearchImpressionShare`
Units Sold	Number of attributed units sold within 14 days after an ad click or view.	Number	`unitsSold`
Units Sold Clicks	Number of attributed units sold within 14 days after an ad click.	Number	`unitsSoldClicks`
Units Sold Clicks14d	Total number of units sold within 14 days after an ad click.	Number	`unitsSoldClicks14d`
Units Sold Clicks14d: CPA	Average advertising cost for each unit sold attributed within 14 days after an ad click.	Currency	`cost`, `unitsSoldClicks14d`
Units Sold Clicks14d: CVR	Conversion rate based on units sold attributed within 14 days after an ad click.	Percentage	`clicks`, `unitsSoldClicks14d`
Units Sold Clicks1d	Total number of units ordered within 1 day after an ad click.	Number	`unitsSoldClicks1d`
Units Sold Clicks1d: CPA	Average advertising cost for each unit sold attributed within 1 day after an ad click.	Currency	`cost`, `unitsSoldClicks1d`
Units Sold Clicks1d: CVR	Conversion rate based on units sold attributed within 1 day after an ad click.	Percentage	`clicks`, `unitsSoldClicks1d`
Units Sold Clicks30d	Total number of units ordered within 30 days after an ad click.	Number	`unitsSoldClicks30d`
Units Sold Clicks7d	Total number of units ordered within 7 days after an ad click.	Number	`unitsSoldClicks7d`
Units Sold Clicks7d: CPA	Average advertising cost for each unit sold attributed within 7 days after an ad click.	Currency	`cost`, `unitsSoldClicks7d`
Units Sold Clicks7d: CVR	Conversion rate based on units sold attributed within 7 days after an ad click.	Percentage	`clicks`, `unitsSoldClicks7d`
Units Sold Other Sku7d	Total number of units ordered within 7 days after an ad click when the purchased SKU differed from the advertised SKU.	Number	`unitsSoldOtherSku7d`
Units Sold Same Sku14d	Total number of units ordered within 14 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`unitsSoldSameSku14d`
Units Sold Same Sku1d	Total number of units ordered within 1 day of an ad click when the purchased SKU matched the advertised SKU.	Number	`unitsSoldSameSku1d`
Units Sold Same Sku30d	Total number of units ordered within 30 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`unitsSoldSameSku30d`
Units Sold Same Sku7d	Total number of units ordered within 7 days of an ad click when the purchased SKU matched the advertised SKU.	Number	`unitsSoldSameSku7d`
Video Complete Views	Number of impressions when the video was viewed to 100%.	Number	`videoCompleteViews`
Video First Quartile Views	Number of impressions when the video was viewed to 25%.	Number	`videoFirstQuartileViews`
Video Midpoint Views	Number of impressions when the video was viewed to 50%.	Number	`videoMidpointViews`
Video Third Quartile Views	Number of impressions when the video was viewed to 75%.	Number	`videoThirdQuartileViews`
Video Unmutes	Number of impressions where a customer unmuted the video.	Number	`videoUnmutes`
Video5Second View Rate	Percentage of impressions when the customer watched the complete video or 5 seconds of the video (whichever is shorter). Sponsored Brands and Sponsored Products video-only metric.	Percentage	`video5SecondViewRate`
Video5Second Views	Number of impressions when the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands and Sponsored Products video-only metric.	Number	`video5SecondViews`
View Click Through Rate	Click-through rate for views (clicks divided by views).	Percentage	`viewClickThroughRate`
Viewability Rate	View-through rate (vtr). Views divided by impressions.	Percentage	`viewabilityRate`
Viewable Impressions	The number of impressions that were viewable.	Number	`viewableImpressions`

Breakdowns

Basic

Breakdown	Description	API Key
Channel	Connector channel name.	Adriel-assigned

Campaign Structure

Breakdown	Description	API Key
Ad Name	Groups results by ad name.	Adriel-derived
Ad Set Name	Groups results by ad group (ad set) name.	Adriel-derived
Campaign Name	Groups results by campaign name.	Adriel-derived
Objective	Campaign objective or Amazon ad product associated with the entity.	`objective`
Platform	Groups results by advertising platform.	Adriel-derived
Status	Current delivery or lifecycle status of the entity.	`state`, `serviceStatus`, `servingStatus`, `adStatus`, `adKeywordStatus`, `campaignStatus`

Creatives

Adriel post-processes ad creatives to generate these breakdowns.

Breakdown	Description	API Key
Ad Copy	Groups results by words identified in the ad creative.	Adriel-derived
Color Clustering	Groups results by similar colors identified in the ad creative.	Adriel-derived
Emoji Analysis	Groups results by emojis identified in the ad creative.	Adriel-derived

Date

Amazon Ads returns daily records; all time-grouping breakdowns are Adriel-side aggregations of the same underlying daily data.

Breakdown	Description	API Key
Auto Time Breakdown	Automatic time grouping selected for the requested date range.	`date`
Daily Breakdown	Calendar day for the row.	`date`
Monthly Breakdown	Calendar month derived from the report date.	`date`
Quarterly Breakdown	Groups results by calendar quarter.	Adriel-side
Week Date Breakdown	Groups results by the date representing each reporting week.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Calendar week derived from the report date.	`date`
Weekly Breakdown (Start: Sun)	Groups results into weeks running from Sunday through Saturday.	Adriel-side
Yearly Breakdown	Groups results by calendar year.	Adriel-side

Others

Breakdown	Description	API Key
No Grouping	Synthetic breakdown that groups all results into a single bucket.	Adriel-side

Amazon Ads-specific

These breakdowns exist only for Amazon Ads and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Breakdown	Description	API Key
Ad	Ad for the row.	`adId`
Ad Account	Amazon Ads account for the row.	`profileId`
Ad Set	Ad group for the row.	`adGroupId`
ASIN	Groups results by advertised product ASIN.	`advertisedAsin`
Campaign	Campaign for the row.	`campaignId`
Keyword Name	Keyword for the row.	`keywordId`
Keyword Match Type	Keyword match type used for the row, such as broad, phrase, or exact.	`matchType`
Keyword Text	Text of the keyword.	`keywordText`
Placement	Amazon placement classification for the impression or click, such as top of search or product pages.	`placementClassification`
Portfolio ID	The portfolio the campaign is associated with.	`portfolioId`
Portfolio Name	The name of the portfolio associated with the campaign.	`portfolioName`
Search Term	The search term used by the customer. Same as query.	`searchTerm`

Limitations

Cache-only reporting — dashboard values reflect the most recent snapshot, not a live Amazon Ads query.
60-day initial cache — on first connection, only the last 60 days of performance are populated; older history is not backfilled.
Region locked at connection time — North America, Europe, and Far East accounts use different API endpoints. Selecting the wrong region yields no data, and the region cannot be changed after the connection is created.
Metric availability differs per sub-API — Sponsored Products has the largest metric set; Sponsored Brands adds video and brand-awareness metrics; Sponsored Display adds view-through and engagement metrics. Querying a metric on the wrong sub-API returns empty values.
Uniqueness metrics may be overvalued — because reporting is cache-only and uniqueness is computed per snapshot, reach aggregated across multi-day windows can overstate true unique reach.
No deleted-data exclusion — the connector does not return deleted elements, so removed campaigns, ad groups, or ads may not appear in reports.
Rate limiting and truncation — Amazon imposes API rate limits; the connector applies built-in rate limiting and retry logic, and some data can be truncated.

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Attribution windows

Metrics

Basic

Campaign Attributes

Campaign Structure

Computed Metric

Conversion Performance

Creative Attributes

Impression Click Performance

Amazon Ads-specific

Breakdowns

Basic

Campaign Structure

Creatives

Date

Others

Amazon Ads-specific

Limitations

API references

See also

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Attribution windows

​Metrics

​Basic

​Campaign Attributes

​Campaign Structure

​Computed Metric

​Conversion Performance

​Creative Attributes

​Impression Click Performance

​Amazon Ads-specific

​Breakdowns

​Basic

​Campaign Structure

​Creatives

​Date

​Others

​Amazon Ads-specific

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Attribution windows

Metrics

Basic

Campaign Attributes

Campaign Structure

Computed Metric

Conversion Performance

Creative Attributes

Impression Click Performance

Amazon Ads-specific

Breakdowns

Basic

Campaign Structure

Creatives

Date

Others

Amazon Ads-specific

Limitations

API references

See also