I've ran a search for open jobs in one of my tables and want to run a prompt that categorises the open jobs into three separate categories then for each, creates a job title column and a separate job description column. Please can someone from clay support look at my prompt and help me out as it's not working. Table is https://app.clay.com/workspaces/346206/workbooks/wb_GVaq7iuvx7P4/tables/t_hGSNyyojXs2m/views/gv_p44WXyFmQJ5i and the column with the formula I'm trying to run is titled "job categorization"
To categorize your open jobs and create separate columns, here's how you can set it up: 1. First, for job categorization: • Click "+ Add column" and select "Use AI" • Choose "Content creation, manipulation, and categorization" for the use case • In the prompt settings, define your three categories and their corresponding keywords using the Categories & Keywords object format 2. For job titles and descriptions: • Create separate columns using "+ Add column" • Use the AI feature to format and extract the specific information • For job titles, you can include formatting rules in your prompt to ensure consistency If you'd like me to help troubleshoot your specific prompt, please share the current prompt you're using and I can provide more targeted guidance.
Did that answer your question?
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
This is the current prompt I'm using: Extract job postings from the column in the Clay table. Each entry contains a job title and description. Categorize and output relevant jobs based on the following priority order: AI or Machine Learning roles – If the job title contains "AI" or "Machine Learning," store the job title in and summarize the job description in (max 50 words). Data Engineer or Data Scientist roles – If the job title contains "Data Engineer" or "Data Scientist," store the job title in and summarize the job description in (max 50 words). Engineer or Developer roles – If the job title contains "Engineer" or "Developer," store the job title in and summarize the job description in (max 50 words). Rules: If a job fits multiple categories, assign it to the highest priority. Discard any job listings that do not match the above categories. Ensure all job descriptions are summarized into 50 words or fewer. Desired Output Format (Separate Columns for Each Priority): /AI_ML_Job_Title | /AI_ML_Job_Description /Data_Job_Title | /Data_Job_Description /Engineer_Developer_Job_Title | /Engineer_Developer_Job_Description Only include jobs that meet the criteria—irrelevant listings should be excluded.
Hey Mark - I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/mJ6JKg33 Let me know if you have any follow-up questions!
Thanks a lot for your help Bo! I just went through the video and ran the columns, they're all working fine
Hi Bo (., I've tried to make an addition to that column but am not sure if I got it right. I've saved it but not ran it, the addition is the SRE job title and description. I tried to create another column from the command like you did, but for some reason it hasn't given me that option so I've reverted to creating new columns and trying to write to them. If you can let me know if and where I've gone wrong, it'll be much appreciated.
Hey Mark, thanks for following up on this. It looks like a few of the original "find jobs" columns have been deleted, so when the "Job Categorization" AI column tries to run, it can't refer to them. https://app.clay.com/workspaces/346206/workbooks/wb_GVaq7iuvx7P4/tables/t_hGSNyyojXs2m/views/gv_p44WXyFmQJ5i As a starting point, you'll want to confirm that you have all the relevant "find jobs" columns in place. Then, return to the prompt to update/remove, so that the prompt can work with the correct data.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.