How to Deduplicate Contacts While Keeping Enriched Data Intact | Clay

How to Deduplicate Contacts While Keeping Enriched Data Intact

Hi team, when deduplicating a column, is there a way to set it so that it deletes the new entries rather than older ones which have been enriched? EG - I have 100 contacts that have been enriched. I add a list of another 100 new contacts, 10 of which are are existing contacts who have already been enriched. How do I ensure the dedupe doesn't delete the 10 enriched contacts, and keep the 10 new ones which have not been enriched? Thanks in advance 🙂

6 comments

Channeled
APP
·
·
Yes, you can manage deduplication through the auto-dedupe feature. Here's how to set it up: 1. Click the Auto-dedupe icon at the bottom right of your table 2. Select "Enable automatic deduplication" 3. Choose the column you want to use for deduplication 4. Click "Save Changes"This will ensure your table maintains a unique set of records by automatically deleting duplicates. The feature helps keep your data clean and prevents spending credits on enriching the same records multiple times.Alternatively, you can manually dedupe a specific column by: 1. Right-clicking the column you want to dedupe 2. Selecting "Dedupe > Delete Duplicate Row" Sources: Auto-update and Auto-dedupe Table Auto-dedupe
Joey W.
·
·
Talk to a human please
Channeled
APP
·
·
Hi Joey W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Owen C.
·
·
Hi there! Thanks for reaching out! When using deduplication, the original value in the table is the one that will be kept. Our deduplication process works by identifying duplicates and removing them based on this rule. For example: * When a contact is uploaded, enriched, and stored in a table, and the same contact is later added again as a new entry, the most recently added version will be deleted automatically (if "Auto-dedupe" is turned on). * This ensures that the original, already enriched contact/row remains intact. Let me know if you’d like further clarification or need help setting this up!
Joey W.
·
·
Awesome, thanks Owen 🙂