Hey! I’ve got a big list I want to enrich it where it only runs the co...

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 😉
Ben R.
·
https://app.clay.com/workspaces/111479/tables/t_OoE2rwDSpNJg/views/gv_9n0yRoJrVqsi##
Matthew Q.
·
Hey Ben, have you already tried our AI formula generator? https://www.clay.com/learn/how-to-use-ai-formulas
Matthew Q.
·
Actually just looked at your table a bit deeper. We’re unable to know when their start date is without enriching the profile to pull that information.
Matthew Q.
·
So in this case you’d need to enrich everyone on your list, then use AI formulas afterwards to restrict what other enrichments you run
Matthew Q.
·
An alternative would be to run the find people search based on the experience conditions - so you’d only find people in the first place that match
Mike J.
·
Matthew Q. does the above ^ "find people search" have the use case of finding people who just started their role at their current company between 0-6 months?
Loading attachments
Mike J.
·
and on a similar note, is there a way to find a person's years of experience working after enriching their personal linkedin profile? Thank you!!
Clay Team
APP
·
Hey Mike, jumping in on this. Yes, you can use the "Maximum Months in current role" and set it to 6 months to achieve this. For the second one, you can also use the formula generator, to sum up their work experience overall but if you need the sum to the same about experience in the same industry only then chatGPT would probably be better at that task
Mike J.
·
This is great. Thank you very much! Arturo O.
Arturo O.
·
Lol just realized I didn't properly edit my last sentence but glad it was somewhat understandable 😆
Mike J.
·
Arturo O. you wouldn't happen to have a conditional formula for it would ya?! 😉
Clay Team
APP
·
To sum up the total experience, sure. I'll generate a prompt to return integer years or months and post the code+prompt. Not much different than using GPT though, it comes down to playing around with the prompt lol
Clay Team
APP
·
Mike J..sum({{Enrich Person from LinkedIn Profile}}?.experience?.map(exp => exp.enddate ? moment.duration(moment(exp.end_date).diff(moment(exp.start_date))).years() : moment.duration(moment('2023').diff(moment(exp.start_date))).years()))
f359fb76-7f31-4379-b8b6-0bad72c410e9.png(29 kB)
Mike J.
·
This is incredible! Thank you VERY much!

Hey! I’ve got a big list I want to enrich it where it only runs the co...

20 comments

Hey! I’ve got a big list I want to enrich it where it only runs the co...

20 comments