This sheet helps you to get a handle on your funnel conversion performance.It pulls in Google Analytrics data and automatically calculates metrics like visit-to-purchase conversion rate, average order size, and more.
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 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).
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.
Doing a regular social media audit can be time consuming. Thankfully this sheet makes it easy to track all your social profiles in one place and pull out things like posting frequency, followers growth and engagement.
This template allows you to run a quick SEO content audit without ever leaving Google Sheets. It pulls raw data from 6 sources (Google Analytics, Google Search Console, Screaming Frog, Ahrefs, Majestic SEO, and Moz) using the super-handy Supermetrics.
This technical audit checklist makes SEO work faster, more effective, and more impactful by considering the underlying problems to tackle/prevent. It then presents them in an easy to use format with handy colour coded grading.
This simple free site audit tool uses sheets formulas to analyze a website from a sitemap URL or list of URLs. It checks for things like Schema usage, titles, meta descriptions, heading issues, and for any duplication issues.
Manually review every page on a site can take ages. This content audit automates over 90% of the process for you, by crosswalking large amounts of data from GA, Ahrefs and Sitemaps. Quickly analyze page level quality – links, bounce rate, organic traffic and more.
A simple-to-use Google Sheet packed with industry data to help give you insight (quickly) into how many clicks you may get when ranking for certain keywords.
No one likes (not provided). Thankfully this handy calculator works out your true CTR using Search Console data, so you can understand your most valuable keywords and how much traffic they’re driving.
Use this free Google Sheets template to conduct competitor analysis as part of your SEO strategy. Find out what keywords and backlinks your competition has, but you do not. Then take advantage of this analysis for your campaign.
This competitor keyword research sheet allows you to explore your competitor's keywords using SEMRush. Then, identify content gaps in your client’s keyword footprint vs the keywords that their competitors rank for (but your client does not).
This post walk you through how to do a competitor content gap analysis using SEMRush. Then using the nifty sheet, you can use Google Search Console to determine if title tags & meta descriptions can be improved.
Clique Hunter is a backlink analysis tool that helps you find out which backlinks your competitors have in common (by analyzing up to 10 of your competitors backlink profiles). The sheet templates helps you do this at scale by analysing your data more efficiently so you can build out your backlink strategy.
This sheet shows you which blog posts are getting the most traffic, allowing you to make sure you know which content is working, what isn't and your best performing topics.
Looking for quick insights into popular content topics across the web? This sheet template has got you covered. It finds topic inspiration for your content marketing efforts in no time, using a large number of new social sites, content aggregators and news sources.
Find target topics instead of keywords with the Topic Opportunity Finder. It aggregates your competitors’ ranking keywords into general topics so you can identify the overall topics that your competitors rank for.
This sheet helps you to find content gaps on your site. If you were wondering, content gaps are keywords ranking past page 3. They can be related topics not being targeted or maybe in need of better on-page optimisation.
If you work in the adult niche, Google doesn't give keyword search volumes for certain queries. Even if you aren't in that industry your SEO and PPC tracking and reporting could be effected... Unless you use this sheet to claw back your data.
This template matches up Search Console and Google Analytics data into a sheet so you can see your top keywords and engagement metrics side by side. Great for seeing which keywords are driving organic traffic.
GooberSuggest is a free keyword research tool for finding SEO opportunities via Google auto complete suggestions. Plug in the SEMRush API and get extra feautres like opportunity highlighting.
Keyword cannibalisation can be annoying. It can be even more annoying to find. Use this sheet to find instances where you are competing with yourself super quick.
Get autocomplete keywords directly in Google Sheets. Find out what people are searching for using the Google Autocomplete API. A massive time saver for keyword research for content writing.
Not really much to say on this one. It's rank checker and it lives in Sheets that lets you track keyword rankings, schedule runs and see over-time statistics.
This template automates checking Google search results for pages that mention your brand, but don't link to your domain. In other words: find unlinked brand mentions on autopilot.
Using this sheet, you'll be able to find link reclamation and unlinked mention opportunities easily. You can then filter by time to find recent opportunities and use the integrated DA metrics to decide on which to go after.
Keep track of all outreach (and digital PR too) efforts with this tracking template. This sheet allows you to track outreach progress, social & industry influencers, competitors and emails.
This sheet shows queries and landing page combinations that receive a high number of impressions but have a low CTR. It also pulls in title tag, meta description and character counts, so you can quickly see which search snippets can be improved to increase CTR.
An AdWords dashboard in Google Sheets to help with aggregation and visualization of performance data so you can understand what's going on with your campaigns.
This Google Sheets project management template helps keep tabs on your SEO efforts, including: project management, content creation, outreach campaigns and client reporting.
A worksheet to help with your SEO work: setting goals, identifying important pages, uncovering technical opportunities, time management, benchmarking and reporting.
A Google Sheets tool to monitor (and get email alerts) when there are important SEO changes to a website, including changes to page title, H1, meta sescription, canonical and robots.txt.
This report template pulls in Google Analytics data into a Google Sheet, to see how usability and page load speed impacts conversion rates. It analyzes where the conversion leaks are hiding in your funnel, across browsers, devices and screen sizes.
This report uses Google Analytics to dig into the overall acquisition efficiency of your site. It analyzes the overall effectiveness of your site at converting visitors into customers, by page and by channel.
This Google Sheets report analyses your sites SEO efficiency. Find out which pages and links are delivering the bulk of your SEO results, and which are a waste of time and space.
This custom SEO dashboard let's you easily analyze what’s causing organic traffic to drop. In fact, you can see organic visibility in specific cities, landing paages, impact on conversion metrics, devices types and more. Seriosuly, it does all the hard work for you.
A simple web scraper built in Google Sheets to scrape web pages directly in sheets (instead of using web scraping tools). Useful for a smaller set of URLs.
Easily scrape Google search results pages and save the keyword ranking data inside this sheet using the ImportXML formula. Useful for monitoring organic rankings, keeping tabs on competing websites or exporting for further analysis.
This social media report sheet is designed to give you a snapshot view of your last 7 days of social media stats, using Buffer data exports. It can also be modified to work with exported data from Twitter, Facebook, or Instagram.
Use this Google Sheet to know which social media posts are on track and which are taking off. Just enter your social media data and the formulas do the rest, highlighting any update that goes above and beyond your average.
This sheets dashboard tracks the performance of social media marketing so you visualize, and share social growth. Get an overview of performance with week-over-week growth and month-over-month growth.
This tool lets you schedule and auto-post your tweets directly from Google Sheets. It even includes repeat functionality and logging. And it's 100% free with no need to create any accounts.
Use this sheet to generate and manage simple redirect rules. Simply choose a destination, add in the URLs to redirect, specify a new page path and add the redirects to your .htaccess file.
Create organization schema microdata and sitelink microdata with this sheets template. Place the code within your homepage’s HTML organization Schema to help enhace SERP features.
This generator creates error-free hreflang tags for your website. It also keeps a list of all accepted language and region codes, so you don't accidentally use the wrong language or region code and mess up your rankings.
Check AMP (Accelerated Mobile Pages) validation in bulk right in Google Sheets. You can even schedule daily, weekly or monthly updates with email notifications.
Using the Search Console API to pull in search performance data (impressions, clicks and CTRs by landing page and query), this Google Sheet analyzes each page and query combination’s performance over a chosen period.