Home
Events
Groups
Members

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

University
Clay live events

Powered by Tightknit

Understanding Lookalike Table Results with Ocean.io: De-Duplication Insights

·

·

Hey, I recently created a lookalike table with ocean.io. Got about 1100 accounts. But after de-dupe, only 300 accounts remain. Is this a glitch or is this how lookalike works?

Understanding Lookalike Table Results with Ocean.io: De-Duplication Insights | Clay

7 comments

· Sorted by Oldest

Stefano
·
·
Hi Mahmuda, Thanks for reaching out! The issue you’re experiencing could be due to deduplication being applied to the wrong column. If the auto-dedupe feature isn’t set to use a unique identifier like the domain, it might be removing two entries that are actually the same. To better understand what’s happening, could you please share the link to the table so we can take a closer look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732026600&signature=d2bb8e213dcf35f1a4ee7e4192c6711ca33d6fc3750d896ddf9f6c0760babe65&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn8BJEQ2BKsam%2FhVPs1Vw%3D%3D%0A
Mahmuda C.
·
·
Hey Stefano, the duplication was based on the domain. almost every company has 3 duplicates with every row being identical
Stefano
·
·
Hi Mahmuda, it seems that ocean.io might be retrieving the same company. I would suggest trying to import the companies without the autodedupe feature and see if that is the case!
Channeled
APP
·
·
Hi Mahmuda C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Mahmuda C.
·
·
Hey sorry for the delayed reply. Like you said, Clay gave multiple duplicate rows - more than 600. I would like to get the credits I spent on them back. let me know. Thanks
Stefano
·
·
Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732644000&signature=72b71ea73d1d1a81e8d92951df1fe23a32d90acd7689cbd59254f13a360095ef&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn6ApMW2BKsam%2FhVPsm9A%3D%3D%0A
Channeled
APP
·
·
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.