Preventing Repeated Enrichment on the Same Domain in Ask AI Enrichment for Find People Table | Clay

Preventing Repeated Enrichment on the Same Domain in Ask AI Enrichment for Find People Table

Trying to write a conditional formula that prevents the Ask AI enrichment in a Find People table from running multiple rows with the same domain (company). Specifically: I have 3 prospects at a company and will use the Ask AI output to personalize an email to these prospects (at the same company). I only need the company-specific output once, because it applies to all 3 prospects. Not sure how to accomplish this through the conditional formula - screenshot attached of my attempt!

✅1

10 comments

Joe H.
·
·
https://app.clay.com/workspaces/192229/tables/t_ZI9BxJGHkunj/views/gv_NmMOV4p7nJWW
Clay Team
APP
·
·
Hi Joe, thanks for getting in touch! In this case I would create another identical table throught a csv import export, dedupe all the domains, use Ai to create the message, and then through a lookup function input all the messages in the original table based on the domain: Here's a video and our docs page for Lookup Record!
Joe H.
·
·
Juan P. Arturo O. Thanks team - is there an easy way to dedupe strings (cells) in a column in my Clay table? I know a function exists for multiple strings in a single cell, but I’m looking to remove duplicate unique strings in a column. For ex: Company Column:
Adobe
Workday
Adobe
…and so on
How would I go about efficiently removing the excess Adobe strings? Can do this in Excel too, just wondering if possible in Clay right now (Airtable has this function on their paid plans fwiw 😄)
Clay Team
APP
·
·
Hey Joe!! Yes, are these comma-separated strings? We have a Normalize and dedupe integration or you can also ask the formula generator in a new column to clean that up for you :)
Clay Team
APP
·
·
I personally use the formulas a lot more but this is the integration that could help too
d7cc0d40-bf89-4c8f-aa01-a07fe5b42782.png(15 kB)
Joe H.
·
·
Hey Arturo O. Thanks for following up here. I’m still not totally clear on how to accomplish this in a Clay table - maybe I’m using the formula incorrectly? Attaching this Loom for crystal clear context:
Joe H.
·
·
https://www.loom.com/share/e8894b4379f84ae89eee1d14699b31e8?sid=f489f1ff-05b5-4802-be9f-d900dc26be5a
Clay Team
APP
·
·
Thanks for the video, Joe! It came down to us not understanding or misunderstanding what you wanted to achieve here. 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
Clay Team
APP
·
·
Joe H., let me know if you have additional questions or if you run into other issues!
Joe H.
·
·
Arturo O. you guys are the best. * facepalm * this was way simpler than i thought!