Destinations
Data Sources
Windsor MCP for AI Insights
About us
Careers
Contact us
Security
Customer Reviews
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
API Documentation
Product Documentation
Case Studies
Blog
Product Updates
Help & Community
Windsor vs Supermetrics
+
Stream marketing data from Amazon Ads to Snowflake
About Amazon Ads
About SnowFlake
Connect Amazon Ads to Snowflake
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 |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date |
| Day of month | TEXT | Day of the month |
| Marketplace | TEXT | Amazon marketplace (country) name |
| Month | TEXT | Number of the month |
| Profile ID | TEXT | Amazon Advertising profile ID |
| Source | TEXT | The name of the Windsor connector returning the row |
| 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: Campaign | TEXT | The name of the campaign |
| Sponsored Brands Campaign Video: Campaign budget Amount | NUMERIC | Total budget allotted to the campaign |
| Sponsored Brands Campaign Video: Campaign budget currency code | TEXT | The currency code associated with 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: Spend (alias for Cost) | NUMERIC | Alias for Cost |
| Sponsored Brands Campaign Video: Total Cost | NUMERIC | Alias for Cost |
| Sponsored Display Campaign: Branded Searches | NUMERIC | 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 | 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 | 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 | NUMERIC | The ID associated with a campaign. |
| Sponsored Display Campaign: Campaign Name | TEXT | The name associated with a campaign. |
| Sponsored Display Campaign: Clicks | NUMERIC | Total number of clicks on an ad. |
| Sponsored Display Campaign: Cost | NUMERIC | Total cost of ad clicks. |
| Sponsored Display Campaign: Detail Page Views | NUMERIC | Number of detail page views occurring within 14 days of an ad click or view. |
| Sponsored Display Campaign: Detail Page Views Clicks | NUMERIC | Number of detail page views occurring within 14 days of an ad click. |
| Sponsored Display Campaign: Impressions | NUMERIC | Total number of ad impressions. |
| Sponsored Display Campaign: Impressions Views | NUMERIC | 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: New To Brand Purchases | NUMERIC | 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 | 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 | 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 | 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 | 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: Purchases | NUMERIC | Number of attributed conversion events occurring within 14 days of an ad click or view. |
| Sponsored Display Campaign: Purchases Clicks | NUMERIC | Number of attributed conversion events occurring within 14 days of an ad click. |
| Sponsored Display Campaign: Purchases Promoted Clicks | 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: Sales | NUMERIC | Total value of sales occurring within 14 days of an ad click or view. |
| Sponsored Display Campaign: Sales Clicks | NUMERIC | Total value of sales occurring within 14 days of an ad click. |
| Sponsored Display Campaign: Sales Promoted Clicks | 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: Units Sold | NUMERIC | Number of attributed units sold within 14 days of an ad click or view. |
| Sponsored Display Campaign: Video Complete Views | NUMERIC | The number of impressions where the video was viewed to 100%. |
| Sponsored Display Campaign: Video First Quartile Views | NUMERIC | The number of impressions where the video was viewed to 25%. |
| Sponsored Display Campaign: Video Midpoint Views | NUMERIC | The number of impressions where the video was viewed to 50%. |
| Sponsored Display Campaign: Video Third Quartile Views | NUMERIC | The number of impressions where the video was viewed to 75%. |
| Sponsored Display Campaign: Video Unmutes | NUMERIC | The number of impressions where a customer unmuted the video. |
| 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 |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
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.