.png){kind=logo}
what is the best way to target recent graduates in people search?
what is the best way to target recent graduates in people search?
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 (Clay), 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 (Clay) what am i doing wrong?
what is end date on your table Bo (Clay)
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 (Clay) anything you can comment on here?