How to import data from Snapchat Ads to Google Sheets

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. 

Installing Catchr for Google Sheets

To begin, you'll need to install the Catchr add-on for Google Sheets. There are two ways to do this:

a. From the marketplace:

1. Go to the Catchr Add-on page on the Google Workspace Marketplace.
2. Click on the "Install" button and accept the permissions.
3. Once the installation is complete, open a Google Sheet and proceed to the next step.

b. From a Google Sheet:

1. Open a new Google Sheet.
2. Click on "Extensions" in the top menu, hover over "Add-ons," and click on "Get add-ons."
3. Search for "Catchr" and select "Catchr - data connector."
4. Click on "Install" and accept the permissions.
5. Close the pop-up once the installation is complete.
6. Launch the Catchr Add-on

Once you have the add-on installed, you could launch it and start working with your Snapchat Ads data.

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.

‍

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

 Then, you will see the following screen:

To add the Snapchat Ads account you want to get data from, click the "+" button and follow the steps 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.

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".

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. 

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.

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.

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.

‍