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
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.

🔒 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 →