SEO Audit Report Template (Free Download) — 200+ Checks, Scored & Prioritized

An SEO audit report template is a structured document that organizes technical findings, on-page issues, and strategic recommendations into a format that stakeholders can act on. The difference between a useful audit report and a data dump is structure — the right template ensures every finding has context, priority, and a clear fix.

This guide gives you a free, downloadable SEO audit report template (Excel + Google Sheets), walks through every section with filled-in examples, and shows you how to present audit findings so clients and executives actually read them. Whether you're an agency delivering client audits or an in-house SEO reporting to leadership, this template covers the complete audit reporting workflow.

Why you need a structured audit report template

Most SEO audits fail not because the analysis is wrong, but because the report is unreadable. A 50-page PDF full of crawl errors, status codes, and screenshots with no prioritization is worse than no report at all — it overwhelms stakeholders and nothing gets fixed.

According to Google's SEO starter guide, the most impactful SEO improvements come from fixing fundamental technical issues first. A good audit report template enforces this by organizing findings by impact, not by category.

The best audit report templates share three characteristics:

• Impact-first structure — Critical issues that block indexation or hurt Core Web Vitals appear before minor optimizations
• Business context — Every finding links to a revenue or traffic impact estimate, not just a technical severity score
• Actionable recommendations — Each issue includes what to fix, who should fix it, and how long it takes

The 8 sections every SEO audit report needs

An SEO audit report template with 200+ checks across 8 categories covers every ranking factor that matters. Here's what each section should include, why it matters, and how to present findings effectively.

Section 1: Executive summary and health score

The executive summary is the only section many stakeholders will read. It needs to answer three questions in under 60 seconds: How healthy is the site? What are the biggest problems? What should we fix first?

Your executive summary should include:

• Overall health score (0–100) — A weighted composite of all 8 category scores
• Category breakdown — Individual scores for crawlability, on-page, speed, links, schema, backlinks, content, and AI readiness
• Top 5 critical findings — The issues with the highest estimated traffic impact
• Quick wins — High-impact, low-effort fixes that can ship this week
• Competitor benchmark — How this site compares to 2–3 competitors on the same scoring framework

The scoring framework matters. We recommend weighting categories by their ranking impact: crawlability (20%), on-page (18%), Core Web Vitals (15%), internal linking (12%), structured data (10%), backlinks (10%), content (8%), and AI readiness (7%). This weighting reflects Google's documented ranking systems and real-world correlation data.

Section 2: Crawlability and indexation (42 checks)

Crawlability issues are the most critical category because if search engines can't crawl and index your pages, nothing else matters. This section covers:

• Robots.txt audit — Identify pages blocked from crawling that should be indexed, and vice versa
• Sitemap health — Missing pages, outdated URLs, oversized sitemaps (>50K URLs), broken sitemap index references
• HTTP status codes — Distribution of 200s, 301s, 302s, 404s, and 5xx errors across the site
• Canonical tag validation — Self-referencing canonicals, conflicting canonicals, canonical chains
• Redirect audit — Redirect chains (>2 hops), redirect loops, 302s that should be 301s
• Index coverage — Compare crawled pages against Google Search Console index coverage report
• Crawl budget analysis — For sites with 10K+ pages, identify crawl budget waste from faceted navigation, internal search, and parameter URLs

In your report, present crawlability findings as a table with columns for issue type, affected URLs (count + sample), severity, and recommended fix. Link to a full URL export in an appendix rather than listing every affected page inline.

Section 3: On-page SEO (38 checks)

On-page SEO issues are the most common findings in any audit. The key is separating critical issues (missing title tags, duplicate H1s) from nice-to-haves (title tag length optimization).

• Title tag audit — Missing, duplicate, too long (>60 chars), too short (<30 chars), keyword-stuffed
• Meta description audit — Missing, duplicate, too long (>160 chars), not compelling
• Heading hierarchy — Missing H1, multiple H1s, skipped heading levels (H1 → H3), keyword placement in H2s
• Image optimization — Missing alt text, oversized images, missing next-gen formats (WebP/AVIF), lazy loading issues
• Content analysis — Word count distribution, thin pages (<300 words), keyword density, reading level
• URL structure — Length, readability, keyword inclusion, parameter handling

For each on-page finding, include a before/after example showing the current state and the recommended fix. This makes developer handoff straightforward — they can see exactly what to change.

Section 4: Core Web Vitals and page speed (28 checks)

Core Web Vitals are a confirmed ranking signal per Google's page experience documentation. Your audit report should cover both lab data (Lighthouse) and field data (CrUX) for the three core metrics:

• Largest Contentful Paint (LCP) — Target: <2.5 seconds. Common fixes: image optimization, server response time, render-blocking resources
• Interaction to Next Paint (INP) — Target: <200ms. Common fixes: reduce JavaScript execution, optimize event handlers, break up long tasks
• Cumulative Layout Shift (CLS) — Target: <0.1. Common fixes: set explicit dimensions on images/embeds, avoid dynamic content injection above the fold

