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…
People searching for a product or service may compare options before deciding what to buy or whom to contact. The phrases they use can help you plan pages that answer real questions, such as which product better fits a specific need.
SEO practitioners often call these commercial intent keywords: search phrases that suggest someone is comparing products, prices, or providers. The term is a useful label, but Google does not use it as a formal category, and it does not prove that a searcher is ready to buy. To find promising phrases, start with the decision a buyer needs to make, expand into comparison language, then check what the search results and your own search data show.
Begin with the product or service you offer and the alternatives a buyer would consider. Then identify the differences that could affect their choice: price, features, compatibility, location, support, or risk.
For example, a company that sells accounting software might find out whether potential buyers compare tools for freelancers, look up prices, or search for alternatives to a product they already use. Those are different decision questions, even though they relate to the same broad category.
Starting with these choices keeps your research focused. A broad starting phrase like “accounting software” can lead to searches that have little to do with choosing a product. A phrase like “accounting software for freelancers” gives you a clearer question to investigate: what options meet that use case?
Use product and category names as starting points. Add words that suggest evaluation, then treat each phrase as a hypothesis about what the searcher wants.
| Search pattern | Illustrative query | Possible decision |
|---|---|---|
| Direct comparison | [option A] vs [option B] |
Which of two named options fits better? |
| Alternatives | alternatives to [product] |
What else could replace a known option? |
| Shortlisting | best [category] for [use case] |
Which options fit a particular need? |
| Reviews | [product] reviews |
What evidence or experience supports a choice? |
| Pricing | [product] pricing or [service] cost |
What does the option cost, and what is included? |
| Provider search | [service] companies in [location] |
Which providers serve a particular area? |
The added words can suggest possible keywords, but they do not establish intent. “Best” may describe early research or active comparison, while a pricing query may come from someone estimating a budget rather than preparing to purchase. Record the decision each phrase seems to express, then test that interpretation against current search results.
Search the strongest candidate phrases in the location and market you want to reach. Note the date and device, then look at the kinds of pages that appear. If results mostly show comparisons and reviews, searchers need a different kind of page than they do when results mostly show definitions or general tutorials. If local directories and provider listings appear, searchers are likely choosing among providers in an area.
Use the results to answer two questions: What is the searcher trying to decide? What page would give them the evidence they need? A direct comparison may call for a page that weighs two options against clear criteria. A pricing search may need current, specific cost information.
Search results are evidence about what Google is showing for a query at that moment, not a fixed recipe for rankings or proof that every searcher has the same goal. Google describes results as its assessment of relevance and quality, and its SEO Starter Guide recommends anticipating the different words people use for the same subject. Use the wording you find to understand the audience, not to force every variation into a page.
Keyword research tools and search-result APIs can return fields that look alike but refer to different things. If a tool gives you a redirect URL instead of the destination page's URL, comparing those links as page addresses gives you invalid overlap results.
In one US English Google-results snapshot on November 11, 2026, eight queries returned 65 organic result rows. Sixty-three rows contained Google goto wrapper URLs, so the destination pages could not be compared from those URL fields. If a text comparison found no matching URLs, that would not prove the queries had no results in common. It would show only that the redirect URLs, which still hide the destination pages, did not match. Because this was one eight-query snapshot, it gives no measure of how often this happens across searches or providers.
When a keyword tool reports that queries overlap or belong in clusters, check whether it compares destination pages after resolving the redirect URLs or uses another documented matching method. If you cannot verify the destination pages, treat the overlap as unknown, not zero.
Google Ads Keyword Planner can suggest related phrases and estimate search activity for selected settings. Its average monthly search estimate is based on a chosen period, location, and Search Network settings; the default average covers 12 months. Its “Competition” measure reflects advertiser competition within those settings; it does not measure organic ranking difficulty or a searcher’s likelihood of buying. Google explains these limits in its guidance on Keyword Planner forecasts.
Google Trends helps compare relative interest across terms, places, and time periods. Its values are normalized for the selected geography and timeframe; they are not absolute search-volume counts. Trends uses a sample and filters some low-volume searches, so a zero can mean there was not enough data to show rather than that nobody searched. Use it to compare patterns, not to forecast exact demand. The Google Trends data FAQ explains how to interpret the scale.
Once your site has search impressions, Google Search Console can show queries that led to your site and the pages that appeared for them. Selecting a query and checking the Pages view helps reveal whether Google is showing the page you expected. Query data is incomplete: Google omits some queries to protect privacy and limits the rows in reports. The visible list is useful evidence, not a complete inventory of searches. See Search Console’s query and page reporting guidance and its explanation of report dimensions and data groupings.
Treat each tool’s numbers according to what it measures. Search volume estimates demand under a tool’s settings. Impressions show that a search result appeared under Google’s counting rules. Clicks show visits from those results. Neither metric alone establishes how many searchers were qualified buyers or how much business a page generated. Search Console also says that many factors affect clicks and that average position summarizes impressions rather than guaranteeing what an individual searcher saw. Its metrics guidance helps distinguish those measures.
Third-party keyword difficulty scores also need context. They are vendor estimates, not measurements of Google’s internal ranking decisions. Google’s guidance on third-party SEO tools cautions that such tools do not have access to its internal ranking data. Use a score to compare candidates within the same tool, if useful, but do not treat it as a Google score or a promise of ranking outcomes.
Group phrases when searchers are making much the same decision and need the same kind of answer. Searches comparing two named products may belong together. Give pricing its own page only when searchers need different information, such as a clear breakdown of costs, differences between plans, or details about what a service quote includes.
For each group, identify the question searchers have, the evidence they need, and the kind of page that can provide it. A comparison page should explain its criteria and show meaningful differences. A product page should make fit, features, and relevant limitations clear. A local provider page should help a prospective customer assess service and location.
Create a separate page when searchers need a different answer. Keep related wording on one page when the underlying need is the same. This avoids producing a thin page for every modifier while still giving buyers information tailored to their decisions. Google recommends descriptive titles and warns against keyword stuffing; repeating exact phrases does not substitute for answering the question.
Google says AI Mode can handle complex comparisons and may use “query fan-out,” which means it issues related searches across subtopics to develop a response. That makes clear, useful information about options and trade-offs relevant to comparison content. Google’s current guidance for AI features points site owners to established Search requirements and helpful content; it does not prescribe a special keyword formula or guarantee that a page will appear as an AI source.
For a comparison page, state what you compared, the criteria you used, and where the evidence has limits. That helps readers assess the information and makes the page’s claims easier to understand. A mention, link, visit, and sale remain different outcomes, so do not treat AI visibility as proof of commercial performance.
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