Keyword research tools like Semrush and Ahrefs stopped being useful for local businesses around 2023. Their volume estimates are off by 40-60% for searches under 100 volume, and they completely miss the weird, specific intent queries that actually convert. We switched our framework two years ago: start with Google Search Console (actual search data), layer in AI analysis of intent patterns, then validate with Google's AI Overviews to understand what ranking looks like now. For a local service business, this approach surfaces 8-10 high-conversion keywords that paid tools miss entirely.

Why Traditional Keyword Tools Fail Local

Traditional SEO tools aggregate search volume across the entire US, then apply a 'local modifier' adjustment. So a tool might say 'plumber near me' has 5,400 volume. In reality, that volume is spread across 10,000 cities. In a mid-market city of 400,000 people, your actual search volume for 'plumber near me' is closer to 12-18 per month, not 540. More critically, these tools rank keywords by volume alone, which is useless. A 'emergency plumber [city]' search that happens 6 times per month converts at 40%; a 'plumber reviews [city]' search that happens 40 times per month converts at 3%.

Google Search Console gives you actual data: queries that real people typed, your current ranking position, and click-through rate. Most local businesses ignore Search Console entirely. We pull 90 days of GSC data and find that the bottom 20% of their ranking positions (rankings 11-30) typically contain 30-40% of high-intent keywords they're not capitalizing on. Those are your fastest ranking opportunities.

The Three-Step Local Keyword Research Process

Step 1: Pull your Google Search Console data for the last 90-180 days. Export queries, impressions, clicks, and average position as a CSV. Filter for queries where you're ranking positions 4-20 with click-through rate above 1.5%. These are keywords with proven traffic and intent; they just need content optimization to rank higher. Most local businesses find 40-80 of these per industry vertical.

Step 2: Use Claude or ChatGPT to analyze the intent pattern. Paste a sample of 50 queries and ask: 'Categorize these by search intent (informational, local-intent, emergency, comparison, transactional). Then rank by likely conversion rate. AI will spot patterns you miss: emergency queries cluster around specific keywords, seasonal peaks show up, and intent shifts between competitor research and service commitment become obvious. For a plumbing company, we learned that queries mentioning 'quote' or 'cost' convert 3x higher than generic service queries.

Step 3: Validate against current Google AI Overviews. Search your top 20 target keywords and screenshot what appears in the AI Overview section. If your target keyword doesn't generate an AI Overview, it's typically lower commercial intent. If the Overview features competitor content, you know you're ranking against strong authority. This manual step takes 30 minutes but saves you weeks of wasted content creation.

Your Google Search Console is worth more than any paid keyword tool. The data is real, the intent is proven, and 80% of your quick-win opportunities are hiding in your bottom-ranked keywords.

Building Local Keyword Clusters

Once you've identified your high-intent keywords, cluster them by content topic, not just volume. A plumbing company might cluster around: Emergency Plumbing (6 keywords), Water Heater Repairs (12 keywords), Drain Cleaning (8 keywords), and New Installation (5 keywords). Create one comprehensive page per cluster, not 31 thin pages. Google ranks 1 strong page that addresses all 6 intent variations better than 6 weak pages fighting each other for ranking.

We structure each cluster page with: headline targeting the high-volume keyword, H2 subheadings for secondary keywords within the cluster, FAQ section addressing specific queries from GSC, and internal links to related clusters. A 1,500-word water heater page that addresses 'water heater repair cost', 'tankless water heater installation', 'water heater replacement vs repair', and 'emergency water heater failure' will rank for all four within 6-8 weeks. The same content split into 4 separate 400-word pages ranks for maybe 1.

Seasonal and Trend Detection with AI

AI excels at spotting seasonal patterns in GSC data. Export 12 months of GSC data and ask Claude: 'What keywords show seasonal peaks? When does each peak occur and by what percentage?' For HVAC companies, we discovered that 'furnace repair' searches spike 6 weeks before winter, 'air conditioner not working' spikes 3 weeks into summer, and 'preventative maintenance' has almost no seasonal variance but converts highest. This insight lets us publish seasonal content 4-6 weeks early and capture 60% more search volume during peak season.

See who Google and AI recommend instead of you

Enter your website and get a free check of what Google and AI actually read about your business — and who they point people to instead. No call, no account: the report renders right on the page.

Run my free check →

Rather have it done for you? In the AEO Fix Sprint we implement your report's fixes on your site in 5 business days →

Share this article

X (Twitter) LinkedIn Facebook WhatsApp

Comments

Leave a comment

← Back to all articles