AdvancedLesson 24 of 305 min read

Content at Scale: Audit, Merge and Refresh

Review a growing site for decaying, thin and overlapping pages with a real program, and decide whether to update, merge or remove each one without losing visitors.

In this lesson you will

  • Run a content audit
  • Spot decay, thin pages and overlap
  • Choose update, merge or remove
  • Keep redirects and value when pruning

About 25 minutes

Two years of articles, and some are quietly dying

After two years of blogging Noor has dozens of pages. She keeps publishing new ones and never looks back. When she finally checks, some of her best older pages are losing visitors every month, two pages answer almost the same question, and a few are so short they say nothing. Publishing more is not always the answer. A content audit is a regular review of what you already have: what is growing, what is fading, what overlaps and what should go. At scale, it is one of the best uses of a marketer’s time. The free SEO course on this site covers the search side in depth, and this lesson focuses on the review habit.

What to look for

  • Decay. A page whose visits have fallen over several months. Causes include out-of-date information, newer competitors and changes in search results.
  • Thin pages. Very short pages with almost no visits. They may be better merged, expanded or removed.
  • Overlap. Two pages that target the same topic compete with each other. This is sometimes called cannibalisation. Merging them into one stronger page usually works better.
  • Winners. Pages that are growing. They show what your audience wants, so link to them and build around them.

Audit a small site with a program

The program below looks at five made-up pages. For each it works out the change in monthly visits over six months, flags a fall of a quarter or more as decaying, and flags a very short page with very few visits as thin. Then it compares the topic words of every pair of pages, using a simple overlap score between 0 and 1, and flags pairs with a score of half or more.

import numpy as np

# MADE-UP monthly visits for six months, words on the page, main topic words
pages = {"candle wick guide": ([420, 400, 380, 330, 300, 270], 1500, {"candle", "wick", "trim"}),
         "why candles tunnel": ([300, 310, 305, 320, 330, 340], 900, {"candle", "tunnel", "burn"}),
         "trim a wick": ([90, 85, 80, 70, 60, 50], 700, {"candle", "wick", "trim"}),
         "about our wax": ([12, 10, 9, 8, 7, 6], 180, {"wax", "soy"}),
         "gift ideas": ([150, 160, 170, 190, 210, 230], 1100, {"gift", "candle", "set"})}
months = np.arange(6)
for name, (v, words, topic) in pages.items():
    slope = np.polyfit(months, v, 1)[0]
    change = 100 * (v[-1] - v[0]) / v[0]
    flags = []
    if change <= -25:
        flags.append("decaying")
    if words < 300 and v[-1] < 20:
        flags.append("thin")
    print(f"{name[:18]}: {change:+.0f}%")
    print("   " + (", ".join(flags) or "healthy"))
def jaccard(a, b):
    return len(a & b) / len(a | b)
names = list(pages)
for i in range(len(names)):
    for j in range(i + 1, len(names)):
        j_ = jaccard(pages[names[i]][2], pages[names[j]][2])
        if j_ >= 0.5:
            print(f"overlap {j_:.2f}: {names[i][:16]} + {names[j][:16]}")
decay = [n for n, (v, w, t) in pages.items() if 100 * (v[-1] - v[0]) / v[0] <= -25]
print("pages losing a quarter or more:", len(decay))
candle wick guide: -36%
   decaying
why candles tunnel: +13%
   healthy
trim a wick: -44%
   decaying
about our wax: -50%
   decaying, thin
gift ideas: +53%
   healthy
overlap 1.00: candle wick guid + trim a wick
pages losing a quarter or more: 3

The ‘candle wick guide’ has lost 36 per cent of its visits, and ‘trim a wick’ has lost 44. ‘About our wax’ has lost 50 per cent and is thin as well. Meanwhile ‘why candles tunnel’ has grown +13 per cent and ‘gift ideas’ +53, so the audience’s attention is moving. In all, 3 pages lost a quarter or more of their visits. The overlap check found one pair with a score of 1.00: ‘candle wick guide’ and ‘trim a wick’ share all their topic words. These are two pages competing for the same searches, and both are decaying. The sensible move is to merge the useful parts of the weaker page into the stronger one, update it, and redirect the old address to the new one, so that visitors and links are not lost.

Decide, then act

Finding Usual action
Decaying, still useful Update and republish with fresh facts
Overlap Merge into one, redirect the other
Thin and unvisited Expand, merge or remove
Growing Link to it and extend it
  1. Export a list of pages with visits for the last six to twelve months.
  2. Flag the decaying, thin and overlapping ones.
  3. Choose one action per page and write it down.
  4. Do the updates first, then the merges, and redirects last, checking each.
  5. Repeat every quarter.
Common mistake: pruning in a hurry

Deleting without a plan. Removing a page that has links or visitors throws that value away. Redirect it to the best replacement, or keep it and improve it.

Check for seasons, and keep quality high

A fall in visits may be seasonal. Compare the same months in the previous year before deciding that a page is decaying. Be careful with AI-written content at scale: Google’s guidance warns against mass-producing pages to manipulate rankings, so write for people and check everything.

List your ten oldest pages with last month’s visits and the visits six months ago. Mark any that fell by a quarter or more, and any pair that cover the same question.

Practice for this lesson

Check what you learned

Five quick questions. Pick an answer and you will see straight away whether it is right and why.

What is a content audit?

  1. A new advert
  2. A page redesign only
  3. A regular review of what you already have
  4. A type of tool

It checks which pages grow, fade, overlap or should go.

What does overlap between two pages risk?

  1. They double traffic
  2. Nothing
  3. They become faster
  4. They compete for the same searches

Two pages on one topic split the value between them.

What should you do when you remove a page with links?

  1. Delete it and move on
  2. Redirect it to the best replacement
  3. Rename it
  4. Hide the links

Redirects keep visitors and link value.

Why compare with the same months last year?

  1. Months are random
  2. It is required
  3. A fall may be seasonal
  4. It avoids tools

Seasonal patterns can look like decay.

How many sample pages lost a quarter or more of their visits?

  1. Three
  2. One
  3. Five
  4. None

The wick guide, the trim page and the wax page.

Summary

  • A content audit reviews what you already have.
  • Look for decay, thin pages, overlap and winners.
  • Merge overlapping pages and redirect the old address.
  • Check for seasonal changes before judging decay.

Next lesson

Lesson 25 covers advanced search ads and bidding.

Questions

How often should I audit?

Quarterly is a good rhythm for an active site. Less often is fine for a small, steady one.

Is the overlap score a Google measure?

No. It is a simple teaching score from shared topic words. Real overlap also depends on what searchers want.

Are the pages real?

No. They are made-up sample pages to show the method.

Progress is saved in this browser.