Connect Amazon Ads to Snowflake

Amazon
+
snowflake

Stream your 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. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

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
Snowflake connector

 

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)
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
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
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
NUMERICTotal advertising cost of sales (cost divided by 14-day sales revenue)
NUMERICAggregate value of attributed sales occurring within 14 days of click on ad
NUMERICNumber of attributed units sold occurring within 14 days of click on an ad
TEXTThe name of the campaign
TEXTThe current status of the campaign
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
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
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
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
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
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
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
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
TEXTThe unique identifier of the campaign. (duplicate)
TEXTCampaign tactic code
NUMERICTotal number of ad clicks
NUMERICTotal cost of all ad clicks
NUMERICCost-per-click (CPC)
PERCENTClick-through rate (CTR)
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
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

Easily connect Amazon Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ 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