How to Do a Content Audit (Prune, Update, Consolidate)

At some point a site stops being a handful of posts and becomes a pile. You have been publishing for a year or two, there are eighty or two hundred URLs, and somewhere in there are the pages that actually bring in traffic and the pages that just sit there. The problem is you can no longer tell which is which by feel. So you keep doing the one thing that feels like progress, which is publishing more, and the pile gets bigger and heavier and harder to steer.

A content audit is the opposite move. Instead of adding, you go through what you already have and make a decision about every page: keep it, improve it, merge it into something better, or delete it. It is unglamorous and it is one of the highest-return things you can do to an established site, because a lot of your traffic problem is not missing content. It is dead weight sitting on top of your winners.

Where does the money actually come from?#

The money does not come from having more pages. It comes from the specific pages that rank, get clicked, and convert a reader into a subscriber, a lead, or a sale. A content audit makes more of those pages by cutting the weight around them and pouring the freed-up effort into the ones with a real shot.

A big messy library
        |
        v
Cut dead pages + merge thin duplicates
        |
        v
Fewer, stronger pages competing for each topic
        |
        v
Winners rank higher and get found faster
        |
        v
More qualified visitors on pages that convert
        |
        v
Revenue

Here is the mechanism most people miss. Thin, abandoned, or duplicate pages are not neutral. They split your relevance across two weak pages when one strong page would rank better, they waste the internal links and attention that could point at your winners, and they make the whole site look lower quality to a search engine judging you on aggregate. Prune the dead weight and consolidate the duplicates, and the pages that matter climb. If you want the full picture of how ranking turns into revenue, how SEO makes money lays out the chain this fits inside.

How it actually works#

Start by getting everything in one place. Export a list of every URL on the site. Then pull a few numbers against each one so you are judging on evidence.

The numbers that matter for each page are simple. How many visits has it gotten over the last several months. Does it rank for any query, and roughly where. Does it earn anything, whether that is affiliate clicks, sales, or email signups. And when was it last touched. You do not need a fancy tool to start. Your analytics and a search-console export cover most of it, and a spreadsheet holds the rest.

Now sort every page into one of the four buckets.

Keep means the page pulls its weight. It ranks, gets traffic, stays accurate, and you would not change much. Leave it alone and move on. Most people waste audit time fiddling with pages that were already fine.

Improve means the page has a pulse but is underperforming. It ranks on page two, or it gets traffic but converts nobody, or it is outdated in a way that is costing it. This is your money bucket. Reviving a page that already has some authority is far cheaper than starting a new one, which is the whole point of updating old content for more traffic.

Merge means two or more pages are fighting over the same topic. When you have three thin posts all circling "email subject lines," they cannibalize each other and none of them wins. Combine them into one strong page, redirect the old URLs to it, and you concentrate the relevance and the links into a single contender.

Delete means the page helps nobody. No traffic, no rankings, no conversions, no strategic reason to exist, and no realistic path to any of those. Cutting it, or redirecting it somewhere relevant, removes weight. Do not keep a page alive out of sentiment for the hour you spent writing it.

Grouping pages by topic while you do this is what turns an audit into a structure. When you see all your related pages side by side, the duplicates and the gaps jump out, and you can shape them into proper clusters. Building a topic cluster step by step shows how the survivors should link together once the mess is cleared.

A clearly hypothetical example#

These numbers are invented to show the shape of a decision, not a promise of results. Yours will differ.

Say you have 120 pages. You pull the data and the picture looks something like this, purely for illustration:

Pages that get real traffic and convert:        18   -> KEEP
Pages with some traffic, page-2 rankings:       22   -> IMPROVE
Thin/duplicate pages fighting each other:        30   -> MERGE into ~10
Zero traffic, zero rankings, zero purpose:       50   -> DELETE or redirect

After the audit you have roughly 50 pages instead of 120. That feels like a loss until you look at what happened. The 30 duplicate pages became 10 stronger ones, each now the single best page on its topic instead of one of three weak ones. The 50 dead pages stopped diluting the site and stopped soaking up internal links that now point at real content. And the 22 improvement pages got your attention instead of being lost in the noise.

The site did not get smaller in any way that matters. It got denser. Every remaining page has a job, and the ones with a shot at ranking are no longer buried. That is the trade you are making: fewer URLs, more of them actually working.

What you need (required vs optional)#

Required:

