Skip to content
Home β€Ί Templates β€Ί Master SEO Audit Template
RR Web Services Pro template

Master SEO
Audit Template

The audit framework we use with every client, rebuilt as a Google Sheets template you can use yourself. Screaming Frog, GA4, Search Console and Ahrefs data in one place. It scores every URL and tells you exactly what to fix, and in what order.

Works with
Screaming Frog
Google Search Console
GA4
Ahrefs
14
Tabs
29K+
Formulas
90
Day roadmap
1K
URLs
Every URL scored from 0 to 100 on technical, content, Search Console, GA4 and backlink signals
Competitor gap analysis that shows exactly where you're behind on DR, backlinks and Core Web Vitals
A revenue calculator that puts a dollar value on your ranking opportunities
A 90-day visual roadmap that fills itself in from your data, ready to present to clients
A Client Report tab that writes itself from 5 filled cells, saving 2 to 3 hours per audit
Master SEO Audit Template

Google Sheets, 14 tabs, 29,000+ formulas, lifetime access

$67 one-time payment, no subscription

Instant access, for as many client audits as you like.

Secure payment through Stripe. Your Google Sheets copy arrives instantly.
Questions? Message us

What you get
README: a full setup guide
Screaming Frog import (1,000 URLs)
Search Console import with 3- and 6-month comparison
GA4 import and Core Web Vitals
Ahrefs import
πŸ†š Competitor gap analysis
Revenue calculator
Master URL view, scored automatically
Dashboard and executive summary
90-day visual roadmap
Client report that writes itself
Easy fixes and hard fixes, separated
Use it on as many client audits as you like
You're in. Open your copy.

Your Google Sheets copy is ready. Click below to open it and make your own copy. Check your email too, since we've sent you the link.

Open the Google Sheets template Questions? Message us anytime
Cover page

A branded audit cover with the client's name, the period and the overall score. It's the first thing a prospect sees, and it sets the tone before they read a word.

Master URL view

Every URL from your Screaming Frog crawl matched with Search Console, GA4 and Ahrefs data in one row, with a combined score from 0 to 100, the trend direction and a plain-English reason for each change.

  • Status codes
  • Word count
  • CTR
  • Position
  • Click trend
  • Bounce rate
  • LCP / CLS / INP
  • Referring domains
  • Priority flag
Dashboard

A site-wide health scorecard, a breakdown of traffic trends, a summary of technical problems, backlink insights and three yellow cells for your own expert observations.

  • Overall average score
  • Number of critical URLs
  • Number of quick wins
  • Revenue opportunity
  • Executive summary input
  • 3 specific insights
πŸ†š
Competitor gap

A domain-level comparison of DR, referring domains, organic traffic and content depth, a backlink gap for each commercial URL, and your Core Web Vitals compared with competitors.

  • DR comparison
  • Backlink gap
  • Shortfall for each page
  • Core Web Vitals vs. competitors
Revenue calculator

Enter your conversion rate and average order value, and the template calculates the extra monthly visitors and revenue if your pages in positions 4 to 10 are improved.

  • Opportunity in positions 4 to 10
  • Expected increase in click rate
  • Extra monthly visitors
  • Extra monthly revenue
  • Yearly revenue opportunity
90-day roadmap

4 workstreams (technical, content, authority and measurement) across 3 phases, with a revenue projection row and yellow cells for client-specific notes. It prints as a stand-alone proposal page.

  • Phase 1: foundation and quick wins
  • Phase 2: structure and authority
  • Phase 3: growth and scale
  • Expected results for each phase
  • Custom notes for each phase
Client report

Fill in 5 cells and the report writes itself: an executive summary, 3 specific insights, traffic analysis, technical health, competitor context, an action plan, the revenue opportunity and a call to action.

  • Fills itself in from the dashboard
  • Pulls revenue from the calculator
  • Competitor context from the gap tab
  • 9 sections, ready to print
  • A "book a call" button built in
Easy and hard fixes

Two tabs that separate what the client's team can do from what only an SEO expert can. The hard fixes tab becomes the scope of your ongoing work, written to show the specialist knowledge it needs.

  • 8 easy fix categories
  • 8 hard fix categories
  • An owner for each fix
  • Estimated time for each fix
  • Shows clearly what depends on what
RR_Master_SEO_Audit_v3.xlsx - Google Sheets
Cover
README
SF Import
GSC Import
GA4 Import
Ahrefs
πŸ†š Competitor Gap
Revenue Calc
Master View
Dashboard
Roadmap
Client Report
MASTER SEO AUDIT REPORT
RR WEB SERVICES Β· rrwebservices.com
Client or website: Enter client name here
Audit period: e.g. Q1 2025 vs Q3 2024
Prepared by: RR Web Services
67
Overall site health score: needs attention
14
Critical
28
At risk
11
Quick wins
203
URLs
SEO agencies

Run client audits faster and present them with more authority. The Client Report tab alone saves 2 to 3 hours per audit, and the revenue calculator helps you win more retainers.

Freelance SEO consultants

Deliver agency-quality work without agency overhead. One template for every client, and it shows you're the expert who sees what others miss.

In-house SEO managers

Make the internal case for budget. The revenue calculator speaks your CFO's language, and the competitor gap tab makes the threat visible.

Digital marketing managers

Take charge of your site's SEO without relying on an agency for every insight. Use the easy fixes tab to get quick wins done right away.

WordPress developers

Add real SEO audits to the services you offer. It's built so people who aren't SEOs can understand it, and your clients will see the value right away.

SEO students and learners

Learn how a proper audit framework works in practice: a working system built from real client work, not theory. See how each data source feeds the scores.

Who this is not for

If you need a fully automated tool that pulls data through an API with no manual exports, this isn't it. You'll export CSV files from each tool and paste them in, which takes 15 to 20 minutes per audit. If you need something that runs entirely on its own, look at dedicated audit software. This template is for people who want to understand what the data is telling them, not just see a score.

No. The template works with whatever data you have. Each import tab stands alone, so you can paste Screaming Frog data, leave Ahrefs blank, and the formulas work with what's there. More data gives a fuller picture, but you can start with just Screaming Frog and Search Console.
Basic familiarity is enough. You paste in data, fill in the yellow cells and the formulas do the rest. The README tab explains every step, and you never have to write a formula.
As many as you like. Make a copy for each client, paste in their data and fill in the yellow cells. One purchase covers every audit you ever run.
Yes. The free version of Screaming Frog crawls up to 500 URLs, which is enough for most small and mid-size sites. For larger sites, you'll need a license.
Yes. The Ahrefs tab feeds backlink signals into the scores, but the template works fully without it. You'll just need to fill in the competitor gap section by hand.
You'll see a Google Sheets link on this page right away. Click it and choose "Make a copy" to save your own editable version. We'll also email you the link as a backup.
If the template doesn't work as described (formula errors, broken tabs or missing sections), we'll fix it or refund you, no questions asked, within 7 days of purchase.
Of course. Once you've made your own copy, it's yours to edit and adapt. Add your logo, change the scoring weights or rework the action plan to suit you.
Have us run the audit for you

The template shows you what to fix. The SEO Clarity report is us doing it for you: a full audit of your site, delivered in 5 days, with an action plan in priority order written for your situation.