# SEO Audit Template
[Home](/) › [Resources](/resources/) › [SEO Audit Template](/resources/seo-audit-template/)
Free Resource · Google Sheets
##
The Bespoke SEO Audit Template I Use on $25K Engagements.
The same four-tab audit framework I deploy on technical SEO retainers - adapted for in-house teams running their own quarterly reviews. No gated “course” funnel. Just the spreadsheet, plus a 12-minute walkthrough video.
- ✓ Built for B2B SaaS & developer-tool sites
- ✓ Conditional formatting auto-flags P0/P1 issues
- ✓ Drop-in compatible with Screaming Frog exports
[
↓ Get Free Access
](#audit-access)
seo-audit-template-v3.2.gsheet
Tab 01
Technical Crawl
142 checks
Tab 02
Indexation
86 rules
Tab 03
Schema & SERP
64 entities
Tab 04
Content Arch.
98 items
⚡ 390 total audit checks · 1-click duplicate
## What’s Inside the Template
Four pre-built tabs covering the full technical SEO surface area. Each row is a discrete check with severity scoring, owner assignment, and status tracking.
🕷️
## Technical Crawlability
142 checks · Tab 01
- **Robots.txt & meta robots** conflict detection
- Response code waterfall (3xx, 4xx, 5xx chains)
- Core Web Vitals per template & section
- Internal PageRank distribution & orphan pages
- JavaScript rendering parity (client vs. server)
- Hreflang & international targeting validation
🗂️
## Indexation Rules
86 rules · Tab 02
- Canonical hygiene & self-referencing audit
- Noindex leakage in production templates
- Pagination & parameter handling rules
- Staging / preview / dev environment exposure
- Sitemap coverage vs. indexable inventory
- Crawl budget waste detection (faceted nav, filters)
🧬
## Schema & Semantic Markup
64 entities · Tab 03
- **JSON-LD validation** across 14 entity types
- Product, SoftwareApplication, FAQ, HowTo coverage
- Organization & Author entity linking
- Rich result eligibility scoring (P0 - P3)
- Speakable & AI-citation markup readiness
- Knowledge Graph entity disambiguation
🏛️
## Content Architecture
98 items · Tab 04
- Topical authority & hub-spoke mapping
- Keyword cannibalization matrix
- Internal link gap & anchor text diversity
- Content decay & refresh velocity tracker
- Funnel-stage distribution (TOFU / MOFU / BOFU)
- Programmatic SEO template inventory
🎁
**Bonus: Severity Scoring Rubric**
Hidden Tab 05 - P0/P1/P2/P3 classification framework with auto-weighted impact scoring.
Included Free
## Get Free Access
One-time email, no newsletter auto-opt-in. You’ll receive a Google Sheets duplicate link and a 12-minute Loom walkthrough of the four tabs.
📩 Send Me the Template
🔒 No spam, no drip campaign. Unsubscribe link included in the email.
✓ 1,200+ downloads
✓ Used by 40+ B2B SaaS teams
✓ Updated quarterly
Need a done-for-you audit instead?
[
Hire Rakesh for a Custom Audit →
](/hire-me/)