WebGain All articles
SEO Strategy

Four Weeks, One Spreadsheet: The Refresh Sprint That Rescues Declining Pages

WebGain
Four Weeks, One Spreadsheet: The Refresh Sprint That Rescues Declining Pages

Photo: Survival ste, CC0, via Wikimedia Commons

Nobody sends you a notification when a blog post starts dying. It just quietly slips from position four to position nine, keeps pulling a few hundred visits a month from people who bounce in eleven seconds, and sits there looking fine in your CMS.

Meanwhile the content team — usually one person — keeps writing new posts, because new posts feel like progress. They're also the slowest possible way to recover traffic you already earned.

Here's a different plan. One month. One spreadsheet. No new content until the sprint is done.

Why old posts are worth more than new ones

A published URL that's been indexed for two years carries history: links, crawl priority, impressions, a tiny bit of trust. A brand-new post starts at zero and waits months to find out if it matters.

So the math is simple. Refreshing a page that already ranks on page two is usually cheaper than writing a new page and hoping. The only requirement is that you know which of your pages are actually slipping — which is a measurement problem, not a writing problem.

Week 1: Find the leakers

Open Search Console and pull a comparison of the last three months against the same three months a year ago, by page. Sort by impressions first, then by clicks. What you're hunting for:

Export the top 25 candidates into a spreadsheet. Add columns for last-updated date, word count, conversion rate if you can measure it, and a one-line note on what's visibly stale. That sheet becomes the whole project.

Week 2: Update the facts

This is the least glamorous week and the one that moves rankings fastest. Walk every post on the list and check the specifics:

While you're in there, add one genuinely new section to each post — a paragraph answering a question that shows up in your support inbox, or a short example from a recent customer. A refresh that adds nothing new is just a spellcheck.

Week 3: Consolidate and re-link

By now a few posts will look obviously weak: 400 words on a topic that a stronger sibling covers in 1,800. Don't pad them. Merge the good bits into the stronger page, redirect the weak URL, and move on.

Then do the internal link pass, which is where most sites leave easy money on the table. For each refreshed page:

Update your navigation or 'related posts' modules if they're pulling in the old URL. A redirect loop is a great way to waste week three.

Week 4: Re-promote and measure

You rewrote the thing. Now tell someone.

Then set a calendar reminder for 45 days out and compare the same metrics you pulled in week one. Not every page will move, and that's fine — but a page that lost 40 percent of its clicks and recovers half of that paid for the whole month.

The part people skip

A refresh sprint works because it's small. Twenty-five pages, four weeks, three hours a week. The temptation is to expand it into a site-wide audit that never ships, and then to abandon the spreadsheet entirely in favor of another new post nobody asked for.

One more thing worth doing: after the sprint, add a 'last reviewed' column to your content calendar and run a ten-page mini-sprint every quarter. Decay doesn't stop. It just gets more expensive the longer you let it run.

All Articles

Related Articles

Be the Source, Not the Result: How Small Sites Earn Citations in AI Answers

Be the Source, Not the Result: How Small Sites Earn Citations in AI Answers

Read the Fine Print Before You Build: How Much of Your Digital Life Do You Actually Own?

Read the Fine Print Before You Build: How Much of Your Digital Life Do You Actually Own?

Location, Location, Location: Your Domain Is the Only Piece of Internet Real Estate You'll Ever Own

Location, Location, Location: Your Domain Is the Only Piece of Internet Real Estate You'll Ever Own