Free guide

Recruitment Funnel Metrics: The 7 Numbers Small Teams Should Track

Big companies have recruiting analysts and dashboards with dozens of charts. Small businesses don't need any of that — but hiring blind is expensive. A handful of simple funnel metrics tell you where good candidates come from, where they drop out and whether your process is getting better. This guide covers the seven metrics that matter most, how to calculate each one in a spreadsheet, and what to do when a number looks wrong.

What is a recruitment funnel?

A recruitment funnel is the sequence of stages a candidate moves through: applied → screened → interviewed → final round → offer → hired. At every stage, some candidates drop out or are rejected. Measuring how many move from one stage to the next — the conversion rate — shows you exactly where the process is leaking.

Free mini funnel template

Copy this table into Excel or Google Sheets and replace the counts with your own numbers for one role or one quarter.

Metric 1: Stage conversion rates

Formula: candidates reaching stage N+1 ÷ candidates reaching stage N.

What it tells you: a very low applied → screened rate usually means your job ad attracts the wrong people (unclear requirements, wrong channel). A low interview → final rate can mean your screening is too loose. A low offer → hire rate points to compensation, slow offers or a poor candidate experience.

Metric 2: Source of hire

Formula: hires from a source ÷ total hires. Also compute the source's own conversion: hires from source ÷ applicants from source.

Why it matters: it tells you where to spend money and time. Many small companies discover that one job board produces lots of applicants but few hires, while employee referrals produce few applicants and most of the hires.

Metric 3: Time to hire

Formula: offer accepted date − application date, averaged across hires. It's covered in depth in our guide on how to calculate time to hire. Track it per stage to find bottlenecks.

Metric 4: Offer acceptance rate

Formula: offers accepted ÷ offers made.

Reading it: a high rate is good; when it drops, ask declining candidates why. The usual causes are salary below market, a slow process during which they received other offers, or an unclear picture of the role. Rejections at this stage are the most expensive, because you've already invested the full interview effort.

Metric 5: Cost per hire

Formula: (external costs + internal costs) ÷ number of hires.

• External: job board fees, ads, agency fees, assessment tools, referral bonuses.
• Internal: estimated hours spent by interviewers and managers × an hourly cost.

Even a rough estimate is eye-opening. Five interviewers spending three hours each per candidate adds up quickly, which is a strong argument for better screening before the interview stage.

Metric 6: Candidate drop-off and reasons

Record a reason every time a candidate is rejected or withdraws — "missing core skill," "salary expectations," "accepted other offer," "no response." After 30–50 candidates, a simple COUNTIF by reason reveals patterns. If "accepted other offer" dominates, you're too slow. If "salary expectations" dominates, your range is off or not stated in the ad.

Metric 7: Quality of hire

The metric that matters most and is hardest to measure. A practical small-company version: at 90 days, ask the manager to rate the new hire 1–5 and record whether they passed probation. Over time, compare quality by source and by interview score. If high interview ratings don't predict good 90-day ratings, your interview questions need work. A structured 30-60-90 day plan gives you a natural checkpoint for this.

Setting up tracking in 30 minutes

1. Create one candidates table with: role, source, date applied, current stage, stage dates, outcome reason, interview score.
2. Use dropdowns for stage, source and reason so the values are consistent.
3. On a second sheet, use COUNTIFS to count candidates per stage and per source.
4. Add the conversion and acceptance formulas above.
5. Review monthly — not daily. Small numbers swing a lot, so look for trends over a quarter.

Our step-by-step recruiting pipeline tracker in Excel guide walks through the columns and formulas in more detail.

Common mistakes

• Tracking too much. Seven metrics are plenty. More creates reporting work nobody reads.
• Ignoring small samples. With five hires a year, one outlier moves the average. Use medians and trends.
• Inconsistent stage names. "Interview," "interviewed" and "1st int" break your counts. Use dropdowns.
• No action. Each metric should lead to a decision: drop a source, speed up scheduling, adjust salary ranges, refine questions.

A worked example: fixing a leaky funnel

Imagine a twelve-person company hiring a sales representative. After a month the numbers look like this: 150 applicants, 12 screened in, 6 interviewed, 1 offer, 0 hires. The applied-to-screened rate of 8% suggests the job ad is attracting the wrong people, so the team rewrites it with a clear salary range, the actual quota and a short description of a typical day. Applications fall to 70, but 20 pass screening. The single offer was declined because the candidate accepted another job while waiting eleven days for a decision, so the team schedules the debrief immediately after final interviews and pre-approves the salary band. The next month produces two offers and one hire in 24 days. Nothing about the candidate market changed — the funnel metrics simply showed where to act. That is the whole value of tracking: each number points to one specific, fixable part of the process.

Frequently asked questions

What's a good overall applicant-to-hire rate? It varies enormously by role and channel. Use it to compare your own roles and sources over time rather than chasing an external benchmark.

Do I need software for this? No. A spreadsheet handles everything here for a small business.

The Recruiting Pipeline Tracker has these metrics built in: stage dropdowns, automatic conversion and time-to-hire calculations, and a one-page dashboard.

← More hiring guides