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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Evaluate intern presentations for full-time conversion
Generate a fair rubric and debrief agenda to score final intern presentations and make return offer decisions.
Respond professionally to a candidate compensation counter-offer
Address a candidate's salary negotiation politely, outlining what your team can adjust while protecting internal pay bands.
Offer summary email highlighting total compensation and benefits
Turn raw compensation details into a warm, clear offer summary email that showcases benefits, equity, and perks beyond base pay.
Write a personalized outreach message to passive candidates
Turn a candidate's background and open job details into a concise, tailored sourcing message that sparks genuine interest.
Turn Interview Notes into a Fair, Evidence-Based Hiring Recommendation
Paste your interview notes and get a hiring recommendation that separates evidence from impressions, rates each role criterion, and lists doubts to check before an offer.
Launch an employee referral drive with clear rewards
Announce high-priority hiring roles and referral bonuses to staff with simple submission steps and qualification rules.
- Turn Rough Role Notes into a Clear, Inclusive Job Description
- Compare a Resume to a Job Description with Evidence Ratings and Probe Questions
- Write a 20-Minute Phone Screen Script with Knockout Questions and Pass Criteria
- Write Reference Check Questions and a 1-4 Scoring Sheet for a Finalist
- Audit a Job Description to Remove Subtle Bias and Jargon
- Build a Role Competency Scorecard with 4-Level Evaluation Criteria