Beyond the three core metrics, report on Time to First Byte (TTFB), render-blocking resources, JavaScript bundle size, and third-party script impact. Present speed data as a page-by-page table sorted by traffic, so stakeholders can see which high-traffic pages have the worst performance.

Section 5: Internal linking structure (22 checks)

Internal linking is one of the most underreported sections in SEO audits, yet it directly affects how search engines discover and prioritize your content. Cover:

• Orphan pages — Pages with zero internal links pointing to them (invisible to crawlers)
• Click depth — Pages that require 4+ clicks from the homepage to reach
• Broken internal links — Links pointing to 404s or redirects within your own site
• Anchor text distribution — Over-optimized vs. natural anchor text patterns
• Link equity flow — Are your most important commercial pages receiving enough internal links?

Visualize the site's link structure as a depth chart showing how many pages exist at each click level. This makes it immediately obvious when important pages are buried too deep.

Section 6: Structured data and schema markup (18 checks)

Structured data determines your eligibility for rich results — review stars, FAQ dropdowns, product prices, and how-to carousels. Missing or broken schema means you lose these SERP features to competitors.

• Schema validation — Test all JSON-LD against Google's Rich Results Test
• Missing schema opportunities — Pages eligible for schema types they don't have (FAQ pages without FAQ schema, product pages without Product schema)
• Schema errors — Required fields missing, deprecated properties, incorrect nesting
• Breadcrumb markup — Ensure breadcrumb schema matches the visible breadcrumb navigation

In your report, create a matrix showing page types vs. applicable schema types, with checkmarks for implemented, X marks for missing, and warning icons for errors. This gives a clear picture of schema coverage at a glance.

Section 7: Backlink profile analysis (24 checks)

The backlink section of an audit report should focus on link quality and risk, not just counts. Cover:

• Referring domain diversity — Total referring domains, new/lost trend, domain authority distribution
• Toxic link identification — Spammy, irrelevant, or potentially harmful backlinks that warrant a disavow file
• Anchor text ratio — Branded vs. exact match vs. generic. Over-optimized anchor text profiles are a penalty signal
• Link velocity — Rate of new link acquisition vs. competitors. Sudden spikes or drops warrant investigation
• Competitor link gap — Domains linking to competitors but not to you — these are your highest-probability outreach targets

Section 8: AI search readiness (14 checks)

AI-powered search is reshaping how users find information. Google's AI Overviews, ChatGPT, Perplexity, and Claude are increasingly answering queries directly. Your audit report should assess how well the site is positioned to earn citations from these AI systems.

• Entity coverage — Does the site have clear, structured information about the entities it represents? AI systems prioritize sources with explicit entity definitions
• FAQ and Q&A content — AI systems heavily cite pages with clear question-and-answer formatting. FAQ schema amplifies this signal
• Citation-worthy content patterns — Definitive statements, statistics, frameworks, and step-by-step processes are the content patterns most likely to earn AI citations
• AI Overview appearances — Track which queries trigger AI Overviews and whether the site appears in cited sources
• Structured data for AI — Comprehensive schema markup helps AI systems understand and accurately represent your content

This section is the biggest gap in competitor audit templates. None of the top-ranking audit report templates cover AI search readiness — including it positions your audit as forward-looking and differentiates your agency from those still running 2020-era audit checklists.

How to score your SEO audit (the weighted framework)

A numeric health score transforms a subjective audit into an objective, repeatable measurement. Here's the scoring framework built into our template:

To calculate the overall score: score each category 0–100 based on pass rate (checks passed ÷ total checks × 100), then multiply by the weight. Sum the weighted scores for the final health score. A site scoring 90+ across all categories is in excellent technical health. Below 50 in any single category signals a critical gap that needs immediate attention.

What to include vs. skip in your audit report

Not everything from your audit tool belongs in the report. The goal is actionable insights, not exhaustive data. Here's what to include and what to leave in a linked appendix:

How to prioritize audit findings (impact × effort matrix)

The most common complaint about SEO audit reports is "great, but where do we start?" A prioritization framework solves this by scoring every finding on two dimensions: estimated traffic impact and implementation effort.

The impact × effort matrix is included in our template as a pre-built worksheet. For each audit finding, score impact (high/medium/low) and effort (low/medium/high), and the template auto-assigns a P0–P3 priority. This turns a list of 60+ issues into a clear execution plan.

How to present audit findings to different audiences

The same audit data needs different presentations depending on who's reading it. Your template should support at least three views:

For executives and clients

