How to Do a Manual Content Audit: Method, Template and Tools 2026

March 8, 2026 11 min read Ahmed EL JAOUARI

A content audit is the exercise you postpone quarter after quarter — until the day Google decides to send a wake-up call. You open Search Console one morning and your traffic has plummeted by 30%. Then you finally decide to audit your content. Except by then, the damage is done.

A proactively performed audit, at least once a year, prevents this scenario. This guide gives you the complete method for performing a manual content audit on a reasonably sized site (up to 500 pages). Beyond that, automated tools become indispensable — but even then, understanding the manual logic remains essential.

Estimated time based on site size

  • Under 50 pages: 4 to 8 hours (doable in one day)
  • 50 to 200 pages: 2 to 5 working days
  • 200 to 500 pages: 1 to 3 weeks — consider a semi-automated tool
  • More than 500 pages: A tool like EEATClean becomes essential

1. Build a Complete URL Inventory

Before analyzing anything, you need to know what exists. Most webmasters underestimate the actual number of indexed pages on their site by 20 to 40%.

The 3 sources to cross-reference for your inventory:

Source 1 — Google Search Console (CSV Export)

Go to GSC > Indexing > Pages and export the list of all indexed pages. This is the official list of what Google "sees" of your site. Note: it only contains pages that are actually indexed, not those that are blocked or in error.

Supplement with: The "Performance > Search results" tab — export with the Clicks, Impressions, CTR, Position columns. These data points will be at the heart of your analysis grid.

Source 2 — Your sitemap.xml

Retrieve all URLs from your sitemap.xml. The difference between your sitemap and the pages indexed by Google is a valuable indicator: pages in the sitemap but absent from the index signal a quality problem as perceived by Google.

Source 3 — A Crawl with Screaming Frog

Run a complete crawl of your site. Screaming Frog will find URLs that neither GSC nor your sitemap lists: noindex pages, orphan pages, URLs with session parameters, etc. Export everything and merge in a spreadsheet.

Expected result: A Google Sheets (or Excel) file with one row per URL. This is your working base for the following steps.

2. Build the Analysis Grid

Your spreadsheet must contain the following columns. Some fill automatically from exports; others require a manual visit to the page.

Column Source What it reveals
Full URLCrawl / GSCUnique page identifier
Title / H1Crawl / ManualPage intent and topic
Clicks (12 months)GSCReal SEO value of the page
Impressions (12 months)GSCRemaining visibility potential
Average positionGSCEffort vs potential gain
Publication dateCMS / ManualContent freshness
Last updated dateCMS / ManualLast editorial intervention
Word countCrawlDepth of coverage
Inbound backlinksAhrefs / GSCAcquired authority — be careful not to delete
Internal links receivedCrawlImportance in your architecture
Final decisionManualKeep / Improve / Merge / Redirect / Delete

3. Analyze and Categorize Each Page

This is the most time-consuming step. You must visit each page and classify it into one of the five following categories.

KEEP — No action needed

The page generates regular traffic, ranks for its target keywords, and the content is up to date and complete. Indicative criteria: >50 clicks/month, position <15, updated <18 months ago, >800 words.

IMPROVE — Editorial update

The page has potential (high impressions, topic still relevant) but its performance is declining. The content is dated, shallow, or lacks recent data. Action: update figures, add sections, enrich E-E-A-T. See our guide what to do with an obsolete article.

MERGE — Content consolidation

Two or three pages cover the same topic with similar angles. None are really performing. Merging them into a single comprehensive article concentrates authority and improves E-E-A-T signals. Redirect the old URLs with 301 to the new merged page.

REDIRECT — 301 to a relevant page

The page hasn't generated traffic for more than a year, but it has inbound backlinks you'd hate to lose. Redirect it to the thematically closest page. Don't redirect everything to the homepage — this dilutes authority without benefit.

DELETE — Deindex or remove

Zero traffic over 12 months, no inbound backlinks, topic out-of-scope, or "thin" content with no real value. These pages damage the overall quality perception of your site by Google. Delete them or add a noindex if you prefer to keep them in your CMS. Read our article why deleting your useless articles boosts your SEO.

4. Prioritize Actions

Once all your pages are categorized, you probably have a list of 50 to 200 pages to process. You need to prioritize.

The prioritization matrix:

  • Priority 1 — Pages in free fall: Pages that had traffic 6 months ago and have lost 60%+. These are your "patient zero." Treat them first.
  • Priority 2 — Pages with backlinks but no traffic: Risk of wasted authority. Redirect or improve as a priority.
  • Priority 3 — "Thin" content in volume: If you have 50 articles of 300 words on similar topics, their consolidation will have an immediate impact on Google's overall quality perception.
  • Then — Pages to improve to gain position: Pages between position 8 and 20 with good impressions. A targeted improvement can push them to the top 5.

5. Execute and Measure

An audit without execution is useless. Organize your action plan in 2-week sprints and document each change.

The golden rules of execution:

  • Never delete more than 10% of your pages at once. Sudden mass deletions can disrupt Googlebot and generate a temporary traffic drop even on pages you're keeping.
  • Wait 3 months before judging the impact. Google can take 4 to 12 weeks to re-crawl and re-evaluate modified pages.
  • Record the date of each intervention in your spreadsheet. This is essential for correlating traffic changes with your actions.
  • Submit modified URLs as a priority in GSC via the "URL Inspection > Request indexing" tool.

The alternative to the manual method

The manual method described here is rigorous but time-consuming. On a site with 200+ articles, it mobilizes several weeks of qualified work. To understand exactly what an automated tool does compared to this approach, check our EEATClean vs manual audit comparison — you can decide which method suits your situation.

To deepen the topic of content deletion and reorientation, also read our guide how to improve your E-E-A-T score — content audit decisions and E-E-A-T signals are intimately linked.


Summary: the 5 steps of a manual content audit

Step Action Estimated duration
1URL inventory (GSC + Sitemap + Crawl)2 to 4 hours
2Build the grid (merge data)3 to 6 hours
3Analyze and categorize each pageLongest — 1 to 3 weeks
4Prioritize action plan2 to 4 hours
5Execute in sprints + measure resultsOngoing (min. 3 months)

Tools and resources for your audit

  • Google Search Console: search.google.com/search-console — Export performance and indexed pages.
  • Screaming Frog SEO Spider: screamingfrog.co.uk — Complete crawl and metadata export.
  • Ahrefs / Semrush: For inbound backlink data — essential before any deletion decision.
  • Google Sheets: The spreadsheet remains the central tool of the manual audit. Use conditional filters and colors to visualize your categorizations.

Your site has more than 100 articles?

Manual auditing quickly becomes unmanageable. EEATClean automatically analyzes all your content, identifies at-risk pages and generates a prioritized action plan in minutes.

Run my free audit
Ahmed EL JAOUARI

Ahmed EL JAOUARI

Information Systems Engineer & Founder of FunInformatique

Information systems engineer and founder of FunInformatique, a leading technology media outlet with over one million monthly readers. With more than 15 years of experience in web publishing and application development, Ahmed combines technical rigor with high-level content strategy. He designed EEATClean to give publishers a surgical analysis framework to transform their content into durable authority assets that meet Google's quality requirements.

Find him on LinkedIn or follow his projects on the Google Play Store.

We'd love your feedback

Contact Us

A question? Leave us a message.