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.
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.
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.
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.
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).
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.
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 🔥
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).
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.‼️