So you work in marketing. Regardless of your position, you are going to spend a good chunk of your time in spreadsheets.
From tracking website analytics, planning content or putting together keyword research docs. It all takes a lot of time. But it doesn’t have to with Google Sheets.
Thankfully there are loads of clever and generous people out there who have made templates to help speed up these tedious jobs.
I’ve spent quite a while compiling all the best Google Sheets Templates so you can do better work by focusing on the data not the process. Enjoy! 👍
‼️ 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.‼️
Browse Google Sheets Templates:
How to use these Google Sheets templates:
- Open up the Sheet template.
- At the top left, click file.
- Then hit make a copy.
- Rename the file, and a copy of the template will be saved to your Drive.
There’s loads of add-ons available to supercharge your Google Sheets. I thought I would group together sheets templates that use the same add-ons.
34 Supermetrics Templates
Supermetrics is an add-on for Google Sheets that lets you report, monitor and analyse your marketing campaigns. They’ve also get some nifty pre-set templates for you to steal. Check them out:
- Paid Channel Mix Template
- Detailed Paid Channel Mix Template
- Detailed Paid Channel Mix with Yandex.Direct Template
- Branding Performance Dashboard by Gauge
- E-commerce Performance Dashboard by Gauge
- High Level Monthly PPC Report
- AdWords Client Budget Tracker & Alert
- AdWords & Organic Keyword Performance Template
- AdWords In Depth PPC Report
- By-flight Client Budget Tracker & Alert Template
- AdWords Monthly Report Template
- Keyword Heatmap Tool Template
- Ad Copy Edit Tool Template
- Ad Label Testing Tool Template
- AdWords Historical Quality Score Template
- Bing Ads Client Budget Tracker & Alert
- Bing Ads High Level PPC Monthly Report
- Bing Ads in Depth PPC Report
- Facebook Ads High Level Monthly Report
- Google AdSense Reporting Template
- Google AdSense + Google Analytics Template
- Post Click Analysis
- Year-on-Year Comparisons Template
- Country Comparisons Template
- US State Comparison Template
- Heatmap Reporting Template
- Traffic Source Bubbles Reporting Template
- Traffic Dashboard Reporting Template
- Cohort Analysis Reporting Template
- SEO Content Audit Template
- Traffic Source Reporting Template
- E-commerce Template (Totals and Channels)
- Social Media Tracking Template
- Facebook Page Management Dashboard
17 Blockspring Templates
Blockspring is an add-on for Google Sheets that makes it simple to connect Google Sheets to hundreds of webapps and data services to help automate reporting, sales operations and more. Check them out:
- Create Lead Profiles
- Create Lead Profiles
- Auto-Updating Report from a Postgres Database
- Build Employee Lists by Company
- Enrich Company List
- Send a List of Checks
- Send a List of Postcards
- Track Job Postings by Company on Indeed
- Download a List of Files to Dropbox from URLs
- Facebook Campaign Report
- Keep Heroku Apps Awake
- Build Email List from Names and Companies
- Multi-Account Facebook Post Report
- Search for a List of Flights
- Find Twitter Influencers by Topic
- Perform a Content Audit
- Track YouTube Statistics
Google Sheets + Marketing = 👍
So there you have it, enough Google Sheets templates to turn you into a supercharged lazy marketer.
Think I’ve missed one? Or maybe you’ve built something yourself that isn’t on the list? Just let me know and I’ll add it.
And of course, you can’t have a list of over 100 Google Sheets templates without including a version in a spreadsheet, you can grab all the above templates right here.
Now go forth and get lazy.