Unlock the power of SEO with our comprehensive collection of free Google Sheets templates designed specifically for search engine optimization and marketing consultants. Whether you’re an experienced SEO professional or just starting your journey, our carefully crafted templates are here to simplify and streamline your SEO efforts.
Each template comes with an associated tutorial on setting up on my blog.
You don’t need to be a spreadsheet whiz to leverage the power of our templates. These Google Sheets templates are created to be intuitive to use with user-friendly interfaces that make data entry, analysis, and reporting a breeze.
Simply input your data, and let the templates do the heavy lifting, regardless of how the complex task.
- Custom Expert Commentary Annotations on Performance and KPIs for Looker Studio
- Event annotations template for Looker Studio (to use with GSC or GA4)
- Sentiment Analysis for SEO in Google Sheets (Template)
- Fuzzy Matching for SEOs (Google Sheets Template)
- Internal Link Opportunities Quick Find (Google Sheets Template)
- No-code LDA Topic Modelling Website Content Clustering for a website (Output Organisation Google Sheet)
- On-page Duplication Analysis (Google Sheets Template)
- Entity Recognition for SEO in Google Sheets (Template)
Custom Expert Commentary Annotations on Performance and KPIs for Looker Studio
— FOR SEO consultants and Marketing analysts
The Google Sheets template is designed to organize and host annotations of custom commentary added by experts, across all of your active reporting sectors (e.g. SEO, Digital PR, Technical, Email, UX, etc) in Looker Studio dashboards.
The process of using this template, and a supporting Looker Studio dashboard is shown in the blog post: How to add expert commentary annotations for GA4 data in Looker Studio dashboards
Event annotations template for Looker Studio (to use with GSC or GA4)
— FOR SEO consultants and Marketing analysts
The Google Sheets template is designed to organize and host annotations of key events, across all of your active sectors (e.g. SEO, Digital PR, Technical, Email, UX, etc), that might influence reporting metrics in Google Search Console or GA4.
Follow the instructions on how to fill in the events, and annotate your data in Looker Studio with key custom events from your organization to better monitor the cause/impact relationships and performance impact of key events.
The process of using this template, and a supporting Looker Studio dashboard is shown in the blog post: How to create custom event annotations for GA4 or Google Search Console data in Looker Studio
Sentiment Analysis for SEO in Google Sheets (Template)
— For digital marketers and Seo consultants
The Sentiment Analysis for SEO Google Sheets Template utilizes Google’s Natural Language API to analyze sentiment in digital content, aiding SEO consultants and marketers. It automatically evaluates text sentiment, sentiment salience, and other metrics, and allows for easy data import. The template also includes an interactive dashboard for analyzing sentiment.
Fuzzy Matching for SEOs (Google Sheets Template)
— FOR SEO consultants and web developers
The Google Sheets template for Fuzzy matching for SEOs is a resource, aimed to streamline your fuzzy matching process in the areas of:
- string assessments and comparisons
- internal link opportunity identification
- redirect checks
- content plagiarism checks
The process of using this template is shown in this post, and an associated video on my YouTube channel.
Internal Link Opportunities Quick Find (Google Sheets Template)
— FOR SEO consultants
The Google Sheets template for quickly finding internal link opportunities is a resource, aimed to streamline your internal linking process.
Simply follow the instructions, and check how to better link your content.
No-code LDA Topic Modelling Website Content Clustering for a website (Output Organisation Google Sheet)
— FOR SEO consultants
The Google Sheets template for organising your LDA Topic Modeling Output for Content Clustering is a easy way to:
- understand and process LDA topic modeling outputs
- identify existing content clusters
- understand your site’s topics better
To work, this template requires the use of a no-code, publicly available web-based application that uses LDA topic modeling.
The process of using this template is shown in my guide on internal linking, and this video on YouTube.
On-page Duplication Analysis (Google Sheets Template)
— FOR SEO consultants
This Google Sheets template takes data from your Screaming Frog and the Search analytics for Sheets browser extension to help you identify page query overlap, exact duplication, and near duplication of on-page elements like titles and headings. See the related resource on conducting Duplication Audits.
Entity Recognition for SEO in Google Sheets (Template)
— For digital marketers and Seo consultants
The SEO Entity Recognition Google Sheets Template is a practical tool for SEO consultants and digital marketers, designed to leverage Google’s Natural Language API for efficient entity recognition. It features automatic entity identification, custom charts, and visualizations, and supports data import from various sources. The template includes an interactive dashboard for quick analysis, focusing on entity distribution and relevance in digital marketing campaigns.