Turn Raw Hiring Data into an Executive Recruiting Summary

Transforms applicant tracking pipeline numbers into a concise executive overview covering funnel drop-offs, time-to-hire, offer acceptance, and action steps.

You getExecutive Scorecard, funnel Breakdown and primary Bottleneck

Prompt

Prompt
Act as a talent acquisition director. Your job is to convert raw recruiting numbers into an executive-ready hiring pipeline report.

I will paste raw data from our applicant tracking system directly below this prompt. If I have not provided the data yet, ask me for: total applicants, candidates screened, candidates interviewed, offers made, offers accepted, and average days open.

Rules:
1. Calculate the conversion rate for each transition step (Application to Screen, Screen to Interview, Interview to Offer, Offer to Accept).
2. Highlight the single biggest drop-off stage and explain the operational risk it creates.
3. Keep every metric tied to hiring velocity or cost impact without jargon.
4. Provide exactly 3 high-impact recommendations to improve pipeline health next quarter.

Output format:
- Executive Scorecard: 4-line summary of total hires, average days to hire, offer acceptance rate, and overall pass-through rate.
- Funnel Breakdown: Markdown table with Stage, Candidates, Conversion %, and Drop-off Rate.
- Primary Bottleneck: 2 sentences naming the worst leak and its primary cause.
- Strategic Recommendations: Exactly 3 numbered items, each starting with an active verb.
- Risks & Blind Spots: One sentence stating what data is missing from the analysis.

Example output

Example for: Q3 engineering recruitment pipeline for 6 open backend software engineer roles.

Executive Scorecard
  • Total Hires Completed: 4 of 6 target roles filled
  • Average Time-to-Hire: 58 calendar days
  • Offer Acceptance Rate: 80% (4 accepted out of 5 extended)
  • Overall Pipeline Yield: 0.95% (4 hires from 420 initial applicants)
Funnel Breakdown
StageCandidatesConversion %Drop-off Rate
1. Application Received420100%0%
2. Recruiter Phone Screen6415.2%84.8%
3. Technical Panel Interview1421.9%78.1%
4. Formal Offer Extended535.7%64.3%
5. Offer Accepted480.0%20.0%
Primary Bottleneck

The technical panel stage presents the sharpest operational leak, eliminating 78.1% of screened candidates. This high attrition indicates either misaligned candidate screening criteria between recruiters and hiring managers or an overly broad technical assignment that discourages qualified senior engineers.

Strategic Recommendations
  1. Recalibrate the recruiter phone screen scorecard against the specific system design criteria required in the technical panel to eliminate unqualified candidates earlier.
  2. Shorten panel scheduling turnarounds from 9 business days to 3 business days by establishing pre-cleared weekly interviewer hold blocks on engineering calendars.
  3. Standardize salary benchmarking conversations during the initial phone screen to protect the 80% offer acceptance rate against late compensation mismatches.
Risks & Blind Spots

This summary lacks post-offer candidate withdrawal feedback and sourcing channel attribution, meaning we cannot verify whether underperforming job boards inflated top-of-funnel drop-offs.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forces direct mathematical conversion rates between stages to pinpoint exactly where pipeline volume collapses.
  • Limits output to a clean four-point executive scorecard and a standard markdown table suitable for leadership decks.
  • Restricts recommendations to exactly three action-oriented steps that directly address funnel bottlenecks.

Paste your raw applicant tracking metrics directly after this prompt in ChatGPT, Claude, or Gemini to get an executive report ready for leadership meetings.

Common edits

  • Specify target department benchmarks if comparing engineering against sales hiring cycles.
  • Request an additional column in the table showing cost-per-hire or source breakdown if financial data is available.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in HR & Management