How to Analyze Google Search Console for Local SEO with Claude

An HVAC company wants to understand which local keywords are driving organic traffic and where their location pages are underperforming. Google Search Console has the data, but extracting actionable insights requires analysis.

Connecting GSC to LocalSEOSkills

The google-search-console-tool skill connects to GSC data. Setup requires:

  • GSC property verified for your website
  • API access configured
  • Connection established in LocalSEOSkills

Once connected, Claude can pull and analyze GSC data directly.

The Analysis Prompt

"Pull the last 90 days of Google Search Console data for [website].
Show me: (1) which local/geo-modified keywords are driving the most impressions,
(2) which pages have high impressions but low CTR (under 3%) —
these are our optimization opportunities,
(3) any local-intent queries ranking on page 2 that we should push to page 1."

Finding Local Keyword Opportunities

GSC Analysis: [Business Name] — 90 Days

HIGH-IMPRESSION LOCAL KEYWORDS

Keyword | Impressions | Clicks | CTR | Avg Position
"HVAC repair Denver" | 1,240 | 67 | 5.4% | 3.2
"air conditioning company Denver" | 890 | 23 | 2.6% | 4.8 ← LOW CTR
"furnace repair Denver CO" | 670 | 41 | 6.1% | 2.9
"Denver heating company" | 540 | 29 | 5.4% | 3.8
"AC repair Denver" | 520 | 31 | 6.0% | 3.1
"HVAC companies near me" | 480 | 19 | 4.0% | 5.2
"Denver HVAC contractors" | 340 | 18 | 5.3% | 4.1

This shows:

  • Which local keywords are driving visibility
  • Click-through rates for each
  • Current ranking positions

The keyword “air conditioning company Denver” stands out — high impressions but low CTR despite reasonable position.

The High-Impression/Low-CTR Fix

Low CTR with decent rankings means something is wrong with how you appear in search results.

LOW CTR OPPORTUNITIES (high impressions, CTR under 3%)

1. "air conditioning company Denver"
   Impressions: 890 | CTR: 2.6% | Position: 4.8

   Current title tag: "HVAC & Air Conditioning Company Denver | [Business Name]"

   Issue analysis:
   - Title is generic
   - Doesn't differentiate from competitors
   - No compelling reason to click

   Recommended fix:
   New title: "Same-Day AC Repair Denver | [Business Name] | Licensed Since 2008"
   - Adds urgency (same-day)
   - Adds credibility (licensed, established)
   - More specific (repair vs. generic "company")

   Expected impact: Improving CTR from 2.6% to 4.5% = 17 additional clicks/month
   from this keyword alone.

2. "Denver heating and cooling services"
   Impressions: 310 | CTR: 2.3% | Position: 6.1

   Current meta description: [Auto-generated by Google]

   Issue: No custom meta description, Google is pulling random content

   Recommended fix:
   Write custom meta: "Denver's trusted heating & cooling experts.
   Same-day service, flat-rate pricing, 24/7 emergency repairs.
   Call [phone] for a free estimate."

   Expected impact: Custom meta with clear value props typically
   improves CTR by 20-40%

Each low-CTR keyword gets:

  • Current title/meta analysis
  • Specific problem identified
  • Recommended fix with exact copy
  • Expected impact quantified

Page 2 Push Strategy

Keywords ranking positions 11-20 are on page 2. With targeted optimization, these can move to page 1.

PAGE 2 PUSH OPPORTUNITIES (positions 11-20)

1. "HVAC maintenance Denver"
   Impressions: 340 | Position: 13.4 | Clicks: 3

   Current page: /services/hvac/
   Issue: Generic services page, not specifically about maintenance

   Opportunity: Create dedicated /hvac-maintenance-denver/ page
   - 800+ words on HVAC maintenance specifically
   - Denver-specific content (seasonal maintenance, climate factors)
   - FAQ section answering common maintenance questions

   Estimated traffic gain at position 5: +28 clicks/month

2. "emergency HVAC repair Denver"
   Impressions: 280 | Position: 14.8 | Clicks: 2

   Current page: Homepage (weak targeting)

   Opportunity: Create dedicated /emergency-hvac-denver/ page
   - 24/7 availability prominently featured
   - Emergency contact information
   - Common emergency scenarios and response times

   Estimated traffic gain at position 4: +22 clicks/month

3. "Denver furnace installation"
   Impressions: 190 | Position: 11.2 | Clicks: 4

   Current page: /furnace-services/
   Issue: Page lacks Denver-specific content

   Opportunity: Add Denver-specific section
   - Denver home heating requirements
   - Local utility rebates for high-efficiency furnaces
   - Furnace sizing for Denver altitude

   Estimated traffic gain at position 5: +14 clicks/month

Page 2 opportunities represent traffic you’re almost getting. Small optimizations can tip these to page 1.

Connecting to Location Page Performance

For multi-location businesses, GSC reveals which location pages are working:

LOCATION PAGE PERFORMANCE

Page | Impressions | Clicks | CTR | Top Keyword
/hvac-denver/ | 2,340 | 142 | 6.1% | "HVAC Denver"
/hvac-aurora/ | 890 | 41 | 4.6% | "HVAC Aurora CO"
/hvac-lakewood/ | 340 | 12 | 3.5% | "HVAC Lakewood"
/hvac-centennial/ | 120 | 3 | 2.5% | "HVAC Centennial" ← underperforming

ANALYSIS:
Denver page performs well — benchmark for others.
Centennial page significantly underperforming:
- Lower impressions suggests weak rankings
- Very low CTR suggests poor title/meta or thin content
- Likely needs content expansion to match Denver page quality

Identify which location pages need work by comparing performance metrics.

Monthly GSC Review Workflow

Build GSC analysis into your monthly routine:

Monthly prompt:

"Pull last 30 days of GSC data for [website].
Compare to previous 30 days.
Show: keyword movement (improved/declined), new ranking keywords,
CTR changes, and any new page 2 opportunities."

What to track month-over-month:

  • Keywords gaining/losing positions
  • CTR trends for key pages
  • New keywords appearing in rankings
  • Traffic changes to location pages

Quarterly prompt:

"Pull 90-day GSC trend data for [website].
Identify: seasonal patterns, long-term ranking trends,
content gaps based on impression data."

Connecting GSC to Local SEO Priorities

GSC data informs local SEO strategy:

Content creation: Keywords with impressions but no dedicated page → create content Page optimization: High impressions, low CTR → optimize title/meta Technical issues: Pages with declining performance → investigate Competitive gaps: Queries you don’t rank for but competitors do → opportunity analysis

"Based on this GSC data, what are the top 3 content opportunities
for [Business Name] to improve local organic visibility?"

Claude analyzes the data and prioritizes what to create or optimize next.

The Complete GSC Analysis Workflow

  1. Pull 90-day GSC data
  2. Identify high-impression local keywords
  3. Find low-CTR opportunities (fix titles/metas)
  4. Identify page 2 push opportunities
  5. Compare location page performance
  6. Prioritize actions by expected impact
  7. Execute fixes and track results
  8. Repeat monthly

GSC contains the data to improve organic local visibility. LocalSEOSkills turns that data into prioritized actions you can execute.