Skip to main content

Home

Clay Announcements
Clay Club Hub
Clay Cohorts
Clay Cup
Discuss Anything
Introduce Yourself
Share Jobs
Share Resources

Community Guidelines

Attend a Clay Club Event

Powered by Tightknit

Efficient Methods to Fetch Company IDs for Contacts | Clay

Discuss Anything

Discuss Anything

Efficient Methods to Fetch Company IDs for Contacts

·Dec 01, 2025 11:47 AM·

Hey everyone, I was trying to fetch company ID from a list of around 26000 companies for each contact. What would be the most efficient method to implement it ?

4 comments

· Sorted by Oldest

Stephen M.
·
·
So you have a list of 26000 companies, each with an ID, and you have a table of contacts and you want to add the appropriate company ID for each contact based on what company they're with?
Rishav M.
·
·
Yes, In contact table I've company name, I want to associate it company Id which exist in different table. These can have week association too. like Mckinsey in contact and Mckinsey & Co in Company should return me Company Id for Mckinsey & Co.
Stephen M.
·
·
Okay, so effectively a vlookup (excel) but in Clay. I haven't tried it, but you could try Clay's Lookup feature. I assume it will give you a column with the match data, and you can extract the account ID into a new column for all the matching rows. It doesn't look like it will fuzzy match (offers "equals" and "contains" operators) so I'd recommend instead of matching of company name, match the company domain but have Clay normalize the domains first.
Stephen M.
·
·
Found a great video walkthrough from Mallory Lee showing how it works: https://www.linkedin.com/posts/mallorylee_claypartner-sponsored-learnclay-activity-7301018407552851968-8GBE/