← Back to BlogSEO

How to Do a Content Audit on Your Small Business Website

Most small business websites have a content problem hiding in plain sight. Not too little content. Too much of the wrong content, left to quietly drag down the pages that could be ranking.

A content audit is the process of reviewing every page on your site, assessing what it is doing for your organic traffic, and deciding whether to keep it, improve it, consolidate it, or remove it. Done properly, it is one of the highest-ROI activities in SEO. No new content required.

This guide walks you through exactly how to do it, using mostly free tools, in a single focused session. Download the free Content Audit Tracker spreadsheet to work through it alongside the guide.

What is a content audit and why does it matter?

A content audit is a systematic review of all the indexed pages on your website. You are assessing each page against one question: is this page helping or hurting my organic performance?

Pages that are thin, duplicated, outdated, or targeting the wrong keywords do not just fail to rank. They can actively suppress the rankings of your better pages by diluting your site's topical authority and splitting Google's attention across too many similar URLs.

For small business sites in particular, the problem compounds quickly. A service page from three years ago, a blog post that repeated the same keyword as your homepage, an FAQ that was never properly optimised. None of them look damaging individually. Together, they create a site that Google struggles to understand.

The data. In a study of over 1,000 websites, HubSpot found that removing or updating underperforming content produced measurable improvements in organic traffic within 30 to 60 days for the majority of sites. The fix was not more content. It was less, better content.


What you need before you start

You do not need expensive software to run a content audit. Here is what I recommend:

Free tools: Google Search Console (essential, no substitute), Google Analytics 4, and a spreadsheet. I have built a ready-to-use Content Audit Tracker you can download below.

Optional paid tools: Screaming Frog crawls your site and exports every URL in minutes. The free version handles up to 500 URLs, which covers most small business sites. Semrush or Ahrefs add keyword ranking data and organic traffic estimates at the page level.

If your site has fewer than 100 pages, you can do a thorough audit using only free tools. If you have more than that, Screaming Frog will save you significant time.

Free Content Audit Tracker. A pre-built spreadsheet with a URL list, performance columns, action dropdowns, and a summary dashboard. Ready to fill in. Download the template (.xlsx)


1. Export all your URLs

The first job is a complete list of every indexed page on your site.

Option 1: Google Search Console. Go to Search Console, open the Index Coverage report, and export the list of valid indexed URLs. This gives you every page Google has indexed.

Option 2: Screaming Frog. Enter your domain and run a crawl. Export the results filtered to HTML pages only. This will include pages that may not be in Search Console yet, and will also catch pages you may have forgotten about.

Option 3: Your sitemap. If you have an XML sitemap, open it in your browser (usually at yourdomain.com/sitemap.xml) and you will see every URL your CMS intends to serve.

Paste all URLs into column A of the Content Audit Tracker. The template has columns pre-built for page title, primary keyword, traffic data, and your action decision.


2. Pull your performance data

With your URL list in place, attach traffic data to each page so you can make evidence-based decisions rather than guesses.

From Google Search Console: Go to the Performance report, filter by page, and export. You will get clicks, impressions, CTR, and average position for each URL. This is your most valuable data set for SEO decision-making.

From Google Analytics 4: Pull page-level sessions and engagement data for the same period. Aim for at least 90 days of data. Seasonality can distort shorter windows.

Match this data to your URL list. You now have a picture of which pages are generating organic visits, which are getting impressions but no clicks, and which are invisible entirely.


3. Categorise every page

This is the core of the audit. For each URL, assign one of four categories. The Content Audit Tracker has a dropdown in column K for each of these.

Keep. The page is performing well, the content is current, and it is targeting the right keyword. Leave it alone except for minor updates.

Improve. The page has some organic visibility but is underperforming. It may be outdated, thin, or missing key sections. It stays, but it needs work.

Consolidate. Two or more pages target the same keyword. Merge the best content into one strong page and 301 redirect the others to it.

Remove. Zero organic traffic for 12 months or more, no backlinks, no useful content. Remove and redirect or return a 404.

