Merging and Filtering Multiple Architect Contact Tables in the UK Using Clay

·

I've created multiple tables looking for Architects in the UK, how do I merge all of these tables containing Architect contacts and use Clay to only find new contacts (So I don't use credits finding the same ones twice)? Many thanks in advance.

✅

1

10 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Adam Randall
·
·
https://app.clay.com/workspaces/49783
Nikhil Bajaj
·
·
curious about the finding only new people part, following
Clay Team
APP
·
·
Hey there Adam sorry for the delay. Quick question for clarification are these tables are in CSV form?
Adam Randall
·
·
The last table is a CSV of everything I've pulled from Linkedin so far (master)
Clay Team
APP
·
·
Hey Adam! Happy to check it out... So, if you already have a master list you compiled into one Clay table after getting the CSVs, you could run additional searches and then cross-match against this bigger list with the Lookup Record integration to remove any duplicates/found matches before you enrich for more information.QQ, are you finding them on LI or where are you sourcing these people?
Adam Randall
·
·
All from LinkedIn. How do I cross-ref in Clay and exclude from find work email recipe?
Clay Team
APP
·
·
Currently, not possible to run a search and exclude existing lists of people but the team is working on that implementation soon. If you generate a new query and import another batch of contacts, the Lookup Record integration can help with that cross-match. Here's a video and our docs page for Lookup Record!
Clay Team
APP
·
·
I'd suggest using the person's LI URL to find a match though, that way you can save credits and remove people before further enriching only the new ones.
Adam Randall
·
·
Perfect, thanks Arturo (Clay)

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Adam Randall
·
·
https://app.clay.com/workspaces/49783
Nikhil Bajaj
·
·
curious about the finding only new people part, following
Clay Team
APP
·
·
Hey there Adam sorry for the delay. Quick question for clarification are these tables are in CSV form?
Adam Randall
·
·
The last table is a CSV of everything I've pulled from Linkedin so far (master)
Clay Team
APP
·
·
Hey Adam! Happy to check it out... So, if you already have a master list you compiled into one Clay table after getting the CSVs, you could run additional searches and then cross-match against this bigger list with the Lookup Record integration to remove any duplicates/found matches before you enrich for more information.QQ, are you finding them on LI or where are you sourcing these people?
Adam Randall
·
·
All from LinkedIn. How do I cross-ref in Clay and exclude from find work email recipe?
Clay Team
APP
·
·
Currently, not possible to run a search and exclude existing lists of people but the team is working on that implementation soon. If you generate a new query and import another batch of contacts, the Lookup Record integration can help with that cross-match. Here's a video and our docs page for Lookup Record!
Clay Team
APP
·
·
I'd suggest using the person's LI URL to find a match though, that way you can save credits and remove people before further enriching only the new ones.
Adam Randall
·
·
Perfect, thanks Arturo (Clay)