Local Keyword Research Worksheet

Most local keyword research fails because it starts with a tool and ends with a giant spreadsheet. Local businesses need a smaller, clearer process that turns search ideas into decisions: which pages to build, which services to prioritize, which questions to answer, and which locations are worth targeting.

Use this worksheet to:

• Build a seed keyword list from real services.
• Capture customer language from calls, forms, reviews, staff, and sales conversations.
• Research keywords using Search Console, Google Business Profile insights, Keyword Planner, search suggestions, competitor pages, and customer questions.
• Separate service keywords from city, neighborhood, problem, price, emergency, comparison, and FAQ keywords.
• Identify which keywords deserve their own page and which belong inside an existing page.
• Avoid duplicate city-swap pages and thin local pages.
• Prioritize keywords by intent, value, proof, difficulty, and business fit, then build a keyword-to-page map.

No ethical keyword worksheet can guarantee rankings — this one helps you choose better targets and page plans.

This worksheet is for small business owners, office managers, marketers, freelancers, web designers, local SEO beginners, and agencies that need a practical keyword research workflow. It is especially useful for:

• Contractors and home service companies
• Service-area businesses that travel to customers
• Clinics, dentists, medspas, therapists, chiropractors, and wellness offices
• Restaurants, coffee shops, caterers, food trucks, bars, and hospitality businesses
• Retail shops, boutiques, showrooms, florists, and local product sellers
• Salons, spas, barbers, gyms, fitness studios, and appointment businesses
• Auto repair, towing, mobile detailing, and repair businesses
• Lawyers, accountants, insurance agents, consultants, real estate professionals, and professional services
• Multi-location businesses and new websites that need a clean local SEO page plan

• A business intake worksheet and a customer-language worksheet
• Seed keyword, local modifier, and intent-bucket worksheets
• Search Console, Google Business Profile, Keyword Planner, search-suggestion, and competitor worksheets
• A keyword scoring matrix and a page decision guide
• A keyword-to-page map and a title-tag-and-H1 worksheet
• A 30-day research plan and a monthly refresh checklist
• 12 AI prompts for discovery, clustering, mapping, and prioritization

Score each keyword 0 (weak), 1 (moderate), or 2 (strong) across service relevance, customer intent, business value, local relevance, proof available, page fit, competition level, and conversion potential. Then read the total:

• 0-5: Reject or hold.
• 6-9: Use as supporting content or an FAQ.
• 10-13: Add to an existing page or create a content section.
• 14-16: Prioritize for a dedicated page, refresh, or campaign.

Use these rules to decide what each keyword becomes:

• Build a dedicated service page when the keyword maps to a real service customers search for directly, the service has business value, the page can explain process, price factors, FAQs, proof, and next steps, and it would not duplicate another page.
• Add to an existing page when the keyword is a subtopic or variation, the need can be answered in a section, or the intent overlaps an existing page.
• Build a city page when the business truly serves the city, demand is meaningful, and the page can include real local context, proof, availability, and next steps.
• Build a neighborhood page when the area has business value and real customer history, and the content would be unique — not a city-name swap.
• Build an FAQ or blog post when the keyword is informational, the searcher is comparing options, or the question supports a service page.
• Reject or hold when the business does not offer the service, the area is not served, the keyword is too broad or the wrong intent, or it would require unsupported claims or a thin page.

A four-week path from inputs to an action plan:

• Days 1-3 — business and customer inputs: complete the intake, list services and locations served, and collect customer questions, review language, and staff notes. Deliverable: customer-language worksheet.
• Days 4-7 — seed keyword build: build service, problem, price, and emergency seeds plus the local modifier list. Deliverable: seed keyword list.
• Days 8-12 — existing data review: review Search Console queries and top pages, and GBP categories, services, reviews, and Q&A. Deliverable: existing keyword opportunity notes.
• Days 13-17 — tool expansion: use Keyword Planner, autocomplete, related searches, People Also Ask, and competitor topics. Deliverable: expanded keyword list.
• Days 18-22 — scoring and filtering: reject wrong-fit keywords, score the rest, and group by intent and page type. Deliverable: scored keyword matrix.
• Days 23-26 — page mapping: map keywords to existing pages, and identify pages to build, pages to improve, and FAQ, blog, and GBP topics. Deliverable: keyword-to-page map.
• Days 27-30 — action plan: choose the top 10 priorities, draft titles and H1s, list proof needed, and assign owners and due dates. Deliverable: local keyword action plan.

• Starting with a tool before defining real services.
• Targeting cities the business does not serve.
• Creating one page for every keyword variation.
• Publishing thin city pages with only the location changed.
• Ignoring customer questions or Search Console data.
• Assuming search volume equals business value.
• Targeting keywords with the wrong intent.
• Building pages without local proof.
• Choosing keywords only because competitors use them.
• Forgetting emergency, price, comparison, and FAQ keywords.
• Failing to update keyword priorities after real leads come in.