I have a table with a column called company name using this column I want to find company domain main seems very simple but I’m finding it really complicated. I use an AI enrichment to find company domain so I can use some context about the type of companies I’m looking for. but because the same company appears many times in the column I’m trying to be efficient with using my credits by not searching for the same company name multiple times. I’ve done this before by sending the rows to another table, de-dupe them do the domain search and then push them back to the original table but this is not working anymore
You can efficiently find company domains while avoiding duplicate credit usage by deduplicating your company names first, then enriching the unique companies. Method 1: Direct deduplication in your table Click your company name column header and select "Dedupe" from the dropdown. This removes duplicates directly in your current table. Method 2: Transfer to another table Use the "write to table" integration to transfer your company column to another table, then run deduplication there. After enriching the unique companies with domains using Clearbit's Company Name to Domain integration, you can pull the domain data back to your original table using linked tables functionality. For domain enrichment, use the Clearbit integration which takes company names as input and returns domains, logos, and other company data.
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 Clay Support.
