A monthly Search Console export you never have to remember

What is the sixteen-month window costing you?

A baseline.

Every serious question about search performance is comparative: is this query trending, did that page recover after the rewrite, has the branded share of impressions grown since launch. Answering any of them needs data older than the window.

Exporting monthly into a spreadsheet solves it and nobody does it, because it is fifteen minutes of clicking with no deadline attached. A routine does exactly that: same query, same dimensions, appended to the same sheet, on the first of the month. Two years later it is the most valuable file in the marketing folder.

Which Search Console work is worth handing over?

The tedious diffs.

Which queries gained impressions but lost position, which pages have a good click-through rate on page two, which URLs dropped out of the index this week. Each is a comparison that costs a person twenty minutes of filtering and produces five things to do.

Then a companion opens all five pages, reads what is actually on them, checks whether a competitor now ranks above you, and files the tickets. Reading the numbers is research; acting on them is marketing work, and doing both in one pass is the difference between a report and a change.

• Monthly export of query and page performance into a sheet you keep forever.
• Queries where position worsened while impressions grew, which is where content decay hides.
• Pages with impressions and a poor click-through rate, sorted by potential rather than by volume.
• Coverage and indexing changes, checked against what shipped that week.

Know what the numbers leave out

Search Console anonymises rare queries, so a long tail of terms is absent and totals in one report will not always reconcile with totals in another. A write-up worth trusting names the slice it is describing, and you can put that in the instruction once and get it every week.

Deciding what to do about a page that lost three positions stays with a person: rewrite, consolidate, or leave it. What the connection removes is the twenty minutes of filtering in front of that decision, every time. If the output is a content plan, content calendar updates is the neighbouring pattern.

Frequently asked questions