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.
The catch is that most audits never get acted on. A few hours of exporting URLs and adding columns, then the spreadsheet sits in a shared drive while the team moves on to something more urgent. The audit happened. The decisions didn't. So this process is built around decisions, not documentation: every page ends up with an action, and the highest-impact actions happen the same week.
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. Short on time? The quick version near the end is a one-hour triage you can run instead.
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. I consolidate when three things are true: the pages target the same or very similar queries, none is ranking in the top 15, and together they would make a stronger piece than any does alone. Keep the URL with the most existing signals (backlinks, internal links, history) and fold the best of the others into it. That isn't deleting anything of value, it's concentrating 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:
- 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.
- 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.
- 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.
- 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.
For every page marked Improve, first ask one question: does this topic still matter to the audience you're trying to reach? If it doesn't, it belongs in Consolidate or Remove, not Improve. If it does, work through the same checklist every time:
- Intent match. Does the page answer what the searcher actually wants? Someone searching "content audit checklist" wants a checklist they can use, not an essay on audit theory.
- Introduction. Do the first 100 words earn attention, or does it take too long to get to the point?
- Freshness. Are any statistics, examples, or references clearly out of date? Updating them signals recency to Google and readers.
- Internal links. Does the page link to related content, and does related content link back to it?
- Title and meta description. Is the keyword there naturally? Does the description give someone a reason to click?
The fix is often less dramatic than you'd expect. A clearer H1, updated statistics, a tighter introduction, and a proper call to action can move a page from position 22 to position 8 within a few weeks. For a page with solid foundations, a focused update takes 30 to 45 minutes.
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.
The quick version: a one-hour triage
If you don't have time for the full audit, this is the lean sweep I run when I just need the quick wins. It covers your top 50 to 100 pages, not the whole site.
Pull just three things: organic clicks for the last 90 days, average position for each page's top queries (both from Search Console), and whether each page is indexed (Search Console's URL Inspection tool). Revenue, bounce rate, and heatmaps can wait. They don't change the first decision, which is simply whether a page is doing anything for you.
Then sort every page into one of three buckets:
- Working. Consistent organic clicks and ranking in positions 1 to 20 for relevant queries. Leave these alone for now.
- Struggling. Indexed and live, but getting little or no traffic: position 20 or worse, or no impressions at all. Most of the quick wins are here. Run them through the update checklist above.
- Dead weight. Not indexed, thin, or so far off-topic there's no plausible path to ranking. Consolidate or remove.
Pick the five most promising struggling pages and update them this week. That's the whole triage.
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
Digital marketing strategist working across SEO, paid media, analytics and website optimisation.
More about me