How to Do a Website Content Audit in 6 Steps

Complete a website content audit by building a URL inventory, joining comparable performance evidence, reviewing each page's purpose and assigning a documented action. Use site-relative benchmarks and editorial judgement instead of universal traffic, word-count or engagement thresholds.

This operational guide shows how to build a reconciled content inventory, attach available performance evidence and record a reviewed keep, update, consolidate or remove decision. A crawler alone cannot provide a complete inventory or make the final editorial decision.

This six-step method scales through sampling, templates and automation. Estimate time only after the URL set, data access, markets and required manual review are known.

Step 1: Gather Your Tools

Before you start pulling data, you need the right tools configured and ready. Trying to run a content audit without proper tooling means you will miss pages, misread performance, and waste hours on manual work that software handles in seconds.

Here is the essential toolkit for a thorough content audit:

• Google Search Console — provides impression counts, click data, average position, and click-through rates for every indexed page. This is your primary source of organic search performance data and it is free.
• Google Analytics 4 — shows sessions, engagement rate, conversions, and user behaviour metrics. You need this to understand what visitors do after they land on a page.
• A site crawler — Screaming Frog, Sitebulb, or another suitable crawler. It inventories URLs reachable from its seeds and settings and can extract metadata, word counts, headings and internal links. Reconcile it with sitemaps, platform exports and Search Console.
• A spreadsheet tool — Google Sheets or Excel. You will combine data from multiple sources into a single master document. Every page gets a row, and every metric gets a column.
• Ahrefs or Semrush — for backlink data, keyword rankings, and competitive benchmarking. These tools show you which pages have earned external authority and which are ranking for valuable terms.

Set up API connections or export schedules before you begin the audit. If you are using Google Sheets, install the Search Analytics for Sheets add-on to pull GSC data directly. The less manual copying you do, the fewer errors creep into your dataset.

Step 2: Crawl and Inventory

Run a configured crawl, then reconcile its discovered URLs with XML sitemaps, Search Console and known platform exports. Record the seeds, rendering, limits and exclusions so the inventory's coverage can be reviewed.

For each URL, your crawl should capture the following data points:

• URL and page title — the basic identifier for every piece of content.
• HTTP status code — live pages return 200. Watch for 301 redirects, 404 errors, and soft 404s that return a 200 status but display an error page.
• Content size — capture main-content word count as descriptive evidence. Review whether the page completes its task rather than treating a threshold as a quality rule.
• Meta description — check whether every page has a unique, compelling meta description or if they are missing and duplicated.
• Heading structure — does the page have a single H1 and a logical hierarchy of H2s and H3s?
• Internal links in and out — pages with zero internal links pointing to them are orphaned and nearly invisible to search engines and users.
• Publish date and last modified date — essential for identifying stale content that needs refreshing.

Export the crawl into a master inventory with one row per intended canonical URL. Add only columns that support a decision and record how URL variants were normalised.

Step 3: Pull Performance Data

With your inventory built, you now layer in performance data from analytics and search platforms. This transforms your spreadsheet from a simple URL list into a decision-making tool.

From Search Console, export page-level data for a comparable period that covers the site's seasonality and available history. Record property, search type, filters and aggregation:

• Total clicks — how much organic traffic the page actually receives.
• Total impressions — how often the page appears in search results, even if nobody clicks.
• CTR — clicks divided by impressions. Compare the same query, page, country, device and result context before attributing a difference to the title or snippet.
• Average position — where the page ranks on average across all its queries.

From Google Analytics 4, add these metrics per page:

• Sessions — total visits from all traffic sources, not just organic.
• Engagement rate — use GA4's current engaged-session definition and confirm key-event configuration. Treat the rate as behavioural evidence rather than proof of content quality.
• Conversions — goal completions, form submissions, purchases, or whatever your site defines as a conversion.
• Revenue — if applicable, the monetary value each page contributes.

