Recipe: weekly hiring signals in a Clay table (new and closed roles per company) If you score accounts on hiring, the useful signal is change: which companies just opened roles for the team you sell to. Here's a setup that gives one row per company with new and closed roles since last week, read live from the company's own career board (Greenhouse, Lever, Ashby, Recruitee, Personio). Step 1: Add an enrichment column, search "Apify" and pick Run Apify Actor. Step 2: Actor: longlever/ats-jobs-feed Step 3: Input JSON (Domain is your column): { "companies": [#{{Domain}}], "mode": "signals", "keywords": ["data"] } Drop "keywords" to count every role, or set it to the function you sell to. Step 4: Map the output fields you want: open_roles, new_roles_count, closed_roles_count, net_change, hiring_velocity_30d (roles posted in the last 30 days), top_departments, new_roles. Step 5: Re-run weekly. The first run is a baseline; from the second run on you get new and closed counts. What it looked like this week: → OpenAI: 805 open roles, 217 posted in the last 30 days, mostly Go To Market and Applied AI → Stripe: 740 open, 233 in 30 days, 71 in the last 7 → Airbnb: 210 open, 98 in 30 days, led by Software Engineering → Linear: 31 open, 10 in 30 days, none in the last week Cost on Apify is $0.002 per company per run (about $9 a month for 1,000 accounts checked weekly). Companies on Workday or SmartRecruiters come back as "no supported board" and aren't charged. Disclosure: I built the Actor. Happy to add fields if something's missing for your scoring.
