People and HR metrics: formulas and SQL
Metrics for hiring, turnover and workforce cost. Headcount timing (start, end or average) is the decision that changes most of these.
- Employee Turnover RateEmployee turnover rate is the percentage of employees who leave the organisation during a period.
- Employee Retention RateEmployee retention rate is the percentage of employees who stay with the company over a period.
- Time to HireTime to hire is the number of days from a candidate entering the hiring process to accepting an offer.
- Cost per HireCost per hire is the average total cost of recruiting one new employee.
- Absenteeism RateAbsenteeism rate is the percentage of scheduled working days lost to unplanned absence.
- Revenue per EmployeeRevenue per employee is annual revenue divided by average headcount, a rough measure of workforce productivity.
- Offer Acceptance RateOffer acceptance rate is the percentage of job offers that candidates accept.
- Overtime RatioOvertime ratio is overtime hours as a percentage of total hours worked, a signal of workload or staffing gaps.