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?
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
Hey Stefano, the duplication was based on the domain. almost every company has 3 duplicates with every row being identical
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Mahmuda C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
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
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
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.