ABCD
1
Digitally Social: Click on File and Make a Copy of this Sheet
2
CategoryWho made itURLWhat it does
3
AnalyticsCoding is for Losershttps://www.youtube.com/watch?v=zp6zxmsYepQThis 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.
4
AnalyticsCoding is for Losershttps://codingisforlosers.com/google-analytics-bigquery-data-pipelineThe 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.
5
AnalyticsLink To Sheetshttps://linktosheets.com/utm-tagging-with-google-spreadheets/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
6
AnalyticsLink To Sheetshttps://linktosheets.com/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).
7
AnalyticsSEERhttp://www.seerinteractive.com/blog/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.
8
AuditsBufferhttps://blog.bufferapp.com/marketing-spreadsheetsDoing 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.
9
AuditsCoding is for Losershttps://codingisforlosers.com/seo-content-audit-sheets-template/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.
10
AuditsDistilledhttps://www.distilled.net/resources/technical-audit-checklist-for-human-beings/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.
11
AuditsRankTankhttps://www.ranktank.org/simple-seo-site-audit-tool/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.
12
AuditsWebrishttps://webris.org/content-audit/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.
13
CalculatorBarrett Wilsonhttps://www.linkedin.com/pulse/how-i-made-seo-search-volume-calculator-google-sheets-barrett-wilsonA 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.
14
CalculatorEdithttps://edit.co.uk/blog/calculate-true-ctr-wmt/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.
15
CalculatorJeremy Riverahttps://jeremyriveraseo.com/seo/get-rough-estimate-potential-organic-traffic-excel/Get a rough estimate of potential organic traffic you can expect from an Ahrefs keyword export.
16
CalculatorWebrishttps://webris.org/roi-ppc-campaign-free-template/This PPC calculator works out the ROI of a paid search campaigns for you (Revenue - Costs / Costs).
17
CalculatorSiege Mediahttps://www.siegemedia.com/seo/seo-roi-from-content-marketingThis SEO calculator works out the ROI of a SEO campaigns for you.
18
CalculatorPear Analyticshttps://pearanalytics.com/blog/2011/roi-calculator-for-search-engine-optimization/Another SEO calculator for working out the ROI of a SEO campaigns.
19
Competitor ResearchMozhttps://moz.com/blog/competitor-analysis-for-seoUse 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.
20
Competitor ResearchInflowhttps://www.goinflow.com/competitor-keyword-research-with-semrush/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).
21
Competitor ResearchSEMRushhttps://www.semrush.com/blog/steal-your-competitors-traffic-with-content-gap-analysis/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.
22
Competitor ResearchMajestichttps://blog.majestic.com/training/clique-hunter-analysis-to-boost-your-off-page-seo-free-template/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.
23
ContentBufferhttps://blog.bufferapp.com/marketing-spreadsheetsThis 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.
24
ContentBuiltvisiblehttps://builtvisible.com/content-strategy-helper/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.
25
ContentGreenlanehttps://www.greenlanemarketing.com/tools/topic-opportunity-finderx/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.
26
Contentjsvxchttps://jsvxc.com/content-gaps/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.
27
KeywordsCoding is for Losershttps://codingisforlosers.com/search-console-find-quick-win-keywords/A Google Sheets template for finding underperforming keywords you can then work on moving up to the first page of Google.
28
KeywordsEdithttps://edit.co.uk/blog/how-to-estimate-search-volume-for-adult-keywords/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.
29
KeywordsMozhttps://moz.com/blog/how-to-uncover-hidden-keyword-level-data-using-google-sheetsThis 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.
30
KeywordsRankTankhttps://www.ranktank.org/bulk-keyword-search-volume-tool/Quickly check search volumes in bulk right in a Google Sheets via SEMRush.
31
KeywordsRankTankhttps://www.ranktank.org/goobersuggest-seo-keyword-research-tool/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.
32
Keywordsjsvxchttps://jsvxc.com/keyword-cannibalization/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.
33
KeywordsRankTankhttps://www.ranktank.org/keyword-cannibalization-checker/This sheet pulls in data via the Supermetrics add on to show you keyword cannibalisation.
34
KeywordsRankTankhttps://www.ranktank.org/keyword-difficulty-tool-opportunity-finder/This sheet finds keyword suggestions and determines which ones would be easier to rank for based on competition using the SEMrush API.
35
KeywordsRankTankhttps://www.ranktank.org/keyword-position-checker-tool/Really does what it says on the tin. This free keyword rank checker tool checks your site's keyword positions.
36
KeywordsRankTankhttps://www.ranktank.org/keyword-research-tool-with-google-autocomplete-api/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.
37
Keywordsrelgrowthhttps://relgrowth.com/seo-tools/keyword-rank-checkerNot 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.
38
Link BuildingRankTankhttps://www.ranktank.org/brand-unlinked-mentions-finder/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.
39
Link BuildingRankTankhttps://www.ranktank.org/free-email-list-cleaner/This sheet helps marketers to setup an email list verification in order to avoid the triggering of emailing filters.
40
Link BuildingRankTankhttps://www.ranktank.org/free-link-reclamation-seo-tool/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.
41
Link Buildingrelgrowthhttps://relgrowth.com/seo-tools/backlink-checkerThis checker allows you to monitor your backlinks, either with quick checks or scheduled bulk queries with thousands of links.
42
Link BuildingWorkshop Digitalhttps://www.workshopdigital.com/blog/ultimate-digital-outreach-tracking-template/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.
43
On-Page OptimisationGreenlanehttps://www.greenlanemarketing.com/tools/meta-rich-snippet-tester/Scrape the SERPs to see discrepancies between when Google is showing the true title tag + meta description vs. a Google-generated one.
44
On-Page Optimisationjsvxchttps://jsvxc.com/html-table-of-contents-generator/Generate a simple HTML table of contents to add to WordPress posts to help improve the UX of guides, FAQ pages or any long form content.
45
On-Page OptimisationRankTankhttps://www.ranktank.org/free-rich-snippet-testing-tool/Use this sheets tool to quickly see how rich snippets and meta data are being indexed in Google for any site.
46
On-Page OptimisationRankTankhttps://www.ranktank.org/title-tag-and-meta-description-auto-verify-tool/Using this Google Sheets tool, you can paste in URLs and automatically pull the title tags and meta descriptions for them.
47
On-Page OptimisationRobbie Richardshttps://www.robbierichards.com/seo/on-page-seo/This Google Sheets template automates most of the boring on-page SEO checks so you can optimize what is important and automate the rest.
48
On-Page OptimisationSEMRushhttps://www.semrush.com/blog/steal-your-competitors-traffic-with-content-gap-analysis/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.
49
Paid SearchOpteohttps://opteo.com/docs/adwords-guides/ppc-command-center-in-google-sheetsAn 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.
50
Project ManagementCoding is for Losershttps://codingisforlosers.com/project-management-google-sheets/This Google Sheets project management template helps keep tabs on your SEO efforts, including: project management, content creation, outreach campaigns and client reporting.
51
Project ManagementMozhttps://moz.com/blog/prioritize-seo-tasksA worksheet to help with your SEO work: setting goals, identifying important pages, uncovering technical opportunities, time management, benchmarking and reporting.
52
ReportingDistilledhttps://www.distilled.net/resources/5-analyses-without-seo-platform/A sheets dashboard to monitor SEO with integrated rank tracking as well as interesting interpretations of the data.
53
ReportingRankTankhttps://www.ranktank.org/monitor-seo-website-changes-with-seocheck/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.
54
ReportingCoding is for Losershttps://codingisforlosers.com/site-performance-report-blockspring-google-analyticsThis 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.
55
ReportingCoding is for Losershttps://codingisforlosers.com/acquisition-channel-report-blockspring-google-analyticsThis 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.
56
ReportingCoding is for Losershttps://codingisforlosers.com/seo-report-blockspring-google-analyticsThis 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.
57
ReportingLink To Sheetshttps://linktosheets.com/forecasting-seo-impacts-on-organic-traffic/This Google Sheet uses basic statistical methods and historic traffic data to forecast SEO, revealing the direction a website is heading.
58
ReportingPortenthttps://www.portent.com/blog/analytics/automated-seosocial-reporting-using-google-spreadsheets-an-example.htmA Google Sheets report that automatically grabs everything from Linkscape data to Google Analytics numbers to Twitter follower counts.
59
ReportingWorkshop Digitalhttps://www.workshopdigital.com/blog/wtf-is-happening-to-my-organic-traffic/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.
60
ScrapingLink To Sheetshttps://linktosheets.com/web-scraping-using-importxml-google-spreadsheets/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.
61
ScrapingLabnolhttps://www.labnol.org/internet/google-web-scraping/28450/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.
62
ScrapingLink To Sheetshttps://linktosheets.com/extract-data-from-wikipedia-wikidata/This Google Sheets template acts as a simple data mining tool that extracts data from Wikipedia and Wikidata.
63
SocialBufferhttps://blog.bufferapp.com/marketing-spreadsheetsThis 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.
64
SocialBufferhttps://blog.bufferapp.com/marketing-spreadsheetsUse 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.
65
SocialBufferhttps://blog.bufferapp.com/marketing-spreadsheetsThis 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.
66
Socialrelgrowthhttps://relgrowth.com/seo-tools/twitter-auto-posterThis 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.
67
Technical SEOGreenlanehttps://www.greenlanemarketing.com/tools/google-indexation-tester/Does what it says on the tin: check which pages in a sitemap have been indexed by Google. It's very easy to use, but incredibly helpful.
68
Technical SEOGreenlanehttps://www.greenlanemarketing.com/tools/url-performance-tool/Get a high-level snapshot of a page’s performance without logging into,and navigating through an analytics platform. Lazy efficiency at it's finest.
69
Technical SEOLink To Sheetshttps://linktosheets.com/generate-301-redirects/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.
70
Technical SEORankTankhttps://www.ranktank.org/bulk-domain-status-code-tool/This Google Sheets template allows you to paste in up to 6000 URLs and get the HTTP status codes for all of them in bulk.
71
Technical SEORankTankhttps://www.ranktank.org/structured-data-sitelinks-search-box-builder/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.
72
Technical SEOrelgrowthhttps://relgrowth.com/seo-tools/hreflang-generatorThis 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.
73
Technical SEOrelgrowthhttps://relgrowth.com/seo-tools/amp-validatorCheck AMP (Accelerated Mobile Pages) validation in bulk right in Google Sheets. You can even schedule daily, weekly or monthly updates with email notifications.
74
Technical SEOrelgrowthhttps://relgrowth.com/seo-tools/website-uptime-monitorUse this tool to monitor your website's hourly uptime/availability and keep tabs on up to 25 URLs.
75
Technical SEOThe Tech SEOhttps://www.thetechseo.com/seo-tools/redirect-checker/This Google Sheets tool helps you to keep track of legacy and current redirects. It monitors when 301 redirects are put live or if they are removed.
76
Technical SEOThe Tech SEOhttps://www.thetechseo.com/seo-tools/discover-lost-urls/A Google Spreadsheet that uses the Wayback Machine API to discover lost URLs and then regain some of that lost SEO value.
77
OtherCoding is for Losershttps://codingisforlosers.com/google-sheets-bigquery-connector/When you reach the limit in Google Sheets, set up your BigQuery analytics right inside sheets and create tables, views, and uploads.
78
OtherRankTankhttps://www.ranktank.org/find-business-address-by-website-domain/This sheet allows you to paste in a list of domains, and quickly find the business addresses and phone numbers.
79
OtherRankTankhttps://www.ranktank.org/search-performance-anomaly-detection/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.
80
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsPaid Channel Mix Template
81
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsDetailed Paid Channel Mix Template
82
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsDetailed Paid Channel Mix with Yandex.Direct Template
83
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsBranding Performance Dashboard by Gauge
84
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsE-commerce Performance Dashboard by Gauge
85
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsHigh Level Monthly PPC Report
86
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAdWords Client Budget Tracker & Alert
87
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAdWords & Organic Keyword Performance Template
88
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAdWords In Depth PPC Report
89
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsBy-flight Client Budget Tracker & Alert Template
90
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAdWords Monthly Report Template
91
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsKeyword Heatmap Tool Template
92
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAd Copy Edit Tool Template
93
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAd Label Testing Tool Template
94
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsAdWords Historical Quality Score Template
95
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsBing Ads Client Budget Tracker & Alert
96
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsBing Ads High Level PPC Monthly Report
97
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsBing Ads in Depth PPC Report
98
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsFacebook Ads High Level Monthly Report
99
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsGoogle AdSense Reporting Template
100
SupermetricsSupermetricshttps://supermetrics.com/template-gallery/google-sheetsGoogle AdSense + Google Analytics Template