Time to hire by role
“calculate time to hire for each role from application date to offer accepted, and the average by department”
Calculate time to hire for each role from Greenhouse applications application date to offer accepted in Greenhouse offers, and the average by department from Greenhouse jobs.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileGreenhouse applicationsCSV export · 18 rows
- FileGreenhouse offersCSV export · 15 rows
- FileGreenhouse jobsCSV export · 10 rows
- StepKeep accepted offersStep 1
- JoinAdd accepted offer dates15 of 18 paired
- JoinAdd role and department15 of 15 paired
- StepAverage time to hireStep 4
- ResultTime To Hire by Role10 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 10 rows came out, and the join paired 15 of 18 rows; the join paired 15 of 15 rows.
- Download Greenhouse applications sample (18 rows)Greenhouse: Candidates > Export > Applications CSV
- Download Greenhouse offers sample (15 rows)Greenhouse: Candidates > Offers > Export CSV
- Download Greenhouse jobs sample (10 rows)Greenhouse: Jobs > All Jobs > Export CSV
What you get back
The result of that run, the rows to look at first.
| Role | Average time to hire (days) | Department average (days) | Department |
|---|---|---|---|
| Software Engineer | 8 | 8 | Engineering |
| Account Executive | 6.5 | 5.5 | Sales |
| Customer Support Specialist | 8.5 | 11.3 | Support |
| Product Designer | 7 | 7 | Product |
| Operations Coordinator | 9 | 9 | Operations |
| Finance Analyst | 10 | 10 | Finance |
| Marketing Manager | 7 | 7 | Marketing |
| Sales Development Representative | 4.5 | 5.5 | Sales |
| Support Engineer | 14 | 11.3 | Support |
| Data Analyst | 4 | 4 | Analytics |
How do you calculate time to hire by role?
Export your Greenhouse applications, offers, and jobs files. Mammoth keeps accepted offers, adds the accepted offer date to each application, then adds role and department from jobs and calculates time to hire. It then shows the result by role and the average by department.
How it works
How to use the Time To Hire by Role workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Time To Hire by Role: questions
Which Greenhouse export should you use?
What happens to rows that do not match?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent