Finding SEO opportunities in your stored GSC data

Stored GSC data is like a toolbox. Having it doesn't fix anything. Knowing which tool to reach for, and in what order, does.

Here are the five patterns I look for first when I sit down with a site's historical GSC data, in the order I actually check them.

1. Pages Google shows but nobody clicks

Filter for pages where impressions are above your site's median but CTR is below it. These are pages Google has already decided are relevant — the hard part is done. Users just aren't choosing them from the SERP.

This is the single highest-ROI pattern in SEO. You're not fighting for visibility; you're fighting for *selection*.

What usually fixes it:

• Rewrite the title tag to be more specific. "Widget Buying Guide" becomes "Widget Buying Guide: 7 Things to Check Before You Spend Over $200"
• Front-load the value. If the page answers a question, make that obvious in the first 60 characters
• Match the language people actually search. Look at the queries driving impressions — are those words in your title?

Don't rewrite the whole page. Start with the title. I've seen CTR double from a title change alone.

2. Queries sitting at positions 5–15

These are the ones that hurt. Impressions are decent, but clicks are weak because you're not on page one (or not high enough on it). The gap between position 8 and position 3 can be a 5x difference in clicks for the same query.

Find queries where:

• Monthly impressions are meaningful (say, 100+)
• Average position is between 5 and 15
• The trend over the last 90 days is stable or improving

These queries don't usually need a new page. They need the existing page to be *more* of what Google already thinks it is: better subheadings, more direct answers, internal links from related content, updated examples or data.

Also worth checking: is the page actually the best format for that query? A query like "how to fix a leaking faucet" might need a step-by-step guide with photos, not a 2,000-word essay.

3. Pages that used to work and are now fading

This one is personal. There's something uniquely frustrating about watching a page you know is good slowly lose ground.

Filter for pages where:

• The 90-day trend is down
• But 6–12 months ago, performance was solid
• The decline isn't sitewide — it's specific to this page or this topic

Usually the culprit is one of three things: the content got stale (outdated data, old examples), a competitor published something better, or search intent shifted (what people want when they search that query changed).

Before you rewrite: figure out which queries actually declined. Sort the page's queries by click change over 90 days. The top losers tell you exactly what to fix.

4. New pages with early momentum

Pages that went from zero to steady impressions in the last 60–90 days. The absolute numbers will look small — maybe 20–50 impressions a month. Don't ignore them.

These pages are in what I think of as the "prove it" phase. Google is testing them against queries. If they keep gaining impressions and query coverage over the next 2–3 months, they're probably going to be real contributors.

The move here isn't to overhaul them. It's to give them a small boost — better internal links, a more specific title, maybe an additional section covering a related sub-topic — and then watch what happens. Premature optimization kills more pages than neglect does.

5. Query families growing faster than the page can handle

Sometimes a topic gets hot, impressions spike across a cluster of related queries, but your page only covers the surface-level question. You're getting shown for queries you're not really answering.

Signs: impressions rising across a query group, but CTR staying flat or declining. The page is visible, but not satisfying.

The fix is usually adding a section, not a new page. Cover the sub-intent, answer the follow-up question, give the deeper comparison. Let one page serve the whole query family.

The order that actually works

When I have limited time (which is always), I go in this order:

1. High-impression, low-CTR pages — fastest fix, biggest immediate impact
2. Near-breakthrough queries (positions 5–15) — one push, outsized return
3. Declining pages with history — recover existing assets before building new ones
4. Early-momentum pages — small investment now, payback later
5. Expanding query families — content expansion for sustained growth

The order matters because #1 and #2 can deliver results in days or weeks. #3, #4, and #5 are longer plays. Do the fast stuff first, fund the longer work with the confidence that comes from quick wins.

The patterns are in your data — if you still have it. GSC Vault automatically backs up your Search Console performance data to Google Drive. Keep the history you need to spot these opportunities. Start your GSC backup →