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 |