Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthSEO & Organic SearchWebsite Content Audit

SpreadsheetSEO & Organic SearchFree

Website Content Audit

Inventory every page with traffic, conversions, age and quality score, and get a keep, update, merge or delete recommendation.

Shown with sample data

Colour

Website Content Audit

Inventory every page with traffic, conversions, age and quality score, and get a keep, update, merge or delete recommendation.

Pages audited
10
Pages to update
5
Pages to merge or delete
3
Traffic share of top page
53%
Organic sessions (12 mo) over time
May 10, 2026Feb 1, 2024

Latest: 600

How to use it

  1. 1Export your page list and 12-month organic sessions and conversions from your analytics tool.
  2. 2Add backlinks from your SEO tool and score each page’s quality from 1 (poor) to 5 (excellent).
  3. 3Adjust the traffic and age thresholds on the Settings sheet to suit your site.
  4. 4Review each recommendation; record your final decision and owner in the last columns.
  5. 5Redirect deleted or merged URLs (301) to the most relevant page so links and traffic are not lost.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Most sites have a few pages doing all the work and many quietly dragging quality down. List each URL with its type, last update, organic sessions, conversions, backlinks and a quick 1–5 quality score; the audit calculates content age and conversion rate and recommends Keep, Update, Merge or Delete using clear rules based on traffic, links, age and quality. The thresholds sit on a Settings sheet so you can tune them for the size of your site.

Who it’s for

  • Annual or half-yearly content clean-ups
  • Preparing for a site redesign or migration
  • Recovering from a traffic drop
  • Prioritising refreshes for an under-resourced content team

What’s included

  • Pages sheet: One row per URL with performance and a recommendation.
  • Settings sheet: Thresholds behind the recommendations.

How to use it

  1. 1Export your page list and 12-month organic sessions and conversions from your analytics tool.
  2. 2Add backlinks from your SEO tool and score each page’s quality from 1 (poor) to 5 (excellent).
  3. 3Adjust the traffic and age thresholds on the Settings sheet to suit your site.
  4. 4Review each recommendation; record your final decision and owner in the last columns.
  5. 5Redirect deleted or merged URLs (301) to the most relevant page so links and traffic are not lost.

Tips

  • Never delete a page with backlinks or conversions without a redirect; the rules send those to Update or Merge instead.
  • Merge overlapping articles on the same topic into one stronger page rather than letting them compete.
  • Update first where traffic is falling but the topic is still in demand; refreshes often recover rankings fastest.
  • Use 12 months of data so seasonal pages are not judged on a quiet month.

Questions

What is a content audit?

A systematic review of every page on a site, using performance data and quality judgments, to decide what to keep, improve, combine or remove.

How do I decide whether to update, merge or delete content?

Keep pages that perform well and are current. Update pages that have traffic or links but are outdated or weak. Merge pages that overlap with stronger pages. Delete (and redirect) pages with no traffic, links or business value.

Does deleting content help SEO?

Removing or consolidating thin, outdated pages can help search engines focus on your best content, but it is not a shortcut. Redirect removed URLs that have links or traffic, and improve what remains.

Related searchescontent audit templatewebsite content audit spreadsheetseo content auditcontent inventorycontent pruningblog audit template

Details

Format
Spreadsheet
Category
SEO & Organic Search
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetSEO & Organic SearchFree

Website Content Audit

Inventory every page with traffic, conversions, age and quality score, and get a keep, update, merge or delete recommendation.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
SEO & Organic Search
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More seo & organic search templates

View all
SEO Keyword Tracker3 sheets

On page one

3

Estimated monthly clicks

830

Quick wins

4

Extra clicks available at position 3, by cluster
7,027
2,665
1,846
878
579
InvoicingBudgetingProjectsPlanningCash flow
SpreadsheetSEO & Organic Search

SEO Keyword Tracker

Target keywords with volume, difficulty, intent and target page, ranking movement, estimated monthly clicks, opportunity and quick wins, plus results by topic cluster.

10 min setupPreview
SEO Audit Checklist2 sheets

Audit score

45%

Fixes needed

6

Quick wins

2

ABCD
1CategoryCheckResultWhat we found
2TechnicalSite loads over HTTPS with no mixed contentPass
3TechnicalXML sitemap submitted and free of errorsFix14 URLs return 404
4TechnicalCore Web Vitals pass on mobileFixLCP 4.1s on product pages
5TechnicalNo important pages blocked by robots.txt or noindexPass
Audit
SpreadsheetSEO & Organic Search

SEO Audit Checklist

Sixty-minute site audit: technical, on-page, content and links, scored with fixes ranked by impact.

10 min setupPreview
Backlink Outreach Tracker2 sheets

Prospects contacted

6

Links won

3

Win rate

50%

ABCD
1SiteAuthority scoreTypeTarget page
2outdoorweekly.example62Guest post/guides/trail-hydration
3gearlist.example48Resource page/guides/packing-list
4hikingforum.example55Broken link/guides/trail-hydration
5citynews.example78Digital PR/research/water-survey
Prospects
SpreadsheetSEO & Organic Search

Backlink Outreach Tracker

Track link prospects from first email to live link, with reply rate and links won by tactic.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