> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/amazon-ads/amazon-ads-supported-columns.md).

# 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](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/amazon-ads.md) 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`                      |                   |