From Ahrefs or Semrush, add backlink counts and referring domain counts for each URL. Pages with strong backlink profiles deserve special attention because removing or redirecting them without care wastes link equity you have spent years building.

Use VLOOKUP or INDEX-MATCH to merge these datasets by URL. Clean up URL formatting first — trailing slashes, HTTP vs HTTPS, and www vs non-www variants will cause mismatches if you do not standardise them.

Step 4: Score Each Page

Now you have a spreadsheet for the reconciled scope and the evidence available for each reviewed page. Scoring can support triage, but it cannot decide which pages should be removed.

Create an optional scoring model only after defining the site's own distributions and goals. Example dimensions include traffic, task completion, conversion contribution, search visibility and link value.

• Traffic evidence — compare equivalent periods and the distribution for the same page type. Do not impose universal session bands.
• Engagement evidence — compare site-defined key events and engagement measures for the intended task.
• Conversion score (0-3) — 0 for no conversions, 1-3 based on conversion volume relative to your site average.
• Search evidence — review clicks, impressions, CTR and average position together at page and query level.
• Link evidence — preserve important relevant links and record provider coverage instead of grading by a universal domain count.

Document any weights and decision bands so reviewers can challenge them. A composite score is a triage aid and must not trigger deletion or consolidation without page review.

Add a conditional formatting colour scale to the composite score column. Green for high scores, yellow for mid-range, red for low scores. This gives you an instant visual overview of your content health when you scroll through the spreadsheet.

Step 5: Assign Actions

Every page in your audit needs a clear action. Ambiguity at this stage means nothing gets done. Create an Action column and assign one of these labels to each URL:

• Keep — the page performs well and needs no changes. Monitor it but do not touch it.
• Update — the page has potential but needs a content refresh. This might mean updating statistics, adding new sections, improving the title tag, or enhancing internal linking.
• Consolidate — the pages duplicate the same user task and one can serve as a genuine successor. Preserve useful information and verify the intended destination before retiring and redirecting a URL.
• Rewrite — the page targets a valuable keyword but the content quality is poor. Start from scratch with a new outline and better research.
• Remove — consider removal only after confirming the page has no continuing user, campaign, support, legal, conversion, link or search purpose. Redirect only to a genuine successor that satisfies the same task; otherwise return an appropriate 404 or 410 and remove internal references.
• Create — this is not an existing page but a gap you identified. During the audit you may notice topics your competitors cover that you do not. Log these as new content opportunities.

Add Priority and Owner fields. Base priority on expected business value, evidence confidence, effort, dependencies and change risk rather than a fixed ranking position.

Sort the spreadsheet by action type and priority so you have a clear execution queue. The action mix depends on the inventory and its purpose. Investigate recurring weaknesses and scoring assumptions without imposing a target ratio of updates, consolidations and removals.

Step 6: Execute and Monitor

An audit that sits in a spreadsheet and never gets executed is worthless. The execution phase is where the actual value is created.

Start with your high-priority updates. These are pages that already have some organic traction and need refinement rather than a complete overhaul. Common update tasks include refreshing outdated statistics, adding new sections to improve topical depth, rewriting title tags and meta descriptions for better CTR, and fixing broken internal and external links.

For consolidation, choose the URL that best and most stably represents the shared user task. Consider relevance, purpose, URL history, demand, links, conversions and implementation cost; preserve useful content and redirect retired URLs only when the survivor is a genuine replacement.

For removals, confirm user, legal, conversion and link value once more. Redirect only to a genuinely relevant destination; otherwise return an appropriate status and remove internal references.

Annotate release dates and monitor the same page and query groups after enough data accumulates. Report the outcome as improved, unchanged or inconclusive without promising a response window.

Choose the next review date from publishing rate, subject risk, release history and monitoring coverage. The content audit frequency guide provides a risk-based schedule.

The best content teams treat the content audit as an ongoing discipline rather than a one-off project. They maintain a living audit spreadsheet that gets updated monthly with fresh performance data, making the formal audit a quick review rather than a ground-up rebuild every time.