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.
Google Sheets, 14 tabs, 29,000+ formulas, lifetime access
Instant access, for as many client audits as you like.
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.
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.
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
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
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
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
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
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
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
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.
Deliver agency-quality work without agency overhead. One template for every client, and it shows you're the expert who sees what others miss.
Make the internal case for budget. The revenue calculator speaks your CFO's language, and the competitor gap tab makes the threat visible.
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.
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.
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.
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.
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.