Recruiting Funnel Analyzer
Conversion and drop-off between your stages, named whatever your team names them. Type the numbers in, or drop a candidate export.
Reads .xlsx and .csv inside your browser. Your file never leaves your computer.
Your stages, top to bottom
Rename them to whatever your team calls them. Counts are how many candidates reached each stage, so every number should be smaller than the one above it.
0%
Overall conversion
—
Applications per Hires
Screened
Steepest drop
The funnel
How this was read
- The stage counts were taken as they are, with no cumulating, so each figure is how many candidates are at that stage rather than how many reached it.
- Stage order: Applications then Screened then Interviewed then Offers then Hires.
- Conversion at each step is that stage as a percentage of the one before it.
- Time to hire is not included. It needs dated events per candidate, which a stage column does not carry.
The mistake that flatters the top of every funnel
A candidate export usually records the furthest stage each person reached. Somebody rejected after the panel has “Panel” in their row, not “Applied”. So counting rows per value tells you how many people stopped at each stage, and a funnel needs how many reached it, which is that number plus everybody who went further.
Get it wrong and the top of the funnel looks tiny and every conversion rate below it looks wonderful. On a small test file the difference was ten candidates at the top against six. This tool asks which kind of column you have, and cumulates when it should.
Why you have to order the stages yourself
Applied, Screened, Phone Screen, HM Screen, Onsite, Panel, Offer, Offer Extended, Hired, Started. No two applicant tracking systems agree, and often no two teams inside one company do either. Nothing in a spreadsheet says which stage comes first, so the tool reads your file’s own stage names and asks you to put them in order rather than guessing and being confidently wrong.
A funnel cannot widen
If a stage has more candidates than the one before it, something is wrong: either the order is wrong or the column means something other than what the tool was told. It says so rather than drawing an impossible chart.
What is not here
Time to hire and time to fill. Those need dated events for each candidate, and a stage column does not carry them. A tool that estimated them from what is in this file would be making the numbers up.