Recruiting KPI dashboard template: Six KPIs with formulas and a worked example

On this page
A recruiting KPI dashboard works when everyone agrees on the definitions behind each number: what counts, over what period, and which system it comes from. This free template sets that up for six starting KPIs, so you can build the dashboard in your ATS, BI tool, or a spreadsheet.
The six KPIs come from our guide to recruiting metrics: time to fill, stage conversion rate, hiring manager acceptance rate, offer acceptance rate, cost per hire, and quality of hire, with new hire retention standing in until quality data matures. Together they give you one number each for speed, pipeline, quality, cost, and the close.
The six KPIs at a glance
Copy this table into your dashboard spec. The downloadable sheet has the same columns, plus space to record each owner and your own baseline.
| KPI | Numerator and denominator | Measurement window | Source system and fields | Suggested owner |
|---|---|---|---|---|
| Time to fill | Offer accepted date − requisition open date, averaged across requisitions filled | Requisitions filled in the month or quarter | ATS: requisition open or approval date, offer accepted date, requisition ID | Talent acquisition leader |
| Stage conversion rate | Candidates who advanced from a stage ÷ candidates who entered that stage × 100 | Candidates who entered the stage in the period, read after they have had time to move | ATS: stage name, stage entered date, stage exit date and outcome | Recruiting operations |
| Hiring manager acceptance rate | Candidates the hiring manager accepts for the next step ÷ candidates submitted × 100 | Candidates submitted in the period | ATS: submitted-to-hiring-manager date, hiring manager decision, recruiter, requisition | Recruiter |
| Offer acceptance rate | Offers accepted ÷ offers extended × 100 | Offers extended in the period | ATS: offer extended date, offer status, decline reason | Talent acquisition leader |
| Cost per hire | (Internal recruiting costs + external recruiting costs) ÷ total hires in the period | Quarter, with costs and hires from the same period | Finance and HRIS: recruiting team pay, tools, agency fees, job ads, events, referral bonuses; ATS: hires | Talent acquisition leader with finance |
| Quality of hire | Sum of indicator scores ÷ number of indicators, each indicator on the same scale | Hires who started in a past period, measured at a fixed point after the start date | HRIS and performance system: start date, performance rating, time to productivity, hiring manager satisfaction, retention | Talent acquisition leader with HR business partners |
| New hire retention (stand-in) | New hires still employed after N months ÷ new hires who started in the period × 100 | Hires who started in a past period, read after N months, often 90 days or one year | HRIS: start date, termination date | HR business partners |
How to fill in the template
- Agree the definitions. Write down when each clock starts and stops and which system is the source of record. If two teams use different start dates for time to fill, the dashboard will argue with itself.
- Name an owner for each KPI. Hold people to what they control. Recruiters control the slate they present more than how fast a manager decides, which is why hiring manager acceptance rate works well as a recruiter KPI.
- Enter a few months of your own data. Set baselines from your own numbers before you set targets. The tracker sheet calculates each rate from the counts you enter.
- Pair KPIs that pull against each other. Read time to fill with quality of hire, and cost per hire with new hire retention, so improving one doesn't quietly damage the other.
- Review on a rhythm. Look at leading KPIs weekly or monthly. Quality of hire and retention take months to arrive, so review them quarterly.
Worked example (synthetic data)
Synthetic example. Every number below is made up to show how the formulas work. These are not benchmarks, customer results, or Findem data. Compare your results with your own baseline, not with this table.
A fictional engineering recruiting team reviews its third quarter (July 1 to September 30):
| KPI | Inputs (synthetic) | Calculation | Result |
|---|---|---|---|
| Time to fill | 10 requisitions filled; 520 days open in total | 520 ÷ 10 | 52 days |
| Stage conversion rate (recruiter screen to submitted) | 80 candidates entered recruiter screen; 60 submitted to hiring managers | 60 ÷ 80 × 100 | 75% |
| Hiring manager acceptance rate | 60 candidates submitted; 18 accepted for interview | 18 ÷ 60 × 100 | 30% |
| Offer acceptance rate | 12 offers extended; 10 accepted | 10 ÷ 12 × 100 | 83% |
| Cost per hire | $90,000 internal costs; $30,000 external costs; 10 hires | ($90,000 + $30,000) ÷ 10 | $12,000 |
| Quality of hire (first-quarter hires, at six months) | Performance 80, time to productivity 75, hiring manager satisfaction 70, each on a 0 to 100 scale | (80 + 75 + 70) ÷ 3 | 75 |
| New hire retention (first-quarter hires, at six months) | 10 started; 9 still employed | 9 ÷ 10 × 100 | 90% |
How to read it. The pattern matters more than any one number. Here, recruiters pass most screened candidates to hiring managers (75%), but managers accept fewer than a third of them (30%). That gap points to a mismatch in what the role needs, not a shortage of candidates. Sourcing more people into the same brief would add work without fixing it. The next step is to sit down with each hiring manager and review the agreed role criteria.
How to interpret each KPI
Use these prompts when a KPI moves against your baseline. Each one names the first thing to check and a next action, so the dashboard leads to a decision.
| Signal | Check first | Next action |
|---|---|---|
| Time to fill rising | Time in stage for the slow requisitions, and open requisitions per recruiter | Fix the slowest stage before adding sourcing volume. |
| Stage conversion falling at one stage | Whether the stage's criteria or interviewers changed | Review that stage with its owner; don't change every stage at once. |
| Low hiring manager acceptance | Whether the recruiter and hiring manager agreed on the role criteria at intake | Review the agreed role criteria before expanding sourcing. |
| Offer acceptance falling | Decline reasons: compensation, timing, or a gap between the interviews and the offer | Record the reason for every declined offer and share the pattern with compensation partners. |
| Cost per hire rising | Spend by channel and role family | Read it next to quality of hire and retention before cutting a channel. A cheap hire who leaves in three months is not cheap. |
| Quality of hire or retention falling | Whether the role was described differently from how it works, a level mismatch, or a rushed decision | Revisit the intake and interview plan for the affected role family. |
When hiring manager acceptance is the problem, our market-informed role calibration playbook walks through the intake conversation step by step.
Where Findem fits
This template works with any ATS or BI tool. If your team uses Findem, two parts of the product connect to it, and they solve different problems.
Evaluate sourcing with Talent Analytics. Talent Analytics in the Findem platform compares every sourcing channel, shows reply rate, interest rate, and time to reply by recruiter, role, team, and location, and follows early activity like searches created and time to first outreach. It covers the sourcing and engagement side of your dashboard, not all six KPIs above.
Fix the intake with Role Calibration (optional). If low hiring manager acceptance is the signal, the Role Calibration agent in Findem Studio turns a hiring conversation into a scored, market-tested search the recruiting team can run, with the hiring manager in control of the bar. Studio is self-serve: sign up, and every new account gets 1,250 free starter credits. Studio shows how each agent is charged before it runs.










