Extract Transform & Load Snapchat Ads data to Google BigQuery

Extract, Transform & Load your Snapchat Ads data into Google BigQuery, in minutes, for free, with our reliable & scalable pre-built integrations. No coding or SQL knowledge required. Transform your data to an analytics ready format with post load transformations. Use a DataChannel managed Google BigQuery data warehouse and reduce your administrative overheads.

Get Started for Free

About Snapchat Ads

Snapchat is a camera and messaging app that connects people to their friends and the world. With Snapchat Ads, advertisers can reach a global audience and drive meaningful results.

Learn more about Snapchat.

‍

Choose what data you would like to move from Snapchat Ads

Ad-Squads

This pipeline can be used to request and retrieve details about the Ad Squads.

Ads

This pipeline can be used to request and retrieve Ad related information.

Campaign Stats

This pipeline can be used to request and retrieve campaign stats data with TOTAL, DAY, and HOUR granularity options.

Campaigns

This pipeline can be used to request and retrieve details about the Campaigns.

Creatives

This pipeline can be used to request and retrieve details about Creatives.

DMA

This pipeline can be used to request and retrieve the list of metro/dma targeting options.

Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.

‍

Steps to Integrate Snapchat Ads with Google BigQuery using DataChannel

From the DataSources section select Snapchat as the data source.
Select your added BigQuery data warehouse as the data destination. If you have not yet added a data warehouse, go to Data Warehouse tab and add a warehouse.
Authorize DataChannel to connect to your Snapchat account using OAuth, similar to the process described in this Documentation page.
Click on + Data Pipeline to start adding data pipelines to your account.