Connect Snapchat Ads to Google BigQuery

snapchat to bigquery

Analyze your Snapchat Ads data with Google BigQuery

Connect Snapchat Ads to Google BigQuery

It is very simple to connect Snapchat Ads to Google BigQuery, it can be done in a fast and easy manner with Windsor.ai.

 

First Step:

You need to select Snapchat Ads as a Data Source and Grant Access to Windsor.ai.

Snapchat Integration

 

Second Step:

You will need to go to Google BigQuery as a Destination.

BigQuery Integration

 

Third Step:

Make sure you follow the instructions on the screen. Once you complete the setup your data will start streaming in the interval you specify. You can always come back and change the settings at a later stage.

BigQuery Integration

 (Don’t forget to grant access to bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com)

 

Fourth Step:

As a connector URL, you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from Charts.Windsor.ai

 

Snapchat Ads metrics & dimensions available for streaming into Google BigQuery

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 RateNUMERICThe 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

Windsor.ai: Easily connect Snapchat Ads to Google BigQuery

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 marketeers, whenever they want.

insights

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

Build your Snapchat Ads and Google BigQuery Integrations