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
CampaignTEXTThe Campaign Name
DateDATEThe Date
ClicksNUMERICThe Number of Clicks
SpendNUMERICThe Amount of Money Spent
Total CostNUMERICThe Amount of Money Spent (Duplicate of Spend)
ImpressionsNUMERICThe Number of Impressions
ConversionsNUMERICThe Number of Conversions
RevenueNUMERICThe Amount of Revenue
Swipe UpsNUMERICThe Number of Swipes
Time Spent (milliseconds)NUMERICTotal Time Spent on top Snap Ad (milliseconds)
Video Views (View Time Only)NUMERICThe total number of impressions that meet the qualifying video view criteria of at least 2 seconds, not including swipe ups
Video Views to 25%NUMERICVideo Views to 25%
Video Views to 50%NUMERICVideo Views to 50%
Video Views to 75%NUMERICVideo Views to 75%
Video Views to CompletionNUMERICVideo Views to Completion
Video ViewsNUMERICThe total 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
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
Purchases (Conversion Event)NUMERICNumber of attributed “PURCHASE” conversion events
Purchase ValueNUMERICValue of attributed “PURCHASE” conversion events
Save (Conversion Event)NUMERICNumber of attributed “SAVE” conversion events
Start Checkout (Conversion Event)NUMERICNumber of attributed “START_CHECKOUT” conversion events
Start Checkout (Conversion Event)NUMERICNumber of attributed “ADD_CART” conversion events
View Content (Conversion Event)NUMERICNumber of attributed “VIEW_CONTENT” conversion events
Add Billing (Conversion Event)NUMERICNumber of attributed “ADD_BILLING” conversion events
Sign Up(Conversion Event)NUMERICNumber of attributed “SIGN_UP” conversion events
Search (Conversion Event)NUMERICNumber of attributed “SEARCH” conversion events
Level Complete (Conversion Event)NUMERICNumber of attributed “LEVEL_COMPLETE” conversion events
App Open (Conversion Event)NUMERICNumber of attributed “APP_OPEN” conversion events
Page View (Conversion Event)NUMERICNumber of attributed “PAGE_VIEW” conversion events
Subscribe(Conversion Event)NUMERICNumber of attributed “SUBSCRIBE” conversion events
Ad Click (Conversion Event)NUMERICNumber of attributed “AD_CLICK” conversion events
Ad View (Conversion Event)NUMERICNumber of attributed “AD_VIEW” conversion events
Complete Tutorial (Conversion Event)NUMERICNumber of attributed “COMPLETE_TUTORIAL” conversion events
Invite (Conversion Event)NUMERICNumber of attributed “INVITE” conversion events
Login (Conversion Event)NUMERICNumber of attributed “LOGIN” conversion events
Share (Conversion Event)NUMERICNumber of attributed “SHARE” conversion events
Reserve (Conversion Event)NUMERICNumber of attributed “RESERVE” conversion events
Achievement Unlocked (Conversion Event)NUMERICNumber of attributed “ACHIEVEMENT_UNLOCKED” conversion events
Add to Wishlist (Conversion Event)NUMERICNumber of attributed “ADD_TO_WISHLIST” conversion events
Spent Credits (Conversion Event)NUMERICNumber of attributed “SPENT_CREDITS” conversion events
Rate (Conversion Event)NUMERICNumber of attributed “RATE” conversion events
Start Trial (Conversion Event)NUMERICNumber of attributed “START_TRIAL” conversion events
List View (Conversion Event)NUMERICNumber of attributed “LIST_VIEW” 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
Swipe Up RateNUMERICThe Swipe Up Rate

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.