Clay Icon

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 ๐Ÿ™‚

  • Avatar of Channeled
    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

  • Avatar of Joey W.
    Joey W.
    ยท
    ยท

    Talk to a human please

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Joey W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    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!

  • Avatar of Owen C.
    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!

  • Avatar of Joey W.
    Joey W.
    ยท
    ยท

    Awesome, thanks Owen ๐Ÿ™‚