• A complete list of every URL on the site. A sitemap export or a crawl gets you this.
• Traffic data per page, from your analytics, over a long enough window to be meaningful (several months, not last week).
• Search performance per page: what ranks and roughly where. A search-console export covers it for free.
• A spreadsheet with one row per page and a column for your decision. This is the whole tool.

Optional but helpful:

• Conversion or revenue data per page, so you can tell a traffic page from a money page. They are not always the same.
• A crawler that flags orphan pages (nothing links to them) and thin pages, which speeds up the sorting.
• A record of which pages have backlinks, since a page with links pointing at it is worth improving or redirecting rather than plain deleting.

What it costs#

In money, close to nothing. Analytics and search console are free, and a spreadsheet is free. If you buy a crawler or an SEO tool it saves time on a large site, but it is optional for a first pass.

The real cost is time and honesty. Time, because going page by page on a big site is a slow afternoon or several. Honesty, because you have to be willing to delete things you were proud of and merge posts you thought were distinct. The discomfort of cutting your own work is the actual tax on an audit. Most people flinch at it, keep everything, and wonder why nothing improves.

There is one risk worth naming. Deleting or redirecting pages carelessly can cost you traffic you were getting without realizing it, or break links pointing at your site. That is why you look at the data first and redirect rather than hard-delete anything with existing traffic or backlinks.

How long it takes#

The audit itself is a project, not a habit. Pulling the data and sorting a site of a hundred or so pages is a few focused sessions. Acting on it, the actual improving and merging, is ongoing and can stretch over weeks because good rewrites take real work.

The results are not instant either. When you merge and redirect, rankings shuffle for a while before they settle, and improved pages take time to climb. Search does not move on your schedule, which is worth expecting up front. If you want a realistic sense of the timelines, how long SEO takes sets expectations that apply here too.

Do a full audit maybe once or twice a year on an active site. Doing it constantly is just procrastinating on publishing.

What beginners usually get wrong#

The first mistake is treating the audit as a chance to tweak everything. You do not need to touch your keep pages. Fiddling with pages that already work is motion, not progress, and it eats the hours you should spend on the improve bucket.

The second is refusing to delete. Every dead page feels like it might matter someday. It will not. A page with no traffic, no rankings, no conversions, and no plan is a liability, and keeping a hundred of them tells a search engine your site is mostly filler.

The third is deleting without redirecting. If a page has any backlinks or leftover traffic, hard-deleting it throws that value away. Redirect it to the most relevant surviving page instead, so the links and the visitors land somewhere useful.

The fourth is auditing content but ignoring the links between pages. After you prune and merge, your internal links are a mess: some point at deleted pages, others still point at the weak version of a merged page. Fixing those is half the value, and internal linking for SEO covers how to point them at your winners on purpose.

How I would start#

1. Export a full list of every URL on the site into a spreadsheet, one row per page.
2. Add columns for traffic, whether it ranks and roughly where, any conversions or revenue, and the date last updated. Fill them from analytics and search console.
3. Group the rows by topic so competing and duplicate pages sit next to each other.
4. Make one decision per page: keep, improve, merge, or delete. Force a choice on every row.
5. Handle deletes first: redirect anything with backlinks or leftover traffic to a relevant survivor, and remove the rest.
6. Handle merges next: combine the duplicates into one strong page and redirect the old URLs into it.
7. Work the improve list last and slowly, because those rewrites are where the traffic gains actually come from.
8. Fix internal links so they point at the surviving, strengthened pages, then note gaps you found for future content.

What I would not do#

I would not audit and then change nothing, which is the most common outcome and a pure waste of the afternoon. I would not keep dead pages out of attachment to the work. I would not hard-delete anything with existing traffic or links instead of redirecting it. I would not spend the whole audit polishing pages that were already fine. And I would not treat the audit as a substitute for ever publishing again. It is a cleanup pass that makes your future publishing land harder, not a replacement for it.

The bottom line#

An established site rarely underperforms because it needs more pages. It underperforms because the good pages are buried under abandoned ones and split across duplicates. A content audit fixes that with four decisions repeated across every URL: keep, improve, merge, delete. Cut the dead weight, consolidate the duplicates, and pour your effort into the pages with a real shot. The library gets leaner, your winners rank higher, and the traffic that arrives lands on pages that actually convert. When you are ready to work the improve pile, updating old content for more traffic is the natural next step.