Google Analytics Templates

Want to create Google Analytics reports, dashboards + other custom data tools in no time? Try using these Google Sheets templates.

Men lie. Women lie. Numbers don’t lie.

Google Analytics is such a big part of digital marketing, without website data to back up what you are saying, you are working in the dark. And no one wants that.

Wrangling data in Google Analytics is a day to day task for many marketers. But it’s not the most usable interface.

You can actually pull that same analytics data into a spreadsheet and play with it any way you want with filtering, custom graphs, mixing with other sources or pushing to a fancy Data Studio report.

The point is: Google Sheets makes playing with Google Analytics data easy.

Google Sheets Analytics Templates

Below you’ll find loads of useful spreadsheet templates from auditing your GA data, event tracking code generators, UTM tagging, heatmaps and more.

Check out these free Google Sheets analytics templates, reports and generators to make your life a bit easier (and a lot faster):

Automated Google Analytics Audit


This automated Google Sheets template pulls in GA data (+ a Screaming Frog export) and analyses a Google Analytics setup. It does 12 checks and assigns a simple pass or fail to each (+ instructions on how to fix any issues). Nice.

Grab the sheet

Conversion Funnel Analytics


This sheet helps you to get a handle on your funnel conversion performance. It pulls in Google Analytics data and automatically calculates metrics like visit-to-purchase conversion rate, average order size, and more.

Grab the sheet

GA Conversion Indexation Analysis


The GA conversion indexation analysis recipe uses the Agency Data Pipeline stack (Stitch, BigQuery, DBT) to pick channels / landing pages on your site that are over or underperforming. Nice.

Grab the sheet

UTM Tagging


Building UTM parameters can be annoying and time-consuming… Until now! This simple tool helps to build UTM parameters easily in order to track your marketing campaigns in Google Analytics.

Grab the sheet

Google Analytics Event Tracking Generator


Google Analytics event tracking is a useful feature for tracking visitor interactions with your website that would not be normally tracked. Use this sheet to generate your event tracking codes (and keep track of event tracking in GA).

Grab the sheet

Google Analytics Heatmap


Want to heatmap specific metrics in order to identify growing or hot trends over time? This sheet pulls in your Google Analytics data and then displays traffic heatmaps so you can easily see peaks and troughs.

Grab the sheet

User Acquisition Heatmap Dashboard


Use this heatmap dashboard to easily identify web traffic patterns on your site like which month, day of the week, or time of day gets the most (or least) amount of traffic/conversions. Nice 🔥

Grab the sheet

UTM Builder Template


A UTM builder with a bunch of functionality for teams like customizable dropdowns that allow you to keep standardized naming conventions and functionality to automatically append a date code to each tracking URL (super useful when using UTM URLs for paid campaigns).

Grab the sheet

SEO Analytics Dashboard


This custom dashboard uses the Google Analytics add-on for Google Sheets to easily analyse what’s causing organic traffic to decline.

Grab the sheet

Analytics Tracking Plan (BigQuery)


This reporting template uses Google Analytics to investigate your site’s overall acquisition efficiency. It assesses your site’s overall success in converting users into consumers, page by page and channel by channel.

Grab the sheet

GA Conversion Index Tracking Plan


Using your Google Analytics data, this pipeline recipe answers one basic question: Which marketing channel(s) should we be focused on?’

Grab the sheet

E-commerce reporting template


With this e-commerce reporting template, you can keep track of the performance of your online store.

Grab the sheet

Post-click analysis template


Check if your ad spend is generating a positive ROI and how your sponsored ads are performing (in comparison to other channels).

Grab the sheet

Website cohort analysis template


Analyze your revenue by cohort, segment retention, and historical retention trends & patterns.

Grab the sheet

Website performance by country reporting template


Keep track of which countries are responsible for the majority of your site’s traffic, conversions, and other metrics.

Grab the sheet

Website performance by US state reporting template


With this handy template, you can quickly discover which states are responsible for the majority of your traffic and conversions.

Grab the sheet

Website traffic by device & source reporting template


Get a quick review into your website’s traffic by source, device, keywords, and more.

Grab the sheet

Website traffic dashboard template


Keep track of your most important website metrics, such as segmentation, top traffic sources, and traffic split by medium and month.

Grab the sheet

Website traffic heatmap template


With this dynamic heatmap template, you get an hourly breakdown of the most important website analytics.

Grab the sheet

Website traffic source bubble chart template


Check out this bubble chart template for a visual representation of your website’s main traffic sources.

Grab the sheet

Year-on-year website performance reporting template


Compare the performance of your website in terms of traffic and conversions to the previous year.

Grab the sheet


 

 

Analytics Sheets for Marketers 🔥

Think I’ve missed a Google Sheets Analytics Template? Or maybe you’ve built something yourself that isn’t on the list? Just let me know and I’ll add it.

‼️ I did not make these templates, I only collected them & presented them here. The creators are the ones linked to. Again, I do not own (or claim to) any of these sheets.‼️

Don’t forget to go check out the other Google Sheets Templates →