Search Console forgets after sixteen months. Keep your own copy.

Two things about the Search Console dashboard make it a bad memory.

It only holds sixteen months, rolling. And every number it shows you over a range is an average, so a page that sat at eleven for eighty days and jumped to four for ten of them reports as a nine and looks like nothing happened.

Both are fixable in an afternoon, and the fix is not a subscription.

What to store

One row per query per page per day. Six columns:

date | query | page | impressions | clicks | position

That is the whole schema. A small business generates a few thousand rows a month, which is nothing. Pull it on a daily schedule and never delete any of it.

Use the Search Console API rather than the export button. Manual exports get done twice and then stop, which is the failure mode this is meant to prevent. A service account, a scheduled job, no browser involved.

What it gives you that the dashboard cannot

• A before-picture. You rewrote a page on the ninth. Did it work? Only answerable if the ninth was recorded at the time.
• Movement instead of averages. The day a position changes is visible. In an averaged range it is invisible.
• New queries the day they appear, rather than whenever you next happen to scroll the report.
• History past sixteen months, which is roughly when a serious content programme starts having something interesting to say about itself.

What our first day said

Every page of ours that ranked for anything was a blog post. Not one service page — the pages that exist to sell something — was ranking for its own subject.

That had been true for months. It was visible in the dashboard the entire time, in the sense that the data was on the screen and nobody had ever sorted it that way. Putting it in a table where we could ask questions of it took ten minutes to answer a question we had not thought to ask.

The part that stings later

Nobody needs this data on the day they build it. You need it in March, when someone asks whether the work done in September moved anything, and the honest answer is that the evidence expired.

Start it before you need it. It is the same argument as verifying Search Console in the first place, one level up, and it has the same shape: the cheapest day was a year ago and the second cheapest is today.