Issues with Duplicate Companies in Lookalike Query Results

·Jun 24, 2025 01:12 PM·

Hi. I just tried running a query to find lookalike queries based on a table of target companies and individuals. I was expecting Clay to skip duplicate companies (eg, where I've got 3 individuals in one company, but the company domain I'm searching on is the same in each row), but this doesn't seem to have happened?

1 comment

· Sorted by Oldest

Channeled
APP
·
·
Company lookalike integrations don't automatically deduplicate based on company domains - they process each row independently. When you have multiple individuals from the same company, each row generates its own set of lookalikes. To avoid duplicates, use our Lookup integration to check for existing records across tables before running lookalikes. You can also use "write to table" to consolidate results and remove duplicates after processing. Consider running lookalikes on a deduplicated company list first, then use "write to table" to expand the results.
Sources: Find Your Next Customer with Company Lookalikes - Clay University Write to Table [Clay 101] - Clay University

Channeled
APP
·
·
Company lookalike integrations don't automatically deduplicate based on company domains - they process each row independently. When you have multiple individuals from the same company, each row generates its own set of lookalikes. To avoid duplicates, use our Lookup integration to check for existing records across tables before running lookalikes. You can also use "write to table" to consolidate results and remove duplicates after processing. Consider running lookalikes on a deduplicated company list first, then use "write to table" to expand the results.
Sources: Find Your Next Customer with Company Lookalikes - Clay University Write to Table [Clay 101] - Clay University