Amazon Ads - Supported Columns

Every column the Amazon Ads connector can download.

These are the columns available to a Amazon Ads connector. The recommended template uses a small subset of them, listed on the Amazon Ads page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

The In default report column marks the ones the recommended template's report brings back. The rest belong to other report types and need a connector configured for them.

Columns

Column	In default report
acosClicks14d
acosClicks7d
adGroupId	default report
adGroupName	default report
adId
adKeywordStatus
adStatus	default report
addToCart
addToCartClicks
addToCartRate
addToCartViews
addToList	default report
addToListFromClicks
addToListFromViews
advertisedAsin
advertisedSku
asinBrandHalo
attributedSalesSameSku14d	default report
attributedSalesSameSku1d	default report
attributedSalesSameSku30d	default report
attributedSalesSameSku7d	default report
attributionType
bidOptimization
brandedSearchRate
brandedSearches
brandedSearchesClicks
brandedSearchesViews
campaignApplicableBudgetRuleId	default report
campaignApplicableBudgetRuleName	default report
campaignBiddingStrategy	default report
campaignBudgetAmount	default report
campaignBudgetCurrencyCode	default report
campaignBudgetType	default report
campaignId	default report
campaignName	default report
campaignPriceTypeCode
campaignRuleBasedBudgetAmount	default report
campaignStatus	default report
clickThroughRate	default report
clicks	default report
conversionsBrandHalo
conversionsBrandHaloClicks
cost	default report
costPerClick	default report
costPerThousandImpressions
costType
cumulativeReach
date	default report
detailPageViews
detailPageViewsClicks
detailPageViewsViews
eCPAddToCart
eCPBrandSearch
endDate	default report
frequencyAverage
grossClickThroughs
grossImpressions
householdFrequencyAverage
householdReach
impressions	default report
impressionsFrequencyAverage
impressionsViews
invalidClickThroughRate
invalidClickThroughs
invalidImpressionRate
invalidImpressions
keyword
keywordBid
keywordId
keywordText
keywordType
kindleEditionNormalizedPagesRead14d	default report
kindleEditionNormalizedPagesRoyalties14d	default report
leadFormOpens
leads
linkOuts
matchType
matchedTargetAsin
newToBrandDetailPageViewClicks
newToBrandDetailPageViewRate
newToBrandDetailPageViewViews
newToBrandDetailPageViews
newToBrandDetailPageViewsClicks
newToBrandECPDetailPageView
newToBrandPurchases
newToBrandPurchases14d
newToBrandPurchasesClicks
newToBrandPurchasesPercentage
newToBrandPurchasesPercentage14d
newToBrandPurchasesRate
newToBrandPurchasesViews
newToBrandSales
newToBrandSales14d
newToBrandSalesClicks
newToBrandSalesPercentage
newToBrandSalesPercentage14d
newToBrandSalesViews
newToBrandUnitsSold
newToBrandUnitsSold14d
newToBrandUnitsSoldClicks
newToBrandUnitsSoldPercentage
newToBrandUnitsSoldPercentage14d
orders14d
ordersClicks14d
placementClassification	default report
portfolioId
productCategory
productName
promotedAsin
promotedSku
purchasedAsin
purchases
purchases14d	default report
purchases1d	default report
purchases30d	default report
purchases7d	default report
purchasesClicks
purchasesOtherSku14d
purchasesOtherSku1d
purchasesOtherSku30d
purchasesOtherSku7d
purchasesPromoted
purchasesPromotedClicks
purchasesSameSku14d	default report
purchasesSameSku1d	default report
purchasesSameSku30d	default report
purchasesSameSku7d	default report
purchasesViews
qualifiedBorrows	default report
qualifiedBorrowsFromClicks
qualifiedBorrowsFromViews
reach
roas
roasClicks14d
roasClicks7d
royaltyQualifiedBorrows	default report
royaltyQualifiedBorrowsFromClicks
royaltyQualifiedBorrowsFromViews
sales
sales14d	default report
sales1d	default report
sales30d	default report
sales7d	default report
salesBrandHalo
salesBrandHaloClicks
salesClicks
salesClicks14d
salesOtherSku14d
salesOtherSku1d
salesOtherSku30d
salesOtherSku7d
salesPromoted
salesPromotedClicks
salesViews
searchTerm
spend	default report
startDate	default report
targeting
targetingExpression
targetingId
targetingText
targetingType
topOfSearchImpressionShare	default report
unitsSold
unitsSold14d
unitsSoldBrandHalo
unitsSoldBrandHaloClicks
unitsSoldClicks
unitsSoldClicks14d	default report
unitsSoldClicks1d	default report
unitsSoldClicks30d	default report
unitsSoldClicks7d	default report
unitsSoldOtherSku14d
unitsSoldOtherSku1d
unitsSoldOtherSku30d
unitsSoldOtherSku7d
unitsSoldSameSku14d	default report
unitsSoldSameSku1d	default report
unitsSoldSameSku30d	default report
unitsSoldSameSku7d	default report
unitsSoldViews
video5SecondViewRate
video5SecondViews
videoCompleteViews
videoFirstQuartileViews
videoMidpointViews
videoThirdQuartileViews
videoUnmutes
viewClickThroughRate
viewabilityRate
viewableImpressions