Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Amazon Ads data to
Amazon Ads Connector Reference
241 metrics155 dimensions
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.
The Amazon Ads connector exposes 396 fields (241 metrics, 155 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Enable Campaign Enable a paused Amazon Sponsored Products campaign. Reversible via pause_campaign.
Enable a paused Amazon Sponsored Products campaign. Reversible via pause_campaign.
Parameters
campaign_idstringRequired
Pause Campaign Pause an active Amazon Sponsored Products campaign. Reversible via enable_campaign.
Pause an active Amazon Sponsored Products campaign. Reversible via enable_campaign.
Parameters
campaign_idstringRequired
Set Campaign Budget Set the daily budget of an Amazon Sponsored Products campaign. The amount is in the account currency major unit (e.g. 50 means 50.00, not cents). Sponsored Products campaigns only support daily budgets.
Set the daily budget of an Amazon Sponsored Products campaign. The amount is in the account currency major unit (e.g. 50 means 50.00, not cents). Sponsored Products campaigns only support daily budgets.
Parameters
campaign_idstringRequiredbudgetnumberRequired
Amazon Ads Fields
Amazon Ads sponsored_brands_ad fields
The sponsored_brands_ad report of the Amazon Ads connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_ad__acos | NUMERIC | Sponsored Brands Ad: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by sales) |
| sponsored_brands_ad__ad_group_id | TEXT | Sponsored Brands Ad: Ad Group ID | The ID associated with the ad group. |
| sponsored_brands_ad__ad_group_name | TEXT | Sponsored Brands Ad: Ad Group Name | The name of the ad group. |
| sponsored_brands_ad__ad_id | TEXT | Sponsored Brands Ad: Ad ID | The ID associated with the ad. |
| sponsored_brands_ad__branded_searches | NUMERIC | Sponsored Brands Ad: Branded Searches | Number of searches for keywords associated with the brand. |
| sponsored_brands_ad__campaign_id | TEXT | Sponsored Brands Ad: Campaign ID | The ID associated with a campaign. |
| sponsored_brands_ad__campaign_name | TEXT | Sponsored Brands Ad: Campaign Name | The name of the campaign. |
| sponsored_brands_ad__campaign_status | TEXT | Sponsored Brands Ad: Campaign Status | The state of the campaign. |
| sponsored_brands_ad__clicks | NUMERIC | Sponsored Brands Ad: Clicks | Total number of ad clicks. |
| sponsored_brands_ad__cost | NUMERIC | Sponsored Brands Ad: Cost | Total cost of ad clicks. |
| sponsored_brands_ad__cpc | NUMERIC | Sponsored Brands Ad: CPC | Cost-per-click (CPC) |
| sponsored_brands_ad__ctr | PERCENT | Sponsored Brands Ad: CTR | Click-through rate (CTR) |
| sponsored_brands_ad__detail_page_views | NUMERIC | Sponsored Brands Ad: Detail Page Views | Number of detail page views attributed to the ad. |
| sponsored_brands_ad__impressions | NUMERIC | Sponsored Brands Ad: Impressions | Total number of ad impressions. |
| sponsored_brands_ad__portfolio_id | TEXT | Sponsored Brands Ad: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_ad__portfolio_name | TEXT | Sponsored Brands Ad: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_ad__purchases | NUMERIC | Sponsored Brands Ad: Purchases | Total number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_brands_ad__roas | NUMERIC | Sponsored Brands Ad: Return on advertising spend (RoAS) | Return on advertising spend (sales divided by cost) |
| sponsored_brands_ad__sales | NUMERIC | Sponsored Brands Ad: Sales | Total value of attributed sales occurring within 14 days of an ad click or view. |
Amazon Ads sponsored_brands_ad_group fields
The sponsored_brands_ad_group report of the Amazon Ads connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_ad_group__acos | NUMERIC | Sponsored Brands Ad Group: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by sales) |
| sponsored_brands_ad_group__ad_group_id | TEXT | Sponsored Brands Ad Group: Ad Group ID | The ID associated with the ad group. |
| sponsored_brands_ad_group__ad_group_name | TEXT | Sponsored Brands Ad Group: Ad Group Name | The name of the ad group. |
| sponsored_brands_ad_group__branded_searches | NUMERIC | Sponsored Brands Ad Group: Branded Searches | Number of searches for keywords associated with the brand. |
| sponsored_brands_ad_group__campaign_id | TEXT | Sponsored Brands Ad Group: Campaign ID | The ID associated with a campaign. |
| sponsored_brands_ad_group__campaign_name | TEXT | Sponsored Brands Ad Group: Campaign Name | The name of the campaign. |
| sponsored_brands_ad_group__clicks | NUMERIC | Sponsored Brands Ad Group: Clicks | Total number of ad clicks. |
| sponsored_brands_ad_group__cost | NUMERIC | Sponsored Brands Ad Group: Cost | Total cost of ad clicks. |
| sponsored_brands_ad_group__cpc | NUMERIC | Sponsored Brands Ad Group: CPC | Cost-per-click (CPC) |
| sponsored_brands_ad_group__ctr | PERCENT | Sponsored Brands Ad Group: CTR | Click-through rate (CTR) |
| sponsored_brands_ad_group__detail_page_views | NUMERIC | Sponsored Brands Ad Group: Detail Page Views | Number of detail page views attributed to the ad. |
| sponsored_brands_ad_group__impressions | NUMERIC | Sponsored Brands Ad Group: Impressions | Total number of ad impressions. |
| sponsored_brands_ad_group__portfolio_id | TEXT | Sponsored Brands Ad Group: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_ad_group__portfolio_name | TEXT | Sponsored Brands Ad Group: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_ad_group__purchases | NUMERIC | Sponsored Brands Ad Group: Purchases | Total number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_brands_ad_group__roas | NUMERIC | Sponsored Brands Ad Group: Return on advertising spend (RoAS) | Return on advertising spend (sales divided by cost) |
| sponsored_brands_ad_group__sales | NUMERIC | Sponsored Brands Ad Group: Sales | Total value of attributed sales occurring within 14 days of an ad click or view. |
Amazon Ads sponsored_brands_campaign_non_video fields
The sponsored_brands_campaign_non_video report of the Amazon Ads connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_campaign_non_video__acos | NUMERIC | Sponsored 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__attributedconversions14d | NUMERIC | Sponsored Brands Campaign Non Video: Attributed conversions (14 days) | Total number of attributed conversion events occurring within 14 days of ad click |
| sponsored_brands_campaign_non_video__attributedorderratenewtobrand14d | PERCENT | Sponsored 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__attributedordersnewtobrand14d | NUMERIC | Sponsored 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 window |
| sponsored_brands_campaign_non_video__attributedordersnewtobrandpercentage14d | NUMERIC | Sponsored Brands Campaign Non Video: Attributed new-to-brand orders share (14 days) | The percentage of total orders that are new-to-brand orders |
| sponsored_brands_campaign_non_video__attributedsales14d | NUMERIC | Sponsored Brands Campaign Non Video: Attributed sales (14 days) | Aggregate value of attributed sales occurring within 14 days of click on ad |
| sponsored_brands_campaign_non_video__attributedsalesnewtobrand14d | NUMERIC | Sponsored 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 ad |
| sponsored_brands_campaign_non_video__attributedsalesnewtobrandpercentage14d | PERCENT | Sponsored Brands Campaign Non Video: Attributed new-to-brand sales share (14 days) | The percentage of total sales of new-to-brand purchases |
| sponsored_brands_campaign_non_video__attributedunitsorderednewtobrand14d | NUMERIC | Sponsored 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 window |
| sponsored_brands_campaign_non_video__attributedunitsorderednewtobrandpercentage14d | NUMERIC | Sponsored 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 orders |
| sponsored_brands_campaign_non_video__attributedunitssold14d | NUMERIC | Sponsored Brands Campaign Non Video: Attributed units sold (14 days) | Number of attributed units sold occurring within 14 days of click on an ad |
| sponsored_brands_campaign_non_video__campaign | TEXT | Sponsored Brands Campaign Non Video: Campaign | The name of the campaign |
| sponsored_brands_campaign_non_video__campaign_budget | NUMERIC | Sponsored Brands Campaign Non Video: Campaign budget | Total budget allotted to the campaign |
| sponsored_brands_campaign_non_video__campaign_budget_type | TEXT | Sponsored Brands Campaign Non Video: Campaign budget type | One of: daily or lifetime |
| sponsored_brands_campaign_non_video__campaign_status | TEXT | Sponsored Brands Campaign Non Video: Campaign status | The current status of the campaign |
| sponsored_brands_campaign_non_video__campaignadformat | TEXT | Sponsored Brands Campaign Non Video: Campaign ad format | Campaign ad format |
| sponsored_brands_campaign_non_video__campaignid | TEXT | Sponsored Brands Campaign Non Video: Campaign ID (duplicate) | The unique identifier of the campaign. (duplicate) |
| sponsored_brands_campaign_non_video__clicks | NUMERIC | Sponsored Brands Campaign Non Video: Clicks | Total number of ad clicks |
| sponsored_brands_campaign_non_video__cost | NUMERIC | Sponsored Brands Campaign Non Video: Cost | Total cost of all ad clicks |
| sponsored_brands_campaign_non_video__cpc | NUMERIC | Sponsored Brands Campaign Non Video: CPC | Cost-per-click (CPC) |
| sponsored_brands_campaign_non_video__ctr | PERCENT | Sponsored Brands Campaign Non Video: CTR | Click-through rate (CTR) |
| sponsored_brands_campaign_non_video__impressions | NUMERIC | Sponsored Brands Campaign Non Video: Impressions | Total number of ad impressions |
| sponsored_brands_campaign_non_video__portfolio_id | TEXT | Sponsored Brands Campaign Non Video: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_campaign_non_video__portfolio_name | TEXT | Sponsored Brands Campaign Non Video: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_campaign_non_video__roas | PERCENT | Sponsored 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__spend | NUMERIC | Sponsored Brands Campaign Non Video: Spend (alias for Cost) | Alias for Cost |
| sponsored_brands_campaign_non_video__totalcost | NUMERIC | Sponsored Brands Campaign Non Video: Total Cost | Alias for Cost |
Amazon Ads sponsored_brands_campaign_video fields
The sponsored_brands_campaign_video report of the Amazon Ads connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_campaign_video__acos | NUMERIC | Sponsored Brands Campaign Video: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by sales) |
| sponsored_brands_campaign_video__branded_searches | NUMERIC | Sponsored Brands Campaign Video: Branded Searches | Number of searches that included the name of your brand occurring within 14 days of an ad click or view. |
| sponsored_brands_campaign_video__campaign | TEXT | Sponsored Brands Campaign Video: Campaign | The name of the campaign |
| sponsored_brands_campaign_video__campaign_budget_amount | NUMERIC | Sponsored Brands Campaign Video: Campaign budget Amount | Total budget allotted to the campaign |
| sponsored_brands_campaign_video__campaign_budget_currency_code | TEXT | Sponsored Brands Campaign Video: Campaign budget currency code | The currency code associated with the campaign. |
| sponsored_brands_campaign_video__campaign_budget_type | TEXT | Sponsored Brands Campaign Video: Campaign budget type | One of: daily or lifetime |
| sponsored_brands_campaign_video__campaign_status | TEXT | Sponsored Brands Campaign Video: Campaign status | The current status of the campaign |
| sponsored_brands_campaign_video__campaignadformat | TEXT | Sponsored Brands Campaign Video: Campaign ad format | Campaign ad format |
| sponsored_brands_campaign_video__campaignid | TEXT | Sponsored Brands Campaign Video: Campaign ID (duplicate) | The unique identifier of the campaign. (duplicate) |
| sponsored_brands_campaign_video__clicks | NUMERIC | Sponsored Brands Campaign Video: Clicks | Total number of ad clicks |
| sponsored_brands_campaign_video__cost | NUMERIC | Sponsored Brands Campaign Video: Cost | Total cost of all ad clicks |
| sponsored_brands_campaign_video__cpc | NUMERIC | Sponsored Brands Campaign Video: CPC | Cost-per-click (CPC) |
| sponsored_brands_campaign_video__ctr | PERCENT | Sponsored Brands Campaign Video: CTR | Click-through rate (CTR) |
| sponsored_brands_campaign_video__detail_page_views | NUMERIC | Sponsored Brands Campaign Video: Detail Page Views | Number of detail page views occurring within 14 days of an ad click or view. |
| sponsored_brands_campaign_video__impressions | NUMERIC | Sponsored Brands Campaign Video: Impressions | Total number of ad impressions |
| sponsored_brands_campaign_video__kindle_edition_normalized_pages_read_14d | NUMERIC | Sponsored Brands Campaign Video: KENP read (14 days) | Number of Kindle Edition Normalized Pages (KENP) read within 14 days of ad click. Relevant to Kindle Direct Publishing (KDP) titles only |
| sponsored_brands_campaign_video__portfolio_id | TEXT | Sponsored Brands Campaign Video: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_campaign_video__portfolio_name | TEXT | Sponsored Brands Campaign Video: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_campaign_video__purchases | NUMERIC | Sponsored Brands Campaign Video: Purchases | Number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_brands_campaign_video__roas | NUMERIC | Sponsored Brands Campaign Video: Return on advertising spend (RoAS) | Return on advertising spend (sales divided by cost) |
| sponsored_brands_campaign_video__sales | NUMERIC | Sponsored Brands Campaign Video: Sales | Total value of sales occurring within 14 days of an ad click or view. |
| sponsored_brands_campaign_video__spend | NUMERIC | Sponsored Brands Campaign Video: Spend (alias for Cost) | Alias for Cost |
| sponsored_brands_campaign_video__totalcost | NUMERIC | Sponsored Brands Campaign Video: Total Cost | Alias for Cost |
Amazon Ads sponsored_brands_purchased_product fields
The sponsored_brands_purchased_product report of the Amazon Ads connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_purchased_product__attribution_type | TEXT | Sponsored Brands Purchased Product: Attribution Type | Attribution type of the purchase: Promoted when the purchased ASIN is the advertised product, Brand Halo when it is another product of the same brand bought indirectly. |
| sponsored_brands_purchased_product__campaign_budget_currency_code | TEXT | Sponsored Brands Purchased Product: Campaign Budget Currency Code | The currency code associated with the campaign budget. |
| sponsored_brands_purchased_product__campaign_id | TEXT | Sponsored Brands Purchased Product: Campaign ID | The ID associated with a campaign. |
| sponsored_brands_purchased_product__campaign_name | TEXT | Sponsored Brands Purchased Product: Campaign Name | The name of the campaign. |
| sponsored_brands_purchased_product__orders_14d | NUMERIC | Sponsored Brands Purchased Product: Orders (14 days) | Total number of attributed orders within 14 days of an ad click. |
| sponsored_brands_purchased_product__portfolio_id | TEXT | Sponsored Brands Purchased Product: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_purchased_product__portfolio_name | TEXT | Sponsored Brands Purchased Product: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_purchased_product__purchased_asin | TEXT | Sponsored Brands Purchased Product: Purchased ASIN | The ASIN that customers purchased after an ad click or view. |
| sponsored_brands_purchased_product__sales_14d | NUMERIC | Sponsored Brands Purchased Product: Sales (14 days) | Total value of attributed sales occurring within 14 days of an ad click. |
| sponsored_brands_purchased_product__units_sold_14d | NUMERIC | Sponsored Brands Purchased Product: Units Sold (14 days) | Total number of attributed units sold within 14 days of an ad click. |
Amazon Ads sponsored_brands_search_term fields
The sponsored_brands_search_term report of the Amazon Ads connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_search_term__acos | NUMERIC | Sponsored Brands Search Term: ACoS | Advertising cost of sales (cost divided by sales). |
| sponsored_brands_search_term__ad_group_id | TEXT | Sponsored Brands Search Term: Ad Group ID | The ID associated with an ad group. |
| sponsored_brands_search_term__ad_group_name | TEXT | Sponsored Brands Search Term: Ad Group Name | The name of the ad group. |
| sponsored_brands_search_term__ad_keyword_status | TEXT | Sponsored Brands Search Term: Keyword Status | The current status of the keyword. |
| sponsored_brands_search_term__campaign_budget_currency_code | TEXT | Sponsored Brands Search Term: Campaign Budget Currency Code | The currency code associated with the campaign budget. |
| sponsored_brands_search_term__campaign_id | TEXT | Sponsored Brands Search Term: Campaign ID | The ID associated with a campaign. |
| sponsored_brands_search_term__campaign_name | TEXT | Sponsored Brands Search Term: Campaign Name | The name of the campaign. |
| sponsored_brands_search_term__clicks | NUMERIC | Sponsored Brands Search Term: Clicks | Total number of ad clicks. |
| sponsored_brands_search_term__cost | NUMERIC | Sponsored Brands Search Term: Cost | Total cost of all ad clicks. |
| sponsored_brands_search_term__cpc | NUMERIC | Sponsored Brands Search Term: CPC | Cost-per-click (CPC). |
| sponsored_brands_search_term__ctr | PERCENT | Sponsored Brands Search Term: CTR | Click-through rate (CTR). |
| sponsored_brands_search_term__impressions | NUMERIC | Sponsored Brands Search Term: Impressions | Total number of ad impressions. |
| sponsored_brands_search_term__keyword_id | TEXT | Sponsored Brands Search Term: Keyword ID | The ID of the keyword. |
| sponsored_brands_search_term__keyword_text | TEXT | Sponsored Brands Search Term: Keyword Text | The keyword text that served the ad. |
| sponsored_brands_search_term__match_type | TEXT | Sponsored Brands Search Term: Match Type | The match type of the keyword. |
| sponsored_brands_search_term__purchases | NUMERIC | Sponsored Brands Search Term: Purchases | Number of attributed conversion events within 14 days of an ad click or view. |
| sponsored_brands_search_term__roas | PERCENT | Sponsored Brands Search Term: RoAS | Return on advertising spend (sales divided by cost). |
| sponsored_brands_search_term__sales | NUMERIC | Sponsored Brands Search Term: Sales | Total value of attributed sales within 14 days of an ad click or view. |
| sponsored_brands_search_term__search_term | TEXT | Sponsored Brands Search Term: Search Term | The customer search term that resulted in an ad click. |
| sponsored_brands_search_term__spend | NUMERIC | Sponsored Brands Search Term: Spend (alias for Cost) | Alias for Cost. |
| sponsored_brands_search_term__totalcost | NUMERIC | Sponsored Brands Search Term: Total Cost | Alias for Cost. |
Amazon Ads sponsored_brands_targeting fields
The sponsored_brands_targeting report of the Amazon Ads connector includes 20 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_brands_targeting__acos | NUMERIC | Sponsored Brands Targeting: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by sales) |
| sponsored_brands_targeting__ad_group_id | TEXT | Sponsored Brands Targeting: Ad Group ID | The ID associated with the ad group. |
| sponsored_brands_targeting__ad_group_name | TEXT | Sponsored Brands Targeting: Ad Group Name | The name of the ad group. |
| sponsored_brands_targeting__campaign_id | TEXT | Sponsored Brands Targeting: Campaign ID | The ID associated with a campaign. |
| sponsored_brands_targeting__campaign_name | TEXT | Sponsored Brands Targeting: Campaign Name | The name of the campaign. |
| sponsored_brands_targeting__clicks | NUMERIC | Sponsored Brands Targeting: Clicks | Total number of ad clicks. |
| sponsored_brands_targeting__cost | NUMERIC | Sponsored Brands Targeting: Cost | Total cost of all ad clicks. |
| sponsored_brands_targeting__impressions | NUMERIC | Sponsored Brands Targeting: Impressions | Total number of ad impressions. |
| sponsored_brands_targeting__keyword_id | TEXT | Sponsored Brands Targeting: Keyword or target ID | The ID of the keyword or targeting clause. |
| sponsored_brands_targeting__keyword_text | TEXT | Sponsored Brands Targeting: Keyword | The keyword text used for bidding on targeted searches. |
| sponsored_brands_targeting__match_type | TEXT | Sponsored Brands Targeting: Match type | The keyword match type (broad, phrase or exact). |
| sponsored_brands_targeting__portfolio_id | TEXT | Sponsored Brands Targeting: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_brands_targeting__portfolio_name | TEXT | Sponsored Brands Targeting: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_brands_targeting__purchases | NUMERIC | Sponsored Brands Targeting: Purchases | Number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_brands_targeting__roas | NUMERIC | Sponsored Brands Targeting: Return on advertising spend (RoAS) | Return on advertising spend (sales divided by cost) |
| sponsored_brands_targeting__sales | NUMERIC | Sponsored Brands Targeting: Sales | Total value of sales occurring within 14 days of an ad click or view. |
| sponsored_brands_targeting__spend | NUMERIC | Sponsored Brands Targeting: Spend (alias for Cost) | Alias for Cost. |
| sponsored_brands_targeting__targeting_expression | TEXT | Sponsored Brands Targeting: Targeting expression | The targeting expression, e.g. a product or category target. |
| sponsored_brands_targeting__targeting_id | TEXT | Sponsored Brands Targeting: Targeting ID | The ID of the targeting clause. |
| sponsored_brands_targeting__targeting_text | TEXT | Sponsored Brands Targeting: Targeting text | The human-readable targeting expression. |
Amazon Ads sponsored_display_ad_group fields
The sponsored_display_ad_group report of the Amazon Ads connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_display_ad_group__acos | NUMERIC | Sponsored Display Ad Group: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by sales) |
| sponsored_display_ad_group__ad_group_id | TEXT | Sponsored Display Ad Group: Ad Group ID | The ID associated with the ad group. |
| sponsored_display_ad_group__ad_group_name | TEXT | Sponsored Display Ad Group: Ad Group Name | The name of the ad group. |
| sponsored_display_ad_group__branded_searches | NUMERIC | Sponsored Display Ad Group: Branded Searches | Number of searches for keywords associated with the brand. |
| sponsored_display_ad_group__campaign_id | TEXT | Sponsored Display Ad Group: Campaign ID | The ID associated with a campaign. |
| sponsored_display_ad_group__campaign_name | TEXT | Sponsored Display Ad Group: Campaign Name | The name of the campaign. |
| sponsored_display_ad_group__clicks | NUMERIC | Sponsored Display Ad Group: Clicks | Total number of ad clicks. |
| sponsored_display_ad_group__cost | NUMERIC | Sponsored Display Ad Group: Cost | Total cost of ad clicks. |
| sponsored_display_ad_group__cpc | NUMERIC | Sponsored Display Ad Group: CPC | Cost-per-click (CPC) |
| sponsored_display_ad_group__ctr | PERCENT | Sponsored Display Ad Group: CTR | Click-through rate (CTR) |
| sponsored_display_ad_group__detail_page_views | NUMERIC | Sponsored Display Ad Group: Detail Page Views | Number of detail page views attributed to the ad. |
| sponsored_display_ad_group__impressions | NUMERIC | Sponsored Display Ad Group: Impressions | Total number of ad impressions. |
| sponsored_display_ad_group__portfolio_id | TEXT | Sponsored Display Ad Group: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_display_ad_group__portfolio_name | TEXT | Sponsored Display Ad Group: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_display_ad_group__purchases | NUMERIC | Sponsored Display Ad Group: Purchases | Total number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_display_ad_group__roas | NUMERIC | Sponsored Display Ad Group: Return on advertising spend (RoAS) | Return on advertising spend (sales divided by cost) |
| sponsored_display_ad_group__sales | NUMERIC | Sponsored Display Ad Group: Sales | Total value of attributed sales occurring within 14 days of an ad click or view. |
| sponsored_display_ad_group__units_sold | NUMERIC | Sponsored Display Ad Group: Units Sold | Total number of attributed units sold occurring within 14 days of an ad click or view. |
Amazon Ads sponsored_display_advertised_product fields
The sponsored_display_advertised_product report of the Amazon Ads connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_display_advertised_product__acos | NUMERIC | Sponsored Display Advertised Product: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_display_advertised_product__ad_group_id | TEXT | Sponsored Display Advertised Product: Ad Group ID | The ID associated with the ad group. |
| sponsored_display_advertised_product__ad_group_name | TEXT | Sponsored Display Advertised Product: Ad Group Name | The name of the ad group. |
| sponsored_display_advertised_product__ad_id | TEXT | Sponsored Display Advertised Product: Ad ID | The ID associated with the ad. |
| sponsored_display_advertised_product__campaign_budget_currency_code | TEXT | Sponsored Display Advertised Product: Campaign Budget Currency Code | The currency code associated with the campaign budget. |
| sponsored_display_advertised_product__campaign_id | TEXT | Sponsored Display Advertised Product: Campaign ID | The ID associated with a campaign. |
| sponsored_display_advertised_product__clicks | NUMERIC | Sponsored Display Advertised Product: Clicks | Total number of ad clicks. |
| sponsored_display_advertised_product__cost | NUMERIC | Sponsored Display Advertised Product: Cost | Total cost of ad clicks. |
| sponsored_display_advertised_product__impressions | NUMERIC | Sponsored Display Advertised Product: Impressions | Total number of ad impressions. |
| sponsored_display_advertised_product__portfolio_id | TEXT | Sponsored Display Advertised Product: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_display_advertised_product__portfolio_name | TEXT | Sponsored Display Advertised Product: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_display_advertised_product__promoted_asin | TEXT | Sponsored Display Advertised Product: Promoted ASIN | The ASIN being promoted. |
| sponsored_display_advertised_product__promoted_sku | TEXT | Sponsored Display Advertised Product: Promoted SKU | The SKU being promoted. |
| sponsored_display_advertised_product__purchases | NUMERIC | Sponsored Display Advertised Product: Purchases | Total number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_display_advertised_product__roas | NUMERIC | Sponsored Display Advertised Product: Return on advertising spend (RoAS) | Return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_display_advertised_product__sales | NUMERIC | Sponsored Display Advertised Product: Sales | Total value of attributed sales occurring within 14 days of an ad click or view. |
| sponsored_display_advertised_product__units_sold | NUMERIC | Sponsored Display Advertised Product: Units Sold | Total number of attributed units sold occurring within 14 days of an ad click or view. |
Amazon Ads sponsored_display_campaign fields
The sponsored_display_campaign report of the Amazon Ads connector includes 33 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_display_campaign__acos | NUMERIC | Sponsored Display Campaign: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_display_campaign__branded_searches | NUMERIC | Sponsored Display Campaign: Branded Searches | The number of searches that included the name of your brand occurring within 14 days of an ad click or view. |
| sponsored_display_campaign__branded_searches_clicks | NUMERIC | Sponsored Display Campaign: Branded Searches Clicks | The number of searches that included the name of your brand occurring within 14 days of an ad click. |
| sponsored_display_campaign__branded_searches_views | NUMERIC | Sponsored Display Campaign: Branded Searches Views | The number of times a branded keyword was searched on Amazon based on the brands associated to the featured ASINs in your campaign, attributed to an ad view. |
| sponsored_display_campaign__campaign_id | TEXT | Sponsored Display Campaign: Campaign Id | The ID associated with a campaign. |
| sponsored_display_campaign__campaign_name | TEXT | Sponsored Display Campaign: Campaign Name | The name associated with a campaign. |
| sponsored_display_campaign__clicks | NUMERIC | Sponsored Display Campaign: Clicks | Total number of clicks on an ad. |
| sponsored_display_campaign__cost | NUMERIC | Sponsored Display Campaign: Cost | Total cost of ad clicks. |
| sponsored_display_campaign__detail_page_views | NUMERIC | Sponsored Display Campaign: Detail Page Views | Number of detail page views occurring within 14 days of an ad click or view. |
| sponsored_display_campaign__detail_page_views_clicks | NUMERIC | Sponsored Display Campaign: Detail Page Views Clicks | Number of detail page views occurring within 14 days of an ad click. |
| sponsored_display_campaign__impressions | NUMERIC | Sponsored Display Campaign: Impressions | Total number of ad impressions. |
| sponsored_display_campaign__impressions_views | NUMERIC | Sponsored Display Campaign: Impressions Views | Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at https://advertising.amazon.com/library/guides/viewability |
| sponsored_display_campaign__kindle_edition_normalized_pages_read | NUMERIC | Sponsored Display Campaign: KENP read | Number of Kindle Edition Normalized Pages (KENP) read within 14 days of an ad click or view. Relevant to Kindle Direct Publishing (KDP) titles only |
| sponsored_display_campaign__new_to_brand_purchases | NUMERIC | Sponsored Display Campaign: New To Brand Purchases | The number of first-time orders for brand products over a one-year lookback window resulting from an ad click or view. Not available for book vendors. |
| sponsored_display_campaign__new_to_brand_purchases_clicks | NUMERIC | Sponsored Display Campaign: New To Brand Purchases Clicks | The number of first-time orders for brand products over a one-year lookback window resulting from an ad click. Not available for book vendors. |
| sponsored_display_campaign__new_to_brand_sales_clicks | NUMERIC | Sponsored Display Campaign: New To Brand Sales Clicks | Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors. |
| sponsored_display_campaign__new_to_brand_units_sold | NUMERIC | Sponsored Display Campaign: New To Brand Units Sold | 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. |
| sponsored_display_campaign__new_to_brand_units_sold_clicks | NUMERIC | Sponsored Display Campaign: New To Brand Units Sold Clicks | Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors. |
| sponsored_display_campaign__portfolio_id | TEXT | Sponsored Display Campaign: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_display_campaign__portfolio_name | TEXT | Sponsored Display Campaign: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_display_campaign__purchases | NUMERIC | Sponsored Display Campaign: Purchases | Number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_display_campaign__purchases_clicks | NUMERIC | Sponsored Display Campaign: Purchases Clicks | Number of attributed conversion events occurring within 14 days of an ad click. |
| sponsored_display_campaign__purchases_promoted_clicks | NUMERIC | Sponsored Display Campaign: Purchases Promoted Clicks | 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__roas | NUMERIC | Sponsored Display Campaign: Return on advertising spend (RoAS) | Return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_display_campaign__sales | NUMERIC | Sponsored Display Campaign: Sales | Total value of sales occurring within 14 days of an ad click or view. |
| sponsored_display_campaign__sales_clicks | NUMERIC | Sponsored Display Campaign: Sales Clicks | Total value of sales occurring within 14 days of an ad click. |
| sponsored_display_campaign__sales_promoted_clicks | NUMERIC | Sponsored Display Campaign: Sales Promoted Clicks | 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__units_sold | NUMERIC | Sponsored Display Campaign: Units Sold | Number of attributed units sold within 14 days of an ad click or view. |
| sponsored_display_campaign__video_complete_views | NUMERIC | Sponsored Display Campaign: Video Complete Views | The number of impressions where the video was viewed to 100%. |
| sponsored_display_campaign__video_first_quartile_views | NUMERIC | Sponsored Display Campaign: Video First Quartile Views | The number of impressions where the video was viewed to 25%. |
| sponsored_display_campaign__video_midpoint_views | NUMERIC | Sponsored Display Campaign: Video Midpoint Views | The number of impressions where the video was viewed to 50%. |
| sponsored_display_campaign__video_third_quartile_views | NUMERIC | Sponsored Display Campaign: Video Third Quartile Views | The number of impressions where the video was viewed to 75%. |
| sponsored_display_campaign__video_unmutes | NUMERIC | Sponsored Display Campaign: Video Unmutes | The number of impressions where a customer unmuted the video. |
Amazon Ads sponsored_display_targeting fields
The sponsored_display_targeting report of the Amazon Ads connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_display_targeting__acos | NUMERIC | Sponsored Display Targeting: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_display_targeting__ad_group_id | TEXT | Sponsored Display Targeting: Ad Group ID | The ID associated with the ad group. |
| sponsored_display_targeting__ad_group_name | TEXT | Sponsored Display Targeting: Ad Group Name | The name of the ad group. |
| sponsored_display_targeting__campaign_id | TEXT | Sponsored Display Targeting: Campaign ID | The ID associated with a campaign. |
| sponsored_display_targeting__campaign_name | TEXT | Sponsored Display Targeting: Campaign Name | The name of the campaign. |
| sponsored_display_targeting__clicks | NUMERIC | Sponsored Display Targeting: Clicks | Total number of ad clicks. |
| sponsored_display_targeting__cost | NUMERIC | Sponsored Display Targeting: Cost | Total cost of all ad clicks. |
| sponsored_display_targeting__detail_page_views | NUMERIC | Sponsored Display Targeting: Detail Page Views | Number of detail page views occurring within 14 days of an ad click or view. |
| sponsored_display_targeting__impressions | NUMERIC | Sponsored Display Targeting: Impressions | Total number of ad impressions. |
| sponsored_display_targeting__portfolio_id | TEXT | Sponsored Display Targeting: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_display_targeting__portfolio_name | TEXT | Sponsored Display Targeting: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_display_targeting__purchases | NUMERIC | Sponsored Display Targeting: Purchases | Number of attributed conversion events occurring within 14 days of an ad click or view. |
| sponsored_display_targeting__roas | NUMERIC | Sponsored Display Targeting: Return on advertising spend (RoAS) | Return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_display_targeting__sales | NUMERIC | Sponsored Display Targeting: Sales | Total value of attributed sales occurring within 14 days of an ad click or view. |
| sponsored_display_targeting__spend | NUMERIC | Sponsored Display Targeting: Spend (alias for Cost) | Alias for Cost. |
| sponsored_display_targeting__targeting_expression | TEXT | Sponsored Display Targeting: Targeting expression | The targeting expression, e.g. a product or audience target. |
| sponsored_display_targeting__targeting_id | TEXT | Sponsored Display Targeting: Targeting ID | The ID of the targeting clause. |
| sponsored_display_targeting__targeting_text | TEXT | Sponsored Display Targeting: Targeting text | The human-readable targeting expression. |
| sponsored_display_targeting__units_sold | NUMERIC | Sponsored Display Targeting: Units Sold | Number of attributed units sold within 14 days of an ad click or view. |
Amazon Ads sponsored_products_advertised_product fields
The sponsored_products_advertised_product report of the Amazon Ads connector includes 28 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_products_advertised_product__acos | NUMERIC | Sponsored Products Advertised Product: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_products_advertised_product__ad_group_id | TEXT | Sponsored Products Advertised Product: Ad Group ID | The ID associated with the ad group. |
| sponsored_products_advertised_product__ad_group_name | TEXT | Sponsored Products Advertised Product: Ad Group Name | The name of the ad group. |
| sponsored_products_advertised_product__ad_id | TEXT | Sponsored Products Advertised Product: Ad ID | The ID associated with the product ad. |
| sponsored_products_advertised_product__advertised_asin | TEXT | Sponsored Products Advertised Product: Advertised ASIN | The ASIN that is being advertised. |
| sponsored_products_advertised_product__advertised_sku | TEXT | Sponsored Products Advertised Product: Advertised SKU | The SKU that is being advertised. |
| sponsored_products_advertised_product__campaign_budget_currency_code | TEXT | Sponsored Products Advertised Product: Campaign Budget Currency Code | The currency code associated with the campaign budget. |
| sponsored_products_advertised_product__campaign_id | TEXT | Sponsored Products Advertised Product: Campaign ID | The ID associated with a campaign. |
| sponsored_products_advertised_product__campaign_name | TEXT | Sponsored Products Advertised Product: Campaign Name | The name of the campaign. |
| sponsored_products_advertised_product__campaigntargetingtype | TEXT | Sponsored Products Advertised Product: Campaign targeting type | Campaign targeting type |
| sponsored_products_advertised_product__clicks | NUMERIC | Sponsored Products Advertised Product: Clicks | Total number of ad clicks. |
| sponsored_products_advertised_product__cost | NUMERIC | Sponsored Products Advertised Product: Cost | Total cost of all ad clicks. |
| sponsored_products_advertised_product__impressions | NUMERIC | Sponsored Products Advertised Product: Impressions | Total number of ad impressions. |
| sponsored_products_advertised_product__portfolio_id | TEXT | Sponsored Products Advertised Product: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_products_advertised_product__portfolio_name | TEXT | Sponsored Products Advertised Product: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_products_advertised_product__purchases_14d | NUMERIC | Sponsored Products Advertised Product: Purchases (14 days) | Total number of attributed conversion events occurring within 14 days of an ad click. |
| sponsored_products_advertised_product__purchases_1d | NUMERIC | Sponsored Products Advertised Product: Purchases (1 day) | Total number of attributed conversion events occurring within 24 hours of an ad click. |
| sponsored_products_advertised_product__purchases_30d | NUMERIC | Sponsored Products Advertised Product: Purchases (30 days) | Total number of attributed conversion events occurring within 30 days of an ad click. |
| sponsored_products_advertised_product__purchases_7d | NUMERIC | Sponsored Products Advertised Product: Purchases (7 days) | Total number of attributed conversion events occurring within 7 days of an ad click. |
| sponsored_products_advertised_product__roas | NUMERIC | Sponsored Products Advertised Product: Return on advertising spend (RoAS) | Return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_products_advertised_product__sales_14d | NUMERIC | Sponsored Products Advertised Product: Sales (14 days) | Total value of attributed sales occurring within 14 days of an ad click. |
| sponsored_products_advertised_product__sales_1d | NUMERIC | Sponsored Products Advertised Product: Sales (1 day) | Total value of attributed sales occurring within 24 hours of an ad click. |
| sponsored_products_advertised_product__sales_30d | NUMERIC | Sponsored Products Advertised Product: Sales (30 days) | Total value of attributed sales occurring within 30 days of an ad click. |
| sponsored_products_advertised_product__sales_7d | NUMERIC | Sponsored Products Advertised Product: Sales (7 days) | Total value of attributed sales occurring within 7 days of an ad click. |
| sponsored_products_advertised_product__units_sold_clicks_14d | NUMERIC | Sponsored Products Advertised Product: Units Sold Clicks (14 days) | Total number of attributed units sold within 14 days of an ad click. |
| sponsored_products_advertised_product__units_sold_clicks_1d | NUMERIC | Sponsored Products Advertised Product: Units Sold Clicks (1 day) | Total number of attributed units sold within 24 hours of an ad click. |
| sponsored_products_advertised_product__units_sold_clicks_30d | NUMERIC | Sponsored Products Advertised Product: Units Sold Clicks (30 days) | Total number of attributed units sold within 30 days of an ad click. |
| sponsored_products_advertised_product__units_sold_clicks_7d | NUMERIC | Sponsored Products Advertised Product: Units Sold Clicks (7 days) | Total number of attributed units sold within 7 days of an ad click. |
Amazon Ads sponsored_products_campaign fields
The sponsored_products_campaign report of the Amazon Ads connector includes 33 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_products_campaign__acos | NUMERIC | Sponsored Products Campaign: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_products_campaign__adnetwork_conversions | NUMERIC | Sponsored Products Campaign: Ad Network Conversions | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
| sponsored_products_campaign__adnetwork_revenue | NUMERIC | Sponsored Products Campaign: Ad Network Revenue | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
| sponsored_products_campaign__attributedconversions14d | NUMERIC | Sponsored Products Campaign: Attributed conversions (14 days) | Total number of attributed conversion events occurring within 14 days of ad click |
| sponsored_products_campaign__attributedconversions1d | NUMERIC | Sponsored Products Campaign: Attributed conversions (1 day) | Total number of attributed conversion events occurring within 24 hours of ad click |
| sponsored_products_campaign__attributedconversions30d | NUMERIC | Sponsored Products Campaign: Attributed conversions (30 days) | Total number of attributed conversion events occurring within 30 days of ad click |
| sponsored_products_campaign__attributedconversions7d | NUMERIC | Sponsored Products Campaign: Attributed conversions (7 days) | Total number of attributed conversion events occurring within 7 days of ad click |
| sponsored_products_campaign__attributedsales14d | NUMERIC | Sponsored Products Campaign: Attributed sales (14 days) | Aggregate value of attributed sales occurring within 14 days of click on ad |
| sponsored_products_campaign__attributedsales1d | NUMERIC | Sponsored Products Campaign: Attributed sales (1 day) | Aggregate value of attributed sales occurring within 24 hours of click on ad |
| sponsored_products_campaign__attributedsales30d | NUMERIC | Sponsored Products Campaign: Attributed sales (30 days) | Aggregate value of attributed sales occurring within 30 days of click on ad |
| sponsored_products_campaign__attributedsales7d | NUMERIC | Sponsored Products Campaign: Attributed sales (7 days) | Aggregate value of attributed sales occurring within 7 days of click on ad |
| sponsored_products_campaign__attributedunitsordered14d | NUMERIC | Sponsored Products Campaign: Attributed units ordered (14 days) | Total number of attributed units ordered within 14 days of ad click |
| sponsored_products_campaign__attributedunitsordered1d | NUMERIC | Sponsored Products Campaign: Attributed units ordered (1 day) | Total number of attributed units ordered within 24 hours of ad click |
| sponsored_products_campaign__attributedunitsordered30d | NUMERIC | Sponsored Products Campaign: Attributed units ordered (30 days) | Total number of attributed units ordered within 30 days of ad click |
| sponsored_products_campaign__attributedunitsordered7d | NUMERIC | Sponsored Products Campaign: Attributed units ordered (7 days) | Total number of attributed units ordered within 7 days of ad click |
| sponsored_products_campaign__campaign | TEXT | Sponsored Products Campaign: Campaign | The name of the campaign |
| sponsored_products_campaign__campaign_budget | NUMERIC | Sponsored Products Campaign: Campaign budget | Total budget allotted to the campaign |
| sponsored_products_campaign__campaign_status | TEXT | Sponsored Products Campaign: Campaign status | The current status of the campaign |
| sponsored_products_campaign__campaignbiddingstrategy | TEXT | Sponsored Products Campaign: Campaign bidding strategy | Campaign bidding strategy |
| sponsored_products_campaign__campaigndailybudget | NUMERIC | Sponsored Products Campaign: Campaign daily budget | Total daily budget for the campaign |
| sponsored_products_campaign__campaignid | TEXT | Sponsored Products Campaign: Campaign ID (duplicate) | The unique identifier of the campaign. (duplicate) |
| sponsored_products_campaign__campaigntargetingtype | TEXT | Sponsored Products Campaign: Campaign targeting type | Campaign targeting type |
| sponsored_products_campaign__clicks | NUMERIC | Sponsored Products Campaign: Clicks | Total number of ad clicks |
| sponsored_products_campaign__cost | NUMERIC | Sponsored Products Campaign: Cost | Total cost of all ad clicks |
| sponsored_products_campaign__cpc | NUMERIC | Sponsored Products Campaign: CPC | Cost-per-click (CPC) |
| sponsored_products_campaign__ctr | PERCENT | Sponsored Products Campaign: CTR | Click-through rate (CTR) |
| sponsored_products_campaign__impressions | NUMERIC | Sponsored Products Campaign: Impressions | Total number of ad impressions |
| sponsored_products_campaign__kindle_edition_normalized_pages_read_14d | NUMERIC | Sponsored Products Campaign: KENP read (14 days) | Number of Kindle Edition Normalized Pages (KENP) read within 14 days of ad click. Relevant to Kindle Direct Publishing (KDP) titles only |
| sponsored_products_campaign__portfolio_id | TEXT | Sponsored Products Campaign: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_products_campaign__portfolio_name | TEXT | Sponsored Products Campaign: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_products_campaign__roas | PERCENT | Sponsored Products Campaign: Total return on advertising spend (RoAS) | Total return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_products_campaign__spend | NUMERIC | Sponsored Products Campaign: Spend (alias for Cost) | Alias for Cost |
| sponsored_products_campaign__totalcost | NUMERIC | Sponsored Products Campaign: Total Cost | Alias for Cost |
Amazon Ads sponsored_products_placement fields
The sponsored_products_placement report of the Amazon Ads connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_products_placement__acos | NUMERIC | Sponsored Products Placement: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_products_placement__adnetwork_conversions | NUMERIC | Sponsored Products Placement: Ad Network Conversions | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
| sponsored_products_placement__adnetwork_revenue | NUMERIC | Sponsored Products Placement: Ad Network Revenue | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
| sponsored_products_placement__attributedconversions14d | NUMERIC | Sponsored Products Placement: Attributed conversions (14 days) | Total number of attributed conversion events occurring within 14 days of ad click |
| sponsored_products_placement__attributedconversions1d | NUMERIC | Sponsored Products Placement: Attributed conversions (1 day) | Total number of attributed conversion events occurring within 24 hours of ad click |
| sponsored_products_placement__attributedconversions30d | NUMERIC | Sponsored Products Placement: Attributed conversions (30 days) | Total number of attributed conversion events occurring within 30 days of ad click |
| sponsored_products_placement__attributedconversions7d | NUMERIC | Sponsored Products Placement: Attributed conversions (7 days) | Total number of attributed conversion events occurring within 7 days of ad click |
| sponsored_products_placement__attributedsales14d | NUMERIC | Sponsored Products Placement: Attributed sales (14 days) | Aggregate value of attributed sales occurring within 14 days of click on ad |
| sponsored_products_placement__attributedsales1d | NUMERIC | Sponsored Products Placement: Attributed sales (1 day) | Aggregate value of attributed sales occurring within 24 hours of click on ad |
| sponsored_products_placement__attributedsales30d | NUMERIC | Sponsored Products Placement: Attributed sales (30 days) | Aggregate value of attributed sales occurring within 30 days of click on ad |
| sponsored_products_placement__attributedsales7d | NUMERIC | Sponsored Products Placement: Attributed sales (7 days) | Aggregate value of attributed sales occurring within 7 days of click on ad |
| sponsored_products_placement__attributedunitsordered14d | NUMERIC | Sponsored Products Placement: Attributed units ordered (14 days) | Total number of attributed units ordered within 14 days of ad click |
| sponsored_products_placement__attributedunitsordered1d | NUMERIC | Sponsored Products Placement: Attributed units ordered (1 day) | Total number of attributed units ordered within 24 hours of ad click |
| sponsored_products_placement__attributedunitsordered30d | NUMERIC | Sponsored Products Placement: Attributed units ordered (30 days) | Total number of attributed units ordered within 30 days of ad click |
| sponsored_products_placement__attributedunitsordered7d | NUMERIC | Sponsored Products Placement: Attributed units ordered (7 days) | Total number of attributed units ordered within 7 days of ad click |
| sponsored_products_placement__campaign | TEXT | Sponsored Products Placement: Campaign | The name of the campaign |
| sponsored_products_placement__campaignid | TEXT | Sponsored Products Placement: Campaign ID | The unique identifier of the campaign. |
| sponsored_products_placement__clicks | NUMERIC | Sponsored Products Placement: Clicks | Total number of ad clicks |
| sponsored_products_placement__cost | NUMERIC | Sponsored Products Placement: Cost | Total cost of all ad clicks |
| sponsored_products_placement__cpc | NUMERIC | Sponsored Products Placement: CPC | Cost-per-click (CPC) |
| sponsored_products_placement__ctr | PERCENT | Sponsored Products Placement: CTR | Click-through rate (CTR) |
| sponsored_products_placement__impressions | NUMERIC | Sponsored Products Placement: Impressions | Total number of ad impressions |
| sponsored_products_placement__placement | TEXT | Sponsored Products Placement: Placement | Ad placement classification, one of: Top of Search, Product Pages, Other |
| sponsored_products_placement__roas | PERCENT | Sponsored Products Placement: Total return on advertising spend (RoAS) | Total return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_products_placement__spend | NUMERIC | Sponsored Products Placement: Spend (alias for Cost) | Alias for Cost |
| sponsored_products_placement__totalcost | NUMERIC | Sponsored Products Placement: Total Cost | Alias for Cost |
Amazon Ads sponsored_products_search_term fields
The sponsored_products_search_term report of the Amazon Ads connector includes 33 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_products_search_term__acos | NUMERIC | Sponsored Products Search Term: ACoS | Advertising cost of sales (cost divided by 14-day sales). |
| sponsored_products_search_term__ad_group_id | TEXT | Sponsored Products Search Term: Ad Group ID | The ID associated with an ad group. |
| sponsored_products_search_term__ad_group_name | TEXT | Sponsored Products Search Term: Ad Group Name | The name of the ad group. |
| sponsored_products_search_term__ad_keyword_status | TEXT | Sponsored Products Search Term: Keyword Status | The current status of the keyword or target. |
| sponsored_products_search_term__campaign_budget_currency_code | TEXT | Sponsored Products Search Term: Campaign Budget Currency Code | The currency code associated with the campaign budget. |
| sponsored_products_search_term__campaign_id | TEXT | Sponsored Products Search Term: Campaign ID | The ID associated with a campaign. |
| sponsored_products_search_term__campaign_name | TEXT | Sponsored Products Search Term: Campaign Name | The name of the campaign. |
| sponsored_products_search_term__clicks | NUMERIC | Sponsored Products Search Term: Clicks | Total number of ad clicks. |
| sponsored_products_search_term__cost | NUMERIC | Sponsored Products Search Term: Cost | Total cost of all ad clicks. |
| sponsored_products_search_term__cpc | NUMERIC | Sponsored Products Search Term: CPC | Cost-per-click (CPC). |
| sponsored_products_search_term__ctr | PERCENT | Sponsored Products Search Term: CTR | Click-through rate (CTR). |
| sponsored_products_search_term__impressions | NUMERIC | Sponsored Products Search Term: Impressions | Total number of ad impressions. |
| sponsored_products_search_term__keyword_id | TEXT | Sponsored Products Search Term: Keyword ID | The ID of the keyword or target. Null for some auto-targeting rows. |
| sponsored_products_search_term__keyword_text | TEXT | Sponsored Products Search Term: Keyword Text | The keyword text, or the auto-targeting expression (e.g. loose-match) for auto campaigns. |
| sponsored_products_search_term__keyword_type | TEXT | Sponsored Products Search Term: Keyword Type | The type of the keyword or target. |
| sponsored_products_search_term__match_type | TEXT | Sponsored Products Search Term: Match Type | The match type of the keyword or target. |
| sponsored_products_search_term__purchases_14d | NUMERIC | Sponsored Products Search Term: Purchases (14 days) | Number of attributed conversion events within 14 days of an ad click. |
| sponsored_products_search_term__purchases_1d | NUMERIC | Sponsored Products Search Term: Purchases (1 day) | Number of attributed conversion events within 24 hours of an ad click. |
| sponsored_products_search_term__purchases_30d | NUMERIC | Sponsored Products Search Term: Purchases (30 days) | Number of attributed conversion events within 30 days of an ad click. |
| sponsored_products_search_term__purchases_7d | NUMERIC | Sponsored Products Search Term: Purchases (7 days) | Number of attributed conversion events within 7 days of an ad click. |
| sponsored_products_search_term__roas | PERCENT | Sponsored Products Search Term: RoAS | Return on advertising spend (14-day sales divided by cost). |
| sponsored_products_search_term__sales_14d | NUMERIC | Sponsored Products Search Term: Sales (14 days) | Total value of attributed sales within 14 days of an ad click. |
| sponsored_products_search_term__sales_1d | NUMERIC | Sponsored Products Search Term: Sales (1 day) | Total value of attributed sales within 24 hours of an ad click. |
| sponsored_products_search_term__sales_30d | NUMERIC | Sponsored Products Search Term: Sales (30 days) | Total value of attributed sales within 30 days of an ad click. |
| sponsored_products_search_term__sales_7d | NUMERIC | Sponsored Products Search Term: Sales (7 days) | Total value of attributed sales within 7 days of an ad click. |
| sponsored_products_search_term__search_term | TEXT | Sponsored Products Search Term: Search Term | The customer search term that resulted in an ad click. |
| sponsored_products_search_term__spend | NUMERIC | Sponsored Products Search Term: Spend (alias for Cost) | Alias for Cost. |
| sponsored_products_search_term__targeting | TEXT | Sponsored Products Search Term: Targeting | The targeting expression that served the ad. |
| sponsored_products_search_term__totalcost | NUMERIC | Sponsored Products Search Term: Total Cost | Alias for Cost. |
| sponsored_products_search_term__units_sold_clicks_14d | NUMERIC | Sponsored Products Search Term: Units Sold Clicks (14 days) | Number of attributed units sold within 14 days of an ad click. |
| sponsored_products_search_term__units_sold_clicks_1d | NUMERIC | Sponsored Products Search Term: Units Sold Clicks (1 day) | Number of attributed units sold within 24 hours of an ad click. |
| sponsored_products_search_term__units_sold_clicks_30d | NUMERIC | Sponsored Products Search Term: Units Sold Clicks (30 days) | Number of attributed units sold within 30 days of an ad click. |
| sponsored_products_search_term__units_sold_clicks_7d | NUMERIC | Sponsored Products Search Term: Units Sold Clicks (7 days) | Number of attributed units sold within 7 days of an ad click. |
Amazon Ads sponsored_products_targeting fields
The sponsored_products_targeting report of the Amazon Ads connector includes 28 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sponsored_products_targeting__acos | NUMERIC | Sponsored Products Targeting: Total advertising cost of sales (ACoS) | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| sponsored_products_targeting__ad_group_id | TEXT | Sponsored Products Targeting: Ad Group ID | The ID associated with the ad group. |
| sponsored_products_targeting__ad_group_name | TEXT | Sponsored Products Targeting: Ad Group Name | The name of the ad group. |
| sponsored_products_targeting__ad_keyword_status | TEXT | Sponsored Products Targeting: Keyword Status | The current status of the keyword or target. |
| sponsored_products_targeting__campaign_id | TEXT | Sponsored Products Targeting: Campaign ID | The ID associated with a campaign. |
| sponsored_products_targeting__campaign_name | TEXT | Sponsored Products Targeting: Campaign Name | The name of the campaign. |
| sponsored_products_targeting__clicks | NUMERIC | Sponsored Products Targeting: Clicks | Total number of ad clicks. |
| sponsored_products_targeting__cost | NUMERIC | Sponsored Products Targeting: Cost | Total cost of all ad clicks. |
| sponsored_products_targeting__impressions | NUMERIC | Sponsored Products Targeting: Impressions | Total number of ad impressions. |
| sponsored_products_targeting__keyword | TEXT | Sponsored Products Targeting: Keyword | The keyword text used for bidding on targeted searches. |
| sponsored_products_targeting__keyword_id | TEXT | Sponsored Products Targeting: Keyword or target ID | The ID of the keyword or targeting clause. |
| sponsored_products_targeting__keyword_type | TEXT | Sponsored Products Targeting: Targeting type | The type of the targeting clause (keyword or product target). |
| sponsored_products_targeting__match_type | TEXT | Sponsored Products Targeting: Match Type | The match type of the keyword or target. |
| sponsored_products_targeting__portfolio_id | TEXT | Sponsored Products Targeting: Portfolio ID | The identifier of the portfolio the campaign belongs to |
| sponsored_products_targeting__portfolio_name | TEXT | Sponsored Products Targeting: Portfolio name | The name of the portfolio the campaign belongs to |
| sponsored_products_targeting__purchases_14d | NUMERIC | Sponsored Products Targeting: Purchases (14 days) | Total number of attributed conversion events occurring within 14 days of an ad click. |
| sponsored_products_targeting__purchases_1d | NUMERIC | Sponsored Products Targeting: Purchases (1 day) | Total number of attributed conversion events occurring within 24 hours of an ad click. |
| sponsored_products_targeting__purchases_30d | NUMERIC | Sponsored Products Targeting: Purchases (30 days) | Total number of attributed conversion events occurring within 30 days of an ad click. |
| sponsored_products_targeting__purchases_7d | NUMERIC | Sponsored Products Targeting: Purchases (7 days) | Total number of attributed conversion events occurring within 7 days of an ad click. |
| sponsored_products_targeting__roas | NUMERIC | Sponsored Products Targeting: Return on advertising spend (RoAS) | Return on advertising spend (14-day sales revenue divided by cost) |
| sponsored_products_targeting__sales_14d | NUMERIC | Sponsored Products Targeting: Sales (14 days) | Total value of attributed sales occurring within 14 days of an ad click. |
| sponsored_products_targeting__sales_1d | NUMERIC | Sponsored Products Targeting: Sales (1 day) | Total value of attributed sales occurring within 24 hours of an ad click. |
| sponsored_products_targeting__sales_30d | NUMERIC | Sponsored Products Targeting: Sales (30 days) | Total value of attributed sales occurring within 30 days of an ad click. |
| sponsored_products_targeting__sales_7d | NUMERIC | Sponsored Products Targeting: Sales (7 days) | Total value of attributed sales occurring within 7 days of an ad click. |
| sponsored_products_targeting__spend | NUMERIC | Sponsored Products Targeting: Spend (alias for Cost) | Alias for Cost. |
| sponsored_products_targeting__targeting | TEXT | Sponsored Products Targeting: Targeting expression | The targeting expression, e.g. a product ASIN or category target. |
| sponsored_products_targeting__top_of_search_impression_share | PERCENT | Sponsored Products Targeting: Top-of-search impression share | Share of top-of-search impressions the keyword or target received out of all available top-of-search impressions. |
| sponsored_products_targeting__units_sold_clicks_14d | NUMERIC | Sponsored Products Targeting: Units Sold Clicks (14 days) | Total number of attributed units sold within 14 days of an ad click. |
Amazon Ads other fields
The Amazon Ads connector has 24 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The Account ID | |
| account_name | TEXT | Account Name | The Account Name | |
| ad_type | TEXT | Ad type | One of: Sponsored Brands, Sponsored Display, Sponsored Products | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| marketplace | TEXT | Marketplace | Amazon marketplace (country) name | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| profileid | TEXT | Profile ID | Amazon Advertising profile ID | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |