Finding People Using Apollo with Clay and Excluding Lists

·

Hello Team, I'm trying to find people using Apollo with Clay, and any way I can exclude different lists (our past clients and our block list)

8 comments

Harvey L.
·
·
https://app.clay.com/workspaces/134116/tables/t_M3VfJE2Pipfl/views/gv_bWvOlKEQsNGV
Harvey L.
·
·
The way i'm thinking right now is adding the 2 list as 2 seperate columns, and have a run condition be: only run if not contain domain from /blocklist and /pastclients
Harvey L.
·
·
also anyway to change the store leads filter at the start of the table as the source? or would you have to do a whole new table?
Clay Team
APP
·
·
Hi Harvey L., sorry for the delay here
Clay Team
APP
·
·
The best way to exclude certain leads if you already have a list of the ones you don't wish to include is by creating a separate clay table/google sheet containing those leads and running the Lookup Record function to find matches between your work table and your "do not contact" list. I'm attaching a helpful video for implementing that here: https://www.loom.com/share/80d613c10d5248f6bfc662cc95c8023d
Clay Team
APP
·
·
And here's further insight on the Lookup Record function: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656
Clay Team
APP
·
·
Unfortunately you can't "rerun" your original search but it is possible to run another store leads search within the same table by navigating to 'Import' in the bottom left corner and then choosing which search you would like to run (which can be the store leads one) and it will check for duplicates on your table before adding the new finds onto the same table
Clay Team
APP
·
·

8c6ff6d4-cb1d-449f-97a0-f6ade4bc5088.png(382 kB)