The Ultimate Guide to Streamlining Snapchat Ads Reporting with Google Sheets

It’s 2025—Snapchat has crossed 400 million daily active users, thanks to its unique interactive experience. In essence, Snapchat is a brilliant mix of AR, social media culture, and visual content in an irresistible product. This social media platform (application) has evolved from trademark puppy filters to full-fledged marketing campaigns and advertisements. 

Advertising on Snapchat has been the obvious solution for any business trying to connect with its younger audience. As the platform evolves, marketers face specific challenges that could hinder their advertising effectiveness. 

1. Snapchat stores ad data for only the last 90 days. 
2. Snapchat’s analytics platform isn’t as detailed or easily interpreted as other social media. 
3. Large volumes of data from large-scale campaigns could be challenging to process in the native analytics platform. 

Given these challenges, a robust data management tool is essential. Now that we’ve established the why, let’s explore the how. Here’s how you can effectively extract Snapchat Ads data to Google Sheets.

How to extract Snapchat Ads to Google Sheets?

This article will take you through simple and efficient methods to extract data from Snapchat Ads to Google Sheets. To get started, install the Two Minute Reports (TMR) add-on to Google Sheets. Here’s a step-by-step installation tutorial: How to install TMR

Once installed, you can proceed to follow two major methods: 

• Method 1: Connecting Snapchat Ads to Google Sheets using the Sidebar
• Method 2: Connecting Snapchat Ads to Google Sheets using in-built templates

Method 1: Create a Snapchat Ads report using the Sidebar

Step 1: Creating a Connection to your source

• Open a new Google Sheet and launch TMR from the extensions menu. The TMR sidebar will appear on the right side. 

Note: The sidebar serves as the primary interface for TMR, with all its features. 

• Navigate to the menu dropdown in the TMR sidebar and click Connections. Next, click Add to create a new Connection.
• The ‘Adding new Connection’ dialog box appears. Here, we will perform three key steps to establish a Connection in Google Sheets, which takes less than 2 minutes:
  • Selecting the Snapchat Ads Connector 
  • Authentication 
  • Mapping your Snapchat account with the respective Connector

• Select Snapchat Ads Connector from the list of options. Next, authorize your Connection by specifying your login credentials. 
• Once you’ve successfully authenticated, you’ll visualize a screen displaying your Account name, ID, Connection name, and Status, as shown below:

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

Note: Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar.

With the Connection established, the next crucial step is to create a query. Let’s explore how to do that.

Step 2: Creating a query and report configuration

To pull your Snapchat Ads performance data, navigate to the Data Queries section and create a new query.

• Click Add and choose the respective Snapchat accounts to analyze your ad performance. 

Note: You can manage multiple client accounts under one roof. Simply select one or more accounts to analyze and gather ad insights. 

• Alternatively, navigate to the Clients section. Add your client and map their corresponding Snapchat account.  
• Click on “Manage Clients” and map the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
• Next, add the Snapchat Ads metrics and dimensions you want to analyze. Once done, select the date range for which you want to analyze ad performance.

• Next, you have to configure your data reporting by choosing how to customize it. You can also organize and filter your data from within the sidebar.
• Once you finish the above steps, click Run Query to visualize the output. This query fetches the data from the data source onto the sheet and cell of your choice.

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

While creating a report through the sidebar is quite straightforward, there’s also an option to streamline the process further. Let’s look at how to utilize built-in templates for reporting on Snapchat Ads.

Method 2: Create Snapchat ad reports with templates

Two Minute Reports offers pre-built templates that help you create visual reports quickly. Each template is engineered with the right combination of KPIs and visual aids to serve specific purposes, such as providing an overview or tracking a specific item. 

• Once the Connection is created and authorized, you can access the Templates Gallery from the Two Minute Reports sidebar menu.

Note: You can also open the Templates Gallery directly from Extensions > Two Minute Reports > Templates

• In the Template Gallery, you can filter the template that fits your purpose by category or data source. You can also search for specific templates if you have something in mind.
• Once you find the right template, click “Use” to build your template. Then, choose the preferred data source and the relevant Accounts.
• Name your report and click “Submit” to create the report. 

Note: Your report will be created in a new Google Spreadsheet. 

