Recruitment KPI Dashboard: Metrics, Formulas, and a Monthly Hiring Review Template
recruitment KPIshiring metricsrecruiting dashboardHR reportinghiring performance

Recruitment KPI Dashboard: Metrics, Formulas, and a Monthly Hiring Review Template

RRecruitment Link Editorial Team
2026-11-04
7 min read

Build a practical recruitment KPI dashboard with formulas, assumptions, examples, and a monthly hiring review process.

A recruitment KPI dashboard turns scattered hiring activity into decisions you can review and improve. This guide provides a reusable set of formulas for application volume, qualified-candidate rate, source performance, interview conversion, time to hire, cost per hire, offer acceptance, and new-hire retention, along with assumptions, worked examples, and a monthly review process.

Overview

A useful recruitment dashboard should answer three questions: Are enough suitable candidates entering the funnel? Where are candidates progressing or dropping out? What does each hire cost in time and money?

For a small hiring team, a spreadsheet can be sufficient. A recruitment software platform or applicant tracking system (ATS) becomes more valuable when several people are hiring, roles are posted across multiple channels, or applications arrive through different forms and job boards. The tool matters less than using consistent definitions and recording the same fields for every vacancy.

Track results by role, hiring manager, location or work arrangement, and candidate source where the volume supports comparison. Avoid combining unrelated roles into one benchmark. A high-volume hourly role, specialist technical role, and internship may have very different conversion rates and hiring timelines.

The core dashboard can include:

  • Applications received
  • Qualified-candidate rate
  • Application-to-interview and interview-to-offer conversion
  • Source performance
  • Time to hire
  • Cost per hire
  • Offer acceptance rate
  • Retention after a defined period

For reliable reporting, connect job boards, application forms, and your ATS where possible. Smart job links can help separate campaign and source activity, while an ATS integration for small businesses can reduce duplicate data entry.

How to estimate

Start with a monthly table in which each row represents a vacancy or hiring campaign. Use the following formulas. Keep the numerator and denominator within the same reporting period unless you clearly label the data as a cohort.

Funnel and quality metrics

Qualified-candidate rate = qualified candidates ÷ total applications × 100. If 18 of 120 applications meet the agreed minimum requirements, the rate is 15%.

Application-to-interview rate = candidates interviewed ÷ applications received × 100. This indicates how effectively the application pool is progressing, but it should be read alongside the qualified-candidate rate.

Interview-to-offer rate = offers made ÷ candidates interviewed × 100. A low rate may reflect a selective process, weak screening, unclear requirements, or inconsistent interviewing. Review the evidence before changing the process.

Offer acceptance rate = accepted offers ÷ offers made × 100. Record declined offers with a reason where the candidate is willing to share one. Compensation, schedule, location, competing offers, and slow communication may have different remedies.

Speed and cost metrics

Time to hire is the number of calendar days from the date a candidate enters the process or applies to the date they accept the offer. Choose one definition and use it consistently. The average time to hire is total days for completed hires ÷ number of completed hires. Also record the median when possible, because one unusually delayed vacancy can distort an average.

Cost per hire = total recruiting costs ÷ number of hires. Include the costs relevant to your decision, such as paid job distribution, sourcing tools, recruitment software, advertising, assessment fees, referral payments, and attributable internal recruiter or hiring-team time. If you include staff time, use an agreed hourly or daily estimate rather than changing the estimate from role to role.

A simple internal time-cost estimate is: hours spent on recruiting activities × loaded hourly cost. Add external costs to this amount. State clearly whether onboarding, relocation, equipment, and post-hire training are excluded; these may belong in a broader cost-of-hire measure rather than the recruiting measure.

Retention and source metrics

New-hire retention rate = hires still employed at the review date ÷ hires in the original cohort × 100. Define the checkpoint, such as 30, 90, or 180 days, and do not compare cohorts with different follow-up periods.

Source-to-hire rate = hires attributed to a source ÷ applications attributed to that source × 100. Also track cost per source and qualified candidates per source. A channel that produces fewer applications may still be more efficient if its applicants are better matched.

Use one attribution rule. For example, record the first tracked source, the last source before application, or the source selected by the candidate. Do not switch between rules during the same comparison.

