blog post

How to import data from Snapchat Ads to Google Sheets

Florian Cabirol
January 30, 2024
How to import data from Snapchat Ads to Google Sheets

Quick steps to create a Snapchat Ads report with Google Sheets:

You can easiliy create a Snapchat Ads report following this step :

  1. Get informations from the data integration from our Snapchat Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Snapchat Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Snapchat Ads report with Looker Studio:

You can easiliy create a Snapchat Ads report following this step :

  1. Get informations from the data integration from our Snapchat Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Snapchat Ads at the end of the page.

The tutorial

Quick steps to create a Snapchat Ads report with PowerBI:

You can easiliy create a Snapchat Ads report following this step :

  1. Get informations from the data integration from our Snapchat Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Snapchat Ads at the end of the page.

The tutorial

Connecting Snapchat ads to Google Sheets has become a crucial step for marketers and businesses that want to track and analyze their advertising campaigns. By integrating these two powerful platforms, you can have easy access to your Snapchat Ads data and manipulate it in a familiar environment.

In this article, we'll walk you through the process of setting up your Google Sheets account, installing Catchr to export your data, and connecting your Snapchat Ads data with Google Sheets using it. Additionally, we'll provide some tips for working with your Snapchat Ads data in Google Sheets. 

Connect your SnapChat Ads data to Google Sheets.

First of all, you need to launch the Catchr add-on from the extension tab. To do so, you need to :

  1. Click on "Extensions".
  2. Then select "Catchr - Data connector" in the dropdown.
  3. A sidebar will open to the right of your screen.
Open the Catchr add-on in Google Sheet.
Open the Catchr add-on in Google Sheet.

Once the Catchr add-on is launched, you will need to click on "Add new" to create a new query.

Add new from Catchr Addon Google Sheets
Add a new query from Google Sheets

 Then, you will see the following screen:

Network Listing from Google Sheet
Network listing from Google Sheets

To add the Snapchat Ads account you want to get data from, click the "+" button and follow the steps on Catchr.

Go to Catchr to create your Snapchat Ads source.
Go to Catchr to create your Snapchat Ads source.
Create your source on Catchr.


Once you have added your account on Catchr, click on "SnapChat Ads" in the right panel of your Google Sheet. You might have to reload the add-on once if the account does not show up.

On the following step, you need to configure the Snapchat Ads account you want to extract data from, the metrics, the dimensions, your data range, specify some filters and options if you want.

Let's deep dive into each section.

Snapchat Ad Accounts

You can find all the accounts that you connected to the platform under this tab. You can select one or more accounts to extract all the data from your Snapchat Ads account.

Metrics

In the metrics tabs, you can find all the metrics available directly from the Snapchat Ads API. You can find some general metrics like :

  • Spend : Total spends of your ads.
  • Clicks : The total number of clicks on your ads.
  • Swipes : Total swipes on your ads.
  • Impressions : The total number of impressions of your ads.

But you will find more specialized ones too, like:

  • View time : The average view time of your ad.
  • Quartile 25%: Video Views to 25%
  • Views completion: Video Views to completion

Dimensions

In the dimensions tab, you will find all the dimensions available through the Snapchat Ads API, such as:

  • Ad Account Name: The account name
  • Day : The day of the statistics associated with your report.
  • Ad Name : The ad name from your Snapchat Ads Manager.

You can find all the dimensions and metrics available through our data connector on the listing fields page that corresponds.

Date range

The date range gave you the possibility to request a report bound to a start date and an end date. We have built some helpers like "Yesterday" or "Last Month". If you want to pull data from a specific time range, you can choose "Custom" then select the start and end dates.

Custom date from Catchr Google Sheet Add-on
Custom date from Catchr Google Sheet Add-on

Filters

The filters tab gave you the opportunity to filter the data you wanted to work on. By way of example, if you only want the data that has more than 100 impressions, you need to select "Impressions" in the "Fields". "Greater than" in the "Filter Type" and 100 in the "Value".

Add a filter from Catchr Google Sheets Add-on
Add a filter from Catchr Google Sheets Add-on

Please, note that successive filters combine with a AND logical operator.

Options

In the options, you can select three different options:

  • Appends rows : The following request will add rows at the end of the Google Sheets range.
  • Combine new rows with old ones: Catchr will automatically update all the rows and add the new one at the end of the sheets.
  • Schedules : You can schedule a refresh date. In this case, your data will refresh automatically on your Google Sheets.

Then, you could click on "Get Data" and the Snapchat Ads data will be automatically added to your Google Sheets.

How to create your first report with the Catchr Add-on for Google Sheets

Now that you know how to extract data, let's create our first report to get you the best performing ads from Snapchat Ads.

 

First, open a new Google Sheet and launch the Catchr Add-on from the "Extensions" menu. In the Catchr sidebar, click on your connected Snapchat Ads data source.

Next, choose the Snapchat Ads accounts you want to analyze. To obtain the best-performing ads, we'll need to select the appropriate metrics and dimensions. Click on "Metrics" and choose metrics such as "Impressions," "Clicks," "Conversions," and "Spend" to get a comprehensive view of your ads' performance. 

Metrics from Snapchat Ads
Metrics from Snapchat Ads

Then, select the dimensions you want to use to break down your metrics. For this analysis, you may want to include dimensions like "Ad Name," "Ad ID," and "Campaign Name" to help identify the top-performing ads easily.

Dimensions from Snapchat Ads
Dimensions from Snapchat Ads

Now, set the date range for your data. Since we're focusing on the last month, you can either choose the "Last month" preset or create a custom date range to cover the past 30 days.

If you want to narrow down your analysis further, you can apply filters based on specific criteria, such as targeting a particular audience or geographic location.

In the options section, you can choose whether you want to add new rows to the end of the list, combine them with the rows that are already there, or replace the current data with new results.

You can set up automatic data refreshes, such as once a day or once a week, so that you always have the most recent information. 

Finally, click on "Get Data" to import the Snapchat Ads data into Google Sheets. Once the data is populated, you can sort and analyze it to identify the best-performing ads. For instance, you can sort the ads by the highest number of conversions, the best click-through rate (CTR), or the lowest cost per conversion.

Result for Snapchat Ads
Result from Snapchat Ads

By following these steps, you can effectively extract the best-performing ads from Snapchat Ads in the last month using the Catchr Add-on for Google Sheets. This data will help you optimize your advertising efforts and make informed decisions about your marketing strategies.

Bonus : Your free Snapchat Ads - Overview Template

In this Snapchat Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Snapchat Ads OverviewTemplate for PowerBI

In this Snapchat Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Snapchat Ads

Explore your Snapchat Ads KPI with PowerBI : How-to, templates and metrics

Learn how to visualize and analyze your Snapchat Ads marketing data in PowerBI with this comprehensive tutorial. Discover how to import data using Catchr, create informative dashboards, and leverage key metrics for in-depth campaign analysis, turning raw data into actionable insights for strategic decision-making.

Florian Cabirol

Connect Snapchat Ads to Looker Studio : How-to, templates and metrics...

Discover your best performing Ad Creative and Campaigns on Snapchat Ads thanks to Looker Studio. Free templates included !

Florian Cabirol

How to import data from Snapchat Ads to Google Sheets

Learn how to connect Snapchat Ads to Google Sheets using Catchr Add-on to track and analyze your ad campaigns. Extract metrics, dimensions, and filter data to optimize your advertising strategy.

Florian Cabirol