Connect Snapchat Ads to Google BigQuery with Windsor.ai

snapchat large

+

bigquery

Stream all your media and ads data from from Snapchat Ads to Google BigQuery

About Snapchat Ads

Snapchat Ads is a social media advertising service which allows businesses and individuals to advertise to their target audiences on Snapchat. The format of the ads have different objectives such as driving traffic to a website, app installs, awareness and reach of brands and video views.

About Google BigQuery

Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.

Snapchat Ads metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
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)NUMERICNumber of attributed "RATE" conversion events
Reserve (Conversion Event)NUMERICNumber of attributed "RESERVE" conversion events
Save (Conversion Event)NUMERICNumber of attributed "SAVE" conversion events
Search (Conversion Event)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
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
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.

Start a free trial today.

Integrate all your data and measure what matters.