Clay Icon

Avoiding Enrichment on Duplicates: A Template to Automate Deduplication

·
·

is there another way to avoid running enrichment on duplicates as a templated formula that stays on my table, instead of having to remember to manually run "dedupe" everytime?

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    I don't want to enrich the company "ecocareers" (duplicate) or any other duplicates that are added to this table in future

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Nick S., taking a look!

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    any guidance on how to run a formula that only enriches if the values are unique?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Nick S., the reason why ecocareers showed up twice in this job search is because those are 2 slightly different job listings (even thought they're from the same company)

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    can you check my formula?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Yes! Based on your description of the formula, it seems to be returning appropriate results in the discard/continue column. Can you describe what the intention of your formula is so I can help you implement it?

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    never mind I managed to figure it out

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    but the follower count isn't pulling through, can you check it out?

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    hey it seems like even when I include quotation marks around a keyword clay still identifies a match when the keyword is included in a word, example: "match" --> matching

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    "search" --> research

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Nick S., sorry for the delay here -- taking another look

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    For the follower count, it is likely because LinkedIn has restrictions on scrapers and we don't use your personal LinkedIn cookie -- this is to protect your privacy & security (accounts have been banned for violating this in the past)

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    For your conditional formula, it sometimes helps to add the word "exact" in the description -- for example, discard if the word is ​_exactly _​"match" (this doesn't include matching). I attempted adding this to your formula -- let me know if it helps:)