How to Build a Keyword Map for a Local Service Business

Key takeaway: A keyword map isn’t a spreadsheet of every service multiplied by every location you serve. It’s a set of decisions: which keywords deserve their own page, which belong inside an existing page as a section, and which shouldn’t exist as separate content at all. This article walks through the actual process, then builds a real map for a fictional Dhaka electrician so you can see every decision made, not just described.

Keyword Research Finds Opportunities. Keyword Mapping Decides Where They Go.

These two get treated as the same task, and they aren’t. Keyword research asks what people search for. Keyword mapping asks where each of those searches should live on your website. Research gives you a list. Mapping turns that list into a site structure.

Skip mapping and go straight from a keyword list to publishing, and the default move is to multiply every service by every area you serve. Three services across two neighborhoods becomes six pages before you’ve asked whether any of those six searcher needs are actually different from each other.

The Three Decisions Behind Every Keyword

Once you have a raw keyword list, every keyword on it resolves into one of three outcomes.

The test behind this table is two questions, asked of every keyword or cluster. First: does this need its own distinct answer, or does answering something else on the page already cover it? Second, if it does need its own answer: is that answer the page’s main purpose, or a supporting detail? Main purpose earns Page or the hero section within one. Supporting detail earns Section.

Not every keyword needs a URL. Nowhere isn’t limited to near-duplicates. A keyword lands there if it’s redundant with something already answered elsewhere, irrelevant to what the business actually offers, an awkward or unnatural phrasing nobody would search verbatim, or simply too negligible in intent to justify any dedicated treatment.

Step 1: Collect

Pull every relevant keyword you can find: service names, service plus location combinations, “near me” variants, pricing and cost questions, urgency-based phrasing (“emergency,” “same day,” “open now”), and specific repair or job terms customers actually use. Don’t filter yet. Filtering happens in step 4.

Step 2: Classify by Intent

Sort the raw list into commercial/transactional (someone close to hiring: “cost,” “hire,” “near me,” service plus city) and informational (someone still learning: “how,” “what,” “why,” comparisons). Some keywords carry both signals at once, like “how much does an electrician cost.” When that happens, the dominant intent decides placement, and commercial usually wins on a keyword that sounds informational but signals someone close to a decision.

For local businesses specifically, add a second dimension alongside intent: the geographic signal. “Electrician” carries implicit local intent once Google detects the searcher’s location. “Electrician Dhaka” states the city explicitly. “Electrician Mirpur” narrows to a specific area. “Electrician near me” signals proximity without naming a place. None of these are different services, but they tell you how explicit a page needs to be about location, which matters when you get to the area decision later.

Step 3: Cluster

Group keywords that represent the same underlying search need, regardless of exact phrasing. “Electrician Dhaka,” “electrician near me,” and “hire an electrician in Dhaka” are one cluster, not three. This is also where near-duplicates reveal themselves early, before you’ve built anything around them separately.

Step 4: Test Each Cluster

Run the Page / Section / Nowhere test on every cluster from step 3. This is where most of the actual thinking happens. Don’t rush it to get to step 5.

Step 5: Assign

Give every cluster that passed as “Page” a working URL. Give every cluster that passed as “Section” a home on an existing or planned page. Drop the rest.

Step 6: Map

Turn the assignments into a table: keyword cluster, intent, decision, target page or section, primary keyword, supporting keywords. This table is your actual keyword map, and it’s the artifact you’ll hand to whoever writes the content.

Let’s Build One for a Dhaka Electrician

Take a fictional electrician offering four core services (electrical wiring, electrical/appliance repair, emergency callout, and ceiling fan installation and repair) across two areas (Mirpur and Dhanmondi), with this raw keyword list from step 1:

electrician Dhaka, electrician Mirpur, electrician Dhanmondi, emergency electrician, emergency electrician Dhaka, electrical wiring, house wiring, electrical wiring Dhaka, electrician near me, electrician cost, emergency electrician cost, how much does an electrician cost, socket repair, switch repair, ceiling fan installation, ceiling fan repair.

Running steps 2 through 5:

That last row needs a separate decision. This is where the geographic-signal dimension from step 2 earns its keep. Explicit area names like “electrician Mirpur” don’t automatically mean two different pages.

If pricing, response time, and service scope are identical in both Mirpur and Dhanmondi, both area names belong naturally inside the copy of the pages above, not as two duplicate pages. If the business charges a travel fee outside a radius, or has genuinely different availability by area, that’s a real difference. Dedicated area pages become justified because there’s now something area-specific to say.

For this electrician, assume service and pricing are identical in both areas. The area names get folded into existing page copy rather than spawning duplicates.

What the Final Website Structure Looks Like

Home (general electrician landing page)
├── Electrical Wiring
├── Electrical/Appliance Repair (with Ceiling Fan section)
├── Emergency Electrician
└── Areas We Serve (Mirpur, Dhanmondi — mentioned within existing pages)

Notice what isn’t here: /emergency-electrician-mirpur/, /emergency-electrician-dhanmondi/, /electrical-wiring-mirpur/, and four more pages just like them. The sixteen-keyword raw list produced three dedicated service pages plus the existing homepage, not six or more thin ones, because most of those keywords resolved to Section or got folded into an existing cluster rather than spawning a new URL.

Here’s what steps 5 and 6 hand off as the finished deliverable:

This is the table a writer actually works from. Everything above it was the reasoning; this is the artifact.

The Two Mistakes: Splitting Too Much vs Consolidating Too Much

Over-fragmenting shows up as multiple pages differing only by a swapped city or service name, competing against each other in search results. Over-consolidating shows up as one page trying to carry every service and area at once, diluted enough that it doesn’t clearly answer any single searcher’s question. Both come from skipping the same test: checking whether a real difference in intent or delivery exists before deciding to split or merge.

The Page-Count Test: Could This Become a Doorway Page?

Before publishing a new location or service variant page, it’s worth checking it against a narrower version of the same test. Google’s spam policies for web search name “doorway abuse” directly: sites or pages created to rank for specific, similar search queries, including pages built around multiple similar domains or locations that funnel users toward one destination without offering distinct value along the way (Google Search Central: Spam Policies for Google Web Search). A page that only differs from another by a swapped city name, with everything else identical, is the clearest version of this pattern, and it’s exactly what the merge decision above is designed to prevent.

My Recommendation

Don’t start a keyword map by listing every service-location combination. Run the six steps: collect the full list, classify by intent, cluster by real search need, test each cluster against Page/Section/Nowhere, assign what passes, then document the result in a single table. A page earns its URL only when it represents a genuinely different search need from everything else on the site. Everything else becomes a section inside a page that already exists, or gets dropped as a near-duplicate.

A good keyword map doesn’t maximize the number of pages you can publish. It minimizes the number of pages you need to satisfy every distinct search intent your keyword research uncovered. For this electrician, that meant three pages, not sixteen keyword-shaped ones.

This same clustering and assignment logic is what decides whether a keyword becomes a service page or a blog post in the first place, which is where the next piece in this series picks up.

Related reading: Near Me Keywords vs Location Keywords, The 3 Pillars of Local Ranking, Local SEO Keyword Research and Search Volume, High-Volume Keywords

About the author: Arif Rahman is a Dhaka-based freelance SEO strategist working with local and service-based businesses across Bangladesh, Australia, and the UAE. He’s spent more hours than he’d like to admit talking clients out of building a page for every city they’ve ever driven through.