Deduplicating Joins Across Citation, Referral, and CRM Data
Website owners comparing citation reports with referrals and customer relationship management (CRM) outcomes need to keep the three record types separate. A…
For a local business, keyword research means finding the words and phrases people search for. It should answer two questions: what are people looking for in the areas the business serves, and would a separate page genuinely help them? A city name in a search phrase is a clue to investigate, not an instruction to publish a new page.
A doorway page targets similar searches with pages that offer little distinct value and send visitors toward the same destination. Google’s spam policies describe doorway abuse as creating pages for similar queries that are less useful than the final destination. The policy sets no page-count limit and does not prohibit useful location pages. Evaluate each page by its purpose and value.
Research service needs, real service coverage, and visitor questions before choosing URLs. Search volume, an estimate of how often people search for a phrase, can support that decision, but it cannot decide it on its own.
Write down where the business operates and what it offers in each area. Distinguish a staffed location customers can visit from a service-area business that travels to customers. Then check whether the business can actually provide the service in every proposed location.
This step keeps keyword research grounded in reality. Google says local results mainly reflect relevance, distance, and prominence. Distance depends on the searcher’s location, so adding a city name to a page does not establish a local presence or guarantee visibility. The local ranking guidance explains these factors, while Google’s Business Profile rules for service areas address how eligible businesses should represent the places they serve. Those profile rules do not prescribe how many website pages to create.
For each possible location, ask what a visitor needs to know there. The answer might be that the business provides the same service across a broad area, with coverage explained on one service page. A separate page needs a stronger reason, such as a genuine customer-facing location or useful, accurate details that differ for that area.
Build a small set of searches from the services people actually need, then add only locations the business serves. Include natural variations in how customers describe the service, such as the type of job or questions about availability. Group phrases that express the same need; do not assign a URL to every variation.
Compare sources by what they measure. Google Ads Keyword Planner gives search estimates based on settings such as location and date range. Its competition measure describes competition among advertisers, not how hard it is to rank among unpaid Google results. Google Trends reports relative search interest on a scale that lets you compare terms, not a count of monthly searches; a zero can mean the term had too little data to display. Use Keyword Planner guidance and the Google Trends explanation to interpret those numbers within their limits.
Search Console shows queries that have already led people to the site appearing in Google Search. Business Profile performance shows searches that surfaced the profile. Neither report gives a full count of local demand: Search Console is specific to the site and report, and some query data is withheld; Business Profile search terms describe profile visibility, not demand for a particular landing page. Check the Search Console performance report and Business Profile performance metrics for what each report includes.
Treat these sources as clues to compare, not numbers to add together. If a phrase has little reported volume but appears in genuine customer inquiries or site queries, record that difference and investigate it. If several sources point to the same service and area, you have stronger evidence that people want that service there. None of these measures forecasts a page’s rankings, leads, or revenue.
The phrase “keyword research for local business” illustrates why intent matters. It describes a search for information about research, rather than a specific local service. A phrase’s wording alone does not establish demand for a business in a particular city.
Search a focused set of service-and-location phrases and record what appears. Check whether results emphasize map listings, business profiles, directories, or web pages. Compare the pages that rank: do they answer different local needs, or do they mainly replace one city name with another?
Use this to compare what the results show, not as a fixed test. Search results vary with location and other context, and Google describes search results as dependent on factors such as the searcher’s location, settings, and past activity in its overview of how Search works. One search from one location does not establish a universal result pattern or a ranking test.
Check exported results carefully if you use a search-results data provider. In a single November 11, 2026 snapshot of eight queries, the returned 65 organic rows included 63 opaque Google redirect URLs. Those URLs did not reveal the destination pages, so destination overlap could not be measured from those fields. This was not a local-city query test and says nothing about how often that issue occurs across Google results or providers. The practical lesson is narrow: find the pages those URLs lead to before claiming that two searches return the same pages.
If nearby city searches appear to return similar pages, that is a reason to examine whether separate pages would add value. It is not proof that the pages would violate Google’s policy. If the results or customer needs appear different, investigate what the business can explain that would help visitors there; search-result differences alone do not justify another URL.
Before creating a location page, state its visitor benefit in plain language. For example: “People in this area can check whether we provide this service, what it includes, and how to arrange it.” Then make sure the page gives them accurate information that the main service page does not already provide.
A separate page makes more sense when the business has a real location or meaningful location-specific information to share. A service-area business with the same offering throughout its coverage may serve visitors better with one clear service page that explains where the business travels. A city name swap, a short rewritten introduction, or a list of nearby places does not by itself make a page useful.
Google’s people-first content guidance emphasizes original value and satisfying the reader’s goal. Before publishing, check that the page stands on its own and fits into the site’s normal navigation. Make sure it explains the service accurately and makes no false claim about a local office. If the only reason for the URL is to target another city phrase, keep the information on a more useful existing page.
The same standard applies to Google’s AI search features. Google says AI Overviews and AI Mode use the same basic search engine optimization (SEO) practices as regular Search, with no extra technical requirements or special optimization. Google must have a page in its index, its catalog of pages, and consider it eligible to appear with a snippet, the brief text shown in regular Search. Google does not guarantee that a page will appear in an AI feature. Clear, useful local information supports understanding; multiplying thin pages does not create a guarantee of visibility. See Google’s guidance on AI features and websites.
Give Vroni a GitHub issue, bug report, spec, or rough idea. It reads the repo, plans the change, writes code, runs checks, and works toward a review-ready pull request.
Take a look at vroni.com