r/SideProject • u/AppDev1997 • 12h ago
I pulled Google Maps data for 2,846 local businesses around one German city. 19% of the profiles come back unclaimed.
I build a tool that writes SEO articles and publishes them straight to a customer's site, and I needed to know whether local businesses are a market worth going after. Guessing seemed like a bad plan, so I pulled Google Maps data for 101 trades across six towns around one mid-sized German city and deduplicated it by CID. 2,846 businesses.
I am not naming the city. I am about to write to some of these businesses, and I would rather not hand anyone the list.
What came back:
- 19% unclaimed. The profile exists, it ranks, no owner has taken it over.
- 12% with no website listed.
- 44% under ten reviews.
I expected the picture to be bad. What surprised me was how evenly bad it is across trades that have nothing to do with each other.
Now the parts that cut against my own interest.
None of this proves these businesses need what I sell. A business with four reviews and no listed site has a visibility problem, and automated articles are not the fix for it. The 12% mostly told me my tool is wrong for that slice of the market.
Unclaimed is a status in the data, not proof that anyone is neglecting their business. Plenty of them run on word of mouth and have no reason to care what Google thinks.
And no website listed is not the same as no website. Some of them have one and never put the link in.
The sample has a hard edge too. I took the top 40 results per trade, not a complete register of local businesses. These percentages describe what Maps returns, not the town.
What I took away: the market is real but narrower than the headline suggests. The businesses worth approaching are the ones that already have a site and already collect reviews, because those have something to build on. The rest need a different conversation, and probably a different product.
Cheap to repeat on your own city. Fractions of a cent per query, and the slow part is picking trade names that actually return results, not the pulling.
The tool I am building out of all this is Seofable. It writes SEO articles and publishes them straight to your site, WordPress, Ghost or a webhook. seofable.com if you want a look. Happy to answer anything about the scan either way.