Introduction

Datasources and destinations

Fields listing for Amazon Ads

Acos Clicks14d
Advertising cost of sales based on purchases made within 14 days of an ad click.
Field IDacosClicks14d
TypeNUMBER
Data Typemetric
Acos Clicks7d
Advertising cost of sales based on purchases made within 7 days of an ad click.
Field IDacosClicks7d
TypeNUMBER
Data Typemetric
Add To Cart
Number of times shoppers added a brand's products to their cart, attributed to an ad view or click.
Field IDaddToCart
TypeNUMBER
Data Typemetric
Add To Cart Clicks
Number of times shoppers added a brand's products to their cart, attributed to an ad click.
Field IDaddToCartClicks
TypeNUMBER
Data Typemetric
Add To Cart Rate
Calculated by divididing addToCart by impressions.
Field IDaddToCartRate
TypePERCENT
Data Typemetric
Add To Cart Views
Number of times shoppers added the brands' products to their cart, attributed to an ad view.
Field IDaddToCartViews
TypeNUMBER
Data Typemetric
Ad Group Id
Unique numerical ID of the ad group.
Field IDadGroupId
TypeNUMBER
Data Typedimension
Ad Group Name
The name of the ad group as entered by the advertiser.
Field IDadGroupName
TypeTEXT
Data Typedimension
Ad Id
Unique numerical ID of the ad.
Field IDadId
TypeNUMBER
Data Typedimension
Ad Keyword Status
Current status of a keyword.
Field IDadKeywordStatus
TypeTEXT
Data Typedimension
Ad Status
Status of the ad group.
Field IDadStatus
TypeTEXT
Data Typedimension
Advertised Asin
The ASIN associated to an advertised product.
Field IDadvertisedAsin
TypeTEXT
Data Typedimension
Advertised Sku
The SKU being advertised. Not available for vendors.
Field IDadvertisedSku
TypeTEXT
Data Typedimension
Asin Brand Halo
Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised.
Field IDasinBrandHalo
TypeNUMBER
Data Typedimension
Attributed Sales Same Sku14d
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.
Field IDattributedSalesSameSku14d
TypeNUMBER
Data Typemetric
Attributed Sales Same Sku1d
Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised.
Field IDattributedSalesSameSku1d
TypeNUMBER
Data Typemetric
Attributed Sales Same Sku30d
Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDattributedSalesSameSku30d
TypeNUMBER
Data Typemetric
Attributed Sales Same Sku7d
Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDattributedSalesSameSku7d
TypeNUMBER
Data Typemetric
Attribution Type
Describes whether a purchase is attributed to a promoted product or brand-halo effect.
Field IDattributionType
TypeTEXT
Data Typedimension
Bid Optimization
Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions.
Field IDbidOptimization
TypeTEXT
Data Typedimension
Branded Searches
The number of searches that included the name of your brand occurring within 14 days of an ad click or view.
Field IDbrandedSearches
TypeNUMBER
Data Typemetric
Branded Searches Clicks
The number of searches that included the name of your brand occurring within 14 days of an ad click.
Field IDbrandedSearchesClicks
TypeNUMBER
Data Typemetric
Branded Searches Views
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.
Field IDbrandedSearchesViews
TypeNUMBER
Data Typemetric
Branded Search Rate
Rate of Branded Searches relative to the number of impressions. (BS/Impressions)
Field IDbrandedSearchRate
TypePERCENT
Data Typemetric
Campaign Applicable Budget Rule Id
The ID associated to the active budget rule for a campaign.
Field IDcampaignApplicableBudgetRuleId
TypeTEXT
Data Typedimension
Campaign Applicable Budget Rule Name
The name associated to the active budget rule for a campaign.
Field IDcampaignApplicableBudgetRuleName
TypeTEXT
Data Typedimension
Campaign Bidding Strategy
The bidding strategy associated with a campaign.
Field IDcampaignBiddingStrategy
TypeTEXT
Data Typedimension
Campaign Budget Amount
Total budget allocated to the campaign.
Field IDcampaignBudgetAmount
TypeNUMBER
Data Typedimension
Campaign Budget Currency Code
The currency code associated with the campaign.
Field IDcampaignBudgetCurrencyCode
TypeTEXT
Data Typedimension
Campaign Budget Type
One of daily or lifetime.
Field IDcampaignBudgetType
TypeTEXT
Data Typedimension
Campaign Id
The ID associated with a campaign.
Field IDcampaignId
TypeNUMBER
Data Typedimension
Campaign Name
The name associated with a campaign.
Field IDcampaignName
TypeTEXT
Data Typedimension
Campaign Rule Based Budget Amount
The value of the rule-based budget for a campaign.
Field IDcampaignRuleBasedBudgetAmount
TypeNUMBER
Data Typedimension
Campaign Status
The status of a campaign.
Field IDcampaignStatus
TypeTEXT
Data Typedimension
Clicks
Total number of clicks on an ad.
Field IDclicks
TypeNUMBER
Data Typemetric
Click Through Rate
Clicks divided by impressions.
Field IDclickThroughRate
TypePERCENT
Data Typemetric
Conversions Brand Halo
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.
Field IDconversionsBrandHalo
TypeNUMBER
Data Typemetric
Conversions Brand Halo Clicks
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.
Field IDconversionsBrandHaloClicks
TypeNUMBER
Data Typemetric
Cost
Total cost of ad clicks.
Field IDcost
TypeNUMBER
Data Typemetric
Cost Per Click
Total cost divided by total number of clicks.
Field IDcostPerClick
TypeNUMBER
Data Typemetric
Cost Per Thousand Impressions
The cost per thousand impressions.
Field IDcostPerThousandImpressions
TypeNUMBER
Data Typemetric
Cost Type
Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).
Field IDcostType
TypeTEXT
Data Typedimension
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.
Field IDcumulativeReach
TypeNUMBER
Data Typemetric
Date Reported By Amazon Report
Date when the ad activity ocurred in the format YYYY-MM-DD.
Field IDdate
TypeTEXT
Data Typemetric
Detail Page Views
Number of detail page views occurring within 14 days of an ad click or view.
Field IDdetailPageViews
TypeNUMBER
Data Typemetric
Detail Page Views Clicks
Number of detail page views occurring within 14 days of an ad click.
Field IDdetailPageViewsClicks
TypeNUMBER
Data Typemetric
Detail Page Views Views
The number of times a product detail page was viewed attributed to an ad view.
Field IDdetailPageViewsViews
TypeNUMBER
Data Typemetric
E C P Add To Cart
Effect cost per add to cart, calculated by cost divided by add-to-cart.
Field IDeCPAddToCart
TypeNUMBER
Data Typemetric
E C P Brand Search
Effective (average) cost to acquire a Branded Search.
Field IDeCPBrandSearch
TypeNUMBER
Data Typemetric
End Date of report
End date of summary period for a report in the format YYYY-MM-DD.
Field IDendDate
TypeTEXT
Data Typemetric
Gross Click Throughs
The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks.
Field IDgrossClickThroughs
TypeNUMBER
Data Typemetric
Gross Impressions
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.
Field IDgrossImpressions
TypeNUMBER
Data Typemetric
Impressions
Total number of ad impressions.
Field IDimpressions
TypeNUMBER
Data Typemetric
Impressions Frequency Average
Average number of times unique users were exposed to an ad over the lifetime of the campaign.
Field IDimpressionsFrequencyAverage
TypeNUMBER
Data Typemetric
Impressions Views
The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.
Field IDimpressionsViews
TypeNUMBER
Data Typemetric
Invalid Click Through Rate
The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)
Field IDinvalidClickThroughRate
TypePERCENT
Data Typemetric
Invalid Click Throughs
Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic.
Field IDinvalidClickThroughs
TypeNUMBER
Data Typemetric
Invalid Impression Rate
The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)
Field IDinvalidImpressionRate
TypePERCENT
Data Typemetric
Invalid Impressions
The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic.
Field IDinvalidImpressions
TypeNUMBER
Data Typemetric
Keyword
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.
Field IDkeyword
TypeTEXT
Data Typedimension
Keyword Bid
Bid associated with a keyword or targeting expression.
Field IDkeywordBid
TypeNUMBER
Data Typedimension
Keyword Id
ID associated with a keyword or targeting expression.
Field IDkeywordId
TypeNUMBER
Data Typedimension
Keyword Text
Text of the keyword.
Field IDkeywordText
TypeTEXT
Data Typedimension
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: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED.
Field IDkeywordType
TypeTEXT
Data Typedimension
Kindle Edition Normalized Pages Read14d
Number of attributed Kindle edition normalized pages read within 14 days of ad click.
Field IDkindleEditionNormalizedPagesRead14d
TypeNUMBER
Data Typemetric
Kindle Edition Normalized Pages Royalties14d
The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click.
Field IDkindleEditionNormalizedPagesRoyalties14d
TypeNUMBER
Data Typemetric
Matched Target Asin
The ASIN associated with the product page where a Sponsored Display ad appeared.
Field IDmatchedTargetAsin
TypeTEXT
Data Typedimension
Match 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: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED.
Field IDmatchType
TypeTEXT
Data Typedimension
New To Brand Detail Page View Clicks
Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.
Field IDnewToBrandDetailPageViewClicks
TypeNUMBER
Data Typemetric
New To Brand Detail Page View Rate
Calculated by dividing newToBrandDetailPageViews / impressions.
Field IDnewToBrandDetailPageViewRate
TypePERCENT
Data Typemetric
New To Brand Detail Page Views
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.
Field IDnewToBrandDetailPageViews
TypeNUMBER
Data Typemetric
New To Brand Detail Page Views Clicks
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.
Field IDnewToBrandDetailPageViewsClicks
TypeNUMBER
Data Typemetric
New To Brand Detail Page View Views
Number of new-to-brand detail page views for all the brands' products, attributed to an ad view
Field IDnewToBrandDetailPageViewViews
TypeNUMBER
Data Typemetric
New To Brand E C P Detail Page View
Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view.
Field IDnewToBrandECPDetailPageView
TypeNUMBER
Data Typemetric
New To Brand Purchases
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.
Field IDnewToBrandPurchases
TypeNUMBER
Data Typemetric
New To Brand Purchases14d
The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.
Field IDnewToBrandPurchases14d
TypeNUMBER
Data Typemetric
New To Brand Purchases Clicks
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.
Field IDnewToBrandPurchasesClicks
TypeNUMBER
Data Typemetric
New To Brand Purchases Percentage
The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.
Field IDnewToBrandPurchasesPercentage
TypeNUMBER
Data Typemetric
New To Brand Purchases Percentage14d
The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.
Field IDnewToBrandPurchasesPercentage14d
TypeNUMBER
Data Typemetric
New To Brand Purchases Rate
The percentage of total orders that are new-to-brand orders. Not available for book vendors.
Field IDnewToBrandPurchasesRate
TypeNUMBER
Data Typemetric
New To Brand Purchases Views
The number of new to branch purchases attributed to an ad view.
Field IDnewToBrandPurchasesViews
TypeNUMBER
Data Typemetric
New To Brand Sales
Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors.
Field IDnewToBrandSales
TypeNUMBER
Data Typemetric
New To Brand Sales14d
Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
Field IDnewToBrandSales14d
TypeNUMBER
Data Typemetric
New To Brand Sales Clicks
Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.
Field IDnewToBrandSalesClicks
TypeNUMBER
Data Typemetric
New To Brand Sales Percentage
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.
Field IDnewToBrandSalesPercentage
TypeNUMBER
Data Typemetric
New To Brand Sales Percentage14d
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.
Field IDnewToBrandSalesPercentage14d
TypeNUMBER
Data Typemetric
New To Brand Sales Views
Total value of sales by new to brand customers occurring within 14 days of an ad view.
Field IDnewToBrandSalesViews
TypeNUMBER
Data Typemetric
New To Brand Units Sold
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.
Field IDnewToBrandUnitsSold
TypeNUMBER
Data Typemetric
New To Brand Units Sold14d
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.
Field IDnewToBrandUnitsSold14d
TypeNUMBER
Data Typemetric
New To Brand Units Sold Clicks
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.
Field IDnewToBrandUnitsSoldClicks
TypeNUMBER
Data Typemetric
New To Brand Units Sold Percentage
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.
Field IDnewToBrandUnitsSoldPercentage
TypePERCENT
Data Typemetric
New To Brand Units Sold Percentage14d
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.
Field IDnewToBrandUnitsSoldPercentage14d
TypePERCENT
Data Typemetric
Orders14d
Number of orders within the last 14 days.
Field IDorders14d
TypeNUMBER
Data Typemetric
Placement Classification
The page location where an ad appeared.
Field IDplacementClassification
TypeTEXT
Data Typedimension
Portfolio Id
The portfolio the campaign is associated with.
Field IDportfolioId
TypeNUMBER
Data Typedimension
Product Category
The category the product is associated with on Amazon.
Field IDproductCategory
TypeTEXT
Data Typedimension
Product Name
The name of the product.
Field IDproductName
TypeTEXT
Data Typedimension
Promoted Asin
The ASIN associated to an advertised product.
Field IDpromotedAsin
TypeTEXT
Data Typedimension
Promoted Sku
The SKU being advertised. Not available for vendors.
Field IDpromotedSku
TypeTEXT
Data Typedimension
Purchased Asin
The ASIN of the product that was purchased.
Field IDpurchasedAsin
TypeTEXT
Data Typedimension
Purchases
Number of attributed conversion events occurring within 14 days of an ad click or view.
Field IDpurchases
TypeNUMBER
Data Typemetric
Purchases14d
Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only.
Field IDpurchases14d
TypeNUMBER
Data Typemetric
Purchases1d
Number of attributed conversion events occurring within 1 day of an ad click.
Field IDpurchases1d
TypeNUMBER
Data Typemetric
Purchases30d
Number of attributed conversion events occurring within 30 days of an ad click.
Field IDpurchases30d
TypeNUMBER
Data Typemetric
Purchases7d
Number of attributed conversion events occurring within 7 days of an ad click.
Field IDpurchases7d
TypeNUMBER
Data Typemetric
Purchases Clicks
Number of attributed conversion events occurring within 14 days of an ad click.
Field IDpurchasesClicks
TypeNUMBER
Data Typemetric
Purchases Other Sku14d
Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU.
Field IDpurchasesOtherSku14d
TypeNUMBER
Data Typemetric
Purchases Other Sku1d
Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU.
Field IDpurchasesOtherSku1d
TypeNUMBER
Data Typemetric
Purchases Other Sku30d
Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU.
Field IDpurchasesOtherSku30d
TypeNUMBER
Data Typemetric
Purchases Other Sku7d
Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU.
Field IDpurchasesOtherSku7d
TypeNUMBER
Data Typemetric
Purchases Promoted
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.
Field IDpurchasesPromoted
TypeNUMBER
Data Typemetric
Purchases Promoted Clicks
Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDpurchasesPromotedClicks
TypeNUMBER
Data Typemetric
Purchases Same Sku14d
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.
Field IDpurchasesSameSku14d
TypeNUMBER
Data Typemetric
Purchases Same Sku1d
Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised.
Field IDpurchasesSameSku1d
TypeNUMBER
Data Typemetric
Purchases Same Sku30d
Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDpurchasesSameSku30d
TypeNUMBER
Data Typemetric
Purchases Same Sku7d
Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDpurchasesSameSku7d
TypeNUMBER
Data Typemetric
Purchases Views
Number of attributed conversion events occurring within 14 days of an ad view.
Field IDpurchasesViews
TypeNUMBER
Data Typemetric
Roas
Return on ad spend.
Field IDroas
TypeNUMBER
Data Typemetric
Roas Clicks14d
Return on ad spend based on purchases made within 14 days of an ad click.
Field IDroasClicks14d
TypeNUMBER
Data Typemetric
Roas Clicks7d
Return on ad spend based on purchases made within 7 days of an ad click.
Field IDroasClicks7d
TypeNUMBER
Data Typemetric
Sales
Total value of sales occurring within 14 days of an ad click or view.
Field IDsales
TypeNUMBER
Data Typemetric
Sales14d
Total value of sales occurring within 14 days of an ad click. Sponsored Products only.
Field IDsales14d
TypeNUMBER
Data Typemetric
Sales1d
Total value of sales occurring within 1 day of an ad click.
Field IDsales1d
TypeNUMBER
Data Typemetric
Sales30d
Total value of sales occurring within 30 days of an ad click.
Field IDsales30d
TypeNUMBER
Data Typemetric
Sales7d
Total value of sales occurring within 7 days of an ad click.
Field IDsales7d
TypeNUMBER
Data Typemetric
Sales Brand Halo
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.
Field IDsalesBrandHalo
TypeNUMBER
Data Typemetric
Sales Brand Halo Clicks
Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDsalesBrandHaloClicks
TypeNUMBER
Data Typemetric
Sales Clicks
Total value of sales occurring within 14 days of an ad click.
Field IDsalesClicks
TypeNUMBER
Data Typemetric
Sales Other Sku14d
Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDsalesOtherSku14d
TypeNUMBER
Data Typemetric
Sales Other Sku1d
Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
Field IDsalesOtherSku1d
TypeNUMBER
Data Typemetric
Sales Other Sku30d
Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDsalesOtherSku30d
TypeNUMBER
Data Typemetric
Sales Other Sku7d
Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDsalesOtherSku7d
TypeNUMBER
Data Typemetric
Sales Promoted
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.
Field IDsalesPromoted
TypeNUMBER
Data Typemetric
Sales Promoted Clicks
Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDsalesPromotedClicks
TypeNUMBER
Data Typemetric
Sales Views
Total value of sales occurring within 14 days of an ad view.
Field IDsalesViews
TypeNUMBER
Data Typemetric
Search Term
The search term used by the customer. Same as query.
Field IDsearchTerm
TypeTEXT
Data Typedimension
Spend
Total cost of ad clicks.
Field IDspend
TypeNUMBER
Data Typemetric
Start Date of report
Start date of summary period for a report in the format YYYY-MM-DD.
Field IDstartDate
TypeTEXT
Data Typemetric
Targeting
A string representation of the expression object used in the targeting clause.
Field IDtargeting
TypeTEXT
Data Typedimension
Targeting Expression
A string representation of the expression object used in the targeting clause.
Field IDtargetingExpression
TypeTEXT
Data Typedimension
Targeting Id
The identifier of the targeting expression.
Field IDtargetingId
TypeNUMBER
Data Typedimension
Targeting Text
The text used in the targeting expression.
Field IDtargetingText
TypeTEXT
Data Typedimension
Targeting Type
The type of targeting used in the expression.
Field IDtargetingType
TypeTEXT
Data Typedimension
Top Of Search Impression Share
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.
Field IDtopOfSearchImpressionShare
TypePERCENT
Data Typemetric
Units Sold
Number of attributed units sold within 14 days of an ad click or view.
Field IDunitsSold
TypeNUMBER
Data Typemetric
Units Sold14d
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.
Field IDunitsSold14d
TypeNUMBER
Data Typemetric
Units Sold Brand Halo
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.
Field IDunitsSoldBrandHalo
TypeNUMBER
Data Typemetric
Units Sold Brand Halo Clicks
Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDunitsSoldBrandHaloClicks
TypeNUMBER
Data Typemetric
Units Sold Clicks
Number of attributed units sold within 14 days of an ad click.
Field IDunitsSoldClicks
TypeNUMBER
Data Typemetric
Units Sold Clicks14d
Total number of units ordered within 14 days of an ad click. Same as unitsSold14d
Field IDunitsSoldClicks14d
TypeNUMBER
Data Typemetric
Units Sold Clicks1d
Total number of units ordered within 1 day of an ad click.
Field IDunitsSoldClicks1d
TypeNUMBER
Data Typemetric
Units Sold Clicks30d
Total number of units ordered within 30 days of an ad click.
Field IDunitsSoldClicks30d
TypeNUMBER
Data Typemetric
Units Sold Clicks7d
Total number of units ordered within 7 days of an ad click.
Field IDunitsSoldClicks7d
TypeNUMBER
Data Typemetric
Units Sold Other Sku14d
Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDunitsSoldOtherSku14d
TypeNUMBER
Data Typemetric
Units Sold Other Sku1d
Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised.
Field IDunitsSoldOtherSku1d
TypeNUMBER
Data Typemetric
Units Sold Other Sku30d
Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDunitsSoldOtherSku30d
TypeNUMBER
Data Typemetric
Units Sold Other Sku7d
Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised.
Field IDunitsSoldOtherSku7d
TypeNUMBER
Data Typemetric
Units Sold Same Sku14d
Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDunitsSoldSameSku14d
TypeNUMBER
Data Typemetric
Units Sold Same Sku1d
Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised.
Field IDunitsSoldSameSku1d
TypeNUMBER
Data Typemetric
Units Sold Same Sku30d
Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDunitsSoldSameSku30d
TypeNUMBER
Data Typemetric
Units Sold Same Sku7d
Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
Field IDunitsSoldSameSku7d
TypeNUMBER
Data Typemetric
Units Sold Views
Number of attributed units sold within 14 days of an ad view.
Field IDunitsSoldViews
TypeNUMBER
Data Typemetric
Video5 Second View Rate
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.
Field IDvideo5SecondViewRate
TypePERCENT
Data Typemetric
Video5 Second Views
The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric.
Field IDvideo5SecondViews
TypeNUMBER
Data Typemetric
Video Complete Views
The number of impressions where the video was viewed to 100%.
Field IDvideoCompleteViews
TypeNUMBER
Data Typemetric
Video First Quartile Views
The number of impressions where the video was viewed to 25%.
Field IDvideoFirstQuartileViews
TypeNUMBER
Data Typemetric
Video Midpoint Views
The number of impressions where the video was viewed to 50%.
Field IDvideoMidpointViews
TypeNUMBER
Data Typemetric
Video Third Quartile Views
The number of impressions where the video was viewed to 75%.
Field IDvideoThirdQuartileViews
TypeNUMBER
Data Typemetric
Video Unmutes
The number of impressions where a customer unmuted the video.
Field IDvideoUnmutes
TypeNUMBER
Data Typemetric
Viewability Rate
View-through rate (vtr). Views divided by impressions.
Field IDviewabilityRate
TypePERCENT
Data Typemetric
Viewable Impressions
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.
Field IDviewableImpressions
TypeNUMBER
Data Typemetric
View Click Through Rate
Click-through rate for views (clicks divided by views).
Field IDviewClickThroughRate
TypePERCENT
Data Typemetric
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension