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

IDTypeNameDescription
acosNUMERICTotal advertising cost of sales (ACoS)Total advertising cost of sales (cost divided by 14-day sales revenue)
adnetwork_conversionsNUMERICAd Network ConversionsThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)
adnetwork_revenueNUMERICAd Network RevenueThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)
attributedconversions14dNUMERICAttributed conversions (14 days)Total number of attributed conversion events occurring within 14 days of ad click
attributedconversions1dNUMERICAttributed conversions (1 day)Total number of attributed conversion events occurring within 24 hours of ad click
attributedconversions30dNUMERICAttributed conversions (30 days)Total number of attributed conversion events occurring within 30 days of ad click
attributedconversions7dNUMERICAttributed conversions (7 days)Total number of attributed conversion events occurring within 7 days of ad click
attributedorderratenewtobrand14dNUMERICAttributed 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)
attributedordersnewtobrand14dNUMERICAttributed new-to-brand orders (14 days)The number of first-time orders for products within the brand over a one-year lookback window
attributedordersnewtobrandpercentage14dNUMERICAttributed new-to-brand orders share (14 days)The percentage of total orders that are new-to-brand orders
attributedsales14dNUMERICAttributed sales (14 days)Aggregate value of attributed sales occurring within 14 days of click on ad
attributedsales1dNUMERICAttributed sales (1 day)Aggregate value of attributed sales occurring within 24 hours of click on ad
attributedsales30dNUMERICAttributed sales (30 days)Aggregate value of attributed sales occurring within 30 days of click on ad
attributedsales7dNUMERICAttributed sales (7 days)Aggregate value of attributed sales occurring within 7 days of click on ad
attributedsalesnewtobrand14dNUMERICAttributed new-to-brand sales (14 days)Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad
attributedsalesnewtobrandpercentage14dNUMERICAttributed new-to-brand sales share (14 days)The percentage of total sales of new-to-brand purchases
attributedunitsordered14dNUMERICAttributed units ordered (14 days)Total number of attributed units ordered within 14 days of ad click
attributedunitsordered1dNUMERICAttributed units ordered (1 day)Total number of attributed units ordered within 24 hours of ad click
attributedunitsordered30dNUMERICAttributed units ordered (30 days)Total number of attributed units ordered within 30 days of ad click
attributedunitsordered7dNUMERICAttributed units ordered (7 days)Total number of attributed units ordered within 7 days of ad click
attributedunitsorderednewtobrand14dNUMERICAttributed 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 window
attributedunitsorderednewtobrandpercentage14dNUMERICAttributed new-to-brand units ordered share (14 days)The percentage of total units that are units from new-to-brand orders
attributedunitssold14dNUMERICAttributed units sold (14 days)Number of attributed units sold occurring within 14 days of click on an ad
campaignTEXTCampaign nameThe name of the campaign
campaignadformatTEXTCampaign ad formatCampaign ad format (for Sponsored Brands)
campaignbiddingstrategyTEXTCampaign bidding strategyCampaign bidding strategy (for Sponsored Products)
campaignbudgetNUMERICCampaign budgetTotal budget allotted to the campaign (for Sponsored Brands, Sponsored Display)
campaignbudgettypeTEXTCampaign budget typeOne of: daily or lifetime (for Sponsored Brands, Sponsored Display)
campaigndailybudgetNUMERICCampaign daily budgetTotal daily budget for the campaign (for Sponsored Products)
campaignidTEXTCampaign IDThe unique identifier of the campaign
campaignstatusTEXTCampaign statusThe current status of the campaign
campaigntacticTEXTCampaign tacticCampaign tactic code (for Sponsored Display)
campaigntargetingtypeTEXTCampaign targeting typeCampaign targeting type (for Sponsored Products)
campaigntypeTEXTCampaign typeOne of: Sponsored Brands, Sponsored Display, Sponsored Products
clicksNUMERICClicksTotal number of ad clicks
costNUMERICCostTotal cost of all ad clicks
cpcNUMERICCPCCost-per-click (CPC)
ctrNUMERICCTRClick-through rate (CTR)
currencyTEXTCurrencyThe currency code associated with the campaign
dateDATEDateDate
impressionsNUMERICImpressionsTotal number of ad impressions
marketplaceTEXTMarketplaceAmazon marketplace (country) name
profileidTEXTProfile IDAmazon Advertising profile ID
roasNUMERICTotal return on advertising spend (RoAS)Total return on advertising spend (14-day sales revenue divided by cost)
spendNUMERICSpend (alias for Cost)Alias for Cost
totalcostNUMERICTotal Cost (alias for Cost)Alias for Cost