Once you’ve authenticated your connection to Snapchat Marketing, you’re ready to create your first query. This guide will walk you through Snapchat Marketing query setup for Google Sheets, Looker Studio (formerly Data Studio), and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.
Before you begin
To connect Supermetrics to Snapchat Marketing, you need to have:
- A valid Snapchat user account with at least Account Admin or Campaign Manager access to an ad account. See roles and permissions
Here’s an example of sufficient user permissions:
Available fields
Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source.
- Field label is the name that appears in the sidebar.
- Metrics can be found under type - “met”.
- Dimensions can be found under type - “dim” .
Basics
The Snapchat Marketing data source allows you to:
- Analyze the performance of your Snapchat advertising campaigns in detail.
- Fetch all the main metrics and conversion data for your advertising campaigns.
- Split the data by campaign, ad group, ad, or by time.
- Inspect results by targeting demographics, such as user interests, location, language, age, gender, and device.
- Combine Snapchat and ecommerce marketing data to calculate the ROI of each campaign.
- Combine Snapchat data with metrics from other paid marketing channels to see which ad channel performs best.
Instructions
- Authenticate the data source in Google Sheets.
- Select Dates. Choose one date range (today, yesterday, last week, etc). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions.
You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted. - Click Get Data to Table to create your query and pull your data.
Advanced options for Google Sheets
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query.
- Include rejected ads in results.
- Replace blank metric values with zeros.
- Combine new results with old.
- Format results for Looker Studio (to import data from Google Sheets to Looker Studio).
- No header row.
- Highlight values with colours (green, red, etc.).
- Advanced settings.
- Authenticate the data source in Looker Studio.
- Under Dimension, select Dimensions.
- Under Metric, select Metrics.
- Select how to sort the data.
- Select the Date range from the auto or custom options. If you choose a custom date range, click the arrow on the top-right hand side. Under a specific period, select a Start Date and End Date.
Advanced options for Looker Studio
You can filter your data by selecting the field, condition, and value to filter by. Learn more about using filters.
- Authenticate the data source in Excel.
- Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions.
You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted. - Click Get data to create your query and pull your data.
Advanced options for Excel
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query.
- Learn more about Excel's Advanced settings.
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up data warehouse and cloud storage products (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up the Supermetrics API
Troubleshooting
The Snapchat Marketing data source includes the following limitations:
- Hourly breakdown is supported only for main advertising metrics, but not for conversion data.
- Breakdown by demographic insights and by time is only available from January 1, 2020, onwards.
- If you want to fetch demographic data for a time period before January 1, 2020, we’ve added lifetime versions of demographic dimensions, which ignore the date selection and return lifetime value for the selected metric.
- Reach (unique impressions) and frequency metrics are supported only on daily granularity and by campaign. Weekly and monthly granularity is not supported.
If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
If you see errors relating to quotas, or “daily query quotas”, read this guide.