Google Search Console for content strategy: find the gaps
Short answer Once a quarter, pull three lists from Search Console's Performance report. Pages losing clicks year over year get refreshed. Searches you show up for with no page built for them become new pages. Searches where two of your pages take turns showing get merged into one. Leave seasonal dips and everything else alone.
Want help applying this to your business? Talk it through on a free 30-minute call.
Book a callThree lists that turn Search Console into a content plan
Your content plan is three decisions: what to fix, what to add, and what to combine. Search Console, Google's free report on how your site shows up in search, answers all three from Google's own numbers.
| List | Where in Search Console | What it means | What to do |
|---|---|---|---|
| Losing clicks | Performance, Date, Compare last 3 months year over year, Pages tab, sort by clicks difference | A page that used to bring visitors is slipping | Refresh it |
| Searches with no page | Insights, trending up queries; or Queries tab, click a search, Pages tab | People find you for a topic you never wrote about | Build a page |
| Two pages, one search | Queries tab, click a search, Pages tab shows two or more of your pages | Your own pages compete and both rank weakly | Merge into one |
Everything else stays as it is.
How to spot decaying posts
A decaying post is one that brings fewer clicks than it did a year ago. Compare the same months, so a slow season doesn't fool you. Google's own steps for this:
"Choose the Date filter on top of the chart, select the Compare tab, and then Compare last 3 months to previous period or Compare last 3 months year over year." (Google Search Central: Debugging drops in Google Search traffic)
Open the Pages tab and sort by the clicks difference. The top of that list is your refresh queue. Before you touch a page, click it, open Queries, and see which searches fell. If every business's searches fell (check Google Trends), it's the market, not your page. Google says so plainly:
"This means your traffic may drop as a result of external influences." (Google Search Central: Debugging drops in Google Search traffic)
How to rewrite, merge or delete a slipping page is its own job: see update, merge or delete old pages.
The shortcut: the Insights report, built into Search Console since mid-2025, lists pages trending up and down. Google describes the down list as pages "that might need a refresh or further investigation" (Google Search Central Blog, June 30, 2025).
How to find new topics in your own searches
The best new topics are ones Google already links to you, with no page that truly answers them. Two places show them.
First, Insights. Google calls its trending up queries "a great source for new content ideas" (Google Search Central Blog, June 30, 2025).
Second, the Queries tab. For each search with steady impressions (times your site was shown) but few clicks, check which page Google used:
"Click a query in the table to filter all report data to the selected query. View the Pages tab to see which URLs were shown." (Search Console Help: Performance report, common tasks)
If Google shows your homepage or a general services page for "tankless water heater cost", that's a gap. A page built for that exact question has a better chance than a page that mentions it once. For picking which near misses to chase first, see keyword research with Search Console.
Only build what a customer would read. Google lists this as a warning sign:
"Are you producing lots of content on many different topics in hopes that some of it might perform well in search results?" (Google Search Central: Creating helpful, reliable, people-first content)
How to find pages to merge
Use the same click-a-search, open-Pages check. When two or more of your pages show for one search, and neither ranks well, they're splitting the job. Common case: a 2021 post "How much does a new roof cost?" and a 2024 post "Roof replacement cost guide".
Merging means one page gets the best of both, and the other sends visitors there with a permanent (301) redirect:
"The 301 and 308 status codes mean that a page has permanently moved to a new location." (Google Search Central: Redirects and Google Search)
Don't merge pages that serve different needs. A service page and a blog post can both show for "drain cleaning" and be fine: one sells, one explains. Merge only when a reader would see them as the same page twice.
What the data won't tell you
Search Console is free, and its limits are worth knowing before you plan on it:
- It keeps 16 months of data. To keep more, Google points to "the Search Analytics API or bulk data exports" (Debugging drops in Google Search traffic).
- "The maximum you can export through the Search Console user interface is 1,000 rows of data." (Google Search Central Blog: performance data deep dive). Enough for most small sites.
- Rare searches are hidden. Google calls them anonymized queries: those that "aren't issued by more than a few dozen users over a two-to-three month period" (same post). Your query rows won't add up to your total clicks.
- It shows only searches you already appear for. Topics you never touched need other tools: see refresh old posts or write new ones.
Also, two reports older guides still mention are gone: Mobile Usability retired in December 2023, and the International Targeting report was deprecated.
How often to review
Quarterly for the plan, monthly for a glance. A quarter gives a three-month comparison enough data to mean something on a small site. Changes take time: Google says "some changes can take effect in a few days, while others could take several months" (Debugging drops in Google Search traffic). Judge a refresh after a full quarter, not a week.
Example
A roofer with 40 blog posts (US dollars)
Year over year, six posts lost most of their clicks. Two were storm-season posts, down because last year had a big hail month: left alone. Two cost posts, "$8,000 to $12,000" from 2021, got current prices. Two roof-cost posts took turns showing for the same search, so they were merged with a 301.
A Toronto accounting practice (Canadian dollars)
Insights showed "rental income tax Ontario" trending up, with Google showing a general tax services page. The practice wrote one page on reporting rental income to the CRA. Three months later it had its own clicks for that search.
A dog groomer with 8 pages
Too little data for quarterly lists. Monthly, the groomer checks one thing: which searches show the homepage instead of a service page. Two became new pages: nail trims and puppy first grooms.
FAQ
Is Search Console free?
Yes: "a free service offered by Google" (Search Console Help: About Search Console). You verify you own the site first: see Search Console for a small business.
Do I need a paid SEO tool for content planning?
Not for your own site. Search Console has Google's real numbers for searches you appear in. Paid tools add estimates for other searches and competitors.
Should I change the publish date after a refresh?
Only if the content changed. Google warns against "changing the date of pages to make them seem fresh" without real changes (Creating helpful, reliable, people-first content).
Is it bad that two of my pages show for one search?
Only when both are weak and say the same thing. A service page and a how-to post on one subject can both earn their place.
Different for you?
- Traffic fell across the whole site at once, not page by page: search trends in Search Console shows whether it's the market.
- You need to choose between rewriting a post and starting a new one: refresh or new blog post.
- You found the slipping pages and want the update steps: update, merge or delete old pages.
- You'd rather have the reviews and page work done for you: SEO & GEO Agent.