Examples · Hiring
Hiring pipeline dashboard
From 412 applicants to 7 hires, with every stage counted the same way.
The decisionWhich stage is slowing hiring down, and will the quarter's plan be met?
Sample data · not a real company
Hiring pipeline, Q4 so farClick a number
W36
W37
W38
W39
W40
W41
Applicants by week
Receipt
Applicants, Q4 so far
- Definition
- Applications received, one per person per role
- Source
- candidates.xlsx, 438 rows
- Left out
- 26 duplicate applications
- Check
- Data through Oct 10
The numbers in this example
Each one with its full receipt.
- Applicants412
- Definition
- Applications received, one per person per role
- Source
- candidates.xlsx, 438 rows
- Left out
- 26 duplicate applications
- Check
- Data through Oct 10
- Screen rate23%
- Definition
- Applicants who reached a screen ÷ applicants
- Source
- candidates.xlsx, 412 applicants
- Left out
- Duplicates
- Check
- Stage names matched to 5 stages
- Offers9
- Definition
- Offers sent, by offer date
- Source
- candidates.xlsx, 9 rows with an offer date
- Left out
- 1 offer withdrawn before sending
- Check
- Data through Oct 10
- Time to hire34 days
- Definition
- Median days from application to accepted offer
- Source
- candidates.xlsx, 7 hires
- Left out
- Hires without an application date
- Check
- All 7 hires have both dates
How it was built
- 1
The decision
The hiring lead decides where to add help: sourcing, screening, or closing.
- 2
The metrics
Applicants, screen rate, offers, time to hire, and a weekly trend.
- 3
The cleaning
Twenty-six duplicate applications and one withdrawn offer were left out and listed.
- 4
The receipts
Stage names were matched to five standard stages, and the receipt shows how.