Recruiting Metrics Excel Template

Recruitment Dashboard Excel Template

Larger companies can analyze from within the department to improve recruiting budgets. You can track this hiring metric over time to identify seasonal patterns. But it will explain the popularity of the roll and how well you might be marketing it.

Limited-Time Special: Download All Products Today 60% Off >>

Business Management Software


Rated #1 Excel Dashboards, Scorecards and KPIs Reports

HR Tools, Scorecards and Dashboard Templates



The number of applicants does not let you know everything with the number of suitable applicants you could attract. Therefore, the number of applicants is a favorable recruitment measure to monitor. Sometimes you may want to reduce the number of applicants.

It is usually not enough to know how many applicants you have. You can split this hiring metric by application phase to find out if a phase has a higher quit rate. Knowing the price of hiring a brand new employee is definitely the reason to plan your recruiting budget.

You need to understand where your high-quality candidates come from. However, not many do it the right way. Fortunately, most companies calculate this recruitment measure.

If your costs have been high, look for methods to reduce them, e.g. by advertising through cheaper methods, or by speeding up in the pre-screening phase with cost-effective skills tests. This includes everything from when the job ad goes live to enough time for a suitable candidate to be confirmed in the post.

The time it takes you to hire is exactly the time it takes to get an employee on board. This is great for identifying bottlenecks in the candidate selection process. This is a useful hiring measure because you can benefit from when and if your recruiting processes are slow.

Staying away is candidates chasing you because they don’t want to be kept in the dark. In case your total hiring time is too great, it’s easy to look through the different steps to find out where the problem is. Keeping track of the feedback for some time and setting a deadline will get things that get out of hand.

This can affect the candidate experience scores. It’s also used to get a bad recruiting pitch when hardly anyone responds. You can use this recruitment metric to get the best channel when using face-to-face contact.

You will have to dig a little deeper to get the answers. Unfortunately, this KPI alone does not let you know exactly what the problem is. Remember, you cannot improve what you cannot measure.

If many candidates decline your offer, ask them what the reason is for their decline. It can be a comparable recruitment measure for the ratio between offer and acceptance. The ratio between your supply and demand is exactly the number of interviews you conduct per recruitment.

Common reasons for withdrawal include a lot of travel, lower wages, and much better jobs elsewhere. You can use a hiring metric to identify exactly what the barriers are. You are able to assess whether you want to request a questionnaire and to record responses.

Knowing why applicants quit can help you identify developments and improve your recruiting processes. Recruitment statistics don’t stop at the end of the recruiting process. These can be pre-selected responses to choose from to really pass your candidate.

Looking at the performance of new recruits in the first year can show you how well you can hire high-quality talent. You need to keep track of how well the people you hire are performing. You compare the caliber of external and internal recruitments by using average scores on the assessment of the quality of the recruitment, or per part of the recruitments that exceeds a collection figure.

It can also signal any underachievers. It will help uncover issues such as finding good, highly educated candidates who are a poor cultural fit. This recruitment measure adds a subjective element to the caliber of the recruitment process.

This is really beneficial for recruitment analysis as research has shown benefits in hiring referred candidates. Employee referrals are candidates who have been referred by existing employees of a company. The challenge may be that you are an employer, or you may be attracting less committed applicants to the position.

If you are experiencing high staff turnover, you need to solve the problem quickly. Job interviews will always be a challenge, but a virtual interview involves a bit more complexity.

Business Management Resources

Rated #1 Excel Dashboards, Scorecards and KPIs Reports

HR Management Templates, Scorecards, Dashboards and Tools