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?

14 comments

Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_8ONS8hJBtbHF/views/gv_v9l4RjsMIPZU
Nick S.
·
·
I don't want to enrich the company "ecocareers" (duplicate) or any other duplicates that are added to this table in future
Clay Team
APP
·
·
Hi Nick S., taking a look!
:thumbsup_all:1
Nick S.
·
·
any guidance on how to run a formula that only enriches if the values are unique?
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)
Nick S.
·
·
can you check my formula?
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?
Nick S.
·
·
never mind I managed to figure it out
Nick S.
·
·
but the follower count isn't pulling through, can you check it out?
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
Nick S.
·
·
"search" --> research
Clay Team
APP
·
·
Hi Nick S., sorry for the delay here -- taking another look
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)
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:)

Avoiding Enrichment on Duplicates: A Template to Automate Deduplication | Clay