SEO Audit Checklist – CrawlRaven 200-Point Audit (Free Google Sheets Template)

How to work through the checklist without wasting a week

A checklist this long is only useful if you run it in the right order. Most of the items depend on the ones above them, so working top to bottom saves you from diagnosing symptoms of a problem you have not found yet.

Run the categories in dependency order

Crawlability first, then indexation, then everything that assumes the page is already in the index. Content and link work done before that is work you may have to redo.

1. Crawlability and indexation. Robots rules, server errors, redirect chains, canonical targets, accidental noindex. These gate every other category.
2. Site architecture and internal links. Orphan pages and deep pages tell you where crawl priority is going, which changes how you read everything below.
3. On-page elements. Titles, descriptions, headings, and duplicate or thin content, template by template rather than page by page.
4. Structured data and Core Web Vitals. Refinements. Valuable, but they rarely explain why a page is missing from search entirely.
5. Local or ecommerce specifics. Only the ones that apply to your site. Skipping an irrelevant category is not a gap.

Triage by severity, not by category

Once you have findings, regroup them. A single noindex on a money page outranks fifty missing alt attributes, even though the alt attributes make a longer and more satisfying list.

• Blocking: the page cannot be crawled, cannot be indexed, or returns an error. Fix this week.
• Diluting: the page is indexable but competing with itself through duplicates, thin variants, or cannibalised keywords. Fix this month.
• Refining: the page works and could work better. Schedule it, and do not let it crowd out the two tiers above.

Three mistakes that make the results misleading

• Auditing pages instead of templates. Sites are generated, so one broken product page usually means every product page is broken. Sample by template and the list gets shorter and more honest.
• Trusting the sitemap as the URL list. The sitemap is what you meant to publish. A link crawl is what you actually exposed, and the difference is where most problems live.
• Treating the checklist as a one-off. A theme update or a plugin change rewrites the output of every page at once, so a passing audit has a shelf life.

What to do once the checklist is filled in

A completed checklist is a diagnosis, not a plan. These are the steps that turn one into the other.

1. 01

   Group findings by fix, not by finding

   Four hundred missing meta descriptions are usually one template change. Collapsing findings into the edits that resolve them turns an intimidating list into a handful of tickets.

2. 02

   Attach each fix to a page that matters

   Sort the affected URLs by the traffic and revenue they already earn. The same technical fault is worth very different amounts depending on where it sits.

3. 03

   Estimate effort honestly

   Separate what you can change yourself from what needs a developer or a platform change. Ranking by impact alone produces plans that never ship.

4. 04

   Fix, then verify the fix

   Re-run the specific check rather than assuming the deploy worked. Validators exist for structured data, redirects, and robots rules; use them.

5. 05

   Re-crawl and diff against the last run

   The useful question after the first audit is not what is broken, but what broke since last time. That is a comparison, which means you need a baseline.

Related guides