Free Recruitment KPI Dashboard Template (Excel & Sheets)

If you ask ten recruiters which KPI matters most, you'll get six answers and four shrugs. That's not because the metrics are subjective — it's because most teams measure what their spreadsheet happens to show, not what actually predicts whether they'll hit quota next quarter. This template fixes that.

What follows is a tight six-KPI dashboard that runs in Google Sheets or Excel, builds on the free recruitment tracker templates we published earlier, and tells you within thirty seconds whether a desk is healthy or in trouble.

The six KPIs that actually matter

1. Time-to-fill — calendar days from req opened to offer accepted
2. Time-to-hire — calendar days from candidate first contact to offer accepted
3. Source-of-hire — which channels produce hires, not just applicants
4. Pipeline velocity — candidates per stage, refreshed weekly
5. Offer acceptance rate — offers accepted ÷ offers made
6. Quality of hire — performance/retention at 90-day mark

Stop here if you're tracking more than these six. You're producing noise, not insight.

The KPIs that predict next quarter's billings are different from the KPIs that look good in a slide deck. Pick the first.

The dashboard structure

One sheet, four sections. Pulls from your candidate pipeline tracker and your requisition tracker — same templates linked above.

Section 1: Headline numbers (top of sheet)

Benchmarks above use European agency averages from SHRM and CIPD's resourcing report. Adjust for your specific niche — executive search will run higher, contingent staffing lower.

Section 2: Source-of-hire breakdown

The chart everyone gets wrong. Don't show source of applicants. Show source of hires. They look completely different.

Formula:

=COUNTIFS(Pipeline!Source, "LinkedIn", Pipeline!Stage, "Hired") / COUNTIFS(Pipeline!Stage, "Hired")

Repeat per source (LinkedIn / Job board / Referral / Direct / Database). Visualise as a bar chart, not a pie chart — pie charts hide the gap between top and bottom sources.

Section 3: Pipeline velocity

Count of active candidates per stage, this week vs four weeks ago. Bottlenecks show up instantly.

If "Screening" balloons week over week, your screening capacity is the bottleneck. If "Interview 2" stagnates, your hiring managers are the bottleneck. The dashboard tells you where the friction is — fixing it is on you.

Section 4: Quality of hire (the metric most teams skip)

The reason most agencies don't track quality of hire is that it requires checking back at 30, 60 and 90 days. Set a recurring task. The data is gold.

Simple version: per hire, log retention status at 90 days (still employed yes/no) and one-line manager feedback (good fit / mixed / poor fit). Aggregate by recruiter, by client, by role type. LinkedIn Talent Solutions data consistently shows quality of hire is the metric most correlated with client retention — and almost nobody measures it.

Conditional formatting that makes the dashboard usable

• Red highlight on time-to-fill above 60 days
• Amber on offer acceptance below 75%
• Green on source-of-hire rows producing more than 25% of hires
• Bold red on any pipeline stage that grew more than 50% week-on-week

The point of the colour coding is to make the dashboard readable at a glance. If you have to squint to find the problem, the problem will not get fixed.

Google Sheets vs Excel for this

Sheets wins for shared visibility. Hiring managers can view live without ever asking you to "send the latest". Real-time updates, no version conflicts.

Excel wins for power users. Pivot tables and slicers are still ahead of Sheets for complex multi-dimensional analysis. If you slice by recruiter × client × month, Excel handles it more elegantly.

Default recommendation: Sheets. Move to Excel only when you hit a wall.

What this dashboard cannot do

Honest version: spreadsheets work up to about 15-20 active reqs and three or four recruiters sharing one. Past that:

• Versions get overwritten
• GDPR retention rules are impossible to enforce
• Generating client-specific reports becomes a manual job
• Quality of hire data gets logged inconsistently

That's when a proper recruiting CRM earns its seat. Yena builds these six KPIs in by default and refreshes them automatically — no formula maintenance, no broken references when someone deletes a column.

FAQ

What's a good time-to-fill in 2026?

SHRM's European benchmark is 44 days. Executive search runs 60-90; contingent staffing 21-30; volume hiring 10-15. Compare against your niche, not the average.

Should I track cost-per-hire?

Useful if you can attribute spend reliably. For most small agencies, the data quality isn't there to make the metric meaningful. Time-to-fill and offer acceptance tell you more about commercial health.

How often should I refresh this dashboard?

Weekly review, monthly client-facing version. Daily refresh produces noise without insight.

Can I add my own KPIs?

Yes — but ask whether each one will change a decision you make. If not, it's vanity.

How do I get this to update automatically?

In Sheets, link the formulas directly to your pipeline and requisition trackers — it'll refresh in real time. In Excel, use power query for live updates from a shared file.

Use it, then outgrow it

This dashboard works for desks doing under 100 placements a year. Past that, you need software that handles multi-tenant data, GDPR retention automatically, and client-facing reports without copy-paste. The dashboard isn't supposed to scale forever — it's supposed to make today's KPIs visible until you outgrow it.

Pair it with the free recruitment tracker templates for the underlying data, and you've got a complete tracking stack at zero software cost.