Inputs and assumptions

Create a data dictionary before building the dashboard. At minimum, define these fields:

  • Application date: when a completed application enters the system.
  • Qualified: a yes-or-no decision based on documented minimum criteria.
  • Interview: specify whether a recruiter screen counts or only a structured hiring-manager interview.
  • Offer: an offer formally sent to the candidate.
  • Hire date: the date the candidate accepts the offer or starts work; choose one for time-to-hire reporting.
  • Source: the channel or campaign credited under your chosen attribution rule.
  • Recruiting cost: the cost categories included in your cost-per-hire calculation.

Separate leading indicators from outcome measures. Applications, response time, and scheduled interviews can signal future results. Hires, accepted offers, cost per hire, and retention describe completed outcomes. A dashboard that reports only applications may reward volume even when candidate quality is poor.

Protect data quality by using required fields, standard source names, and a single vacancy ID across job posting software, forms, smart links, and the ATS. Check for duplicate candidates before calculating rates. If a metric has fewer than a practical number of observations, label it as directional rather than treating it as a stable benchmark.

Do not set universal targets without considering role difficulty, hiring volume, geography, work arrangement, compensation, and seasonality. Your first two or three reporting cycles should establish a baseline. Targets can then be based on your own historical performance and the operational capacity of the hiring team.

Worked examples

Assume a company closes one vacancy during a month. It receives 120 applications, identifies 18 qualified candidates, interviews 9, makes 3 offers, and receives 2 acceptances.

MetricCalculationResult
Qualified-candidate rate18 ÷ 120 × 10015%
Application-to-interview rate9 ÷ 120 × 1007.5%
Interview-to-offer rate3 ÷ 9 × 10033.3%
Offer acceptance rate2 ÷ 3 × 10066.7%

Suppose the campaign cost $480 in job distribution and sourcing fees. The team estimates 32 hours of internal recruiting work at $30 per hour, or $960. Total estimated recruiting cost is therefore $1,440. With two hires, estimated cost per hire is $1,440 ÷ 2 = $720.

For time to hire, assume the two accepted offers took 24 and 38 days from application to acceptance. The average is (24 + 38) ÷ 2 = 31 days, while the median is also 31 days because there are two observations. If the next hire takes 90 days, review the median and the individual vacancy details instead of assuming the entire process has deteriorated.

For source analysis, imagine one source produced 40 applications, 8 qualified candidates, and 1 hire, while another produced 30 applications, 6 qualified candidates, and 1 hire. The first source has a 20% qualified-candidate rate; the second has 20% as well. Their value may still differ if one costs more, produces faster interviews, or has stronger retention. Funnel volume alone is not enough to select a channel.

When to recalculate

Review the dashboard monthly when hiring is active, but do not wait for the monthly meeting to correct missing or inconsistent records. A weekly operational check can confirm that applications have source data, stages are current, and candidate response times are visible. Monthly reporting is better for trends; weekly reporting is better for managing work in progress.

Recalculate benchmarks when pricing inputs change, a recruitment tool or job board is added or removed, the hiring mix changes, or the team adopts a new attribution rule. Revisit cost per hire when internal time assumptions, advertising budgets, or software plans change. Revisit retention after each defined cohort checkpoint rather than mixing recent hires with mature cohorts.

Use this practical monthly review:

  1. Export or sync vacancy, candidate, source, stage, date, and cost data.
  2. Check definitions and remove duplicates before calculating rates.
  3. Compare each active role with similar prior roles, not with an undifferentiated company average.
  4. Identify the largest funnel drop-off and the most expensive or slowest step.
  5. Choose one process change, such as improving a job description, screening criteria, response time, or source tracking.
  6. Record the change, owner, expected result, and review date.

After several cycles, the dashboard should become a decision tool rather than a scorecard. Use it to decide where to post a job, which recruitment tools need better integration, when a screening process needs clarification, and which changes improve completed hiring outcomes—not merely application volume. For consistent evaluation, pair the dashboard with a candidate screening checklist and document the assumptions behind every reported number.

Related Topics

#recruitment KPIs#hiring metrics#recruiting dashboard#HR reporting#hiring performance
R

Recruitment Link Editorial Team

Recruitment 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.