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.

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. -- https://app.clay.com/workspaces/663911/workbooks/wb_0szl0s35d2WtdcZuVsv/tables/t_0szl0uaYidfq64WzofE/views/gv_0szl0ua6easjTrXanCS

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?

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.

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.

Yes, but that depends on the publisher. Also, it won't be automatically activated for current subscriptions -- that's what someone from CF said in one of a LinkedIn thread I was going through yester night.

welcome Melanie W.! Though I don't know anyone in NEtherland that can join you on-site team but feel free to ping if you need help. Happy to share what I learned with fellow community members here.

Found another way to get the column value. Thanks