wowprompt

Recruitment funnel report with time to hire and stage drop-off

Turns an export from a hiring tracker or spreadsheet into a recruitment funnel report: candidates at each stage, conversion between stages, time to hire, offer acceptance and the source that brings the best hires. Use it for a monthly hiring review or when roles stay open far longer than planned.

A funnel table with counts and conversion rates per stage, time to hire by role, a source quality table, the three biggest bottlenecks with causes, and actions for next month
The output this prompt produced, unedited.

The prompt

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

  1. Summary in five bullets with the most important number first.
  2. | Stage | Candidates | Conversion to next stage | Median days in stage |
  3. | Role | Applicants | Offers | Joined | Days to hire | Days open |
  4. | Source | Applicants | Reached final round | Joined | Joined per 100 applicants |
  5. The three biggest bottlenecks, each with the evidence and the most likely cause.
  6. Withdrawal and offer-decline reasons grouped and counted.
  7. 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.
recruitment funneltime to hirehiring metricsrecruitment reportcandidate pipelinetalent acquisition

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity