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
dateDATEDateDate
marketplaceTEXTMarketplaceAmazon marketplace (country) name
profileidTEXTProfile IDAmazon Advertising profile ID
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 Remarketing: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Ad Network ConversionsThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)sponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Ad Network RevenueThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)sponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed conversions (1 day)Total number of attributed conversion events occurring within 24 hours of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed conversions (30 days)Total number of attributed conversion events occurring within 30 days of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed conversions (7 days)Total number of attributed conversion events occurring within 7 days of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed sales (1 day)Aggregate value of attributed sales occurring within 24 hours of click on adsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed sales (30 days)Aggregate value of attributed sales occurring within 30 days of click on adsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed sales (7 days)Aggregate value of attributed sales occurring within 7 days of click on adsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed units ordered (14 days)Total number of attributed units ordered within 14 days of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed units ordered (1 day)Total number of attributed units ordered within 24 hours of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed units ordered (30 days)Total number of attributed units ordered within 30 days of ad clicksponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Attributed units ordered (7 days)Total number of attributed units ordered within 7 days of ad clicksponsored_display_campaign_remarketing
TEXTSponsored Display Campaign Remarketing: CampaignThe name of the campaignsponsored_display_campaign_remarketing
TEXTSponsored Display Campaign Remarketing: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_display_campaign_remarketing
TEXTSponsored Display Campaign Remarketing: Campaign tacticCampaign tactic codesponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: ClicksTotal number of ad clickssponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: CostTotal cost of all ad clickssponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: CPCCost-per-click (CPC)sponsored_display_campaign_remarketing
PERCENTSponsored Display Campaign Remarketing: CTRClick-through rate (CTR)sponsored_display_campaign_remarketing
TEXTSponsored Display Campaign Remarketing: CurrencyThe currency code associated with the campaignsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: ImpressionsTotal number of ad impressionssponsored_display_campaign_remarketing
PERCENTSponsored Display Campaign Remarketing: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Spend (alias for Cost)Alias for Costsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign Remarketing: Total CostAlias for Costsponsored_display_campaign_remarketing
NUMERICSponsored Display Campaign T00001: Total advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)sponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: Attributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on adsponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: Attributed units sold (14 days)Number of attributed units sold occurring within 14 days of click on an adsponsored_display_campaign_t00001
TEXTSponsored Display Campaign T00001: CampaignThe name of the campaignsponsored_display_campaign_t00001
TEXTSponsored Display Campaign T00001: Campaign statusThe current status of the campaignsponsored_display_campaign_t00001
TEXTSponsored Display Campaign T00001: Campaign ID (duplicate)The unique identifier of the campaign. (duplicate)sponsored_display_campaign_t00001
TEXTSponsored Display Campaign T00001: Campaign tacticCampaign tactic codesponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: ClicksTotal number of ad clickssponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: CostTotal cost of all ad clickssponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: CPCCost-per-click (CPC)sponsored_display_campaign_t00001
PERCENTSponsored Display Campaign T00001: CTRClick-through rate (CTR)sponsored_display_campaign_t00001
TEXTSponsored Display Campaign T00001: CurrencyThe currency code associated with the campaignsponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: ImpressionsTotal number of ad impressionssponsored_display_campaign_t00001
PERCENTSponsored Display Campaign T00001: Total return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)sponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: Spend (alias for Cost)Alias for Costsponsored_display_campaign_t00001
NUMERICSponsored Display Campaign T00001: Total CostAlias for Costsponsored_display_campaign_t00001
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 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
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
NUMERICSponsored Display Campaign T00020: CPCCost-per-click (CPC)sponsored_display_campaign_t00020
PERCENTSponsored Display Campaign T00020: CTRClick-through rate (CTR)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 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 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
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
NUMERICSponsored Display Campaign T00030: CPCCost-per-click (CPC)sponsored_display_campaign_t00030
PERCENTSponsored Display Campaign T00030: CTRClick-through rate (CTR)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 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