• Click “Go to your new spreadsheet” to access the new report. Once the new report opens up, launch the TMR sidebar.
• Open the menu next to the “Add” button and click “Run All Queries” to update the template with your data within the date range. 
• Once the queries are complete, the template will be updated with your data. 

Scheduling data refresh and emails 

So far, you have: 

• Installed Two Minute Reports (TMR)
• Created a Data Source (Snapchat Ads) in TMR
• Created and executed a Data Query that fetches your data

Now you have your data in your Google Spreadsheet. The next time you need fresh data, you can run the query again. 

Or you can automate your data queries. 

With the “Schedule Refresh” feature, TMR runs automatically, constantly refreshing your queries to your desired date, time, and duration. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard. 

Here’s how you set this feature up. 

• Click on the menu and then on Schedule Reports to open the section. From this section, you can create a “Schedule,” an instruction for Two Minute Reports to run the query automatically.

• Name the Schedule and choose the time interval between the data refreshes. From this section, you can choose the following: 
  • You want your data daily, weekly, or monthly.
  • The designated day for the refresh
  • The time for the refresh
• Choose the Action for every data refresh— choose whether you need an email notification for every refresh. 
• Then choose the relevant sheet for the refresh and type in your email (in case you need an email notification)
• You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel file, or attach the spreadsheet as an Excel file.
• Save the refresh and ensure that TMR will refresh your data at the desired intervals. 

Continue reading about this feature: “How to Refresh Data Automatically in Google Sheets.”

Common mistakes to avoid when pulling or interpreting data from Snapchat Ads

When working with Snapchat Ads and integrating the data into Google Sheets, marketers can sometimes encounter pitfalls that lead to misinterpretation or inefficient reporting. Here’s a list of common mistakes to avoid and insights on using tools like Google Sheets for enhanced data handling. 

Overlooking data limitations

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

Instead, regularly export your data to Google Sheets to maintain a historical record. This way, you can analyze trends over time without losing critical insights.

Neglecting proper query configuration

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

Instead, take the time to set clear objectives for the metrics you need. Consider setting up a Google Sheets template outlining these objectives to streamline query configurations.

Ignoring data context

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

Instead, 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.

Assuming all metrics are easily comparable

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

Instead, establish a consistent metric framework in Google Sheets where you can categorize and compare similar campaigns for a fair analysis.

Failing to adjust for missing data values

Mistake: Not setting up parameters for missing data can skew your report conclusions.

Instead, when configuring your query, include settings that replace blank values with zeros. Furthermore, document these adjustments in your Google Sheets for transparency.

Rushing the data interpretation process

Mistake: Some marketers hastily read reports without analyzing trends, potential anomalies, or outlier data points.

Instead, visualize your data using charts and graphs after pulling it to Google Sheets. This approach can help spot patterns or irregularities that need further investigation.

Neglecting updates and iteration

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

Instead, schedule periodic reviews of your Google Sheets reports to ensure they align with ongoing campaign goals. Use feedback to iterate on query configurations and reporting styles. 

By being mindful of these common mistakes and incorporating best practices, you can greatly enhance the effectiveness of your Snapchat Ads reporting and data analysis efforts.

Why import Snapchat Ads Data in Google Sheets? 

Google Sheets has been a popular option for all report creation, including Snapchat Ads, Google Ads, and Facebook (Meta) Ads, for the best reasons. 

Simple segmentation and complex analytics

Snapchat’s interface might make segmenting and filtering data difficult. The native interface also might not let you create custom formulas and metrics. Extracting your ad data to a Google spreadsheet allows you to segment, transform, and visualize it in many ways. 

Add-ons and extensions

Google Sheets can integrate several handy functions through add-ons. Two Minute Reports (TMR) is a great example. With this add-on, you can extract data, manage data, create reports, and even automate them to update themselves every hour. 

Data management and automation

By constantly integrating your Snapchat Ads data to Google Sheets, you can eliminate downloading CSV files, analyzing, and creating reports manually. You can also always access fresh and actionable data by scheduling data extraction with tools like TMR. 

Collaborative access

Building a spreadsheet also allows for seamless collaboration between functions in your organization. The ease of data accessibility allows teams to work together with real-time data, fostering a highly collaborative environment. 

