Content Audit Spreadsheet

Most sites have more content than they can maintain well. A content audit forces a decision on every existing page: is this earning its keep, or is it diluting the site? This spreadsheet makes that decision systematic.

The main tab imports a URL list from your sitemap or a crawl export. For each URL, you record: monthly organic sessions (from Google Analytics), ranking keywords and top position (from Google Search Console or Ahrefs), number of backlinks, publication date, last updated date, word count, and a manual quality score (1–5) based on accuracy, depth, and relevance.

A decision column at the end of each row uses a simple scoring formula to suggest an action — Keep (performing well), Update (traffic but outdated or thin), Consolidate (multiple similar pages), or Remove (no traffic, no backlinks, low quality). The formula is editable, and there's a manual override column for editorial judgment.

A summary tab shows the audit totals: how many pages fall into each action category, estimated organic traffic impact, and total word count by action. This helps you prioritise what to work on first and communicate the audit findings to stakeholders without building a separate slide.