Recruitment KPI Dashboard Excel Template

Do you want to learn how effective is your recruiting process. Then, here’s an Recruitment KPI Template to track your performance of hiring activities.

A ready-to-use KPI Dashboard designed for recruiters, hiring managers and HR people. Also, it’s in Excel. So no need to install or learn any new software.

You’ll easily input your Actual, Target and Previous Year values and monitor your performance trends in professional KPI Dashboards. Furthermore, it provides most common recruitment metrics for you.

Then, let’s see the details of the Recruitment KPI Dashboard Excel Template.

Recruitment KPI Dashboard Excel Template Features:

Firstly, you’ll find navigation buttons on the menu. There are mainly two groups: 1. Input and 2. Output.

Let’s see each section more closely:

Input Sections:

On the input group, you’ll find:

• Metric Settings: This is where you’ll list your KPI’s. We have provided you the most common metrics for recruitment. But, feel free to update these metrics, or add new ones.
• Current Year Actuals: Here you’ll input current year values for the defined metrics.
• Current Year Targets: Define your target values for each metric.
• Previous Year Actuals: Input your previous year values to make year-on-year comparisons.

Output Sections:

After inputting your values, you can analyze the Recruitment KPI Metrics in professional dashboards. So, you’ll find two different analysis area here: 1. Monthly Analysis Dashboard, 2. Trend and Charts

1. Monthly Analysis Dashboard

In this Dashboard panel of the Recruitment KPI Template, you’ll see the monthly evaluation of your entire metrics.

The Green, Yellow and Red circles will let you see your performance at a glance. Also, you’ll find both monthly and cumulative change analysis here.

Please note that you can change the analysis month from the drop-down menu just at the left-top of your dashboard.

2. Trends and Charts

Lastly, you’ll also find a metric-based analysis in your recruitment kpi template. Thus, you can select the individual metrics from the drop-down menu and analyze the trend charts.

Also, you’ll see a barometer that shows your success percentage to attain your Targets for the selected metric:

That’s all for the Recruitment KPI Template.

Detailed Description of Recruitment KPI Dashboard Metrics:

We have seen the sections above. But the Metrics section of this template deserves a closer look.

• Efficiency and Speed: Time to Fill, Time to Hire, Hiring Velocity, Average Interview Duration, Screening Efficiency
• Cost and Investment: Cost per Hire, Recruitment Marketing ROI, Recruitment Cost Ratio
• Quality and Performance: Performance of Hire, First-Year Attrition, Internal Mobility Rate, Hiring Manager Satisfaction
• Process and Workflow: Interview-to-Offer Ratio, Offer-to-Acceptance Ratio, Selection Rate, Interview-Drop-off Rate, Diversity Hire Rate
• Candidate Experience: Candidate Satisfaction, Applicant Drop-off Rate, Candidate Net Promoter Score (NPS)

As this recruitment kpi template is totally modifiable, you can easily add new metrics or new metric groups to your list.

Also, in the Metrics section, you’ll input the KPI Code, KPI Group, Criteria, Unit, Lower Better, Cumulative Calculation Method as well as optional KPI Description.

We want to underline the importance of two headers here:

• Lower Better: This question is to understand if your metric indicates a better performance when it’s a lower absolute value. If so, select Yes here.
• Cumulative Calculation Method: Define how to calculate the cumulative for your metrics: with Average formula, or with Sum formula.

This is how you’ll configure all your Recruitment Metrics.

This Recruitment KPI Template will be a reference for your OKR (Objectives and Key Results) tracking for your hiring activities.

Recruitment KPI Dashboard Excel Template Features Summary:

• Both Monthly and Cumulative analysis
• Comparison with Past Year and Target values
• Professional dashboards
• Dynamic KPI List
• Compatible with Excel 2010 and later versions
• Works both on Windows and Mac
• No installation needed. Ready to use
• Full Print ready
• Does not include any VBA macros