.png){kind=logo}
Avoiding Duplicate Company Enrichment in Contact Lists
Hey, How can we avoid enriching the same company multiple times when we have a list with several contacts who potentially work at the same company?
Hey, How can we avoid enriching the same company multiple times when we have a list with several contacts who potentially work at the same company?
To avoid enriching the same company multiple times when you have a list with several contacts from the same company, use Clay’s linked tables feature: ** First, enrich your companies in a dedicated "Find Companies" table. ** Clay automatically links your "Find Companies" table to your "Find People" table. This means you only need to enrich each company once. ** In your "Find People" table, use a lookup column to pull company attributes (like tech stack, revenue, etc.) from the enriched company data. This way, all contacts associated with the same company will reference the same enriched company record, saving credits and preventing duplicate enrichments. ** If you update or add new details to your company table later, rerun the lookup column in your people table to sync the latest information. This approach ensures you enrich each company just once, and all related contacts benefit from that enrichment automatically.
what about if you have already a google sheet with all the information contact & company in the same sheet?
If your Google Sheet contains both contact and company information in the same sheet, you can avoid enriching the same company multiple times by first deduplicating the company data before enrichment. Here’s a recommended approach: ** Import your sheet into Clay and create a separate table for companies by extracting unique company identifiers (like domain or company name). ** Enrich the companies table once, so each company is only enriched a single time. ** Link your contacts table to the companies table using a lookup column. This allows you to pull enriched company data into each contact row, ensuring all contacts from the same company reference the same enriched record and you don’t use extra credits for duplicate enrichments. ** If you update or add new company data, rerun the lookup in your contacts table to refresh the information. If you need to display only one row per company or set up conditional enrichments, you can use formulas and lookups as shown in this video guide.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.