Most keyword research advice tells you to start from scratch with a seed keyword. That works โ but it misses the biggest shortcut in SEO: your own data. Google Search Console already tells you which queries Google thinks you're relevant for. Combine that with Ahrefs' difficulty filters, and you get a keyword list that's both realistic and high-upside.
Here's the exact method, step by step.
Open Google Search Console โ Performance. Look at three timeframes:
๐ก The gold is in the Queries tab. Sort by impressions (high) and CTR (low). A query with 5,000 impressions but 1% CTR means Google shows you โ but searchers aren't clicking. That's a title/meta rewrite opportunity, not a new content opportunity.
Filter for queries where:
These are your "almost ranking" keywords. A small push โ better title, FAQ schema, a content refresh โ can move them from position 12 to position 4, which typically 3โ5x's the clicks.
Take your top 10 "almost ranking" queries into Ahrefs Keywords Explorer and apply these filters:
| Filter | Setting | Why |
|---|---|---|
| Keyword Difficulty (KD) | 0 โ 10 | Only terms you can realistically rank for |
| Search Intent | Match your page type | Informational for guides, commercial for product pages |
| Category | Your niche | Filters out irrelevant high-volume noise |
| Volume | 500+ | Enough traffic to matter |
This is where the magic happens. A seed like "microphone" can return 13,000+ matching terms. The filters cut that to a shortlist of winnable keywords โ things like "wireless microphone for recording" with solid volume and single-digit KD.
Score each keyword with a simple formula:
Opportunity = (Monthly Volume ร Relevance) รท KD
Relevance is 1โ3 (how well it fits your existing content). Higher score = write it first.
A keyword with 2,000 monthly searches, relevance 3, and KD 4 scores 1,500. A keyword with 50,000 searches but KD 65 scores 769 โ despite 25x the volume, it's the worse target for a growing site.
Before writing, Google the keyword and look at the top 5 results:
Typically 2โ8 weeks for KD 0โ10 terms on an established site, longer on brand-new domains. Track in GSC weekly.
Google Keyword Planner (free with a Google Ads account) gives volume ranges. For difficulty, use free trials or the "allintitle:" Google operator as a rough proxy โ fewer allintitle results means less competition.
VisionQuantech builds AI-powered SEO systems for small businesses โ keyword research, content, and technical fixes, done for you. See our SEO service for the full done-for-you package.
Get a Free SEO Audit