There is a category of merchant that both the local SEO world and the ecommerce world manage to under-serve at the same time: the business with a physical footprint and a real online catalog. Local specialists treat the website as a brochure. Ecommerce specialists treat the shop as an irrelevance. The merchant sits between two consultants who each ignore half of their business, and nobody pitches the part that connects them.
What a matched profile actually tells you
44,132 of the 153,515 stores in the database carry a matched Google Business profile. Each one brings a gmb block into the record: placeId, name, category, rating, reviewsCount, address, city, zip, latitude, longitude, isClaimed and totalPhotos, sitting in the same object as platform, productCount, monthlyTraffic and the rest.
The lazy read is “this merchant has a shop”. The useful read is broader. A matched profile means a verifiable street address, a public phone number, published opening hours, a category Google has assigned whether the merchant agreed or not, and a running stream of public opinion attached to the brand name. It also means there is a human being at a known location who can be reached without going through a contact form nobody checks.
Most importantly, it means the business has two demand channels that almost certainly do not talk to each other. One is a catalog competing nationally or internationally on search. The other is a profile competing inside a radius of a few kilometres on entirely different ranking mechanics. Selling the bridge between them is an offer with essentially no competition in the merchant’s inbox.
Unclaimed profiles are the cleanest opening in this whole market
The isClaimed flag is the single highest-signal boolean in the record. When it reads false, Google generated the listing algorithmically or a customer suggested it, and the merchant never took ownership. That means the category may be wrong, the hours may be wrong, the photos were uploaded by strangers, and the reviews have gone unanswered for years.
Cold email that opens with a specific, verifiable, mildly alarming fact outperforms every clever hook ever written. “Your Google Business listing still shows as unclaimed, which means anyone can suggest an edit to your hours and Google will often accept it.” That is not a pitch. It is a fact the merchant can verify in thirty seconds and cannot comfortably ignore, and it demonstrates that you looked at their business specifically rather than merged their name into a template.
The remedy is also the perfect first engagement, because it is small, bounded and obviously valuable. Claim the listing, complete verification, correct the primary category, set real hours, replace the stranger photos with proper ones, wire the website field to the catalog. A few hours of work, a defensible fee, and afterwards you are the person who fixed their Google presence. Everything else you ever sell them starts from that position.
Reviews: read the count, the rating, and the gap between them
reviewsCount and rating sit in the same record, and the relationship between them sorts prospects into three distinct sales conversations. Sorting on either one alone throws away the interesting information.
High rating with a low count — an excellent score across twenty or thirty reviews — describes a business that is genuinely good and structurally invisible. Review volume is among the strongest local ranking factors, and this merchant simply never asks. The fix is a systematic request at the point of delivery or collection, spread deliberately over weeks rather than fired off in a single burst, because a cluster of reviews landing on one day looks like exactly what it usually is.
Low rating with a high count is the reputation engagement: a response programme, a service post-mortem, a structured recovery over months. Slower, more delicate, and much better paid, because the merchant already knows they have a problem and has usually been quoted for it before. Middling on both axes is the standard local SEO engagement, and the largest group by far.
One tactic worth carrying into every proposal: reviews containing the words customers actually search for do more ranking work than reviews saying “great service”. A merchant who asks “could you mention what you bought and which area you came from?” collects reviews that rank, not merely reviews that reassure. It costs nothing to change the wording of the request and it changes what the reviews are worth.
The category trap that invalidates everything downstream
The gmb block carries the profile’s assigned category. It is the field most people skim past, and it quietly decides whether any of the other work can succeed.
Google evaluates a profile inside its primary category first. A shop selling running equipment filed under a generic sporting-goods label will not rank for the searches that matter, no matter how many descriptions are rewritten, photos uploaded or reviews collected. The lever sits upstream of every deliverable a typical local SEO package contains, which is why so many of those packages quietly under-deliver.
Changing it is not risk-free. Aggressive edits to category or name can push a profile into review or suspension, which is precisely why this is a paid service rather than a tip you give away. Being the person who can say “your category is wrong, here is why nothing else you have tried worked, and here is the sequence for changing it without losing the listing” is worth considerably more than being the person offering to write descriptions.
The profile is a second storefront and merchants treat it like a business card
The totalPhotos field is a proxy for how seriously the merchant takes the surface. Google increasingly renders the profile as a small site in its own right — products, services, hours, descriptions, posts, questions and answers — and for a lot of local searches it is the only page the customer ever sees.
Two arguments most merchants have never heard. First: more content on the profile is better, not worse. Product entries, service entries, long descriptions, real photographs. This is one of the very few surfaces where filling in every available field is unambiguously correct, and most merchants stopped after the address. Second: publish over time. A single burst of optimisation produces a spike followed by a slide; steady additions week after week hold the position, exactly the way content publishing does on a website.
Third, and the cheapest win in the entire list: opening hours. A profile that is open when its neighbours are closed gets surfaced when its neighbours cannot serve the search, because availability is part of what the ranking is trying to solve for. A merchant who also ships nationally can often defend far wider hours than a purely physical business can, and almost none of them have thought about it.
Where the catalog and the profile actually connect
This is the offer nobody else is making, and it exists because the two halves live in the same record: platform, productCount, monthlyTraffic, organicKeywords, currency and lang on one side; category, city, coordinates, rating, reviewsCount and isClaimed on the other.
Concrete deliverables that need both halves. Click and collect wired into the ecommerce platform and surfaced on the profile, which turns local search into online orders. City and neighbourhood landing pages on the site that the profile links into, and that feed relevance back the other way. Product entries on the profile generated from the real catalog rather than typed once and abandoned. Review requests triggered automatically by online orders shipping to nearby postcodes, which is the only reliable way a local merchant collects reviews at scale.
Individually each of those is a small project. Together they are a retainer, and they are defensible because they require both skill sets. A local SEO freelancer without platform access cannot build them. An ecommerce developer without local expertise will never think of them. Sitting in the overlap is the entire commercial argument.
Building the list and writing the first email
Start from the 44,132 matched records and split them into three lists rather than one. Unclaimed profiles attached to a live catalog, where the opening is the ownership fact. Claimed profiles with a strong rating and fewer than fifty reviews, where the opening is review acquisition. Claimed profiles with a weak rating and a large review count, where the opening is reputation and the price should reflect the difficulty.
Then layer platform and country on top. A merchant on WooCommerce in a mid-sized city, running four hundred products, holding an excellent rating across thirty-one reviews with an unclaimed profile, is not a segment. It is a specific person with a specific and fixable problem, and you can write to them as one.
Keep the email to four lines and one artifact. The fact, the consequence, the thing you already made, and a soft question. Something like: your listing is still unclaimed and the category on it does not match what you actually sell; that is usually why a shop with your reviews does not show up in the map results; I put together a one-page fix list; want me to send it? No call requested, nothing to download, nothing to sign. The call comes later, and it comes from them.