← Insights

Recruitment

A hiring funnel you can actually see

July 2026 · 6 min read

Ask most teams how their hiring is going and you get a feeling, not a figure. "Busy." "Slow." "We had a good one but they went elsewhere." The applicant list on the shared drive holds every fact you would need to turn those feelings into numbers, and yet it answers none of the questions a hiring lead is actually asked: how long are we taking, what is a hire costing us, and where are we losing the people we wanted?

A recruitment tracker earns its place the moment it stops being a list and starts being a funnel. The idea is simple. Every candidate enters at the top, and at each stage some drop away - screened out, self-withdrawn, offered and declined. Count how many survive each stage and the shape of your process appears. A narrow neck early on is a sourcing or screening problem; a narrow neck at offer is a problem with how you sell the role or what you pay.

Log each candidate once

The whole method rests on one discipline: enter a candidate a single time, record the source they came from and the furthest stage they reached, and let everything else compute. Days in process should never be typed - it is the gap between the date they applied and today (or their close date), and a spreadsheet works that out without being asked. The moment you find yourself hand-counting anything, the tracker has failed and you are back to a list.

Sources matter more than people expect. If you log where every candidate came from - a job board, a referral, an agency, your own careers page - the tracker can tell you which channels deliver hires and which merely deliver volume. Plenty of teams pour money into a source that produces a hundred applications and no offers, and never notice because the applications feel like progress.

The two numbers finance asks for

Time-to-hire is the average number of days from application to accepted offer across the roles you actually filled. It is the number that tells you whether your process is competitive - a strong candidate in a hot market will not wait three weeks for a first-stage decision. Watch it as an average and watch it per role; one slow-moving vacancy can flatter or wreck the mean.

Cost-per-hire is the total you spent to fill a role - advertising, agency fees, referral bonuses - divided by the hires you made. It is the figure a budget conversation opens with, and the one recruitment teams are least often ready to give. Capture the spend against each vacancy as you go and the average falls out for free at year end, instead of being reconstructed from memory and invoices in a panic.

A funnel that narrows sharply at one stage is not a failure to hide - it is the single most useful thing your recruitment data can tell you.

Reading the funnel

Put the stage counts side by side - Applied, Screened, Interviewed, Offered, Hired - and read the drops between them. Some narrowing is healthy: you should reject most applicants. The signal is in where the biggest drop sits relative to where you want it. Losing people between offer and hire is the expensive kind of leak, because you have already spent the interview time and the candidate was good enough to want. That pattern usually points at pay, at speed, or at a clumsy final stage - and it is invisible on a flat list, because the list treats a rejected applicant and a declined offer as the same closed row.

The offer-accept rate deserves its own line for the same reason. A team that makes ten offers to land four hires has a very different problem from one that makes five to land four, even though both filled the roles. The first is either aiming too high or losing on package; the second is running an efficient, well-calibrated process. Only the funnel view separates them.

None of this needs a recruitment system or a subscription. It needs one file where a vacancy is logged with its hiring manager and budget, a candidate is logged once with a source and a stage, and a dashboard reads the whole pipeline back to you - open vacancies, offer-accept rate, average time-to-hire, average cost-per-hire, and hires by source - the instant you open it before a hiring review.