A structured SEO audit template covering 6 dimensions: technical SEO, on-page, off-page, content quality, local SEO, and AI visibility. Includes a weighted scoring system that produces an overall SEO health score out of 100.
Last updated: March 2026 · Reading time: 13 min
A multi-tab spreadsheet that produces a quantified SEO health score.
This SEO audit template is a multi-tab spreadsheet designed to produce a quantified SEO health score. Each audit dimension is scored separately, then weighted and combined into an overall score out of 100.
An SEO audit template is a structured spreadsheet or document used to systematically evaluate a website’s search optimization across technical, content, authority, and visibility dimensions, producing a quantified health score and prioritized action plan.
Only 54.6% of websites meet overall Core Web Vitals thresholds as of November 2025 (HTTP Archive). The template helps you find every gap, score its severity, and prioritize fixes by impact.
Here’s the tab structure:
Each audit item is scored on a 0-3 scale: 0 (critical failure), 1 (needs major improvement), 2 (partially optimized), 3 (fully optimized). The dimension score is calculated as the percentage of points earned versus points possible.
| Dimension | Weight | Max Items | Why this weight |
|---|---|---|---|
| Technical SEO | 25% | 15 | Foundation. If Google can’t crawl it, nothing else matters. |
| On-Page SEO | 20% | 12 | Direct ranking signals. Title tags, content structure, internal links. |
| Off-Page & Backlinks | 20% | 10 | Authority signals remain a top-3 ranking factor (Backlinko, 2024). |
| Content Quality | 15% | 10 | E-E-A-T and content depth. Google’s quality rater guidelines emphasize experience and expertise. |
| Local SEO | 10% | 8 | Critical for location-based businesses; weighted lower for national/global sites. |
| AI Visibility | 10% | 8 | Increasingly important as AI Overviews appear in 44% of queries (SE Ranking, 2025). |
Score interpretation:
For sites without physical locations, redistribute the 10% local SEO weight equally across Technical (27.5%) and Content (17.5%).
Technical SEO is the foundation. Start every audit here. Run Screaming Frog (free up to 500 URLs) or Sitebulb as your primary crawl tool, then validate findings in Google Search Console.
| # | Audit Item | What to check | Tool |
|---|---|---|---|
| 1 | Crawlability | robots.txt not blocking important pages; no accidental noindex tags | Screaming Frog |
| 2 | Indexation health | Pages indexed vs. pages submitted in sitemap; no index bloat | Google Search Console |
| 3 | XML sitemap | Sitemap exists, submitted, contains only canonical indexable URLs | Screaming Frog |
| 4 | Canonical tags | Every indexable page has a self-referencing canonical; no conflicts | Screaming Frog |
| 5 | HTTPS & security | Full HTTPS, valid SSL, HSTS enabled, no mixed content | SSL Labs |
| 6 | Core Web Vitals (LCP) | Largest Contentful Paint under 2.5 seconds | PageSpeed Insights |
| 7 | Core Web Vitals (INP) | Interaction to Next Paint under 200 milliseconds | PageSpeed Insights |
| 8 | Core Web Vitals (CLS) | Cumulative Layout Shift under 0.1 | PageSpeed Insights |
| 9 | Mobile usability | Responsive design, tap targets 48px+, no horizontal scroll | Mobile-Friendly Test |
| 10 | Page load speed | Median page load under 3 seconds on 4G | GTmetrix |
| 11 | Redirect chains | No chains longer than 1 hop | Screaming Frog |
| 12 | 404 errors | No broken internal links; custom 404 page with proper status | Screaming Frog |
| 13 | URL structure | Lowercase, hyphens, descriptive, no parameters for content pages | Manual review |
| 14 | Structured data | Schema markup validated with zero errors | Rich Results Test |
| 15 | International targeting | Hreflang tags configured correctly (if applicable) | Ahrefs / Screaming Frog |
On-page SEO covers the elements you control directly on each page. According to Semrush’s 2025 ranking factors study, title tag optimization, content relevance, and internal link structure remain among the strongest on-page correlations with top-10 rankings.
| # | Audit Item | What to check |
|---|---|---|
| 16 | Title tags | Unique, 50-60 chars, primary keyword included, compelling for clicks |
| 17 | Meta descriptions | Unique, 150-160 chars, action-oriented, includes keyword |
| 18 | H1 tags | One H1 per page, contains primary keyword |
| 19 | Header hierarchy | Logical H1 > H2 > H3 flow, no skipped levels |
| 20 | Keyword targeting | Each page targets a unique primary keyword; no cannibalization |
| 21 | Content depth | Minimum 800 words for core pages; answers the search query comprehensively |
| 22 | Image optimization | WebP/AVIF format, descriptive alt text, compressed, lazy-loaded below fold |
| 23 | Internal linking | Every key page linked from at least 3 other pages; descriptive anchor text |
| 24 | URL optimization | Short, descriptive, keyword-relevant |
| 25 | Content freshness | Key pages updated within 12 months; “last updated” dates visible |
| 26 | Readability | Short paragraphs, subheadings every 200-300 words, scannable |
| 27 | Call to action | Every page has a clear next step; no dead-end pages |
The most common on-page issue we find at ScaleGrowth.Digital: keyword cannibalization. Use a keyword mapping template to assign one primary keyword per URL and eliminate overlap.
Off-page SEO measures your site’s authority and reputation signals. Backlinks remain a top-3 ranking factor (Backlinko, 2024). Quality matters far more than quantity.
| # | Audit Item | What to check |
|---|---|---|
| 28 | Referring domains count | Total unique domains linking; compare against top 3 competitors |
| 29 | Link quality distribution | Percentage of links from DR 40+ domains vs. low-quality spam |
| 30 | Anchor text distribution | Natural mix: branded (40-60%), generic (15-25%), keyword-rich (5-15%), URL (10-20%) |
| 31 | Toxic backlinks | Identify and disavow links from spam, PBN, or penalized domains |
| 32 | Link velocity | New links per month trending flat or growing |
| 33 | Competitor gap | Domains linking to competitors but not to you |
| 34 | Brand mentions | Unlinked brand mentions found and converted to backlinks |
| 35 | Content linkability | Site has link-worthy assets: data, research, tools, templates, guides |
| 36 | Social signals | Content shared on social platforms; social profiles link back to site |
| 37 | Digital PR opportunities | HARO/Connectively responses, expert commentary, industry publications |
Content quality auditing in 2026 goes beyond word count. Google’s quality rater guidelines emphasize E-E-A-T: Experience, Expertise, Authoritativeness, and Trustworthiness.
| # | Audit Item | What to check |
|---|---|---|
| 38 | E-E-A-T signals | Author bios, credentials, “about” pages, editorial process, source citations |
| 39 | Content uniqueness | No duplicate or near-duplicate content |
| 40 | Topical authority | Content covers topics comprehensively with supporting pages and internal clusters |
| 41 | Search intent match | Content format matches what ranks |
| 42 | Content freshness | Time-sensitive content updated within 12 months; stale content flagged |
| 43 | Thin content | Pages with fewer than 300 words that aren’t serving a specific UX purpose |
| 44 | Content gaps | Keywords competitors rank for that you don’t have content addressing |
| 45 | User engagement | Bounce rate, time on page, and scroll depth via GA4 |
| 46 | Content cannibalization | Multiple pages competing for the same keyword |
| 47 | Media assets | Images, videos, infographics, tables supporting the content |
Skip this section if your business operates purely online. For businesses with physical locations, local SEO often drives 30-50% of total organic leads. 98% of consumers search online for local businesses (BrightLocal, 2025).
| # | Audit Item | What to check |
|---|---|---|
| 48 | Google Business Profile | Claimed, verified, complete profile with correct categories, photos, and services |
| 49 | NAP consistency | Name, address, phone identical across GBP, website, and top 20 directories |
| 50 | Local citations | Listed on 4 data aggregators + 15-20 general directories + 5-10 industry directories |
| 51 | Reviews | Active review generation, response to all reviews, 4.0+ average rating |
| 52 | Location pages | Unique content per location, not template-swapped; includes local schema |
| 53 | Local backlinks | Links from chamber of commerce, local press, community organizations |
| 54 | Local schema | LocalBusiness schema with specific subtype, geo-coordinates, opening hours |
| 55 | Map Pack ranking | Track rankings for top 5 local keywords in Google Maps and Local Pack |
For a deeper dive, use our dedicated 34-point local SEO checklist.
AI visibility is the newest dimension of SEO auditing. Google AI Overviews appear in 44.4% of search queries (SE Ranking, 2025). Your content needs to be structured for AI extraction.
| # | Audit Item | What to check |
|---|---|---|
| 56 | Structured data coverage | Schema markup on all key content types: Article, Product, FAQ, HowTo, Organization |
| 57 | Entity definition | Brand, people, products clearly defined with consistent descriptions |
| 58 | Answer-first content | Every H2 section starts with a direct answer in the first 2-3 sentences |
| 59 | Definition blocks | Key concepts defined in standalone, extractable sentences or blockquotes |
| 60 | Fact density | At least 1 specific, citable number per 200 words |
| 61 | Source citations | Claims backed by named sources with dates |
| 62 | FAQ sections | Structured FAQ content on key pages with FAQPage schema markup |
| 63 | AI engine presence | Search your brand and key topics in ChatGPT, Perplexity, Google AI; document appearances |
The key principle: write content that an AI system can confidently cite as a source. Clear definitions, specific data, named sources, and structured markup.
A complete SEO audit takes 2-4 weeks for a site with 50-500 pages.
“We’ve built and delivered over 80 SEO audits using variations of this template. The scoring system is what separates a useful audit from a laundry list of issues. When a CMO sees ’47 out of 100,’ they understand the scale of the problem instantly. When they see a list of 200 findings with no prioritization, the audit gets shelved.”
Hardik Shah, Founder of ScaleGrowth.Digital
Repeat this audit quarterly. A quarterly audit cadence keeps your SEO strategy grounded in current data.
Auto-scoring formulas, weighted dimension calculations, and auto-populated action plan.
Includes all 63 audit items across 6 dimensions.
No email required. Instant access.
A complementary checklist format for ongoing SEO maintenance.
Turn your audit findings into a structured strategy with quarterly milestones.
A deeper technical audit with step-by-step instructions for each check.
Run a full SEO audit quarterly and after every major site change (redesign, CMS migration, domain change). After a Google core algorithm update, re-run the technical and content sections immediately.
At minimum: Google Search Console (free), Screaming Frog (free up to 500 URLs), and PageSpeed Insights (free). For backlink analysis, you’ll need Ahrefs, Semrush, or Moz (starting around $99-$129/month as of early 2026).
In our experience auditing 80+ websites, the average first-time audit score is 45-55 out of 100. A score above 70 indicates a strong SEO foundation. Above 85 is excellent. Below 40 indicates fundamental problems that need immediate attention.
A checklist is a pass/fail list of items to complete. An audit template goes deeper: it scores each item on a scale, calculates weighted dimension scores, produces an overall health score, and generates a prioritized action plan. Use a checklist for routine maintenance and an audit template for comprehensive assessment.
Yes, as of 2026 it’s essential. AI Overviews appear in over 44% of Google searches, and AI answer engines like ChatGPT and Perplexity are handling a growing share of informational queries.
Our SEO practice runs full audits across 35+ dimensions with proprietary scoring. We deliver a prioritized roadmap and quarterly re-audits to track progress.