Join the Community

Automating Clay Table Updates for Job Openings in HR Recruitment

·

·

Is there a way to update the Clay table whenever there are new job openings in my target list of companies? I want to create an evergreen outbound campaign which will run 24X7X365. The aim is to reach out to companies that are hiring for some specific roles in the Netherlands. We are an HR recruitment firm and want to reach out to companies with more than say X number of openings (we have specific job roles that we help with recruiting). So far I’m able to build a static table which is working fine but what to do in-order to automate it. A few issues I’m facing:

1.
The list of companies is huge-20k+, and refreshing it everyday is going to be expensive.
2.
I couldn’t find a way to ascertain if there are new openings in a company using the current enrichments. The one I can use gives a number but the problem is that using that enrichment is going to be super costly as per #1. Also, since it is going to update the same cell, I’m not sure how I will find if there are new openings in a company. I may have to use Clay Formulas but not sure if they are going to be effective. So, how could I automate finding new openings in these companies?

13 comments

Clay
APP
·
·
For your evergreen job tracking campaign, use the Find Jobs Enrichment on your company list with these cost-effective strategies: Setup: 1. Add Find Jobs Enrichment to your companies table - it pulls from PredictLeads, Google Jobs, and our native database 2. Filter by job keywords for your specific roles 3. Set up Auto-Update to automatically process new data Cost Management: ** Use scheduled columns to refresh data at custom intervals (weekly/monthly vs daily) ** Only refresh companies that haven't been enriched recently by setting a "Last Enrichment Date" filter Detecting New Openings: ** Store previous job counts in a separate column ** Use Clay formulas to compare current vs previous counts * Only trigger outreach when count increases significantly (your X threshold) This approach minimizes credits by refreshing strategically while maintaining automation for your 20k+ company list.
Sources: Find Jobs Source + Enrichment [Clay 101] - Clay University Find Jobs Source + Enrichment [Clay 101] - Clay University Keeping your CRM Up to Date With Clay [CRM Enrichment] - Clay University
Nitin B.
·
·
No, I think this still is very costly cause I have multiple tables with 20k+ companies (3 in total as of now) and refreshing them once gonna consume 60k+ credits in a month. I don't see the ROI of building this on Clay. I want to build a setup wherein I get to know when a new company opens job and it get added to Clay and then the enrichment do its work next.
Nitin B.
·
·
May be the last enrichment date function can help me a bit but not sure how good it is going to be. I know how this can be done on Clay very well. I have a static table already. I just want to find a cost effective way to do this monitoring.
Gabe E.
·
·
Hi Nitin, Can you send along the link (url) to the table/what you have so far so we can take a look?
(52 kB)
Nitin B.
·
·
Hi Gabriel, I figured how to do this without wasting a lots of credits. Next I'm stuck at is how to find there is a net new increase in the new job openings because every time the enrichment schedule will run, it is going to update the same column. One solution is to keep another column with past data and then use formula to calculate if the number increased. But there is a problem as well as the information in the second column will become stale after a month and I will always be subtracting from an old number which might not be true. How to solve this? Also can I run this enrichment on Find Company table instead on Find People at Company table and then sync the values from Find Company Table with Find People at Company table? Is it possible?
Gabe E.
·
·
Hi Nitin, I'm so glad you were able to find a fix here! Do you mind sharing the table so I can look where you're already building? Gabe
Bittu
·
·
Hey Nitin, I can build a custom solution for you here, DM me if that sounds interesting.
Nitin B.
·
·
Gabe E. -- https://app.clay.com/workspaces/663911/workbooks/wb_0szl0s35d2WtdcZuVsv/tables/t_0szl0uaYidfq64WzofE/views/gv_0szl0ua6easjTrXanCS
Gabe E.
·
·
Hi Nitin! Thanks for reaching out. We can definitely help you with this workflow! To start, I'd run a "Find Jobs at these companies" source on a schedule using your original company list (video here). Using as a source will create a new table and avoid the cell limit payload issue. Please let me know if this will work for you and how else I can help here! Gabe
Nitin B.
·
·
Gabriel the problem is that every time the enrichment schedule will run, the same companies will get qualified and will get pushed to outreach. I want to setup some guardrails like I want to check the delta in new jobs this month vs previous month, and then run the outreach. Because it can happen that a company may keep opening new job posts and we will setup multiple sequences for them. I hope I am making sense here. So in a way, I want to have three columns, one running enrichment on schedule (# job counts) and one having data of the last enrichment run (# previous job counts) and a third column Delta. I don't know how to go about it. Also if there is an alternative please let me know. I want to run an evergreen OB campaign. This gonna be 100% automated.
Gabe E.
·
·
Hi Nitin, running the Find jobs off the company table should work. It wont add in old data. Even if it finds old responses, those won't be added in. You can turn on the auto de-dupe on the job link urls as another failsafe. Also, this initial find jobs search will be free! Gabe
Nitin B.
·
·
Hi Gabriel, the Find Job feature isn't gonna work because I want to only reachout to companies with more than 3 openings. This part is sorted. I will use another enrichment and that works fine. My problem is calculating delta. The net new job addition every month or fortnight.
Bo (.
·
·
Hi Nitin, Here’s a Loom that walks through how to set this up: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7 You can use a lookup to pull in the previous job count and then compare it to the current count. This will let you calculate the delta and set conditions for outreach only when the net new openings meet your criteria. Let me know if you have more questions.

Automating Clay Table Updates for Job Openings in HR Recruitment | Clay