Format: Excel
Who is it for?
- ABA Business Owner or Business Operations Manager
- HR Manager
What is it for?
What does it include?
- It has three major spreadsheets and a sample for each spreadsheet to illustrate the data analysis.
Recruitment Stats: This tab tracks the number of applicants and candidates progressing through the hiring process. It automatically generates graphs showing monthly applicant volume and an overview of offers extended each month, providing visibility into recruitment trends and pipeline activity.
Separation Stats: This tab tracks monthly separations, recording both employment length and reasons for each. It generates analyses and graphs displaying monthly separation counts, distributions of separation reasons, and insights into separation patterns by tenure group.
Workforce Analytics: This tab tracks new hires and separations to calculate net headcount changes. It also computes monthly and annual turnover rates and generates graphs to visualize workforce trends and overall staffing stability.
HR KPI Recruitment and Separations
This spreadsheet is provided as a tool to support tracking and analysis of client pipeline and flow within ABA services. It is intended for informational and administrative purposes only and does not constitute clinical, financial, or legal advice. Users are responsible for verifying the accuracy of the data they enter and for making business or clinical decisions based on their own professional judgment. The creator of this spreadsheet is not liable for any errors, omissions, or outcomes resulting from its use.