River
Y CombinatorBacked by Y Combinator
FREE TEMPLATE

Blog Post Refresh and Update Plan

Five documents and four sheets that decompose a traffic decline into its five signatures, then send the rewrite only to the pages a rewrite recovers.

Free download  ·  No account needed

Update Log, cycle 1

What the lost traffic was actually made of

61 of 214 pages declining over twelve weeks, measured against the same twelve weeks a year earlier. A fictional certification publisher, Kelbrook Learning.

SignatureClicks lostShareWhere it goes
Position decay12,90037%Rewrite. The only one that is
Presentation decay7,60022%Title and markup. An afternoon
Demand decay6,13017%Nothing recovers it
Coverage loss5,45016%One canonical, no writing
Substitution2,7808%Consolidate, do not rewrite
No signature400%Inside noise

A third of the loss is a writing job. The other two thirds route to three people who were never going to be asked, and one of those routes is a decision to do nothing and write down why.

The single biggest loser, 6,290 clicks on one guide, gained impressions and held position 3.1 to 3.4. Every click it lost went above the click. Ranked by traffic lost, it is the first page a writer opens.

Kelbrook Learning went into a refresh quarter with 61 declining posts and 34,900 lost clicks, ranked by traffic lost. The top row was a guide down 6,290 clicks, more than any other page on the site. Its impressions had gone up 2.1 per cent and its average position had moved from 3.1 to 3.4. Nothing about that page had got worse. The results page around it had changed, its click-through rate had fallen from 7.9 to 2.6 per cent, and two days of rewriting would have touched a body that nobody had stopped reaching.

That is arithmetic rather than bad luck. Search Console defines click-through rate as clicks divided by impressions, so a click figure is impressions multiplied by click-through rate by construction, and those two factors answer to completely different causes. Rank two hundred posts by clicks lost and the sort has already discarded the diagnosis. Decompose it instead, add average position as the third reading, and five signatures separate cleanly. One of them is a rewrite. The other four are a title, a canonical, a redirect and a decision.

So this pack builds the register with the decomposition in it, assigns a signature to every declining page, and routes. It handles the two traps that make a naive sort actively wrong, then measures the result against a control set of untouched pages so the number survives being questioned. It installs into the marketing workspace, beside the content brief pack, the editorial calendar pack that schedules what the queue produces, the content inventory and pruning pack and the rest of the template library.

The decomposition, the queue it produces, and the result against a control

One row per declining page with both windows side by side, the queue ordered by recoverable clicks, and the eight-week result measured against untouched pages in the same clusters.

Decay Register

Twelve weeks against the same twelve weeks a year earlier. Both windows on every row, before any verdict.

PageClicksImpressionsCTRPositionSignature
/pmp-exam-eligibility9,410 to 3,120118.9k to 121.4k7.9% to 2.6%3.1 to 3.4Presentation
/scrum-master-salary6,840 to 2,01084.3k to 31.7k8.1% to 6.3%4.2 to 9.6Position
/remote-work-stats5,220 to 1,14074.6k to 16.9k7.0% to 6.7%4.4 to 4.6Demand
/prince2-vs-pmp4,470 to 052.1k to 08.6% to 0.0%6.2 to 0.0Coverage
/how-to-pass-capm3,980 to 1,66047.3k to 21.2k8.4% to 7.8%5.8 to 11.3Substitution
/pm-interview-questions2,960 to 94088.4k to 19.3k3.3% to 4.9%8.6 to 6.9Position
/capm-vs-pmp1,520 to 47018.9k to 5.1k8.0% to 9.2%7.2 to 5.4Position
/kanban-board-setup1,310 to 1,29016.8k to 16.4k7.8% to 7.9%4.6 to 4.7No signature

The last two green position columns are the decay, not the comfort. A link must get an impression for its position to be recorded, so a page that stops appearing for its weaker queries stops averaging them in. Both pages held their head terms, lost roughly forty long-tail variants each, and improved on the survivors while losing two thirds of their clicks.

Row four exported at position 0.0 because a dash exports as a zero, so it sorted to the top of the file above every live page. Its canonical had moved to a sibling in January. The page was serving normally the whole time.

Refresh Queue

Position decay only, ordered by recoverable clicks rather than by clicks lost.

#PageLostRecoverableQueries lostDemandProtect
1/scrum-master-salary4,8304,40031FlatCertification section, position 4
2/pm-interview-questions2,0201,85038FlatTop 20 general questions
3/pmp-application-audit2,1201,40014Down 11%Eligibility summary
4/agile-estimation76070019Up 8%Story points intro
5/risk-register-template48043012FlatDownload and worked example
7/capm-vs-pmp1,05038027Down 34%Eligibility comparison table
out/pmp-exam-eligibility6,29000n/aRerouted: presentation decay
out/remote-work-stats4,08000Down 61%Rerouted: no demand to recover

The two largest losses on the site are not in the queue. Ranking by clicks lost puts them first and second; ranking by what a rewrite can recover takes them out entirely. Between them they are 10,370 clicks and zero days of writing.