Before you delete anything. Do not delete a URL without first checking whether it has any backlinks pointing to it. Check in Ahrefs or the GSC Links report. If it has external links, redirect it to the most relevant page rather than returning a 404.


4. Prioritise your improvements

You now have a categorised list. Work through it in this order:

  1. Consolidation opportunities first. These have the fastest and most measurable impact on rankings. Merging cannibalised pages often produces visible ranking improvements within four to six weeks.
  2. High-impression, low-click pages second. Google is already showing these in results, but searchers are not clicking. The problem is usually a weak title or meta description. Quick wins with potentially high upside.
  3. Improve pages with existing backlinks third. A page with external links pointing to it already carries authority. Improving the content can unlock rankings without needing to build new links.
  4. Remove decisions last. There is less urgency here. Work through your highest-value improvements first, then clean up the deadweight pages in a second pass.

If you want a faster, decision-first version of this triage, I break down the exact content audit process I use to find quick SEO wins, a lean sweep designed to surface the highest-impact changes in a single session.


5. Update your spreadsheet as you go

A content audit is not a one-off project. It is a record you maintain.

Once you have completed the initial audit, schedule a review every quarter. In each quarterly pass: add any new pages published since the last audit, update traffic data for the pages you improved to assess the impact, flag any pages that have dropped significantly in position, and check for new cannibalisation issues that may have crept in.

A live spreadsheet you return to every quarter is worth more than a polished one-time report you never look at again.


How long does a content audit take?

20 to 50 pages: a focused session of two to three hours should cover the full audit, including data collection, categorisation, and a prioritised action list.

50 to 150 pages: expect a half day, particularly if you are doing the data matching manually.

Over 150 pages: use Screaming Frog and Semrush to automate the data collection step. The categorisation still requires human judgement, but the setup time drops significantly.


Frequently asked questions

What is a content audit for a small business website?

A content audit is a systematic review of every page on your website. You assess each page's organic performance using data from Google Search Console and Analytics, then decide whether to keep it, improve it, consolidate it with similar pages, or remove it. The goal is to ensure every page on your site is contributing to your organic traffic rather than diluting it.

How often should a small business do a content audit?

A full content audit once per year is a reasonable baseline for most small business sites. If you publish content regularly, a lighter quarterly review keeps cannibalisation and underperforming pages in check before they compound. High-growth sites publishing multiple posts per week benefit from a monthly pass on new content.

Can I do a content audit without paid tools?

Yes. Google Search Console and Google Analytics 4 are free and provide the core data you need: which pages are indexed, how many clicks and impressions each page receives, and what keyword positions look like. Screaming Frog's free version crawls up to 500 URLs. For the majority of small business sites, this is sufficient. Paid tools like Semrush or Ahrefs add speed and depth but are not required to complete a thorough audit.

What is the difference between a content audit and a technical SEO audit?

A content audit focuses on the quality, relevance, and performance of your existing pages. A technical SEO audit focuses on the infrastructure: site speed, crawlability, indexing errors, structured data, and Core Web Vitals. They are complementary processes. A content audit without a technical audit may miss crawl issues that are suppressing good content. Many practitioners run both together.

What should I do with pages that have no traffic but are linked from my navigation?

Navigation links signal importance to Google. If a page is in your navigation but generating no organic traffic, ask whether it should be there at all. If it serves a genuine user purpose, improve the content rather than removing it. If it is genuinely redundant, remove it from the navigation and the index, and redirect the URL to the most relevant alternative.


The bottom line

A content audit will not give you new content. It will give you a clearer, stronger site that Google can actually understand and rank. For most small businesses, that is worth more than the next ten blog posts combined.

Start with Google Search Console, build your spreadsheet, and work through the four categories: keep, improve, consolidate, remove. The consolidation decisions alone will often move rankings within a few weeks.

If you find pages cannibalising each other during your audit, my guide on keyword cannibalisation walks you through the exact consolidation and redirect process.

Download the free Content Audit Tracker (.xlsx) and run your first audit this week.

Jayne Hamilton

Jayne Hamilton

Digital marketing strategist. Building at the intersection of AI, SEO, and real business growth.

More about Jayne