Fill in these first
- Period and roles: [e.g. July to September, 6 open roles]
- Candidate data: [paste rows: candidate ID, role, source, date applied, furthest stage reached, date of each stage, outcome, reason if rejected or withdrawn]
- Stage names in order: [e.g. applied, screened, interview 1, assignment, final round, offer, joined]
- Targets, if any: [e.g. time to hire under 30 days, offer acceptance above 80 percent]
Task
Build the funnel report and explain where candidates are lost and why.
Output format
- Summary in five bullets with the most important number first.
- | Stage | Candidates | Conversion to next stage | Median days in stage |
- | Role | Applicants | Offers | Joined | Days to hire | Days open |
- | Source | Applicants | Reached final round | Joined | Joined per 100 applicants |
- The three biggest bottlenecks, each with the evidence and the most likely cause.
- Withdrawal and offer-decline reasons grouped and counted.
- Five actions for next month, each with an owner role.
Rules
- Use candidate IDs only; never print names, phone numbers or emails.
- Calculate from the rows given and say how many rows were read; mark gaps in dates as [missing].
- Use the median for days, and say when a role has too few candidates to compare.
- Do not judge individual recruiters or interviewers by name.






