Recruitment KPI Dashboard and Tracker Template

A recruitment KPI dashboard should show where work enters the funnel, how it converts and where it slows down. This free spreadsheet keeps the underlying counts visible so every percentage can be checked.

Download the recruitment KPI dashboard template

What the template contains

Dashboard

The dashboard summarises vacancies, contacts, qualified candidates, submissions, interviews, offers and placements. It also shows the core conversion rates and monthly trend.

Monthly inputs

Enter one row per month. Input cells cover:

• Vacancies opened and filled
• Candidates contacted
• Positive responses
• Screens completed
• Qualified candidates
• Candidates submitted
• Interviews
• Offers
• Accepted offers
• Placements or hires
• Median time to submit and fill
• Recruitment cost and revenue

Formula columns calculate conversion and commercial measures.

Metric dictionary

Every metric includes a definition, formula and interpretation note. Edit the definition if your team uses a different start or end event.

Core dashboard formulas

KPI	Formula
Positive response rate	Positive responses / candidates contacted
Screen-to-qualified rate	Qualified candidates / completed screens
Submission-to-interview rate	Interviews / candidates submitted
Interview-to-offer rate	Offers / interviews
Offer acceptance rate	Accepted offers / offers made
Fill rate	Vacancies filled / vacancies opened
Cost per hire	Recruitment cost / hires
Revenue per placement	Recruitment revenue / placements

The workbook handles empty denominators without displaying formula errors.

How to use the recruitment KPI tracker

1. Agree each metric definition before entering data.
2. Use the same calendar cut-off every month.
3. Enter raw counts and durations in the highlighted input cells.
4. Review conversion rates with their numerators and denominators.
5. Investigate large movements before setting targets.
6. Add a note when a new client, market or process change affects comparability.

What not to combine

Keep materially different recruitment models separate where possible:

• Permanent and temporary recruitment
• High-volume and specialist hiring
• New desks and mature desks
• Internal recruitment and agency delivery
• Candidate-level and interview-event counts

If you need a consolidated view, preserve the segmented data underneath it.

A useful review sequence

Workload

Did vacancies opened and vacancies filled change? Is the team carrying more active work?

Reach

Did candidate contact volume or response rate change? Was that caused by the role, message, source or market?

Qualification

Are completed screens producing relevant candidates? A falling rate can indicate a search or brief problem.

Client or hiring-manager decision

Are submissions progressing to interview? Review evidence quality, vacancy alignment and feedback time.

Closing

Are interviews converting to offers, and are offers being accepted? Record decline reasons instead of relying only on the headline rate.

For detailed definitions and interpretation, use the 25 recruitment KPIs guide.

Template FAQ

Can the tracker be used for an agency?

Yes. It includes recruitment revenue and revenue-per-placement fields. Add gross profit or temporary-worker margin if that better reflects your model.

Can it be used for an in-house team?

Yes. Leave revenue blank and focus on workload, conversion, speed, cost and hiring outcomes.

Should each recruiter have a separate dashboard?

Use individual views only when the work and definitions are comparable and the recruiter controls the measured activity. Process measures are often more useful at team, client or vacancy-type level.

Does the spreadsheet contain benchmark targets?

No. Universal targets would be misleading across different markets and recruitment models. Use your own stable baseline and documented service expectations.