Recruitment KPI Dashboard: Metrics, Formulas, and a Free Hiring Tracker Template
recruitment metricshiring analyticsATSrecruitment operationstemplatessmall business hiring

Recruitment KPI Dashboard: Metrics, Formulas, and a Free Hiring Tracker Template

RRecruitment.link Editorial Team
2026-08-03
7 min read

Build a practical recruitment KPI dashboard with formulas, a hiring tracker template, worked examples, and a clear reporting cadence.

A recruitment KPI dashboard turns scattered hiring activity into decisions you can act on. This guide explains the core recruitment metrics and formulas, provides a copyable hiring tracker template, and shows how small businesses can connect ATS, job board, and sourcing data without building an overly complex reporting system.

Overview

A useful recruitment KPI dashboard should answer five practical questions:

  • How long does it take to fill and hire for a role?
  • What does each hire cost?
  • Which sources produce qualified applicants and hires?
  • Where do candidates leave the hiring process?
  • Are new hires meeting expectations after joining?

You do not need dozens of metrics to answer these questions. Start with a small set that has a clear owner, a defined formula, and a regular reporting date. A spreadsheet can work for a small hiring volume; an ATS reporting dashboard becomes more useful when multiple roles, recruiters, hiring managers, or job boards are involved.

Keep definitions consistent. For example, “time to hire” may mean the time from a candidate’s application to accepted offer, while “time to fill” may mean the time from an approved requisition to accepted offer. Both can be useful, but combining them in one number makes comparisons unreliable.

For related operational improvements, see the guide to recruitment workflow automation and the comparison of candidate sourcing tools for small recruiting teams.

How to estimate

1. Time to hire

Formula: total days from each candidate’s application date to accepted offer date ÷ number of hires.

Use the same calendar convention for every role. If you want to understand the full vacancy period, track time to fill separately:

Time to fill: total days from approved requisition date to accepted offer date ÷ number of filled roles.

Report the average and the median when possible. A single unusually long search can pull the average upward, while the median shows the midpoint of your completed searches.

2. Cost per hire

Formula: total recruiting costs for the period ÷ number of hires in the period.

Decide what belongs in the numerator before you begin. A practical internal calculation may include job advertising, recruitment software, background checks, assessment tools, event costs, and external recruiter fees. A broader calculation can also include the estimated internal time spent by recruiters and interviewers. The important point is to label the version clearly, such as “direct cost per hire” or “fully loaded cost per hire.”

For a more detailed worksheet, use the cost per hire calculator guide.

3. Source of hire

Formula: hires attributed to a source ÷ total hires × 100.

Track the original source and the final source separately if your process involves several touchpoints. For example, a candidate may first discover a role through a job board, then apply through a smart job link shared by an employee. Define which source receives credit before comparing channels.

4. Applicant-to-interview conversion

Formula: applicants who reach an interview stage ÷ total applicants × 100.

This metric can highlight targeting or screening problems. A very low rate may indicate that the job description attracts many people without the required qualifications, or that screening criteria are too restrictive. A very high rate may indicate that the team is moving too many applicants into interviews.

5. Offer acceptance rate

Formula: accepted offers ÷ total offers made × 100.

Record the reason when an offer is declined, using consistent categories such as compensation, location, timing, role scope, or another offer. Do not assume the reason from a candidate’s silence; use a confirmed response where available.

6. Quality of hire

Quality of hire is usually a composite measure rather than one universal formula. Create a simple score using agreed inputs, such as performance review outcome, hiring manager assessment, retention at a defined milestone, or completion of role-specific goals.

For example, assign each input a score from 1 to 5 and calculate the average after the new hire reaches an agreed review point. Document the review date and scoring rules so that later cohorts can be compared fairly.

Inputs and assumptions

Before building a recruitment analytics dashboard, create a data dictionary. This prevents common disagreements about what each number means.

FieldRecommended definition
Requisition dateDate the role was approved for hiring
Application dateDate the candidate entered the process
Interview dateDate the candidate first completed an interview
Offer dateDate the written offer was issued
Accepted dateDate the candidate accepted the offer
SourceStandardized channel or campaign label
Stage outcomeAdvanced, rejected, withdrawn, declined, or hired
Cost categoryAdvertising, software, assessment, event, or internal time

Use a consistent reporting period, such as calendar month or quarter. Exclude open roles from completed-hire calculations, but report them separately as pipeline activity. If a role is paused, record the pause date rather than silently allowing the vacancy clock to continue.

A copyable hiring tracker can use one row per candidate with these columns:

Requisition ID | Role | Department | Location | Candidate ID | Source | Application Date | Screen Date | Interview Date | Offer Date | Accepted Date | Current Stage | Outcome | Rejection Reason | Recruiter | Hiring Manager | Direct Cost | Quality Review Date | Quality Score

Use a candidate ID instead of displaying unnecessary personal information in summary reports. Limit access to sensitive candidate data and keep dashboard outputs focused on aggregated hiring activity.

Worked examples

Time to hire calculator

Suppose three candidates accept offers after 18, 25, and 32 days from application. The calculation is:

(18 + 25 + 32) ÷ 3 = 25 days

The average time to hire is 25 days. The median is also 25 days in this example. If a fourth hire took 90 days, the average would change substantially, which is why reporting both measures can help explain the shape of the data.

Cost per hire

Assume a reporting period includes $900 in job advertising, $300 in assessments, and $600 in allocated recruitment software costs. If the team makes three hires:

($900 + $300 + $600) ÷ 3 = $600 per hire

This is a direct-cost example. If internal interview time is added, label the result as a fully loaded estimate and document the hourly assumptions used.

Conversion and source comparison

If 80 applicants produce 16 interviews, applicant-to-interview conversion is:

16 ÷ 80 × 100 = 20%

If one source produces 30 applicants and two hires, its source-of-hire rate among applicants is 6.7%. That figure should not be treated as a universal quality ranking without considering role type, spend, applicant volume, and the length of the hiring cycle. Add source-level interview and offer data to understand where quality changes.

When connecting an ATS with job board software, pass a consistent source label or campaign identifier with every application. If an integration is unavailable, use tagged URLs, smart job links, or a controlled source field. Avoid manually combining differently named channels after the reporting period has ended.

When to recalculate

Review the dashboard on a predictable cadence. A small business may need a monthly review, while a team hiring continuously may review weekly pipeline activity and monthly outcomes.

  • Weekly: open requisitions, applicants by stage, overdue feedback, and upcoming interviews.
  • Monthly: time to hire, source of hire, conversion rates, offer acceptance, and spend.
  • Quarterly: quality of hire, source mix, process bottlenecks, and whether dashboard definitions still fit the business.

Recalculate when recruitment software pricing changes, advertising spend changes, a new sourcing channel is added, the hiring process gains or removes a stage, or the team changes how it defines a hire. Revisit benchmarks cautiously: role complexity, location, seniority, seasonality, and hiring volume can all affect results.

To put the tracker into use, choose five or six starting metrics, define each one in writing, assign an owner for data quality, and create a fixed reporting date. Then compare results by role and source rather than relying only on one company-wide average. After one reporting cycle, remove fields that are never used and add only those that support a real decision. A focused recruitment KPI dashboard is easier to maintain, easier to explain, and more likely to improve the hiring process.

Related Topics

#recruitment metrics#hiring analytics#ATS#recruitment operations#templates#small business hiring
R

Recruitment.link Editorial Team

Recruitment and Hiring Operations Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.