Recruiter analytics

Hi there!

It sounds like you’re on the right track with your spreadsheet! Here are a few metrics and methods you can use to analyze your recruiting performance:

1. Conversion Rates:
2. Application to Interview Rate: (Number of candidates interviewed / Number of applications received) x 100
3. Interview to Offer Rate: (Number of offers made / Number of candidates interviewed) x 100

4. Offer Acceptance Rate: (Number of offers accepted / Number of offers made) x 100

5. Time-to-Fill:

6. Track the number of days it takes to fill positions. You can calculate this as:

7. Average Time-to-Fill = Total number of days to fill positions / Number of positions filled.

8. Quality of Hire:

9. This can be assessed after a candidate has been in the role for a certain period. Collect feedback from hiring managers on candidate performance, retention rates, and overall satisfaction.

10. Screening Quality:

11. You can calculate the screening quality by determining the percentage of candidates who progressed through to the next stage in the recruitment process.

12. For example, if you interviewed 10 candidates and 3 were good enough to get offers, your screening quality would be (3/10) x 100 = 30%.

13. Diversity Metrics:

14. Track the diversity of your candidate pool and hires to ensure you’re reaching a wide audience.

15. Source of Hire:

16. Analyze which sources yield the highest quality candidates.

17. For each source, you could calculate the percentage of candidates who became hires.

18. Trend Analysis:

19. Analyze your performance trends over months – Are your conversion rates improving? Is your time-to-fill decreasing? This can help identify areas for improvement.

Here’s a simple way to start implementing this in your spreadsheet:

• Create a new sheet for your metrics.
• Use formulas to calculate the above metrics using your existing data. For example, to calculate the application to interview rate, you could use the COUNTIF function to count the relevant statuses and get the totals needed for your formula.

Once you set this up, you’ll have a clear picture of your performance and can identify areas for growth and development!

Good luck, and feel free to ask if you need any more specific advice!