Connect Snapchat Ads to Google Sheets: Tutorial and templates (2026)

Snapchat has crossed 450 million users, thanks to its unique interactive experience. In essence, the platform has a brilliant mix of AR, social media culture, and visual content, designed to keep users engaged. It has evolved from trademark puppy filters to full-fledged marketing campaigns and advertisements.

Advertising on Snapchat has been the obvious solution for businesses trying to connect with their younger audience. As the platform evolves, marketers face specific challenges that could hinder their analytical and reporting workflow. This is due to the following reasons:

• Snapchat’s analytics platform is less customizable, which makes it difficult to track multi-client campaigns and goals.
• Large volumes of data from high-volume campaigns can be challenging to process in the native analytics platform.

Given these challenges, you need a reliable workflow that streamlines your campaign KPIs across multiple clients in a single dashboard. The solution is to connect your Snapchat Ads reporting to Google Sheets with Two Minute Reports. 

Now let’s explore the two efficient ways to connect your Snapchat Ads data to Google Sheets. By the end, you’ll know how to automate performance reporting and drive smarter decisions. 

Let’s get started.

How to connect Snapchat Ads data to Google Sheets?

You can connect Snapchat Ads data to Google Sheets using the following methods:

Method 1: Connecting Snapchat Ads data to Google Sheets using the sidebar.

Method 2: Connecting Snapchat Ads data to Google Sheets using pre-built templates.

To get started, install the Two Minute Reports add-on from the Google Workspace Marketplace. Once you’ve installed, you can proceed with the following steps.

Method 1: Connecting Snapchat Ads to Google Sheets using the sidebar

Step 1: Creating a Connection to your source

To create a Connection, you must connect your Snapchat Ads accounts to Google Sheets.

To do this, launch the Two Minute Reports add-on from the Extensions menu in your spreadsheet. Next, open the sidebar and perform the following steps:

Go to Menu > Click Connections > Click Add to start creating a new Connection

Once this is done, the “Adding new connection” dialog box appears. Next, authenticate your Snapchat Ads connection with Two Minute Reports.

1. Select the Snapchat Ads connector. 

2. Next, authorize your Connection by specifying the login credentials. Once you’ve authenticated, you can visualize the following fields: Name, ID, Connection Name, as shown below:

3. Enable the toggle for the accounts you want to run queries. Please note that you cannot extract data from the disabled accounts.

4. Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected Snapchat Ads accounts are reflected in the sidebar.

Now that you’ve created the Connection, the next step is to create a query. Let’s explore how to do that.

Step 2: Creating a query and report configuration

To extract your Snapchat Ads campaign data, click Data Queries from the Menu dropdown. You can follow the steps below to create your Snapchat Ads report.

1. Click Add and select your desired Snapchat Ads account from the sidebar.

2. Alternatively, navigate to the “Clients” section. Click on “Manage clients” and map the necessary account details. Once done, click Save & Close to save your client’s details. 

3. Next, add the required Snapchat Ads metrics and dimensions you want to analyze. Then select the date range to track and measure campaign performance. 

4. Once you finish the above steps, click Run Query to visualize the final results. This query fetches the data from your chosen Snapchat Ads account onto the sheet and cell of your choice. 

Pro tip: You can set up automated refresh schedules (daily, weekly or monthly) and keep your clients informed with real-time campaign performance updates.

Pro TMR tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extension > Two Minute Reports > Choose your desired quick action.

While creating your Snapchat Ads report through the sidebar is straightforward, there’s also another easier way to streamline your campaign performance analysis. Let’s look at leveraging Snapchat Ads reporting via built-in templates.

Method 2: Create a Snapchat Ads report using pre-built templates

You can access the Snapchat Ads templates for Google Sheets via: Extensions > Two Minute Reports > Templates.

• In the template gallery, you can choose your desired Snapchat Ads template to streamline performance tracking.
• Next, click Use to build your report. Your template will open in Google Sheets.
• Finish importing your template by selecting the required Snapchat Ads accounts from the dropdown. Once done, click Submit to create your report. 

• Next, click Extensions > Two Minute Reports > Run all queries to auto-populate your dashboard with data-driven insights.

Common mistakes to avoid when pulling data from Snapchat Ads

When connecting Snapchat Ads to Google Sheets, marketers can encounter pitfalls that lead to misinterpretation or inefficient reporting. Here’s a list of common mistakes to avoid, along with reliable solutions for enhanced data handling.

1. Overlooking data limitations

Issue: Snapchat retains only lead generation data for the last 90 days. Many marketers forget this and attempt to analyze long-term performance without adequate historical data.

Solution: Regularly export your Snapchat leads ads data to Google Sheets to maintain a historical record. You can also automate this process by setting up refresh schedules, so you can analyze trends without losing critical insights.

2. Neglecting proper query configuration

Issue: Failing to configure the query effectively can result in incomplete or irrelevant data being pulled into reports.

Solution: With Two Minute Reports, you can run a structured query (consisting of metrics and dimensions) that aligns with your campaign objectives. You can then set up dashboards to auto-update, eliminating manual data overload.

3. Ignoring data context

Issue: It’s easy to get caught up in the numbers and overlook their context, such as seasonal trends or campaign-specific factors.

Solution: Use a notes column in Google Sheets to document insights related to specific data points. This added context can be invaluable when interpreting results later.

4. Assuming all metrics are easily comparable

Issue: Many marketers compare metrics from different campaigns or timeframes without accounting for variables like budget, creative differences, or audience shifts.

Solution: Establish a consistent metric framework in Google Sheets to categorize and compare similar campaigns for a fair analysis.

5. Neglecting updates and iteration

Issue: Marketers may set up their reports once and neglect to review or update them regularly.

Solution: Set up automated refresh schedules based on your client reporting frequency. With real-time updates, you can ensure continuous performance monitoring and improve next steps based on iteration and feedback.

Which metrics from Snapchat Ads analytics should you track?

Here are the top metrics you can track and visualize to optimize your campaign performance.

Get Snapchat Ads in Looker Studio 

Connect your Snapchat Ads account to Looker Studio using Two Minute Reports for creating detailed reports and visual dashboards without the complexity of manual data entry. With no-code integration, comprehensive analytical capabilities, and automated workflows, strategic campaign insights from Snapchat Ads have become quicker and more accessible.

Connect your advertising platforms with Google Sheets

Integrate Snapchat Ads with other PPC platforms such as Google Ads, LinkedIn Ads, etc, in a single Google Sheets dashboard using Two Minute Reports. Blend key PPC metrics across all ad platforms, analyze cross-channel ROI and allocate optimal resources. With unlimited reporting across Google Sheets and Looker Studio, faster data syncs, and real-time performance insights, stay on top of trends and accomplish your ROI goals.