Menu

How to find local businesses with no website (a lead list for web designers)
📰

How to find local businesses with no website (a lead list for web designers)

DEV Community: webdev·Catalin Friptu·6 days ago
#KCsynb8i
#devtowebdev#devto#dev#city#name
Reading 0:00
15s threshold

If you build websites for small businesses, the best prospects are the ones that don't have a website yet: a dentist with only a phone number on the map, a salon that lives on Instagram, a restaurant whose domain expired two years ago.

Here's how to build that list for any city from OpenStreetMap, for free, plus the three traps that make most "no website" lists useless.

Step 1: query OpenStreetMap with Overpass

OpenStreetMap stores businesses as tagged objects: amenity=dentist , shop=hairdresser , amenity=restaurant , shop=car_repair , and so on. Many have phone , email , opening_hours , and sometimes website . The Overpass API lets you ask for "dentists in this city with a name but no website tag":

[out:json][timeout:60]; area["name"="Graz"]["boundary"="administrative"]["admin_level"="6"]->.city; nwr["amenity"="dentist"]["name"](area.city)[!"website"][!"contact:website"]; out center tags;

Enter fullscreen mode

Exit fullscreen mode

Paste it into overpass-turbo.eu , press Run, and export the result.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.