A repeatable, search-led process using Search Console, Keyword Planner and AI to prioritize B2B content and boost CTR
Join developers getting comprehensive guides, code examples, optimization tips, and time-saving prompts to accelerate their development workflow.
No spam. Unsubscribe anytime.
If your content backlog is full of good ideas and your team still can't agree on what to publish next, the fix is a prioritization system, not another brainstorm. This guide walks through a workflow that starts from Google Search Console and Keyword Planner data instead of opinion: how to find pages that are already getting impressions but losing clicks, how to use AI to process hundreds of queries into a real publishing plan, how to match the right format to each opportunity, and how to run this as a repeatable monthly process instead of a one-off audit.
I built this workflow running SEO audits and content clustering for established B2B clients, where the challenge was never a shortage of topics. Sales had a list of recurring questions, product teams wanted to explain technical differences, leadership had strategic themes to push, and marketing had a spreadsheet of keywords and half-finished drafts. What was missing was a defensible way to decide what to write first. That's what this workflow solves.
Ask a sales or technical team at a decades-old B2B company to list content topics, and you'll get a year's worth of ideas inside one workshop. They know the recurring customer questions, the technical constraints, the purchasing risks, and the misconceptions that trip up less experienced buyers.
Ideas at that volume need a filter, because they carry very different amounts of value. Some questions come up constantly in sales calls but attract almost no search volume. Some keywords pull large audiences that have nothing to do with your actual buyers. Some topics are commercially important but so competitive that a single new article won't move the needle without a lot of supporting content behind it. Meanwhile, some of the biggest opportunities are already sitting on your own website: a page pulling thousands of impressions, ranked near the bottom of page one, converting almost none of that visibility into clicks.
Without a structured filter, content planning turns into a negotiation. The most senior person in the room picks the topic, marketing chases whatever trend is current, a competitor publishes something and gets copied, or an agency hands over a keyword spreadsheet nobody knows how to turn into a schedule. The output is a calendar full of reasonable ideas with no real order behind it.
Replacing "what should we write about" with "where is demand already proven and where is our site failing to capture it" turns content planning into a commercial investigation with evidence behind every decision.
Your website is probably already appearing for hundreds or thousands of relevant queries, whether people click through or not. Google Search Console shows exactly that: for any page, how many times it appeared in results, how many clicks it got, the click-through rate, the average position, the specific queries tied to it, and how all of that has moved over time.
That's demand attached to assets you already control. Google has already connected parts of your site to specific subjects, so the real question becomes whether those pages satisfy the searcher well enough to earn stronger visibility and more clicks. For a mid-market B2B company, improving a page that already has impressions is a more predictable move than publishing something new and waiting to find out whether Google decides it deserves to rank.
No single number tells you where to focus. A genuine opportunity shows up through a combination of four signals working together.
Impressions tell you how often a page or query showed up in search results, which signals that Google already sees a connection between the search and your content. A page can rack up thousands of impressions and still convert almost none of them into visits, and that gap is frequently where the real opportunity sits.
Take a technical product page pulling 12,000 impressions, 24 clicks, a 0.2 percent click-through rate, and an average position of 9.2. Google has already surfaced this page for the right searches. The content, presentation, or positioning is failing to close the loop. Common causes include weak titles, a description that misses the search intent, thin content, a poor match between query and page, tougher competitors, missing supporting material, or a position that's technically on page one but far enough down to get skipped. The first move here is checking whether the existing page can be fixed before deciding to write something new.
Position tells you how far a page sits from meaningful visibility. A page ranking around 8 through 11 is often a realistic near-term win: a modest improvement can move it several places and meaningfully increase traffic. A page sitting around position 48 is a different kind of project, usually requiring stronger content, more internal and external links, or a broader supporting cluster before it climbs. Both are worth pursuing, they just carry different expected timelines and effort.
Click-through rate shows how often people pick your result once they've seen it. A low rate needs context before you act on it: the page might rank too low to attract clicks, the query might only loosely match your content, an AI-generated answer might be sitting above your result, or the search intent might not match what your page delivers.
When a page combines high impressions, a reasonable position, and a very low click-through rate, that combination is worth investigating directly. The fix is sometimes editorial and sometimes technical or presentational: a sharper title, a clearer description, a relevant image, a stronger answer near the top of the page, or wording that matches how people are actually searching.
Search volume doesn't know your business priorities. A high-volume keyword can produce very little commercial value, while a lower-volume one can signal a buyer close to a real decision. Sorting queries by intent makes this visible:
All four categories carry value, but the highest-volume query is rarely the best first investment. A lower-volume comparison or decision-stage topic frequently pulls in more qualified buyers than a broad informational one.
Reviewing your site's top queries as one giant list gives a useful overview and is too broad to plan content from directly. Established company sites carry a lot of branded traffic: people searching your company name, locations, staff, or existing products. That traffic matters for other reasons and doesn't represent new market discovery.
Non-branded searches are where the growth signal lives, because those are people who may not know your company yet. The practical steps: open the performance report, switch the view from queries to pages, pull out commercially relevant pages with meaningful impressions, filter out anything dominated by branded or navigational traffic, then open one page at a time and review only the queries tied to it.
That page-level view is where the useful patterns show up. A single service page might be tied to hundreds of query variations covering definitions, product names, misspellings, use cases, comparisons, location terms, price questions, industry-specific phrasing, and a fair amount of noise. That list can look chaotic at first glance, and that's exactly the point where AI earns its place in the workflow.
Reading through several hundred queries by hand is possible and a poor use of a senior marketer's or technical expert's time. Export the page-level queries and metrics to a spreadsheet, hand it to Claude, ChatGPT, or another model, and ask it to strip out irrelevant queries, group similar phrases, separate branded from non-branded terms, flag question-based searches, classify intent, surface recurring themes, highlight high-impression low-click pages, and suggest whether each theme belongs on the existing page or warrants its own asset.
The AI here is interpreting demand Google has already recorded, not inventing it. A generic prompt like "give me blog ideas for an industrial company" produces plausible-sounding topics based on broad patterns. A prompt built from your own page-level queries, impressions, clicks, positions, and commercial context produces something grounded in your actual market presence, which is a meaningfully stronger starting point even though it still needs human review.
A workable prompt structure:
// File: prompts/content-opportunity-analysis.txt
Analyze the attached Search Console export for this service page.
Remove irrelevant and branded queries. Group the remaining queries
by search intent and recurring subject. Identify opportunities to
improve the existing page, create FAQs, publish supporting articles,
build comparison content, or create commercial landing pages.
Prioritize opportunities using impressions, current position,
click-through rate, and likely relevance to a mid-market B2B buyer.
Do not recommend separate pages when they would substantially
duplicate the existing page.
Layering in company context sharpens the output further: what you sell, your typical buyer, geographic coverage, average project value, key industries, sales cycle length, technical constraints, existing content, and any topics you deliberately want to avoid targeting.
Search Console shows how your site currently interacts with demand. Google Ads Keyword Planner shows the market around that demand: average monthly searches, recent trends, year-over-year change, advertiser competition, approximate cost per click, and related terms and phrasing.
That data is useful even for companies with no plans to run paid campaigns, because competition and bid estimates give a rough read on commercial interest. Companies generally bid higher when a query connects to valuable business. A high cost-per-click can point to strong buyer intent, heavy competition, high customer value, a tough organic environment, or a broad term pulling in many different buyer types, so it's a signal to weigh alongside the rest, not a rule to follow on its own. A low-competition query can point to a genuine gap or simply weak commercial relevance, and the surrounding context usually tells you which.
| Data source | What it reveals | Best used for |
|---|
Combined, these two sources answer sharper questions than either does alone: does this page already have momentum, is the topic growing or shrinking, are companies paying to reach this audience, are buyers using different wording than your site does, is the existing page targeting a phrase that's too broad, and is there enough demand to justify a dedicated comparison or guide.
Not every opportunity needs a blog post. Picking the right format is one of the highest-leverage decisions in this workflow.
Improve the existing page when queries connect closely to a page's central subject. That can mean a clearer definition, better examples, stronger headings, technical specs, relevant images, cost factors, process explanations, embedded FAQs, internal links, or a case study. Creating a separate article to repeat what belongs on the service page itself just splits authority for no benefit.
Add FAQs for narrow, direct questions: installation time, cost drivers, upgrade paths, maintenance requirements, climate suitability, or what information an estimate requires. FAQs strengthen the existing page instead of forcing the reader to a second resource.
Write a comparison article when the data reveals genuine uncertainty between two alternatives. A strong comparison explains where each option performs best, the real trade-offs, cost and maintenance differences, and the conditions under which the recommendation changes, rather than declaring a universal winner.
Publish an educational guide when the topic needs more depth than a commercial page can reasonably hold: how a system works, how to plan a project, common mistakes, procurement considerations, or questions to ask suppliers. The guide should link naturally to the relevant service instead of functioning as a disguised sales page.
Build an industry page when one sector has distinct requirements, terminology, or project history worth showing directly: relevant services, specific challenges, applicable standards, project examples, and evidence of experience in that environment.
Build a location page when the company has real service coverage, local projects, and operational relevance to show, connecting services available in the area, local project evidence, and regional considerations. Producing near-duplicate pages with only the city name swapped creates volume without adding value.
Build a tool when the query itself signals that the user wants a decision rather than an article: cost estimates, sizing, compatibility checks, or eligibility. A calculator, estimator, or guided questionnaire can outperform a long-form article for both discoverability and lead qualification.
Search data shows what people ask. It rarely shows why they're asking, whether the person asking is a serious buyer, or how the company should actually answer. That gap is where internal experience earns its place in the process.
Before committing real production time to a piece, check with sales or technical staff: do customers actually ask this, at what stage of the buying process, is the wording accurate, does it reflect a common misconception, is it commercially valuable, can the company answer it better than competitors, is there project evidence to draw on, are there claims to avoid, and what qualification would an inexperienced writer likely miss.
This step catches a specific failure mode: content that performs well in search while attracting the wrong audience. For a B2B company running lean on marketing capacity, one article that helps a serious buyer through a complex decision is worth more than a broad piece pulling in thousands of students, hobbyists, or unqualified visitors.
A simple scoring model keeps this comparison consistent across topics. Rate each candidate from one to five on existing visibility, ranking opportunity, commercial intent, business relevance, expertise advantage, evidence availability, format fit, and conversion path.
The highest total shouldn't automatically set the publishing order, but it gives marketing, sales, product, and leadership a shared basis to debate priorities from instead of arguing from four different sets of assumptions.
A large set of related queries can tempt a team into building a separate page for every variation, which usually backfires: multiple pages compete for the same intent, Google struggles to pick the most relevant one, internal link authority splits across pages instead of concentrating, and the company ends up with more maintenance and less depth per page.
Before adding a new page, check whether the query represents a genuinely different question with a substantially different answer, whether it targets a distinct industry, use case, geography, or buying stage the existing page doesn't cover, and whether the existing page could simply be expanded instead. A single strong commercial page, a handful of focused FAQs, one comparison article, and relevant case studies frequently outperform ten overlapping articles competing with each other.
A single article rarely establishes strong authority on a competitive B2B subject, because search engines and AI systems weigh the broader body of connected content. A solid cluster typically includes a core service page, a detailed guide, a comparison article, several FAQs, a set of case studies, an industry page, a regional page, and a tool, all linked together.
Each piece plays a distinct role: the service page drives commercial action, the guide explains the subject, the comparison supports evaluation, the case studies prove real experience, the FAQ resolves narrow questions, and the tool helps the buyer self-qualify. The cluster works because the pieces cover the subject from connected angles instead of repeating the same text under different titles.
A workable monthly cadence for a mid-market B2B team:
Week 1 — Identify the opportunity. Review pages with high impressions, low click-through rates, positions near page one, and strong commercial relevance. Pick one or two for deeper analysis.
Week 2 — Analyze demand. Export page-level queries, run them through AI for grouping and intent classification, and layer in Keyword Planner data and competitor observations.
Week 3 — Capture expertise. Interview the relevant salesperson, engineer, or project lead and collect examples, qualifications, and project evidence.
Week 4 — Publish and connect. Improve the existing page or publish the new asset, add internal links, FAQs, case studies, metadata, and imagery, and distribute through the right channels before tracking performance over the following months.
That cadence is sustainable for a company aiming for steady progress without building a publishing operation it can't maintain.
Rankings are a useful proxy and not the actual goal. A fuller measurement set includes growth in non-branded impressions, movement in average position, improved click-through rate, qualified organic visits, engagement with supporting pages, tool completions, contact requests, sales conversations shaped by the content, questions prospects stop needing sales to explain manually, content sales teams start reusing directly, visibility inside AI-generated answers, and revenue tied back to organic discovery.
Not every article produces a directly attributable lead. Some content lifts a service page's performance, some helps a prospect validate the company after a referral, some shortens the sales cycle, and some simply gives an AI system enough material to reference the company accurately. The underlying objective across all of it is making the company easier to discover and easier to trust.
Data shows where interest exists. AI processes the volume. Search tools estimate demand and competition. None of that carries knowledge of which customers you want more of, which projects are most profitable, which services are operationally constrained, or which topics drive the strongest sales conversations, so the final call stays with people who understand the business.
The workflow holds together because each piece corrects a weakness in the others: search evidence keeps the plan grounded in real demand instead of internal preference, commercial judgment keeps the plan pointed at relevant buyers instead of raw traffic, subject-matter experts protect accuracy, AI absorbs the repetitive analysis and drafting work, and ongoing measurement shows whether the whole thing produced value.
How much Search Console data do I need before this workflow is useful? A few months of history is enough to start. Three to six months gives a more stable read on trends, but you can run the first pass with whatever data you currently have.
Should I always fix an existing page before writing something new? Check the existing page first when a query is closely related to a page you already have. If the existing page targets a different intent or a genuinely different audience, a new asset is the better move.
What if a topic scores well but sales says nobody actually asks about it? Trust the validation step. Search volume without a real corresponding buyer conversation is a weak signal on its own, and it's usually better spent on a topic sales can confirm firsthand.
How many queries does a typical service page carry in Search Console? Anywhere from a few dozen to several hundred, depending on the page's age and how broad its subject is. Older, broader pages tend to accumulate the most variation.
Can this workflow work without an SEO specialist on staff? Yes, as long as someone owns pulling the Search Console export monthly and someone technical is available to validate accuracy before publishing. The AI-assisted grouping step removes most of the specialist skill this used to require.
Most established B2B companies already have more content ideas than they can execute. The question worth asking isn't what to write next. It's where proven demand, existing visibility, commercial relevance, and a real expertise advantage all line up at once.
That question produces a different kind of content plan: one that favors targeted improvements over endless publishing, connects marketing work to real customer uncertainty, gives sales and technical teams a clear reason to contribute, and uses AI as an analytical assistant instead of an idea generator working from outside the business.
Let me know in the comments if you have questions, and subscribe for more practical guides on building content systems that hold up under scrutiny.
Thanks, Matija
| Intent type | Example queries | Typical role |
|---|
| Informational | "what is X", "how does X work" | Builds awareness, supports SEO breadth |
| Comparison | "product A vs product B", "which material is better" | Supports active evaluation |
| Commercial investigation | "best solution for X environment", "typical cost of X" | Signals a buyer close to shortlisting |
| Transactional | "request a quote", "find a provider near me" | Signals immediate purchase intent |
| Search Console | Where your site already ranks, impressions, clicks, position | Prioritizing improvements to existing pages |
| Keyword Planner | Broader market demand, trends, competition, CPC | Sizing new topics and validating commercial value |