Analyze my recruiting funnel and find where candidates drop off
A funnel analysis of pass-through rates, time in stage, and sources that pinpoints bottlenecks and what to fix first.
The prompt
Analyze my recruiting funnel data and tell me where we're losing candidates.
Data: [PASTE ATS export or numbers by stage - e.g. applied, screened, hiring manager review, interviews, offer, accepted; with dates and source if available]
Roles covered and time period: [DETAILS]
Targets or benchmarks we use: [e.g. time to fill, offer acceptance rate - or "none"]
Known context: [e.g. hiring freeze, new interview process, a new job board]
Do the following:
1. Calculate pass-through rates between each stage, time in each stage, and overall time to fill, by role and by source if the data allows.
2. Identify the 3 biggest bottlenecks and the likely causes (e.g. slow hiring manager review, a screen that's too strict, offers below market, a source bringing low-quality applicants).
3. Compare sources on quality (how many reach interview and offer), not just volume.
4. If demographic data is included and was collected lawfully, check stage-by-stage pass-through for signs of adverse impact and flag where to look closer. Tell me to involve HR or legal before acting on it.
5. Recommend 3-5 fixes with the metric each should move.
Output: a summary table, the findings in plain language, and a short note I can share with leadership. Only use the numbers I provide; state where small sample sizes make a conclusion unreliable.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- DETAILS
- e.g. time to fill, offer acceptance rate - or "none"
- e.g. hiring freeze, new interview process, a new job board
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Design a data model for HR reporting and analyticsA warehouse design for HR data with effective dating, clear grain, agreed metric definitions, and access controls for sensitive fields.
- Design a one-page company scorecard for my leadership teamA single page of leading and lagging metrics, with owners, targets, and thresholds, that the leadership team reviews every week.
- Prepare a quarterly people review for the business leader I supportTurns your client group's HR data into a concise quarterly review with insights, risks, and recommended actions for the leader.
- Write a monthly IT and security report for leadershipTurns ticket, uptime, and security metrics into a short report showing trends, risks, and decisions needed.