Workflow efficiency

Setting up automated workflows to channel data from Snapchat Ads to Google Sheets effectively streamlines the data journey from source to analysis. This process ensures seamless synchronization when you connect Snapchat Ads to Google Sheets, enabling consistent workflow management by keeping your datasets always synchronized.

Marketing strategy enhancement

You can export data from all your ad platforms, social media, and web tools to Google Sheets. This enables multi-channel analytics to evaluate performance simultaneously across many verticals. Having all your data in a unified report helps you compare platforms' performances and make data-driven decisions to optimize strategy. 

Which metrics from Snapchat Ads Analytics should you track?

Identifying what you can track from Snapchat Ads is crucial to building the perfect report. Every metric provides specific insight—find out which ones are more relevant to your business and advertising goals.

Here are the top metrics that Two Minute Reports can extract from Snapchat Ads: 

Delivery

1. Impressions
2. Reach
3. Frequency
4. Spend
5. eCPM

Performance

1. Clicks
2. Conversions
3. CTR
4. Conversion Rate
5. eCPV 

Video 

1. Video Views (2-second, 15-second, Total)
2. Video View Time
3. Video Average View Percentage

Demographics

1. Age
2. Gender
3. Location
4. Device Type
5. Interests

Snapchat-specific

1. Lens Views
2. Lens Plays
3. Filter Impressions
4. Story Opens
5. Swipe-Ups on Lenses.

Learn more about these metrics and the dimensions that you can add to them here.

Why Two Minute Reports for Snapchat Ads?

Centralized data integration: TMR is a Google Sheets add-on designed to consolidate your Snapchat Ads metrics alongside data from various other platforms. It eliminates the hassle of manual CSV imports, providing a seamless data flow directly from Snapchat Ads into Google Sheets.

Extensive integrations and upcoming features: Currently, TMR supports integrations with Snapchat ads, major advertising platforms, analytics tools, SEO services, social media, e-commerce, email, mobile, CRM, and databases. With exciting upcoming integrations, TMR will further enhance its capabilities for users focused on Snapchat advertising.

Intuitive reporting: The reports generated through the TMR add-on are professional and mobile-friendly, specifically tailored to highlight key metrics from Snapchat Ads. The intuitive interface allows users to create, customize, and share reports effortlessly across multiple stakeholders.

Cost-effective and user-friendly: TMR stands out as an affordable and easy-to-use add-on. It features a low learning curve while delivering powerful functionality without compromising performance, especially for Snapchat Ads campaigns.

Native Connectors and API Bridge: The native connectors simplify data extraction from Snapchat Ads and other platforms. The API Bridge feature broadens access to any data source that returns JSON, ensuring unlimited data connectivity within Google Sheets.

Efficiency and customization: TMR empowers users to quickly set up personalized dashboards using pre-built templates that can be customized and duplicated for specific Snapchat Ads reporting needs. These templates also streamline the generation of reports and performance summaries for clients.

Automatic data refreshes and reports: With TMR, you can schedule automatic data refreshes directly in Google Sheets and send beautifully formatted reports via email, saving time and keeping clients updated with the latest Snapchat Ads performance data.

Two Minute Reports are designed for data consolidation and empowering businesses that leverage Snapchat Ads. With TMR’s AI-powered report creation and configuration tools, you can automate and streamline your reporting processes, facilitating quicker and more efficient data-driven decisions.

Get Snapchat Ads data in Looker Studio

Two Minute Reports can be installed to integrate Snapchat Ads data with Looker Studio (formerly Google Data Studio), enabling advanced data analysis and visualization. 

This Snapchat Ads add-on allows the creation of detailed reports and dashboards using insights from Snapchat Ads without the complexity of manual data entry. Looker Studio’s customization capabilities also let users craft custom formulae in a user-friendly interface. 

With seamless integration, comprehensive analytical capabilities, and automated workflows, strategic business intelligence from Snapchat Ads has become quicker and more accessible. 

Connect similar platform data sources with Google Sheets

With this add-on, you can connect 30+ data sources to Google Sheets, create additional reports, create visualizations, and build a comprehensive report. 

• Facebook Ads
• Google Ads
• LinkedIn Ads