Connect Snapchat Ads to Snowflake

snapchat Field Reference logo
+
snowflake

Stream your marketing data from Snapchat Ads to Snowflake

Connect Snapchat Ads to Snowflake in 2023

It is very simple to connect Snapchat 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 Snapchat Ads as a Data Source and Grant Access to Windsor.ai.

Snapchat Ads Windsor.ai Onboarding Screen

 

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.

Snapchat Ads metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account IDTEXTSnapchat Ads advertiser ID.
Account NameTEXTSnapchat Ads advertiser name.
Ad NameTEXTAd name
Ad Squad Daily BudgetNUMERICAd squad daily budget
Ad Squad IDTEXTAd squad ID
Ad Squad Lifetime BudgetNUMERICAd squad lifetime budget
Ad Squad NameTEXTAd squad name
Ad Squad Optimization GoalTEXTAd squad optimization goal
Ad Squad StatusTEXTAd squad status
Ad Squad TypeTEXTAd squad type
Ad Network ConversionsNUMERICAd network reported conversions (alias for Purchases)
Ad Network RevenueNUMERICAd network reported revenue (alias for Purchase Value)
CampaignTEXTCampaign name
ClicksNUMERICNumber of ad clicks (alias for Ad Click)
Achievement Unlocked (Conversion Event)NUMERICNumber of attributed "ACHIEVEMENT_UNLOCKED" conversion events
Ad Click (Conversion Event)NUMERICNumber of attributed "AD_CLICK" conversion events
Ad View (Conversion Event)NUMERICNumber of attributed "AD_VIEW" conversion events
Add Billing (Conversion Event)NUMERICNumber of attributed "ADD_BILLING" conversion events
Add to Cart (Conversion Event)NUMERICNumber of attributed "ADD_CART" conversion events
Add to Wishlist (Conversion Event)NUMERICNumber of attributed "ADD_TO_WISHLIST" conversion events
App Open (Conversion Event)NUMERICNumber of attributed "APP_OPEN" conversion events
Complete Tutorial (Conversion Event)NUMERICNumber of attributed "COMPLETE_TUTORIAL" conversion events
Invite (Conversion Event)NUMERICNumber of attributed "INVITE" conversion events
Level Complete (Conversion Event)NUMERICNumber of attributed "LEVEL_COMPLETE" conversion events
List View (Conversion Event)NUMERICNumber of attributed "LIST_VIEW" conversion events
Login (Conversion Event)NUMERICNumber of attributed "LOGIN" conversion events
Page View (Conversion Event)NUMERICNumber of attributed "PAGE_VIEW" conversion events
Purchases (Conversion Event)NUMERICNumber of attributed "PURCHASE" conversion events
Purchase ValueNUMERICValue of attributed "PURCHASE" conversion events (in Ad Account’s currency)
Rate (Conversion Event)PERCENTNumber of attributed "RATE" conversion events
Reserve (Conversion Event)NUMERICNumber of attributed "RESERVE" conversion events
Save (Conversion Event)NUMERICNumber of attributed "SAVE" conversion events
NUMERICNumber of attributed "SEARCH" conversion events
Share (Conversion Event)NUMERICNumber of attributed "SHARE" conversion events
Sign Up (Conversion Event)NUMERICNumber of attributed "SIGN_UP" conversion events
Spent Credits (Conversion Event)NUMERICNumber of attributed "SPENT_CREDITS" conversion events
Start Checkout (Conversion Event)NUMERICNumber of attributed "START_CHECKOUT" conversion events
Start Trial (Conversion Event)NUMERICNumber of attributed "START_TRIAL" conversion events
Subscribe(Conversion Event)NUMERICNumber of attributed "SUBSCRIBE" conversion events
View Content (Conversion Event)NUMERICNumber of attributed "VIEW_CONTENT" conversion events
Visit (Conversion Event)NUMERICNumber of attributed "VISIT" conversion events
CurrencyTEXTAd Account currency
Custom Event 1 (Conversion Event)NUMERICNumber of attributed "CUSTOM_EVENT_1" conversion events
Custom Event 2 (Conversion Event)NUMERICNumber of attributed "CUSTOM_EVENT_2" conversion events
Custom Event 3 (Conversion Event)NUMERICNumber of attributed "CUSTOM_EVENT_3" conversion events
Custom Event 4 (Conversion Event)NUMERICNumber of attributed "CUSTOM_EVENT_4" conversion events
Custom Event 5 (Conversion Event)NUMERICNumber of attributed "CUSTOM_EVENT_5" conversion events
DateDATEDate
ImpressionsNUMERICNumber of impressions
ObjectiveTEXTThe Objective of the campaign
Video Views to 25%NUMERICVideo views to 25%
Video Views to 50%NUMERICVideo views to 50%
Video Views to 75%NUMERICVideo views to 75%
Time Spent (milliseconds)NUMERICTotal time spent on top Snap ad (milliseconds)
SpendNUMERICAmount of money spent
Swipe Up RatePERCENTThe Swipe Up Rate
Swipe UpsNUMERICNumber of swipes
Total CostNUMERICAmount of money spent (alias for Spend)
Transaction RevenueNUMERICTransaction revenue (alias for Purchase Value)
TransactionsNUMERICNumber of transactions (alias for Purchases)
Video ViewsNUMERICTotal number of impressions that meet the qualifying video view criteria of at least 2 seconds of consecutive watch time or a swipe up action on the Top Snap
Video Views (View Time Only)NUMERICTotal number of impressions that meet the qualifying video view criteria of at least 2 seconds, not including swipe ups
Video Views to CompletionNUMERICVideo views to completion

Easily connect Snapchat 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 Snapchat Ads and Snowflake Integrations