• Lead with the health score and 3-sentence narrative summary
• Show competitor comparison (your score vs. 2–3 competitors)
• Focus on revenue impact: "Fixing these 5 issues could recover an estimated 2,400 sessions/month"
• Include a timeline: what gets fixed this month, next month, and this quarter

For SEO managers and strategists

• Full category breakdown with individual check pass/fail status
• Historical trend if this is a recurring audit ("crawlability improved from 64 → 82 since last quarter")
• Competitor gap analysis: specific keywords and backlinks competitors have that you don't
• Content opportunities identified during the audit

For developers and engineering teams

• Technical findings formatted as actionable tickets (issue, affected URLs, fix steps, acceptance criteria)
• Before/after code examples for implementation issues (schema markup, canonical tags, meta robots)
• Performance budgets and Core Web Vitals targets per page template
• Prioritized by sprint-friendly sizing (S/M/L effort estimates)

Our template includes separate tabs for each audience. The executive view auto-generates from the detailed findings — you fill in the data once and the summary populates automatically. Learn more about structuring client-facing SEO reports in our companion template guide.

5 mistakes that make audit reports useless

After reviewing hundreds of SEO audit reports, these are the five patterns that consistently prevent findings from getting implemented:

1. No executive summary — Jumping straight into technical findings loses non-technical stakeholders in the first 30 seconds. Always lead with the health score and top 5 issues.
2. No prioritization — A flat list of 80 issues with equal weight guarantees nothing gets fixed. Use the P0–P3 impact × effort framework to create a clear execution order.
3. Technical jargon without business context — "47 pages return 302 status codes" means nothing to a CMO. Try: "47 pages are temporarily redirected instead of permanently, which dilutes link equity and could reduce organic traffic by 5–10%."
4. Screenshots without annotations — A raw Lighthouse screenshot doesn't tell the reader what to fix. Annotate screenshots highlighting the specific issue and the recommended action.
5. No follow-up plan — An audit without a follow-up cadence is a one-time event. Build in a 30/60/90-day review schedule and define who owns each action item.

SEO audit tools for generating report data

You need data before you can fill in a report template. Here are the tools that generate the audit data your template needs, and how they compare:

For a deeper comparison, see our reviews of Ahrefs, Semrush, Sitebulb, and Lumar. For agencies that need white-label audit reports, we cover the best options in our dedicated comparison.

How to use this template (step-by-step walkthrough)

Here's how to go from a fresh download to a complete audit report:

1. Download the template — Grab the Excel file or make a copy of the Google Sheet
2. Run your audit — Use CrawlRaven, Screaming Frog, or your preferred crawl tool to generate the raw audit data
3. Fill in the Overview tab — Enter the site URL, crawl date, pages crawled count, and any notes about the audit scope
4. Populate each category tab — Transfer findings from your audit tool into the relevant category sheets. Each sheet has pre-defined columns for issue, affected URLs, severity, and recommended fix
5. Review auto-generated scores — The template calculates category scores and the overall health score based on your entries
6. Customize the executive summary — The template auto-populates the top 5 findings, but you should add the narrative summary explaining what the data means for this specific site
7. Set priorities — Use the Actions tab to assign P0–P3 priorities based on the impact × effort matrix
8. Export or present — Share the Google Sheet directly, or export tabs as PDF for a polished client deliverable

How often to run SEO audits (and when to re-audit)

A single audit is a snapshot. The value comes from regular re-audits that track progress and catch regressions. Here's the recommended cadence:

• Comprehensive audit — Quarterly for most sites, monthly for sites with frequent deployments
• Monitoring crawls — Weekly automated crawls to catch regressions (new 404s, broken schema, CWV spikes)
• Trigger-based audits — After major site redesigns, CMS migrations, or Google core updates
• Pre-launch audits — Before launching new sections, redesigns, or domain migrations

For agencies managing multiple clients, CrawlRaven automates the monitoring crawl and flags regressions so you can focus quarterly audits on strategic analysis rather than re-checking the same 200 items manually. Learn more about what SEO audits cost and how to scope audit engagements.

Generate audit reports automatically with CrawlRaven

If you're running 5+ audits per month, manually filling in templates becomes a bottleneck. CrawlRaven automates the entire audit reporting workflow:

• 200+ automated checks across all 8 categories, scored and weighted automatically
• Auto-generated executive summary with health score, top findings, and competitor benchmarks
• Prioritized action plan — Every issue scored on impact × effort with P0–P3 priorities
• White-label PDF reports — Add your agency branding, logo, and custom colors
• Client-ready presentation — Executive, strategist, and developer views generated from a single crawl
• AI search readiness — The only audit tool that includes LLM citation analysis and AI Overview tracking

Whether you use our free template for manual audits or CrawlRaven for automated reporting, the goal is the same: turn technical SEO data into an actionable document that gets issues fixed. For proposals that include audit findings, see our SEO audit proposal guide.