Local SEO Keyword Pack — Service × City Matrix + Page Plan

Unlike free "give me local keywords for a plumber" prompts and generic local SEO audit skills, this one builds the full service × city × modifier matrix with a bundled script, tells you which pages each keyword deserves, and refuses to plan doorway pages. Location pages only get built where you have real local proof. Volume stays blank until you check it. Nothing is made up.

Sample run (real data, 22 Oct 2026): a plumber in Austin, TX that also serves Round Rock, Cedar Park and Pflugerville, with 3 services (plumber, drain cleaning, water heater repair). The bundled local_keyword_matrix.py built the matrix. We then checked every candidate against public Google autocomplete (US, English, 54 queries). Autocomplete only shows that people type a phrase. It is not search volume.

1. 147 keyword candidates: 48 core (Austin + "near me") and 99 expansion (the 3 service-area cities)
2. 22 of the 147 appear word for word in Google autocomplete, e.g. "plumber round rock", "emergency plumber pflugerville", "water heater repair pflugerville"
3. "{service} {city}" is the strongest pattern (8 of 12 confirmed), then "emergency {service} {city}" (4 of 12) and "best {service} {city}" (3 of 12)
4. "{service} in/near {city}", "company", "affordable", "cost", "prices" and "reviews" + city: 0 of 12 each, so use them in page copy, not as page targets
5. Drain cleaning in Round Rock, Cedar Park and Pflugerville: no suggestions at all, so no city pages. Cover those cities on one service-area page
6. "plumber {city} tx" is suggested for all 4 cities, so plumber gets the Austin service page, plus location pages only where there are local jobs and reviews
7. Missing from the default patterns but present in autocomplete: the "tx" suffix (17 suggestions) and "water heater replacement {city}" (all 4 cities). Add them with --modifiers
8. Negative keywords from the same data: "austin mn", "austin indiana", "austintown ohio", "costa mesa" (cost → costa), "plumber austin salary", "plumber costume"
9. Volume column blank and verified = no on all 147 rows (nothing estimated)

What it does

• Generates a service × city × modifier keyword matrix offline (CSV, stdlib Python, no API keys)
• Splits keywords into core (primary city + "near me") and expansion (service-area cities) tiers
• Maps every keyword to the home page, a service page, a location page or the Google Business Profile
• Runs a go/no-go test for every location page: real local proof (jobs, reviews, staff, photos) or no page
• Fills in a Google Business Profile sheet: primary and secondary categories, services, description, Q&A, posts
• Hands you a verification checklist for the volume column (your own tool, Google Keyword Planner or autocomplete)

Use cases

• Agencies onboarding a local service client
• Trades, clinics, salons and law firms planning service and city pages
• A follow-up to a local SEO audit, or a site stuck with 40 copy-paste city pages

Works in Claude Code, Cursor and Codex · tested on real data · v1.0 updated Oct 2026 · questions answered within 24h Check the intent of your finished list in bulk with the free-to-try Cygnix Apify actor: apify.com/cygnix_labs/serp-intent-mapper · More tools: github.com/cygnixlabs-cmd

Pairs well with (Cygnix Labs, on Agensi):

• Local SEO Audit: GBP + NAP Fix Plan for Small Business: fix the profile before you add pages (agensi.io/skills/local-seo-audit-gbp-nap-fix-plan-for-small-business)
• Keyword Clusters + Intent Map: group non-local keywords into topics (agensi.io/skills/keyword-clusters-intent-map-no-paid-seo-tool-needed)
• SERP Intent Mapper: match each keyword to the right page type (agensi.io/skills/serp-intent-mapper-keyword-page-type-match)
• Keyword Gap Analysis: keywords local competitors rank for and you don't (agensi.io/skills/keyword-gap-analysis-competitor-gaps-priority-plan)
• SEO Meta Tags Generator: titles, descriptions and LocalBusiness schema for each page (agensi.io/skills/seo-meta-tags-generator-titles-descriptions-schema)
• Plan Programmatic SEO Pages Without Thin Content: if you do scale city pages, gate them first (agensi.io/skills/plan-programmatic-seo-pages-without-thin-content)
• SEO Content Brief (free): a writer-ready brief for each service page (agensi.io/skills/seo-content-brief-writer-ready-outline)