what is the best way to target recent graduates in people search?
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
also is there a way to limit total months of experience in a search. Not just “max months current role”
Hey, thanks for reaching out! There isn’t a direct way to target recent graduates or limit total months of experience before the search. However, once the data is in the table, you can use a formula to calculate how long ago they graduated. For example, a formula like: “How long ago was /school in days, weeks, months.” You can then create a filter to remove rows that don’t fit your criteria. As for total months of experience, if you’re referring to how long someone has been working in total, you could apply a similar approach after the data is in the table. Use a formula to calculate their total work experience and filter the results based on that. Let me know if you need further clarification! 😊
hey Bo (., thanks for the quick response. What data would you be running the formula off of? I dont see what to use in the formula to calculate that, even on fully enriched.
Great question. Here's a video explaining how: https://cln.sh/jGThr062 Here's prompt 1: Create a formula that calculates how long ago the latest education end date was. The formula should: Find the most recent end date from the education entries /education Find the most recent education end date from the {{Enrich Person from Profile}} data. If no valid date is found, return an empty string. If a valid date is found: a. Calculate the difference between that date and today. b. Express the result in years if it's 1 year or more. c. Express the result in months if it's 1 month or more but less than a year. d. Express the result in days for any shorter period. Ensure the formula handles potential date format issues, empty values, and invalid dates. Use Clay.com's built-in date parsing and calculation functions. Format the output as a single string like "5 years", "3 months", or "12 days". And here's prompt 2: Create a formula that calculates the total work experience duration based on the earliest start date across all job experiences. The formula should: Find the earliest start date from all work experience entries listed here /experience Calculate the time difference between that earliest date and today's date Express the result in years, rounding down to the nearest whole year Return the result as a string in the format "X years of experience" Handle cases where no valid start date is found
The formula would not generate. what do you think? https://www.loom.com/share/7e91418c19ac42f8a61ecf88612b2452?sid=53571a79-71c5-4d56-9b19-e6bc263afaff
Hey there, Could you try creating this formula again? Your set up is correct, so it's possible it could've just been a lag time issue with the product. If this error is still occurring, do you mind sending the table url so we can take a closer look?
Hey Schuyler! 😊Back online - Let me know if you still need help but it should be working. It might take a little longer since the prompt is quite complex. Just give it some time, and it should eventually come through. If it doesn’t, feel free to send me the table, and I’ll gladly take the time to load it for you. Thanks for your patience! 👍
Create a formula that calculates how long ago the latest education end date was. The formula should: Find the most recent end date from the education entries Find the most recent education end date from the {{Enrich Person from Profile}} data. If no valid date is found, return an empty string. If a valid date is found: a. Calculate the difference between that date and today. b. Express the result in years if it’s 1 year or more. c. Express the result in months if it’s 1 month or more but less than a year. d. Express the result in days for any shorter period. Ensure the formula handles potential date format issues, empty values, and invalid dates. Use Clay.com’s built-in date parsing and calculation functions. Format the output as a single string like “5 years”, “3 months”, or “12 days”.
Bo (. what am i doing wrong?
what is end date on your table Bo (.
Hey Schuyler! Jumping in for Bo✨. Can you share your table url? It looks like there's an issue with how the end date field is being parsed. Happy to review the current output.
https://www.loom.com/share/97ed90a3e25b491faf01a65e5d58d956?sid=258e2178-c833-48fe-887f-bcb7ac8e77c3 recorded another loom. Arturo O. anything you can comment on here?
Hey Schuyler 😊 No need to tag everyone in this case, as this pops up in our ticketing system, so it doesn’t speed things up. Just to explain how our AI formula works—it uses an AI model to translate prompts into JavaScript, which is why it can occasionally encounter issues. I went ahead and experimented with the prompt and managed to get it working. Here’s the process I followed: 1. Tried the prompt. 2. If it didn’t work, I explained the issue to an LLM (like Claude or ChatGPT). 3. Tried the updated prompt. Either way, you now have both versions. I’d recommend copying the JavaScript and saving it for future use. It's available here;https://app.clay.com/workspaces/285280/tables/t_Fo79e5bRdnMd/views/gv_FSieCqfhaNiX https://downloads.intercomcdn.com/i/o/1193094560/deceb2e497159ad04d143488/CleanShot+2024-09-25+at+_42yO4WMmum%402x.png?expires=1727288100&signature=33eea297220da6e84dc36ec2ebc92759595803f1859ee0c554e4a52fb5f4d901&req=dSEuFcl3mYRZWfMW1HO4zSLOFLbEF3l0DQb7JaHTXtR1aXVV2ep%2FQ1T0ocPD%0A9gxR%0A Let me know if you need anything else! 😊
thanks for assisting here! “earliest” is amount of time since graduation? Experience is total time since first experience?
https://app.clay.com/workspaces/285280/tables/t_zY22FAyBMipu/views/gv_pXWm5dQZtgjr Cindy Lee - row 7 Why is it giving me 2 years for time since graduation? She graduates in 2026 I tried editing the formula, no luck.
I see you copied the prompt not the Javascript here! https://cln.sh/TzLR1PKq Here's a video showing what I did instead
Cool, I tried but didn’t know how to tweak. Will try again
Ok let me know :)!!!
im still having issues
can you check column time since graudation, idk what im doing wrong
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
can we hop on a quick call and you can show me how to save this? im going to need this on pretty much every new people table and I need an easy way to do that
Hey there! 😊 I just copied the formula again. Did it resolve the issue you noticed? If not, could you point out what still seems off? I’m happy to have someone from our team jump on a call to help, though it won’t be me personally. You can easily book a support call with our CX team here: CX Support Call 📞 Let me know how it goes!
thanks man. is there a way to easily apply this formula to people search tables?
Recorded a video for ya: https://cln.sh/lyhwmVcc
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Schuyler G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: