Mining Google Search Console for Keyword Ideas
Google Search Console is the best free keyword source you have, because it lists the real queries your pages appeared for. Filter for queries with many impressions and a position between 8 and 30, and you will find posts that are close to ranking well and topics you never planned.
You need a verified site and a few weeks of data. Once you have that, here is how to turn the report into a to-do list.
Where to find the data
In Search Console, open the Performance report for search results. By default it shows total clicks, impressions, click-through rate, and average position for the last few months.
Click the Queries tab beneath the chart to see individual search phrases. Turn on all four metrics so the table shows each one. You can change the date range, and a longer range gives more stable data.
You can also click a page in the Pages tab and then switch to Queries, which shows only the queries for that page. That is how you see what a single post is really being found for.
Note that Google hides a small share of rare queries for privacy, so the list is not complete. It is still the closest thing to ground truth.
Find near-miss keywords
Sort the Queries table by impressions and scan for rows with a low average position, such as page two or three, but a decent number of impressions. These are searches where Google already considers your page relevant and shows it, just not near the top.
Pages in positions 8 to 20 often respond to focused improvements. You might add a section that answers the query directly, tighten the heading, or expand a thin explanation. Moving from page two to page one can change traffic noticeably, though results vary.
Write down the query, the page, and the current position. These become your update list.
Discover queries you never targeted
Look for rows where the query differs from the page’s main topic. A post about watering tomatoes might appear for “why are my tomato leaves curling,” a question you did not address in detail.
Each of these is a content gap. Either extend the existing post with a section that answers the new question, or write a dedicated post if the question is big enough to stand alone.
A rule of thumb: if the extra query could be answered in a few paragraphs and fits the same reader, add a section. If it needs its own explanation and would pull the page off topic, make a new post and link to it.
Spot pages with a click-through problem
Compare impressions with clicks. If a query has many impressions and a very low click rate, even at a good position, your title or snippet may not be persuasive.
Look at how your listing appears in the results and compare it with the neighbors. Is the title clear and specific? Does it promise what the searcher wants? Rewriting a title is cheap, and it can raise clicks without changing the position.
Click-through rates naturally drop with position, so judge each row against others at a similar position, not against a single standard.
Group the queries into topics
Export the table to a spreadsheet. Add a column called “topic” and label each row with the subject it belongs to. After a few dozen rows, you will see clusters.
A large cluster of queries around one subject tells you the topic is working for you and deserves more coverage. A cluster you did not expect might point to a direction worth following.
This also helps you avoid writing duplicates. If a cluster already points at one page, extend that page instead of starting a new one.
Check for cannibalization
Sometimes two of your pages appear for the same query, and the ranking flips between them. In the Queries tab, click a query, then switch to Pages to see which pages are showing.
If two posts compete for the same search, consider merging them or making their focus more distinct. A single strong page usually does better than two weaker ones.
Make it a monthly habit
Set a monthly reminder. Export the last 28 days, compare with the prior month, and update your spreadsheet. Note any new queries and any that lost position.
Keep the process short. Fifteen minutes with a clear list of actions is better than a long review that produces no changes.
Handle the new-site problem
If your site is only a few weeks old, the report may show a handful of queries and very few impressions. That is normal. Search engines need time to crawl, index, and test new pages before they show them widely.
In this period, keep publishing and keep your keyword plan based on autocomplete and the results pages. Check Search Console once a week for signs that pages are being indexed, using the page indexing report, and fix any errors it flags.
Do not draw conclusions from a few clicks. A query with three impressions tells you very little, so wait until you have a larger sample before changing a page based on it.
A small note on seasonal topics
Some queries rise and fall through the year. If you notice impressions climbing for a seasonal subject, update the relevant post a month or two before the peak. Pages need time to be recrawled, so the earlier you improve them, the better prepared they are when searches rise.
What to do next
Open the Performance report today and set the date range to the last three months. Sort queries by impressions, then mark every row with a position between 8 and 30. Pick three that match pages you can improve in an hour each.
For each, open the page, add or expand a section that answers the query directly, and adjust the heading if needed. Record the date of the change and the starting position, so you can check the effect a few weeks later.