Connect Amazon Ads to Snowflake

Amazon
+
snowflake

Stream marketing data from Amazon Ads to 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:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. 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.

google bigquery amazon ads integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

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

Connect your data

 

nametypedescription
Account IDTEXTThe Account ID
Account NameTEXTThe Account Name
Ad typeTEXTOne of: Sponsored Brands, Sponsored Display, Sponsored Products
DateDATEDate
MarketplaceTEXTAmazon marketplace (country) name
Profile IDTEXTAmazon Advertising profile ID
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICTotal number of attributed conversion events occurring within 14 days of ad click
PERCENTThe number of new-to-brand orders relative to the number of clicks (New-to-brand order rate = new-to-brand orders / clicks)
NUMERICThe number of first-time orders for products within the brand over a one-year lookback window
NUMERICThe percentage of total orders that are new-to-brand orders
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
NUMERICAggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad
PERCENTThe percentage of total sales of new-to-brand purchases
NUMERICThe number of units from first-time orders for products within the brand over a one-year lookback window
NUMERICThe percentage of total units that are units from new-to-brand orders
NUMERICNumber of attributed units sold occurring within 14 days of click on an ad
TEXTThe name of the campaign
NUMERICTotal budget allotted to the campaign
TEXTOne of: daily or lifetime
TEXTThe current status of the campaign
TEXTCampaign ad format
TEXTThe unique identifier of the campaign. (duplicate)
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
NUMERICTotal number of ad impressions
PERCENTTotal return on advertising spend (14-day sales revenue divided by cost)
NUMERICAlias for Cost
NUMERICAlias for Cost
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICTotal number of attributed conversion events occurring within 14 days of ad click
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
TEXTThe name of the campaign
NUMERICTotal budget allotted to the campaign
TEXTOne of: daily or lifetime
TEXTThe current status of the campaign
TEXTCampaign ad format
TEXTThe unique identifier of the campaign. (duplicate)
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
NUMERICTotal number of ad impressions
PERCENTTotal return on advertising spend (14-day sales revenue divided by cost)
NUMERICAlias for Cost
NUMERICAlias for Cost
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)
NUMERICThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)
NUMERICThe number of searches that included the name of your brand occurring within 14 days of an ad click.
NUMERICNumber of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICThis 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.
NUMERICTotal value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal number of attributed conversion events occurring within 14 days of ad click
NUMERICTotal number of attributed conversion events occurring within 24 hours of ad click
NUMERICTotal number of attributed conversion events occurring within 30 days of ad click
NUMERICTotal number of attributed conversion events occurring within 7 days of ad click
NUMERICThe number of first-time orders for products within the brand over a one-year lookback window
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
NUMERICAggregate value of attributed sales occurring within 24 hours of click on ad
NUMERICAggregate value of attributed sales occurring within 30 days of click on ad
NUMERICAggregate value of attributed sales occurring within 7 days of click on ad
NUMERICAggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad
NUMERICTotal number of attributed units ordered within 14 days of ad click
NUMERICTotal number of attributed units ordered within 24 hours of ad click
NUMERICTotal number of attributed units ordered within 30 days of ad click
NUMERICTotal number of attributed units ordered within 7 days of ad click
NUMERICThe number of units from first-time orders for products within the brand over a one-year lookback window
TEXTThe name of the campaign
NUMERICTotal budget allocated to the campaign.
TEXTCurrent status of the campaign. One of active, paused, or archived.
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
TEXTDetermines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
NUMERICTotal 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.
TEXTThe currency code associated with the campaign
NUMERICTotal number of ad impressions
PERCENTTotal return on advertising spend (14-day sales revenue divided by cost)
NUMERICAlias for Cost
NUMERICAlias for Cost
NUMERICClick-through rate for views (clicks divided by views)
NUMERICThe number of impressions where the video was viewed to 100%.
NUMERICThe number of impressions where the video was viewed to 25%.
NUMERICThe number of impressions where the video was viewed to 50%.
NUMERICThe number of impressions where the video was viewed to 75%.
NUMERICThe number of impressions where a customer unmuted the video.
NUMERICFor 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.
NUMERICFor 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.
NUMERICThis 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICThe total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.
NUMERICTODo
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)
NUMERICThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)
NUMERICThe number of searches that included the name of your brand occurring within 14 days of an ad click.
NUMERICNumber of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICNumber of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICThis 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.
NUMERICTotal value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.
NUMERICTotal number of attributed conversion events occurring within 14 days of ad click
NUMERICTotal number of attributed conversion events occurring within 24 hours of ad click
NUMERICTotal number of attributed conversion events occurring within 30 days of ad click
NUMERICTotal number of attributed conversion events occurring within 7 days of ad click
NUMERICThe number of first-time orders for products within the brand over a one-year lookback window
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
NUMERICAggregate value of attributed sales occurring within 24 hours of click on ad
NUMERICAggregate value of attributed sales occurring within 30 days of click on ad
NUMERICAggregate value of attributed sales occurring within 7 days of click on ad
NUMERICAggregate value of attributed sales of new-to-brand orders occurring within 7 days of click on ad
NUMERICTotal number of attributed units ordered within 14 days of ad click
NUMERICTotal number of attributed units ordered within 24 hours of ad click
NUMERICTotal number of attributed units ordered within 30 days of ad click
NUMERICTotal number of attributed units ordered within 7 days of ad click
NUMERICThe number of units from first-time orders for products within the brand over a one-year lookback window
TEXTThe name of the campaign
NUMERICTotal budget allocated to the campaign.
TEXTCurrent status of the campaign. One of active, paused, or archived.
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
TEXTDetermines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
NUMERICTotal 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.
TEXTThe currency code associated with the campaign
NUMERICTotal number of ad impressions
PERCENTTotal return on advertising spend (14-day sales revenue divided by cost)
NUMERICAlias for Cost
NUMERICAlias for Cost
NUMERICClick-through rate for views (clicks divided by views)
NUMERICThe number of impressions where the video was viewed to 100%.
NUMERICThe number of impressions where the video was viewed to 25%.
NUMERICThe number of impressions where the video was viewed to 50%.
NUMERICThe number of impressions where the video was viewed to 75%.
NUMERICThe number of impressions where a customer unmuted the video.
NUMERICFor 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.
NUMERICFor 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.
NUMERICThis 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICFor 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.
NUMERICThe total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.
NUMERICTODo
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICThe Ad Network Reported Conversions (alias for Attributed conversions for 1 day)
NUMERICThe Ad Network Reported Revenue (alias for Attributed sales for 1 day)
NUMERICTotal number of attributed conversion events occurring within 14 days of ad click
NUMERICTotal number of attributed conversion events occurring within 24 hours of ad click
NUMERICTotal number of attributed conversion events occurring within 30 days of ad click
NUMERICTotal number of attributed conversion events occurring within 7 days of ad click
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
NUMERICAggregate value of attributed sales occurring within 24 hours of click on ad
NUMERICAggregate value of attributed sales occurring within 30 days of click on ad
NUMERICAggregate value of attributed sales occurring within 7 days of click on ad
NUMERICTotal number of attributed units ordered within 14 days of ad click
NUMERICTotal number of attributed units ordered within 24 hours of ad click
NUMERICTotal number of attributed units ordered within 30 days of ad click
NUMERICTotal number of attributed units ordered within 7 days of ad click
TEXTThe name of the campaign
NUMERICTotal budget allotted to the campaign
TEXTThe current status of the campaign
TEXTCampaign bidding strategy
NUMERICTotal daily budget for the campaign
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign targeting type
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
NUMERICTotal number of ad impressions
PERCENTTotal return on advertising spend (14-day sales revenue divided by cost)
NUMERICAlias for Cost
NUMERICAlias for Cost
TodayDATEToday's date

Easily connect Amazon Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Amazon Ads and Snowflake Integrations