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

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

Hey! I’ve got a big list I want to enrich it where it only runs the column if they’ve been in their latest exp more than 1 month but less than 6 months

20 comments

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?
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!
Clay Team
APP
·
Of course, it may not do a perfect job for everyone now that I'm checking some of my examples so it's why GPT may be a bit better at this.
Mike J.
·
yeah it's not working for me. it's breaking for some reason. Here is my table: https://app.clay.com/workspaces/48100/tables/t_tXRZq7QP73mM/views/gv_RdJw9wPxxcWe
Clay Team
APP
·
Hey Mike, sorry about that one! Will check and refresh it if I can find a better version of the formula to achieve this
Arturo O.
·
·
Mike J., I found a working formula but had to manually edit it: {{Enrich Person from Profile}}?.experience && Math.floor(moment.duration(moment("2023").diff(moment(_.minBy({{Enrich Person from Profile}}?.experience, 'start_date')?.start_date))).asYears()) The alternative to this is if you'd like to prompt it because your columns could be named something different.
1.
Create one formula column and use this prompt: "return the oldest start date from /{personsExperienceList}"
2.
Create a second formula column and prompt it to "return the number of years using the "oldest start date" column and up to the current year 2023"
Ben R.
·
·
This looks great guys, thank you