+
Stream marketing data from Amazon Ads to Snowflake
About Amazon Ads
About SnowFlake
Connect Amazon Ads to Snowflake in 2023
It is very simple to connect Amazon Ads to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select Amazon Ads as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.
Amazon Ads metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Account ID | TEXT | The Account ID |
| Account Name | TEXT | The Account Name |
| Ad type | TEXT | One of: Sponsored Brands, Sponsored Display, Sponsored Products |
| Date | DATE | Date |
| Marketplace | TEXT | Amazon marketplace (country) name |
| Profile ID | TEXT | Amazon Advertising profile ID |
| Sponsored Brands Campaign Non Video: Total advertising cost of sales (ACoS) | NUMERIC | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| Sponsored Brands Campaign Non Video: Attributed conversions (14 days) | NUMERIC | Total number of attributed conversion events occurring within 14 days of ad click |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand order rate (14 days) | PERCENT | 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: Attributed new-to-brand orders (14 days) | NUMERIC | The number of first-time orders for products within the brand over a one-year lookback window |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand orders share (14 days) | NUMERIC | The percentage of total orders that are new-to-brand orders |
| Sponsored Brands Campaign Non Video: Attributed sales (14 days) | NUMERIC | Aggregate value of attributed sales occurring within 14 days of click on ad |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand sales (14 days) | NUMERIC | Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand sales share (14 days) | PERCENT | The percentage of total sales of new-to-brand purchases |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand units ordered (14 days) | NUMERIC | The number of units from first-time orders for products within the brand over a one-year lookback window |
| Sponsored Brands Campaign Non Video: Attributed new-to-brand units ordered share (14 days) | NUMERIC | The percentage of total units that are units from new-to-brand orders |
| Sponsored Brands Campaign Non Video: Attributed units sold (14 days) | NUMERIC | Number of attributed units sold occurring within 14 days of click on an ad |
| Sponsored Brands Campaign Non Video: Campaign | TEXT | The name of the campaign |
| Sponsored Brands Campaign Non Video: Campaign budget | NUMERIC | Total budget allotted to the campaign |
| Sponsored Brands Campaign Non Video: Campaign budget type | TEXT | One of: daily or lifetime |
| Sponsored Brands Campaign Non Video: Campaign status | TEXT | The current status of the campaign |
| Sponsored Brands Campaign Non Video: Campaign ad format | TEXT | Campaign ad format |
| Sponsored Brands Campaign Non Video: Campaign ID (duplicate) | TEXT | The unique identifier of the campaign. (duplicate) |
| Sponsored Brands Campaign Non Video: Clicks | NUMERIC | Total number of ad clicks |
| Sponsored Brands Campaign Non Video: Cost | NUMERIC | Total cost of all ad clicks |
| Sponsored Brands Campaign Non Video: CPC | NUMERIC | Cost-per-click (CPC) |
| Sponsored Brands Campaign Non Video: CTR | PERCENT | Click-through rate (CTR) |
| Sponsored Brands Campaign Non Video: Impressions | NUMERIC | Total number of ad impressions |
| Sponsored Brands Campaign Non Video: Total return on advertising spend (RoAS) | PERCENT | Total return on advertising spend (14-day sales revenue divided by cost) |
| Sponsored Brands Campaign Non Video: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Brands Campaign Non Video: Total Cost | NUMERIC | Alias for Cost |
| Sponsored Brands Campaign Video: Total advertising cost of sales (ACoS) | NUMERIC | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| Sponsored Brands Campaign Video: Attributed conversions (14 days) | NUMERIC | Total number of attributed conversion events occurring within 14 days of ad click |
| Sponsored Brands Campaign Video: Attributed sales (14 days) | NUMERIC | Aggregate value of attributed sales occurring within 14 days of click on ad |
| Sponsored Brands Campaign Video: Campaign | TEXT | The name of the campaign |
| Sponsored Brands Campaign Video: Campaign budget | NUMERIC | Total budget allotted to the campaign |
| Sponsored Brands Campaign Video: Campaign budget type | TEXT | One of: daily or lifetime |
| Sponsored Brands Campaign Video: Campaign status | TEXT | The current status of the campaign |
| Sponsored Brands Campaign Video: Campaign ad format | TEXT | Campaign ad format |
| Sponsored Brands Campaign Video: Campaign ID (duplicate) | TEXT | The unique identifier of the campaign. (duplicate) |
| Sponsored Brands Campaign Video: Clicks | NUMERIC | Total number of ad clicks |
| Sponsored Brands Campaign Video: Cost | NUMERIC | Total cost of all ad clicks |
| Sponsored Brands Campaign Video: CPC | NUMERIC | Cost-per-click (CPC) |
| Sponsored Brands Campaign Video: CTR | PERCENT | Click-through rate (CTR) |
| Sponsored Brands Campaign Video: Impressions | NUMERIC | Total number of ad impressions |
| Sponsored Brands Campaign Video: Total return on advertising spend (RoAS) | PERCENT | Total return on advertising spend (14-day sales revenue divided by cost) |
| Sponsored Brands Campaign Video: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Brands Campaign Video: Total Cost | NUMERIC | Alias for Cost |
| Sponsored Display Campaign T00020: Total advertising cost of sales (ACoS) | NUMERIC | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| Sponsored Display Campaign T00020: Ad Network Conversions | NUMERIC | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
| Sponsored Display Campaign T00020: Ad Network Revenue | NUMERIC | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
| Sponsored Display Campaign T00020: Attributed Branded Searches (14 days) | NUMERIC | The number of searches that included the name of your brand occurring within 14 days of an ad click. |
| Sponsored Display Campaign T00020: Attributed Conversions Same SKU (14 days) | NUMERIC | 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 T00020: Attributed Conversions Same SKU (1 day) | NUMERIC | Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed Conversions Same SKU (30 days) | NUMERIC | Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed Conversions Same SKU (7 days) | NUMERIC | Number of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed Detail Page View (14 days) | NUMERIC | This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d. |
| Sponsored Display Campaign T00020: Attributed Sales Same SKU (14 days) | NUMERIC | 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 T00020: Attributed Sales Same SKU (1 day) | NUMERIC | Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed Sales Same SKU (30 days) | NUMERIC | Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed Sales Same SKU (7 days) | NUMERIC | Total value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00020: Attributed conversions (14 days) | NUMERIC | Total number of attributed conversion events occurring within 14 days of ad click |
| Sponsored Display Campaign T00020: Attributed conversions (1 day) | NUMERIC | Total number of attributed conversion events occurring within 24 hours of ad click |
| Sponsored Display Campaign T00020: Attributed conversions (30 days) | NUMERIC | Total number of attributed conversion events occurring within 30 days of ad click |
| Sponsored Display Campaign T00020: Attributed conversions (7 days) | NUMERIC | Total number of attributed conversion events occurring within 7 days of ad click |
| Sponsored Display Campaign T00020: Attributed new-to-brand orders (14 days) | NUMERIC | The number of first-time orders for products within the brand over a one-year lookback window |
| Sponsored Display Campaign T00020: Attributed sales (14 days) | NUMERIC | Aggregate value of attributed sales occurring within 14 days of click on ad |
| Sponsored Display Campaign T00020: Attributed sales (1 day) | NUMERIC | Aggregate value of attributed sales occurring within 24 hours of click on ad |
| Sponsored Display Campaign T00020: Attributed sales (30 days) | NUMERIC | Aggregate value of attributed sales occurring within 30 days of click on ad |
| Sponsored Display Campaign T00020: Attributed sales (7 days) | NUMERIC | Aggregate value of attributed sales occurring within 7 days of click on ad |
| Sponsored Display Campaign T00020: Attributed new-to-brand sales (14 days) | NUMERIC | Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad |
| Sponsored Display Campaign T00020: Attributed units ordered (14 days) | NUMERIC | Total number of attributed units ordered within 14 days of ad click |
| Sponsored Display Campaign T00020: Attributed units ordered (1 day) | NUMERIC | Total number of attributed units ordered within 24 hours of ad click |
| Sponsored Display Campaign T00020: Attributed units ordered (30 days) | NUMERIC | Total number of attributed units ordered within 30 days of ad click |
| Sponsored Display Campaign T00020: Attributed units ordered (7 days) | NUMERIC | Total number of attributed units ordered within 7 days of ad click |
| Sponsored Display Campaign T00020: Attributed new-to-brand units ordered (14 days) | NUMERIC | The number of units from first-time orders for products within the brand over a one-year lookback window |
| Sponsored Display Campaign T00020: Campaign | TEXT | The name of the campaign |
| Sponsored Display Campaign T00020: Campaign Budget | NUMERIC | Total budget allocated to the campaign. |
| Sponsored Display Campaign T00020: Campaign Status | TEXT | Current status of the campaign. One of active, paused, or archived. |
| Sponsored Display Campaign T00020: Campaign ID (duplicate) | TEXT | The unique identifier of the campaign. (duplicate) |
| Sponsored Display Campaign T00020: Campaign tactic | TEXT | Campaign tactic code |
| Sponsored Display Campaign T00020: Clicks | NUMERIC | Total number of ad clicks |
| Sponsored Display Campaign T00020: Cost | NUMERIC | Total cost of all ad clicks |
| Sponsored Display Campaign T00020: Cost Type | TEXT | Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click). |
| Sponsored Display Campaign T00020: CPC | NUMERIC | Cost-per-click (CPC) |
| Sponsored Display Campaign T00020: CTR | PERCENT | Click-through rate (CTR) |
| Sponsored Display Campaign T00020: Cumulative Reach | NUMERIC | Total number of unique users exposed to an ad from either a campaign, ad group, or product ad over the lifetime of the campaign or the past six months, whichever is shorter. This metric is updated daily. |
| Sponsored Display Campaign T00020: Currency | TEXT | The currency code associated with the campaign |
| Sponsored Display Campaign T00020: Impressions | NUMERIC | Total number of ad impressions |
| Sponsored Display Campaign T00020: Total return on advertising spend (RoAS) | PERCENT | Total return on advertising spend (14-day sales revenue divided by cost) |
| Sponsored Display Campaign T00020: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Display Campaign T00020: Total Cost | NUMERIC | Alias for Cost |
| Sponsored Display Campaign T00020: VCTR | NUMERIC | Click-through rate for views (clicks divided by views) |
| Sponsored Display Campaign T00020: Video Complete Views | NUMERIC | The number of impressions where the video was viewed to 100%. |
| Sponsored Display Campaign T00020: Video First Quartile Views | NUMERIC | The number of impressions where the video was viewed to 25%. |
| Sponsored Display Campaign T00020: Video Midpoint Views | NUMERIC | The number of impressions where the video was viewed to 50%. |
| Sponsored Display Campaign T00020: Video Third Quartile Views | NUMERIC | The number of impressions where the video was viewed to 75%. |
| Sponsored Display Campaign T00020: Video Unmutes | NUMERIC | The number of impressions where a customer unmuted the video. |
| Sponsored Display Campaign T00020: View Attributed Branded Searches (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, this is the number of searches that included the name of your brand occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedBrandedSearches14d. |
| Sponsored Display Campaign T00020: View Attributed Conversions (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d. |
| Sponsored Display Campaign T00020: View Attributed Detail Page View (14 days) | NUMERIC | This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d. |
| Sponsored Display Campaign T00020: View Attributed Orders New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. For CPC campaigns, this value is equal to attributedOrdersNewToBrand14d. |
| Sponsored Display Campaign T00020: View Attributed Sales (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d. |
| Sponsored Display Campaign T00020: View Attributed Sales New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. For CPC campaigns, this value is equal to attributedSalesNewToBrand14d. |
| Sponsored Display Campaign T00020: View Attributed Units Ordered (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedUnitsOrdered14d. |
| Sponsored Display Campaign T00020: View Attributed Units Ordered New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the 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. For CPC campaigns, this value is equal to attributedUnitsOrderedNewToBrand14d. |
| Sponsored Display Campaign T00020: View Impressions | NUMERIC | The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns. |
| Sponsored Display Campaign T00020: TODO | NUMERIC | TODo |
| Sponsored Display Campaign T00030: Total advertising cost of sales (ACoS) | NUMERIC | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| Sponsored Display Campaign T00030: Ad Network Conversions | NUMERIC | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
| Sponsored Display Campaign T00030: Ad Network Revenue | NUMERIC | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
| Sponsored Display Campaign T00030: Attributed Branded Searches (14 days) | NUMERIC | The number of searches that included the name of your brand occurring within 14 days of an ad click. |
| Sponsored Display Campaign T00030: Attributed Conversions Same SKU (14 days) | NUMERIC | 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 T00030: Attributed Conversions Same SKU (1 day) | NUMERIC | Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed Conversions Same SKU (30 days) | NUMERIC | Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed Conversions Same SKU (7 days) | NUMERIC | Number of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed Detail Page View (14 days) | NUMERIC | This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d. |
| Sponsored Display Campaign T00030: Attributed Sales Same SKU (14 days) | NUMERIC | 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 T00030: Attributed Sales Same SKU (1 day) | NUMERIC | Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed Sales Same SKU (30 days) | NUMERIC | Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed Sales Same SKU (7 days) | NUMERIC | Total value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised. |
| Sponsored Display Campaign T00030: Attributed conversions (14 days) | NUMERIC | Total number of attributed conversion events occurring within 14 days of ad click |
| Sponsored Display Campaign T00030: Attributed conversions (1 day) | NUMERIC | Total number of attributed conversion events occurring within 24 hours of ad click |
| Sponsored Display Campaign T00030: Attributed conversions (30 days) | NUMERIC | Total number of attributed conversion events occurring within 30 days of ad click |
| Sponsored Display Campaign T00030: Attributed conversions (7 days) | NUMERIC | Total number of attributed conversion events occurring within 7 days of ad click |
| Sponsored Display Campaign T00030: Attributed new-to-brand orders (14 days) | NUMERIC | The number of first-time orders for products within the brand over a one-year lookback window |
| Sponsored Display Campaign T00030: Attributed sales (14 days) | NUMERIC | Aggregate value of attributed sales occurring within 14 days of click on ad |
| Sponsored Display Campaign T00030: Attributed sales (1 day) | NUMERIC | Aggregate value of attributed sales occurring within 24 hours of click on ad |
| Sponsored Display Campaign T00030: Attributed sales (30 days) | NUMERIC | Aggregate value of attributed sales occurring within 30 days of click on ad |
| Sponsored Display Campaign T00030: Attributed sales (7 days) | NUMERIC | Aggregate value of attributed sales occurring within 7 days of click on ad |
| Sponsored Display Campaign T00030: Attributed new-to-brand sales (14 days) | NUMERIC | Aggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad |
| Sponsored Display Campaign T00030: Attributed units ordered (14 days) | NUMERIC | Total number of attributed units ordered within 14 days of ad click |
| Sponsored Display Campaign T00030: Attributed units ordered (1 day) | NUMERIC | Total number of attributed units ordered within 24 hours of ad click |
| Sponsored Display Campaign T00030: Attributed units ordered (30 days) | NUMERIC | Total number of attributed units ordered within 30 days of ad click |
| Sponsored Display Campaign T00030: Attributed units ordered (7 days) | NUMERIC | Total number of attributed units ordered within 7 days of ad click |
| Sponsored Display Campaign T00030: Attributed new-to-brand units ordered (14 days) | NUMERIC | The number of units from first-time orders for products within the brand over a one-year lookback window |
| Sponsored Display Campaign T00030: Campaign | TEXT | The name of the campaign |
| Sponsored Display Campaign T00030: Campaign Budget | NUMERIC | Total budget allocated to the campaign. |
| Sponsored Display Campaign T00030: Campaign Status | TEXT | Current status of the campaign. One of active, paused, or archived. |
| Sponsored Display Campaign T00030: Campaign ID (duplicate) | TEXT | The unique identifier of the campaign. (duplicate) |
| Sponsored Display Campaign T00030: Campaign tactic | TEXT | Campaign tactic code |
| Sponsored Display Campaign T00030: Clicks | NUMERIC | Total number of ad clicks |
| Sponsored Display Campaign T00030: Cost | NUMERIC | Total cost of all ad clicks |
| Sponsored Display Campaign T00030: Cost Type | TEXT | Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click). |
| Sponsored Display Campaign T00030: CPC | NUMERIC | Cost-per-click (CPC) |
| Sponsored Display Campaign T00030: CTR | PERCENT | Click-through rate (CTR) |
| Sponsored Display Campaign T00030: Cumulative Reach | NUMERIC | Total number of unique users exposed to an ad from either a campaign, ad group, or product ad over the lifetime of the campaign or the past six months, whichever is shorter. This metric is updated daily. |
| Sponsored Display Campaign T00030: Currency | TEXT | The currency code associated with the campaign |
| Sponsored Display Campaign T00030: Impressions | NUMERIC | Total number of ad impressions |
| Sponsored Display Campaign T00030: Total return on advertising spend (RoAS) | PERCENT | Total return on advertising spend (14-day sales revenue divided by cost) |
| Sponsored Display Campaign T00030: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Display Campaign T00030: Total Cost | NUMERIC | Alias for Cost |
| Sponsored Display Campaign T00030: VCTR | NUMERIC | Click-through rate for views (clicks divided by views) |
| Sponsored Display Campaign T00030: Video Complete Views | NUMERIC | The number of impressions where the video was viewed to 100%. |
| Sponsored Display Campaign T00030: Video First Quartile Views | NUMERIC | The number of impressions where the video was viewed to 25%. |
| Sponsored Display Campaign T00030: Video Midpoint Views | NUMERIC | The number of impressions where the video was viewed to 50%. |
| Sponsored Display Campaign T00030: Video Third Quartile Views | NUMERIC | The number of impressions where the video was viewed to 75%. |
| Sponsored Display Campaign T00030: Video Unmutes | NUMERIC | The number of impressions where a customer unmuted the video. |
| Sponsored Display Campaign T00030: View Attributed Branded Searches (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, this is the number of searches that included the name of your brand occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedBrandedSearches14d. |
| Sponsored Display Campaign T00030: View Attributed Conversions (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d. |
| Sponsored Display Campaign T00030: View Attributed Detail Page View (14 days) | NUMERIC | This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDetailPageView14d. |
| Sponsored Display Campaign T00030: View Attributed Orders New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. For CPC campaigns, this value is equal to attributedOrdersNewToBrand14d. |
| Sponsored Display Campaign T00030: View Attributed Sales (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d. |
| Sponsored Display Campaign T00030: View Attributed Sales New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. For CPC campaigns, this value is equal to attributedSalesNewToBrand14d. |
| Sponsored Display Campaign T00030: View Attributed Units Ordered (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedUnitsOrdered14d. |
| Sponsored Display Campaign T00030: View Attributed Units Ordered New To Brand (14 days) | NUMERIC | For Sponsored Display vCPM campaigns, the 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. For CPC campaigns, this value is equal to attributedUnitsOrderedNewToBrand14d. |
| Sponsored Display Campaign T00030: View Impressions | NUMERIC | The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns. |
| Sponsored Display Campaign T00030: TODO | NUMERIC | TODo |
| Sponsored Products Campaign: Total advertising cost of sales (ACoS) | NUMERIC | Total advertising cost of sales (cost divided by 14-day sales revenue) |
| Sponsored Products Campaign: Ad Network Conversions | NUMERIC | The Ad Network Reported Conversions (alias for Attributed conversions for 1 day) |
| Sponsored Products Campaign: Ad Network Revenue | NUMERIC | The Ad Network Reported Revenue (alias for Attributed sales for 1 day) |
| Sponsored Products Campaign: Attributed conversions (14 days) | NUMERIC | Total number of attributed conversion events occurring within 14 days of ad click |
| Sponsored Products Campaign: Attributed conversions (1 day) | NUMERIC | Total number of attributed conversion events occurring within 24 hours of ad click |
| Sponsored Products Campaign: Attributed conversions (30 days) | NUMERIC | Total number of attributed conversion events occurring within 30 days of ad click |
| Sponsored Products Campaign: Attributed conversions (7 days) | NUMERIC | Total number of attributed conversion events occurring within 7 days of ad click |
| Sponsored Products Campaign: Attributed sales (14 days) | NUMERIC | Aggregate value of attributed sales occurring within 14 days of click on ad |
| Sponsored Products Campaign: Attributed sales (1 day) | NUMERIC | Aggregate value of attributed sales occurring within 24 hours of click on ad |
| Sponsored Products Campaign: Attributed sales (30 days) | NUMERIC | Aggregate value of attributed sales occurring within 30 days of click on ad |
| Sponsored Products Campaign: Attributed sales (7 days) | NUMERIC | Aggregate value of attributed sales occurring within 7 days of click on ad |
| Sponsored Products Campaign: Attributed units ordered (14 days) | NUMERIC | Total number of attributed units ordered within 14 days of ad click |
| Sponsored Products Campaign: Attributed units ordered (1 day) | NUMERIC | Total number of attributed units ordered within 24 hours of ad click |
| Sponsored Products Campaign: Attributed units ordered (30 days) | NUMERIC | Total number of attributed units ordered within 30 days of ad click |
| Sponsored Products Campaign: Attributed units ordered (7 days) | NUMERIC | Total number of attributed units ordered within 7 days of ad click |
| Sponsored Products Campaign: Campaign | TEXT | The name of the campaign |
| Sponsored Products Campaign: Campaign budget | NUMERIC | Total budget allotted to the campaign |
| Sponsored Products Campaign: Campaign status | TEXT | The current status of the campaign |
| Sponsored Products Campaign: Campaign bidding strategy | TEXT | Campaign bidding strategy |
| Sponsored Products Campaign: Campaign daily budget | NUMERIC | Total daily budget for the campaign |
| Sponsored Products Campaign: Campaign ID (duplicate) | TEXT | The unique identifier of the campaign. (duplicate) |
| Sponsored Products Campaign: Campaign targeting type | TEXT | Campaign targeting type |
| Sponsored Products Campaign: Clicks | NUMERIC | Total number of ad clicks |
| Sponsored Products Campaign: Cost | NUMERIC | Total cost of all ad clicks |
| Sponsored Products Campaign: CPC | NUMERIC | Cost-per-click (CPC) |
| Sponsored Products Campaign: CTR | PERCENT | Click-through rate (CTR) |
| Sponsored Products Campaign: Impressions | NUMERIC | Total number of ad impressions |
| Sponsored Products Campaign: Total return on advertising spend (RoAS) | PERCENT | Total return on advertising spend (14-day sales revenue divided by cost) |
| Sponsored Products Campaign: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Products Campaign: Total Cost | NUMERIC | Alias for Cost |
| Today | DATE | Today's date |
Easily connect Amazon Ads to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.