Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Discuss Anything

Efficient Methods to Fetch Company IDs for Contacts | Clay

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.
Loading attachments
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/