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


 

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 miss out on new templates.

Sign up to get notified when new Google Sheets templates + tools get added to the directory.