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
ID | Type | Name | Description |
---|---|---|---|
account_id | TEXT | Account ID | The Account ID |
account_name | TEXT | Account Name | The Account Name |
acos | NUMERIC | Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
adnetwork_conversions | NUMERIC | Ad Network Conversions | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
adnetwork_revenue | NUMERIC | Ad Network Revenue | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
attributedconversions14d | NUMERIC | Attributed conversions (14 days) | Total number of attributed conversion events occurring within 14 days of ad click |
attributedconversions1d | NUMERIC | Attributed conversions (1 day) | Total number of attributed conversion events occurring within 24 hours of ad click |
attributedconversions30d | NUMERIC | Attributed conversions (30 days) | Total number of attributed conversion events occurring within 30 days of ad click |
attributedconversions7d | NUMERIC | Attributed conversions (7 days) | Total number of attributed conversion events occurring within 7 days of ad click |
attributedorderratenewtobrand14d | NUMERIC | 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) |
attributedordersnewtobrand14d | NUMERIC | Attributed new-to-brand orders (14 days) | The number of first-time orders for products within the brand over a one-year lookback window |
attributedordersnewtobrandpercentage14d | NUMERIC | Attributed new-to-brand orders share (14 days) | The percentage of total orders that are new-to-brand orders |
attributedsales14d | NUMERIC | Attributed sales (14 days) | Aggregate value of attributed sales occurring within 14 days of click on ad |
attributedsales1d | NUMERIC | Attributed sales (1 day) | Aggregate value of attributed sales occurring within 24 hours of click on ad |
attributedsales30d | NUMERIC | Attributed sales (30 days) | Aggregate value of attributed sales occurring within 30 days of click on ad |
attributedsales7d | NUMERIC | Attributed sales (7 days) | Aggregate value of attributed sales occurring within 7 days of click on ad |
attributedsalesnewtobrand14d | NUMERIC | Attributed new-to-brand sales (14 days) | Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad |
attributedsalesnewtobrandpercentage14d | NUMERIC | Attributed new-to-brand sales share (14 days) | The percentage of total sales of new-to-brand purchases |
attributedunitsordered14d | NUMERIC | Attributed units ordered (14 days) | Total number of attributed units ordered within 14 days of ad click |
attributedunitsordered1d | NUMERIC | Attributed units ordered (1 day) | Total number of attributed units ordered within 24 hours of ad click |
attributedunitsordered30d | NUMERIC | Attributed units ordered (30 days) | Total number of attributed units ordered within 30 days of ad click |
attributedunitsordered7d | NUMERIC | Attributed units ordered (7 days) | Total number of attributed units ordered within 7 days of ad click |
attributedunitsorderednewtobrand14d | NUMERIC | 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 window |
attributedunitsorderednewtobrandpercentage14d | NUMERIC | Attributed new-to-brand units ordered share (14 days) | The percentage of total units that are units from new-to-brand orders |
attributedunitssold14d | NUMERIC | Attributed units sold (14 days) | Number of attributed units sold occurring within 14 days of click on an ad |
campaign | TEXT | Campaign | The name of the campaign |
campaign_budget | NUMERIC | Campaign budget | Total budget allotted to the campaign (for Sponsored Brands, Sponsored Display) |
campaign_budget_type | TEXT | Campaign budget type | One of: daily or lifetime (for Sponsored Brands, Sponsored Display) |
campaign_status | TEXT | Campaign status | The current status of the campaign |
campaignadformat | TEXT | Campaign ad format | Campaign ad format (for Sponsored Brands) |
campaignbiddingstrategy | TEXT | Campaign bidding strategy | Campaign bidding strategy (for Sponsored Products) |
campaigndailybudget | NUMERIC | Campaign daily budget | Total daily budget for the campaign (for Sponsored Products) |
campaignid | TEXT | Campaign ID (duplicate) | The unique identifier of the campaign. (duplicate) |
campaigntactic | TEXT | Campaign tactic | Campaign tactic code (for Sponsored Display) |
campaigntargetingtype | TEXT | Campaign targeting type | Campaign targeting type (for Sponsored Products) |
campaigntype | TEXT | Campaign type | One of: Sponsored Brands, Sponsored Display, Sponsored Products |
clicks | NUMERIC | Clicks | Total number of ad clicks |
cost | NUMERIC | Cost | Total cost of all ad clicks |
cpc | NUMERIC | CPC | Cost-per-click (CPC) |
ctr | PERCENT | CTR | Click-through rate (CTR) |
currency | TEXT | Currency | The currency code associated with the campaign |
date | DATE | Date | Date |
impressions | NUMERIC | Impressions | Total number of ad impressions |
marketplace | TEXT | Marketplace | Amazon marketplace (country) name |
profileid | TEXT | Profile ID | Amazon Advertising profile ID |
roas | PERCENT | Total return on advertising spend (RoAS) | Total return on advertising spend (14-day sales revenue divided by cost) |
spend | NUMERIC | Spend (alias for Cost) | Alias for Cost |
totalcost | NUMERIC | Total Cost | Alias for Cost |