Generating a List of People Based on Addresses and Title Criteria: Looking for Feedback and Direction

Andrew T. · 2024-02-09 19:06:22.448446+00

Hey Clay team -- I'm coming back to a challenge that I've struggled to solve and would love feedback or direction. I have a list of addresses of businesses (commercial offices, universities, etc.). What I'm trying to do is generate a list of people who work at those addresses and meet certain title criteria. I have the title criteria dialed in, but starting from addresses and finding people based on that is where I'm stumped. Would love to hear any ideas!

Generating a List of People Based on Addresses and Title Criteria: Looking for Feedback and Direction | Clay

Andrew T.
·
·
No table yet! 🙂 I can easily set up a sample of addresses, though.
Clay Team
APP
·
·
Hey there Andrew sorry for the delay, thanks for reaching.
Clay Team
APP
·
·
In "New Table" you can use the Location filter to narrow search area down to Cities, Staes, and Countries. Unfortunately using specific address isn't an option. But from there you can enter in the rest of your criteria and see if you get any hits.
Andrew T.
·
·
Thanks LuisArturo -- Interesting. If I narrow the results to a city (or set of cities), can I reverse enrich the contacts for address where they work?
LuisArturo
·
·
Hmm that's an interesting idea, let me test it it to see if there's a way to make that work
Andrew T.
·
·
Thank you!
Clay Team
APP
·
·
So yes this can be done, Here is a Loom that shows how you can do this. https://www.loom.com/share/03be6291a3de4a829062374bf2f75b22
Andrew T.
·
·
LuisArturo -- This is great! Thank you for working on this. In your example, row 8 is a common scenario for what I am running up against. The person is in San Francisco, put on the company LinkedIn enrich, the address pulled is New York. Ideally, I'd like to get the company location in the city (or closest to) the city where the person is located. In my scenario, it's common for the people I'm looking for to be employed by large, national facility services companies but work at a specific location in or near their city. Any thoughts on this?
Clay Team
APP
·
·
Yes here is a follow up loom, simply because its easier to explain through video rather than typing it out. https://www.loom.com/share/f18c677263c34b1ab8f50b73acebd71b
Andrew T.
·
·
Thanks for the help on this. I'll give this a try and see what I come up with!
Andrew T.
·
·
Okay LuisArturo... I've had a chance to play with this. The challenge I'm running into is the variable number of locations for the company. I'm trying to do this at scale, so I don't want to scrub through each row. So, I tried using a Claygent prompt to help determine the correct address from the list. This is proving to have inconsistent results. Do you have any ideas on how I might be able to do this? Here's my table: https://app.clay.com/workspaces/10648/tables/t_KDC18qjNakIj/views/gv_YJUnSyaaNLDz In the "Addresses Found" view, the first row is a good example of what I'm working through.
Clay Team
APP
·
·
Hey there Andrew sorry for the delay taking a look.
Andrew T.
·
·
No worries! Thanks for the help.
Clay Team
APP
·
·
Hey Andrew so I spent some time reworking the prompt and the one I ended up with, looked to have an accuracy around 90%. I ran it with about 25 of your rows and the only one with some questions was the first one. I also refunded you the credits used during testing
Andrew T.
·
·
Thanks! I'll take a look!

29 comments