Logan C.

I figured it out, thanks Hari K.

There is not a specific table yet as I need to find people from these places and that will be the starting point.

Municipalities? Are you sure? The vast majority of these aren’t selectable. List:

Also, the Google Maps integration doesn’t allow the granular location search FYI. The search returns far fewer results (~20 vs 300) when I try to use free text “roofing companies servicing any of the following cities: [list above]” instead of using radius + business type

The main issue is that many (seemingly around half) of these companies are returning no contacts using the Clay web scraper. Also, the Google Maps integration isn’t populating any info to other columns (name, location, etc). See screenshot attached. How do I resolve this?

Hi Gabriel, https://app.clay.com/workspaces/611783/workbooks/wb_0swmwr2sZpTjfn6QWxR/tables/t_0swmwr3DTy8gnrj5UfV/views/gv_0swmwr4nSxr3qTpEpwC is the draft table

Hi LuisArturo and Munnawar H., Thank you both for the help here and thanks LuisArturo for the Loom — really appreciate it. What you walked through aligns with what I was doing the other day, so it’s a great sanity check. Different question: I’m trying to filter businesses by specific towns in the South Bay Area (listed below), but when I use Clay’s location filter, it only seems to allow larger cities from some preset database — I’m only seeing San Jose and Santa Clara as options. Is there any way to apply more granular location filters, such as by ZIP code?

Munnawar H. thank you for your response. Yes that is correct. I am trying to figure out which enrichments to use/the different ways to accomplish this. 1 would not work because I am trying to use Clay to find their names. 2 would not be applicable because target prospects do not use such platforms. 3 seems most viable and I am trying to figure out the most effective/efficient way to do this but could use some help here. Are any other ways to do this? Any business/people directories I could search?