Every queue row carries the queries it stopped ranking for. Those are the specification, and the held sections are named so the rewrite does not delete the paragraph that was still working.

Before and After Performance

Eight weeks after the edits against the eight weeks before, measured against eleven untouched pages in the same clusters.

PageBeforeAfterChangeNet of controlCame back through
/scrum-master-salary1,2402,980+140.3%+126.2 ptsImpressions, CTR held
/pm-interview-questions5801,190+105.2%+91.1 ptsImpressions, CTR held
/agile-estimation8901,190+33.7%+19.6 ptsImpressions, CTR held
/risk-register-template9801,140+16.3%+2.2 ptsImpressions, CTR held
/pmp-application-audit810705-13.0%-27.1 ptsNothing. Impressions fell further
Refresh batch4,5007,205+60.1%+46.0 ptsImpressions
Control, 11 pages9,44010,770+14.1%baselinen/a
Title batch, 2 pages3,3406,700+100.6%+86.5 ptsCTR, impressions flat

Without the control this batch grew sixty per cent. A quarter of that was the site rising underneath it. Saying so is what makes the other forty-six points believable, and one page in five went backwards against a rising site.

The title batch was two pages and an afternoon and it netted 2,890 clicks against the five-page rewrite's 2,070. The top row of the clicks-lost list was the right page to work on and the wrong work to do.

What's in the pack

01

Decay Register

One row per declining page carrying clicks, impressions, click-through rate and average position for both windows side by side, before it carries any verdict, plus the two flags that stop a sort being wrong.

02

Decay Signatures

The five shapes a decline takes, what each one means, how to confirm it, and the route it goes to. Position decay is the rewrite. Presentation, demand, coverage and substitution are four other people's jobs.

03

Reading the Performance Data

Six things Google's performance report reference says about its own metrics that change what a register means, including why a link needs an impression for its position to be recorded and why an exported dash arrives as position 0.0.

04

Refresh Queue

The position-decay rows only, ordered by recoverable clicks rather than clicks lost, each carrying the queries the page stopped ranking for and the sections that are still working and must not be touched.

05

Control Set and Before and After Performance

Untouched pages in the same clusters, matched on pre-period clicks and chosen when the register is built rather than after the results are in, then the eight-week movement of both sets side by side.

06

Date and Markup Handling

What Google actually documents about byline dates, which is that they are its own estimate from several factors rather than a field anybody sets, and the one remedy it gives for a date that stays wrong.

07

Refresh Method and Update Log

How to turn a query diff into a specification, and a full worked cycle. The register, the routes, the edits, and the page that went backwards reported at the same size as the one that doubled.

How to use it

  1. 1

    Open in River, or take it blank

    Open the pack in River and send your performance history, or download the Word documents and CSV sheets and fill them in yourself.

  2. 2

    Send pages and queries

    Search performance by page and by query over the longest window you can pull, ideally past twelve months so the same weeks compare year on year, plus the articles or a content export.

  3. 3

    Read the signature split first

    The share of your lost clicks a rewrite can actually recover, and the largest single loss beside the work its signature calls for. Those two usually disagree, and that is the finding.

  4. 4

    Refresh, then measure against the control

    Body work on the queue, titles on a separate batch so the result attributes. Eight weeks later, both sets measured together, including the pages that fell.

Frequently asked questions

Is this template free?

Yes. The download is Word documents and CSV sheets, no account and no card. Edit with AI is the optional half: the agent runs your own performance history through the decomposition and fills the register. Every pack sits in the template library.

Why not just rank pages by traffic lost?

Because clicks are impressions multiplied by click-through rate, so that ranking is sorted by a number that already threw away the diagnosis. In the worked cycle the top two losers, 10,370 clicks between them, are a title job and a page nobody searches for any more.

Our top page's average position went up while traffic fell. What is that?

Decay, and the most reliable early signal there is. A link must get an impression for its position to be recorded, so a page that slips out of sight for its weaker queries stops averaging them in and the score improves across the survivors. The register flags every instance.

Does changing the published date help?

Not on its own. Google's byline date guidance describes the date shown in results as its own estimate drawn from several factors, so there is no field that sets it. Set the modified date because the page changed, and stop there.

A refreshed page still shows the old date in search results. What now?

Cut the other dates the template prints. Once the visible date and the structured value agree, Google's documented remedy for an incorrect date being selected is removing some or all of the other dates on the page: comment timestamps, related-post bylines, the sidebar of recent articles.

Why does the pack insist on a control set?

Because a batch that grows eleven per cent while the untouched pages in the same clusters grow fourteen has cost you three points, and no before-and-after on its own will ever say so. The control is chosen when the register is built, never after the results arrive.

How far back should the comparison window go?

Past twelve months, so the same weeks compare year on year instead of against last quarter. The performance report holds sixteen months, which is exactly one such comparison. Anything longer needs the API or a bulk export, and a refresh programme starts one on day one.

Find out which third of your decline is a rewrite

Take the Word documents and CSV sheets blank, or open this exact pack in River and send it the search performance history you already have.

Edit with AI