Amazon Ads Field Reference

Sample

 

http://connectors.windsor.ai/amazon_ads?fields=date,campaigntype,campaignname,totalcost,clicks&api_key=[your API key]&date_preset=last_7d

The Amazon Ads connector lets you pull Amazon Ads data on a various breakdown levels. If you specify the fields date_from and date_to it will query the data for absolute date ranges.


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe Account ID
account_nameTEXTAccount NameThe Account Name
ad_typeTEXTAd typeOne of: Sponsored Brands, Sponsored Display, Sponsored Products
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate
day_of_monthTEXTDay of monthDay of the month
marketplaceTEXTMarketplaceAmazon marketplace (country) name
monthTEXTMonthNumber of the month
profileidTEXTProfile IDAmazon Advertising profile ID
sourceTEXTSourceThe name of the Windsor connector returning the row
NUMERICSponsored Brands Campaign Non Video: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_brands_campaign_non_video
PERCENTSponsored Brands Campaign Non Video: Attributed new-to-brand order rate (14 days)The number of new-to-brand orders relative to the number of clicks (New-to-brand order rate = new-to-brand orders / clicks)sponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed new-to-brand orders (14 days)The number of first-time orders for products within the brand over a one-year lookback windowsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed new-to-brand orders share (14 days)The percentage of total orders that are new-to-brand orderssponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed new-to-brand sales (14 days)Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on adsponsored_brands_campaign_non_video
PERCENTSponsored Brands Campaign Non Video: Attributed new-to-brand sales share (14 days)The percentage of total sales of new-to-brand purchasessponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed new-to-brand units ordered (14 days)The number of units from first-time orders for products within the brand over a one-year lookback windowsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed new-to-brand units ordered share (14 days)The percentage of total units that are units from new-to-brand orderssponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Attributed units sold (14 days)Number of attributed units sold occurring within 14 days of click on an adsponsored_brands_campaign_non_video
TEXTSponsored Brands Campaign Non Video: CampaignThe name of the campaignsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Campaign budgetTotal budget allotted to the campaignsponsored_brands_campaign_non_video
TEXTSponsored Brands Campaign Non Video: Campaign budget typeOne of: daily or lifetimesponsored_brands_campaign_non_video
TEXTSponsored Brands Campaign Non Video: Campaign statusThe current status of the campaignsponsored_brands_campaign_non_video
TEXTSponsored Brands Campaign Non Video: Campaign ad formatCampaign ad formatsponsored_brands_campaign_non_video
TEXTSponsored Brands Campaign Non Video: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: ClicksTotal number of ad clickssponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: CostTotal cost of all ad clickssponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: CPCCost-per-click (CPC)sponsored_brands_campaign_non_video
PERCENTSponsored Brands Campaign Non Video: CTRClick-through rate (CTR)sponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: ImpressionsTotal number of ad impressionssponsored_brands_campaign_non_video
PERCENTSponsored Brands Campaign Non Video: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Spend (alias for Cost)Alias for Costsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Non Video: Total CostAlias for Costsponsored_brands_campaign_non_video
NUMERICSponsored Brands Campaign Video: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_brands_campaign_video
TEXTSponsored Brands Campaign Video: CampaignThe name of the campaignsponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: Campaign budgetTotal budget allotted to the campaignsponsored_brands_campaign_video
TEXTSponsored Brands Campaign Video: Campaign budget typeOne of: daily or lifetimesponsored_brands_campaign_video
TEXTSponsored Brands Campaign Video: Campaign statusThe current status of the campaignsponsored_brands_campaign_video
TEXTSponsored Brands Campaign Video: Campaign ad formatCampaign ad formatsponsored_brands_campaign_video
TEXTSponsored Brands Campaign Video: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: ClicksTotal number of ad clickssponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: CostTotal cost of all ad clickssponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: CPCCost-per-click (CPC)sponsored_brands_campaign_video
PERCENTSponsored Brands Campaign Video: CTRClick-through rate (CTR)sponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: ImpressionsTotal number of ad impressionssponsored_brands_campaign_video
PERCENTSponsored Brands Campaign Video: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: Spend (alias for Cost)Alias for Costsponsored_brands_campaign_video
NUMERICSponsored Brands Campaign Video: Total CostAlias for Costsponsored_brands_campaign_video
NUMERICSponsored Display Campaign T00020: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Ad Network ConversionsThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Ad Network RevenueThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Branded Searches (14 days)The number of searches that included the name of your brand occurring within 14 days of an ad click.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Conversions Same SKU (14 days)Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Conversions Same SKU (1 day)Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Conversions Same SKU (30 days)Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Conversions Same SKU (7 days)Number of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Detail Page View (14 days)This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Sales Same SKU (14 days)Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Sales Same SKU (1 day)Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Sales Same SKU (30 days)Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed Sales Same SKU (7 days)Total value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed conversions (1 day)Total number of attributed conversion events occurring within 24 hours of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed conversions (30 days)Total number of attributed conversion events occurring within 30 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed conversions (7 days)Total number of attributed conversion events occurring within 7 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed new-to-brand orders (14 days)The number of first-time orders for products within the brand over a one-year lookback windowsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed sales (1 day)Aggregate value of attributed sales occurring within 24 hours of click on adsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed sales (30 days)Aggregate value of attributed sales occurring within 30 days of click on adsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed sales (7 days)Aggregate value of attributed sales occurring within 7 days of click on adsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed new-to-brand sales (14 days)Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on adsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed units ordered (14 days)Total number of attributed units ordered within 14 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed units ordered (1 day)Total number of attributed units ordered within 24 hours of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed units ordered (30 days)Total number of attributed units ordered within 30 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed units ordered (7 days)Total number of attributed units ordered within 7 days of ad clicksponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Attributed new-to-brand units ordered (14 days)The number of units from first-time orders for products within the brand over a one-year lookback windowsponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: CampaignThe name of the campaignsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Campaign BudgetTotal budget allocated to the campaign.sponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: Campaign StatusCurrent status of the campaign. One of active, paused, or archived.sponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: Campaign tacticCampaign tactic codesponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: ClicksTotal number of ad clickssponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: CostTotal cost of all ad clickssponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: Cost TypeDetermines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: CPCCost-per-click (CPC)sponsored_display_campaign_t00020
PERCENTSponsored Display Campaign T00020: CTRClick-through rate (CTR)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Cumulative ReachTotal 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.sponsored_display_campaign_t00020
TEXTSponsored Display Campaign T00020: CurrencyThe currency code associated with the campaignsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: ImpressionsTotal number of ad impressionssponsored_display_campaign_t00020
PERCENTSponsored Display Campaign T00020: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Spend (alias for Cost)Alias for Costsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Total CostAlias for Costsponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: VCTRClick-through rate for views (clicks divided by views)sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Video Complete ViewsThe number of impressions where the video was viewed to 100%.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Video First Quartile ViewsThe number of impressions where the video was viewed to 25%.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Video Midpoint ViewsThe number of impressions where the video was viewed to 50%.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Video Third Quartile ViewsThe number of impressions where the video was viewed to 75%.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: Video UnmutesThe number of impressions where a customer unmuted the video.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Branded Searches (14 days)For Sponsored Display vCPM campaigns, this is the number of searches that included the name of your brand occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedBrandedSearches14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Conversions (14 days)For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Detail Page View (14 days)This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Orders New To Brand (14 days)For Sponsored Display vCPM campaigns, the number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. For CPC campaigns, this value is equal to attributedOrdersNewToBrand14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Sales (14 days)For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Sales New To Brand (14 days)For Sponsored Display vCPM campaigns, the total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. For CPC campaigns, this value is equal to attributedSalesNewToBrand14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Units Ordered (14 days)For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedUnitsOrdered14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View Attributed Units Ordered New To Brand (14 days)For Sponsored Display vCPM campaigns, the 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. For CPC campaigns, this value is equal to attributedUnitsOrderedNewToBrand14d.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: View ImpressionsThe total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.sponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00020: TODOTODosponsored_display_campaign_t00020
NUMERICSponsored Display Campaign T00030: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Ad Network ConversionsThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Ad Network RevenueThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Branded Searches (14 days)The number of searches that included the name of your brand occurring within 14 days of an ad click.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Conversions Same SKU (14 days)Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Conversions Same SKU (1 day)Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Conversions Same SKU (30 days)Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Conversions Same SKU (7 days)Number of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Detail Page View (14 days)This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Sales Same SKU (14 days)Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Sales Same SKU (1 day)Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Sales Same SKU (30 days)Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed Sales Same SKU (7 days)Total value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed conversions (1 day)Total number of attributed conversion events occurring within 24 hours of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed conversions (30 days)Total number of attributed conversion events occurring within 30 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed conversions (7 days)Total number of attributed conversion events occurring within 7 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed new-to-brand orders (14 days)The number of first-time orders for products within the brand over a one-year lookback windowsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed sales (1 day)Aggregate value of attributed sales occurring within 24 hours of click on adsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed sales (30 days)Aggregate value of attributed sales occurring within 30 days of click on adsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed sales (7 days)Aggregate value of attributed sales occurring within 7 days of click on adsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed new-to-brand sales (14 days)Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on adsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed units ordered (14 days)Total number of attributed units ordered within 14 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed units ordered (1 day)Total number of attributed units ordered within 24 hours of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed units ordered (30 days)Total number of attributed units ordered within 30 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed units ordered (7 days)Total number of attributed units ordered within 7 days of ad clicksponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Attributed new-to-brand units ordered (14 days)The number of units from first-time orders for products within the brand over a one-year lookback windowsponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: CampaignThe name of the campaignsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Campaign BudgetTotal budget allocated to the campaign.sponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: Campaign StatusCurrent status of the campaign. One of active, paused, or archived.sponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: Campaign tacticCampaign tactic codesponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: ClicksTotal number of ad clickssponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: CostTotal cost of all ad clickssponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: Cost TypeDetermines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: CPCCost-per-click (CPC)sponsored_display_campaign_t00030
PERCENTSponsored Display Campaign T00030: CTRClick-through rate (CTR)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Cumulative ReachTotal 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.sponsored_display_campaign_t00030
TEXTSponsored Display Campaign T00030: CurrencyThe currency code associated with the campaignsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: ImpressionsTotal number of ad impressionssponsored_display_campaign_t00030
PERCENTSponsored Display Campaign T00030: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Spend (alias for Cost)Alias for Costsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Total CostAlias for Costsponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: VCTRClick-through rate for views (clicks divided by views)sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Video Complete ViewsThe number of impressions where the video was viewed to 100%.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Video First Quartile ViewsThe number of impressions where the video was viewed to 25%.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Video Midpoint ViewsThe number of impressions where the video was viewed to 50%.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Video Third Quartile ViewsThe number of impressions where the video was viewed to 75%.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: Video UnmutesThe number of impressions where a customer unmuted the video.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Branded Searches (14 days)For Sponsored Display vCPM campaigns, this is the number of searches that included the name of your brand occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedBrandedSearches14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Conversions (14 days)For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Detail Page View (14 days)This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Orders New To Brand (14 days)For Sponsored Display vCPM campaigns, the number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. For CPC campaigns, this value is equal to attributedOrdersNewToBrand14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Sales (14 days)For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Sales New To Brand (14 days)For Sponsored Display vCPM campaigns, the total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. For CPC campaigns, this value is equal to attributedSalesNewToBrand14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Units Ordered (14 days)For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedUnitsOrdered14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View Attributed Units Ordered New To Brand (14 days)For Sponsored Display vCPM campaigns, the 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. For CPC campaigns, this value is equal to attributedUnitsOrderedNewToBrand14d.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: View ImpressionsThe total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.sponsored_display_campaign_t00030
NUMERICSponsored Display Campaign T00030: TODOTODosponsored_display_campaign_t00030
NUMERICSponsored Products Campaign: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_products_campaign
NUMERICSponsored Products Campaign: Ad Network ConversionsThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)sponsored_products_campaign
NUMERICSponsored Products Campaign: Ad Network RevenueThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)sponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed conversions (1 day)Total number of attributed conversion events occurring within 24 hours of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed conversions (30 days)Total number of attributed conversion events occurring within 30 days of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed conversions (7 days)Total number of attributed conversion events occurring within 7 days of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed sales (1 day)Aggregate value of attributed sales occurring within 24 hours of click on adsponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed sales (30 days)Aggregate value of attributed sales occurring within 30 days of click on adsponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed sales (7 days)Aggregate value of attributed sales occurring within 7 days of click on adsponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed units ordered (14 days)Total number of attributed units ordered within 14 days of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed units ordered (1 day)Total number of attributed units ordered within 24 hours of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed units ordered (30 days)Total number of attributed units ordered within 30 days of ad clicksponsored_products_campaign
NUMERICSponsored Products Campaign: Attributed units ordered (7 days)Total number of attributed units ordered within 7 days of ad clicksponsored_products_campaign
TEXTSponsored Products Campaign: CampaignThe name of the campaignsponsored_products_campaign
NUMERICSponsored Products Campaign: Campaign budgetTotal budget allotted to the campaignsponsored_products_campaign
TEXTSponsored Products Campaign: Campaign statusThe current status of the campaignsponsored_products_campaign
TEXTSponsored Products Campaign: Campaign bidding strategyCampaign bidding strategysponsored_products_campaign
NUMERICSponsored Products Campaign: Campaign daily budgetTotal daily budget for the campaignsponsored_products_campaign
TEXTSponsored Products Campaign: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_products_campaign
TEXTSponsored Products Campaign: Campaign targeting typeCampaign targeting typesponsored_products_campaign
NUMERICSponsored Products Campaign: ClicksTotal number of ad clickssponsored_products_campaign
NUMERICSponsored Products Campaign: CostTotal cost of all ad clickssponsored_products_campaign
NUMERICSponsored Products Campaign: CPCCost-per-click (CPC)sponsored_products_campaign
PERCENTSponsored Products Campaign: CTRClick-through rate (CTR)sponsored_products_campaign
NUMERICSponsored Products Campaign: ImpressionsTotal number of ad impressionssponsored_products_campaign
PERCENTSponsored Products Campaign: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_products_campaign
NUMERICSponsored Products Campaign: Spend (alias for Cost)Alias for Costsponsored_products_campaign
NUMERICSponsored Products Campaign: Total CostAlias for Costsponsored_products_campaign
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20