Clay Icon
Join the Community
02 Support

How to Automatically Reject Duplicate and General Email Addresses for Enrichment

Avatar of Taylor R.Taylor R.
·
·

Hi there! Quick Question: How can I automatically reject enriched email addresses that are the following:

  • Duplicates (same email for more than 1 row of the company)

  • General / Shared Inboxes (Info@, Sales@, Contact@, Marketing@, Partnerships@, Hello@, etc)

When finding email addresses for 3 members of an organization, I attempted to use the "Waterfall enrichment" for email discovery. The issue was that I was clearly getting unusable email addresses (the same for all 3 contacts) OR a general one. I tried to use the Condition Formula + ai but it didn't work. Any ideas?

14 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Taylor, thanks for getting in touch! To remove duplicates you can click on the column header with the duplicate values and in the dropdown menu you'll find the "dedupe" button.Here's a quick video about deduping in Clay: https://www.loom.com/share/4d10c62c49f14df593f32012bd2c3017

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    for the catch all emails you need to specify in the waterfall settings that you don't want them, is at the bottom in the debounce section

  • Avatar of Taylor R.
    Taylor R.
    ·
    ·

    I tried writing the formula.... What should I put in?

  • Avatar of Taylor R.
    Taylor R.
    ·
    ·

    The duplicates video isn't quite relevant. I want the waterfall to continue to using the other APIs to find the right email.

  • Avatar of Taylor R.
    Taylor R.
    ·
    ·

    Juan P. Sorry Juan - can you tell me where the Debounce section is and what to put in to avoid general inboxes?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    ­

    3abc5c0f-8e40-47b8-9ac3-f1915faa38e7.png(81 kB)
  • Avatar of Taylor R.
    Taylor R.
    ·
    ·

    Is there a way of requiring each verification api to follow the same rules BEFORE getting to the point of rejecting emails altogether?

  • Avatar of Taylor R.
    Taylor R.
    ·
    ·
  • Avatar of Taylor R.
    Taylor R.
    ·
    ·

    Clay Team Juan P. I need help on very specific problem. Is there a way to remove general emails and duplicates from each step of the work email enrichment waterfall? I used Ai Condition Run Formula Generator to try and exclude general emails from the results. "Exclude general email addresses in {{list of emails}} field that contain or start with: Hello@ Info@ Mail@ Marketing@ Sales@ Support@ Community@ Help@ This would be a HUGE reduction in manual work. AND the reason for migrating our Outbound to Clay. Can someone help me?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    You can run a separate debounce verification in the first step

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    ­

    0753a9e4-a7dc-439e-a64a-b2c6102a9d41.png(80 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    ­

    5a2b47ec-e701-4bbc-9964-d118f7f31784.png(67 kB)