How to find blog topic ideas from Search Console data

7 min read·30 September 2026

Most small business blogs don't run short of topics because there's nothing to write about. They run short because nobody has time to guess what people want. The quickest place to find blog topic ideas is Google Search Console. It already lists the searches that showed your site to someone, and many of those searches don't have a page built for them yet. In an afternoon, you can turn that list into a shortlist of posts people are already searching for.

This guide covers the workflow we use: set up the report, pull five kinds of topic from it, decide between a new post and an update, and know where the data runs out.

Set up the Performance report so the ideas show up

Open Search Console, go to Performance, then Search results. A few settings make the query list far more useful for topic research.

• Date range: pick the longest range available. Seasonal topics and one-off questions only turn up over a long window.
• Metrics: tick Impressions and Average position as well as clicks. An impression means your page appeared in someone's results, whether or not they clicked. Average position is roughly where you showed up, with 1 at the top.
• Branded filter: add a Query filter and choose Non-branded. Searches for your business name tell you nothing about new topics. Google's help page explains that branded traffic often comes from people already familiar with your site, while non-branded traffic can indicate new audience growth. The filter isn't available for sub-properties such as a /blog/ folder or for sites with low impressions, so skip this step if you don't see it.
• Queries tab, sorted by impressions: clicks show what's already working. Impressions show demand you're only half meeting.

Then export the table to Google Sheets with the Export button. You'll want to sort and tag rows, which is quicker in a spreadsheet.

Five places to find blog topic ideas from Search Console

1. Queries your site shows for without a matching page

This is the richest seam. Click any high-impression query, then open the Pages tab to see which URLs Google showed for it.

If the page is your homepage, a service page, or a post that only mentions the topic in passing, you've found a gap. Google thinks you're vaguely relevant, but you haven't written the page that answers the search.

Say you run a joinery firm in Leeds (a hypothetical). Your "fitted wardrobes" service page shows for "how much do fitted wardrobes cost uk" at position 38. That query wants a price guide, not a sales page. That's a post.

2. Question queries

Questions tend to make good blog posts because the search itself tells you the headline. In the Query filter, choose Custom (regex). Regex, short for regular expression, is a way of matching text patterns rather than exact words. Paste this:

^(how|what|why|when|where|which|who|can|does|do|is|are|should|will)\b

That shows every query starting with a question word. Query filtering isn't case-sensitive, so you don't need capital letters in the pattern.

3. Long, specific queries

Longer searches usually come from people who know exactly what they want, and they often slip past the big sites. This pattern matches queries of five words or more:

^(\S+\s+){4,}\S+$

Read down the list and group queries that ask the same thing in different words. Five variations on "can I paint over oak kitchen cabinets" are one post, not five.

4. Modifier queries

Some words signal a specific kind of post. Try filtering for them one at a time, or together:

(cost|price|vs|versus|best|cheap|template|checklist|example|near me|grant|regulations)

Each one points to a format. "Cost" and "price" want a price guide. "Vs" wants a comparison. "Checklist" and "template" want something people can use. "Regulations" wants a plain explainer with links to the official source.

5. The queries around your best page

Switch to the Pages tab, click your strongest blog post, then go back to Queries. You'll see everything that post ranks for.

Most of those queries will match the post. A few will be neighbouring topics the post only touches on. Those are the natural next posts in a topic cluster: a group of posts on one subject that link to each other, so both readers and Google can see you cover it properly.

If your site gets a lot of search traffic, Search Console Insights now offers Query groups, which groups similar search queries together so you can quickly see the main topics your audience searches for. It's only available to properties with a large volume of queries, so most small business sites won't see it yet. The regex filters above do the same job by hand.

A bonus: queries that are rising

Use the Compare option in the date picker, for example the last three months against the three before, and sort by the difference column. Google's help page suggests this to see queries or pages with significant change from a previous period. A query that's climbing for you may be climbing for everyone.

New post or update to an existing one?

Not every query deserves a new post. Writing a second page on a topic you already cover can split Google's attention between two of your own pages, and neither does as well. SEOs call this cannibalisation.

Use the Pages tab check from step 1 and sort each query into one of three piles:

1. The right page already ranks, somewhere around positions 4 to 20. Improve that page instead. We cover how in our guide to striking distance keywords in Search Console.
2. The wrong page ranks, such as a service page for an informational question, or a post on a different subject. Write a new post and link to it from the page that's currently showing.
3. Nothing ranks well, but the query fits what you sell. Write a new post, and expect it to take longer to get going.

A simple test: if the best answer to the query would be a new H2 section in an existing post, update. If it would need its own title, write a new post.

Turn the list into a shortlist

By now your spreadsheet probably has dozens of candidate queries. Add four columns:

• Topic: group near-duplicate queries under one working title.
• Decision: new post, update, or skip.
• Fit: would a reader of this post plausibly become a customer? Score 1 to 3.
• Demand: total impressions for the group.

Sort by fit first, then demand. A post on a question your ideal customer asks will earn more for a small business than a popular question from people who'll never buy from you. Pick the top five or six and put them in the calendar. That's two or three months of posts if you publish every other week.

What Search Console can't tell you

Search Console is a record of searches where you already appeared. That makes it the best source of ideas you have a realistic chance with, and a poor source of everything else.

• It hides a large share of queries. Google omits some searches to protect user privacy, and these anonymised queries are left out of the table entirely. They're also dropped from totals as soon as you apply a query filter, so your regex views will look smaller than your overall numbers. Ahrefs' study of Search Console data found anonymised queries made up 46.77% of website traffic in April 2025. Rare, very specific searches tend to be the ones hidden.
• It doesn't show every row. Google says Search Console stores and shows only the most important data rows. The fuller list is only available through Search Console's bulk data export, which is more setup than most small sites need.
• It shows nothing you don't already rank for. If you've never written about a subject, Search Console won't suggest it. A true content gap analysis, meaning a comparison of what you cover against what searchers want, also needs outside sources: Google's autocomplete and "People also ask" boxes, competitor blogs, and above all the questions customers ask you on the phone.
• Impressions aren't search volume. A query with 40 impressions at position 60 may have far more demand than that, because few people scroll that far.

So treat the report as a list of leads, not a verdict. It tells you where Google already connects you with a topic. You still need to judge whether you can write the best answer on the web.

Do this once a month

Topic research from Search Console isn't a one-off job. New queries turn up as your site grows and as people search in new ways. Once a month, re-run the question and modifier filters, compare the last 28 days with the period before, and add anything new to the sheet. It's a short job once the regex patterns are saved in a notes file.

The best blog topics usually aren't clever ideas. They're searches Google already shows you for, without a page that properly answers them. Your next step: open Search Console, apply the question-word regex above to the last few months of non-branded data, and write down the first three queries where the page Google shows isn't the page the searcher wants.

Researched and drafted with Blog AI, checked against its sources, and edited before publishing. How the checks work