Amazon is releasing a new version of the reporting API for Sponsored Advertising (Brands, Products, Display, Video). However, the rollout is uneven; only Sponsored Products is available in the new API. As a result, this creates a situation where we have to leverage two different APIs for reports. Given the significant changes from v2 to v3, we have two connectors;

Sponsored Brands & Sponsored Display on the v2 API
Sponsored Products using the new v3 API.

While we highlight key changes between v2 and v3 below, given the significant changes for Sponsored Products reports between the legacy v2 and new v3 API reports, we suggest reviewing Amazon's migration guide and the Amazon Ads API Reporting API V3 FAQs.

Available Reports Version 3 Reporting API

Currently, the new API is limited in the available reports compared to V2. Only Sponsored Products is available in the new API. Per Amazon;

Version 3 reporting currently supports all Sponsored Products report types in version 2. For Sponsored Display and Sponsored Brands reports, you should continue to use version 2 while we add support to version 3.

Specifically, here is what is available in the new V3 API reporting;

Report type	Sponsored Products	Sponsored Brands
Campaign	x
Targeting	x
Search term	x
Advertised product	x
Purchased product	x	x

As you can see, the available reports are not paralleled with v2 (yet). This is why we have TWO connectors, one for Sponsored Brands & Display and another for Sponsored Products.

Changes to Metric Naming

In addition to changes in reports, the content of those reports is changing. There are changes to metric names from v2 to v3. Per Amazon, below are some of those changes for reference;

Version 2 metric name	Version 3 column name
asin	advertisedAsin
attributedConversions1d	purchases1d
attributedConversions7d	purchases7d
attributedConversions14d	purchases14d
attributedConversions30d	purchases30d
attributedConversions1dSameSKU	purchasesSameSku1d
attributedConversions7dSameSKU	purchasesSameSku7d
attributedConversions14dSameSKU	purchasesSameSku14d
attributedConversions30dSameSKU	purchasesSameSku30d
attributedUnitsOrdered1d	unitsSoldClicks1d
attributedUnitsOrdered7d	unitsSoldClicks7d
attributedUnitsOrdered14d	unitsSoldClicks14d
attributedUnitsOrdered30d	unitsSoldClicks30d
attributedSales1d	sales1d
attributedSales7d	sales7d
attributedSales14d	sales14d
attributedSales30d	sales30d
attributedSales1dSameSKU	attributedSalesSameSku1d
attributedSales7dSameSKU	attributedSalesSameSku7d
attributedSales14dSameSKU	attributedSalesSameSku14d
attributedSales30dSameSKU	attributedSalesSameSku30d
attributedUnitsOrdered1dSameSKU	unitsSoldSameSku1d
attributedUnitsOrdered7dSameSKU	unitsSoldSameSku7d
attributedUnitsOrdered14dSameSKU	unitsSoldSameSku14d
attributedUnitsOrdered30dSameSKU	unitsSoldSameSku30d
attributedUnitsOrdered1dOtherSKU	unitsSoldOtherSku1d
attributedUnitsOrdered7dOtherSKU	unitsSoldOtherSku7d
attributedUnitsOrdered14dOtherSKU	unitsSoldOtherSku14d
attributedUnitsOrdered30dOtherSKU	unitsSoldOtherSku30d
attributedSales1dOtherSKU	salesOtherSku1d
attributedSales7dOtherSKU	salesOtherSku7d
attributedSales14dOtherSKU	salesOtherSku14d
attributedSales30dOtherSKU	salesOtherSku30d
attributedConversions1dOtherSKU	purchasesOtherSku1d
attributedConversions7dOtherSKU	purchasesOtherSku7d
attributedConversions14dOtherSKU	purchasesOtherSku14d
attributedConversions30dOtherSKU	purchasesOtherSku30d
attributedKindleEditionNormalizedPagesRead14d	kindleEditionNormalizedPagesRead14d
attributedKindleEditionNormalizedPagesRoyalties14d	kindleEditionNormalizedPagesRoyalties14d
keywordText	keyword
currency	campaignBudgetCurrencyCode
campaignRuleBasedBudget	campaignRuleBasedBudgetAmount
applicableBudgetRuleId	campaignApplicableBudgetRuleId
applicableBudgetRuleName	campaignApplicableBudgetRuleName
otherAsin	purchasedAsin
targetingText	targeting
placement	placementClassification
newToBrandOrders14d	newToBrandPurchases14d
newToBrandOrdersPercentage14d	newToBrandPurchasesPercentage14d
campaignBudget	campaignBudgetAmount
biddingStrategy	campaignBiddingStrategy
sku	advertisedSku
query	searchTerm
targetId	keywordId
keywordStatus	adKeywordStatus
targetingExpression	keyword
targetingType	keywordType

New metrics

Version 3 also introduces new metrics, including purchaseClickRate1d, purchaseClickRate7d, purchaseClickRate14d, purchaseClickRate30d, costPerClick, acos7d, roas7d, clickThroughRate, impressions1y, clicks1y, spend1y, costPerClick1y, attributionType, productName, productCategory, date, startDate, endDate, acosClicks7d, acosClicks14d, roasClicks7d, roasClicks14d.