The audit framework we use with every client — rebuilt as a Google Sheets template you can use yourself. Screaming Frog, GA4, GSC, and Ahrefs data in one place. Scores every URL. Tells you exactly what to fix and in what order.
Google Sheets · 14 tabs · 29,000+ formulas · Lifetime access
Instant access. Use on unlimited client audits.
Your Google Sheets copy is ready. Click below to open it and make your own copy. Check your email too — we've sent a copy of the link.
Open Google Sheets Template Questions? Message us any timeBranded audit cover with client name, period, and overall score. First thing a prospect sees — sets the tone before they read a word.
Every URL from your Screaming Frog crawl matched against GSC, GA4, and Ahrefs data in one row. Composite 0–100 score per URL. Trend direction. Plain English reason for each trend movement.
Site-wide health scorecard, traffic trend breakdown, technical issues summary, backlink intelligence, and three yellow cells for your specific expert insights.
Domain-level comparison: DR, referring domains, organic traffic, content depth. Page-level backlink gap per commercial URL. Core Web Vitals vs competitors.
Enter your conversion rate and average order value. Template calculates additional monthly visitors and revenue if striking distance pages (position 4–10) are optimised.
Four workstreams (Technical, Content, Authority, Measurement) across three phases. Revenue projection row. Yellow cells for client-specific notes. Prints as a standalone proposal page.
Fill in 5 cells. The report writes itself — executive summary, 3 specific insights, traffic analysis, technical health, competitor context, action plan, revenue opportunity, and CTA.
Two tabs that separate what the client's team can implement vs what only an SEO expert can do. The Hard Fixes tab is your retained work scope — pre-written to position specialist knowledge.
Run client audits faster and present them with more authority. The Client Report tab alone saves 2–3 hours per audit. The revenue calculator closes more retainers.
Deliver agency-grade work without agency overheads. One template, unlimited clients. Positions you as the expert who sees what others miss.
Build the business case for budget internally. The revenue opportunity calculator speaks CFO language. The competitor gap tab makes the threat visible.
Take control of your site's SEO without depending on an agency for every insight. Use the easy fixes tab to action quick wins immediately.
Add real SEO audit capability to your service offering. Built for non-SEOs to understand — your clients will see the value immediately.
Learn how a proper audit framework actually works — not theory, but a working system built from real client work. See how every signal connects.
If you need a fully automated tool that pulls data via API without any manual export — this isn't that. You'll need to export CSV files from each tool and paste them in. The setup takes 15–20 minutes per audit. If you need something that runs entirely on its own, look at dedicated SaaS audit platforms. 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 — a complete audit of your site delivered in 5 days, with a prioritised action plan written for your specific situation.