Duplicate Rows Issue on Find People Search

Andrew T. · 2024-03-01 19:45:58.569048+00

Clay team - I'm running into a scenario where I'm seeing a number of duplicate rows on a find people search. Would you mind taking a look?

Duplicate Rows Issue on Find People Search | Clay

12 comments

· Sorted by Oldest

Andrew T.
·
·
I opted to add a couple of waterfalls, so I'm not sure how many dupes there are or what this will do for credits... 🙂
Andrew T.
·
·
https://app.clay.com/workspaces/10648/tables/t_5gFG6Wd46zOY/views/gv_LYHaZBYZH0hY
Andrew T.
·
·
Looks like the same issue applies to this table as well: https://app.clay.com/workspaces/10648/tables/t_994fhIw1Iud8/views/gv_fjvPcHR2mCtY
Clay Team
APP
·
·
Hey there Andrew sorry for the delay taking a look.
Andrew T.
·
·
No worries. Thanks!
Clay Team
APP
·
·
So if you want to remove duplicates what you can do is click on the LinkedIn URL column header and menu will pop up. There will be an option called "Dedupe" this will remove any duplicate profiles.
Andrew T.
·
·
Is there a way to prevent duplicates from being imported in the first place?
Clay Team
APP
·
·
Hey Andrew! I see you're in a grandfathered plan but maybe we can help out here. Of course, most of the new features get auto-enabled with the active plans so perhaps that's why you didn't see it here, where you can now exclude lists from searches.
4666eddd-098a-419e-a130-b7bdd2c71b2f.png(18 kB)
Clay Team
APP
·
·
Took a quick look and seems like you do have it though, so that would be the feature to use to prevent adding duplicates to an existing table.
Andrew T.
·
·
I'm referring to preventing duplicates on the find people action within the same table (not between tables. Is this a bug that the same linkedin profiles are pulled in in duplicate within the same find people action in the same table?
Clay Team
APP
·
·
Got it! Yes, there are some edge cases where a profile was either scraped twice for some reason or the person had two profiles but the provider still added them.
Clay Team
APP
·
·
The team is already testing the auto-dedupe feature which will remove them, but it's in beta so we're just waiting for the full test to be completed which should help soon after with those.
👍1

Andrew T.
·
·
I opted to add a couple of waterfalls, so I'm not sure how many dupes there are or what this will do for credits... 🙂
Andrew T.
·
·
https://app.clay.com/workspaces/10648/tables/t_5gFG6Wd46zOY/views/gv_LYHaZBYZH0hY
Andrew T.
·
·
Looks like the same issue applies to this table as well: https://app.clay.com/workspaces/10648/tables/t_994fhIw1Iud8/views/gv_fjvPcHR2mCtY
Clay Team
APP
·
·
Hey there Andrew sorry for the delay taking a look.
Andrew T.
·
·
No worries. Thanks!
Clay Team
APP
·
·
So if you want to remove duplicates what you can do is click on the LinkedIn URL column header and menu will pop up. There will be an option called "Dedupe" this will remove any duplicate profiles.
Andrew T.
·
·
Is there a way to prevent duplicates from being imported in the first place?
Clay Team
APP
·
·
Hey Andrew! I see you're in a grandfathered plan but maybe we can help out here. Of course, most of the new features get auto-enabled with the active plans so perhaps that's why you didn't see it here, where you can now exclude lists from searches.
4666eddd-098a-419e-a130-b7bdd2c71b2f.png(18 kB)
Clay Team
APP
·
·
Took a quick look and seems like you do have it though, so that would be the feature to use to prevent adding duplicates to an existing table.
Andrew T.
·
·
I'm referring to preventing duplicates on the find people action within the same table (not between tables. Is this a bug that the same linkedin profiles are pulled in in duplicate within the same find people action in the same table?
Clay Team
APP
·
·
Got it! Yes, there are some edge cases where a profile was either scraped twice for some reason or the person had two profiles but the provider still added them.
Clay Team
APP
·
·
The team is already testing the auto-dedupe feature which will remove them, but it's in beta so we're just waiting for the full test to be completed which should help soon after with those.
👍1