wowprompt

Employee attrition analysis by team, tenure and exit reason

Calculates attrition rates from a headcount and leavers list, breaks them down by team, tenure band and exit reason, and points to the patterns worth acting on. Use it before a quarterly people review or when one team seems to keep losing staff.

A table of attrition rate by team and tenure band, a ranked list of exit reasons, and three findings with suggested retention actions
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Period: [e.g. 1 April 2026 to 30 September 2026]
  • Headcount at the start and end of the period, by team: [paste]
  • Leavers: [one row each with team, role level, joining date, leaving date, voluntary or involuntary, and stated exit reason]
  • Any known events in the period: [e.g. office move, salary revision, new manager in Sales]
  • Benchmark you compare against, if any: [e.g. last year's rate, none]

Task

Measure attrition correctly, find where it is concentrated, and suggest what to look into first.

Output format

  1. Overall attrition rate: leavers divided by average headcount, shown as a period rate and an annualised rate, with the formula.
  2. | Team | Average headcount | Leavers | Voluntary | Rate % |
  3. | Tenure band (under 6 months, 6-12 months, 1-3 years, over 3 years) | Leavers | Share % |
  4. Exit reasons ranked by count, with reasons grouped into plain themes such as pay, manager, growth, workload, relocation.
  5. Three findings, each with the evidence and one action to test.

Rules

  • Keep voluntary and involuntary exits apart in every table.
  • Flag any team with fewer than ten people: one leaver changes its rate sharply, so say so.
  • Do not name individuals or guess reasons that were not recorded; mark them "not stated".
  • Report what the data shows; do not claim a cause from a single period.

Example

Finding: 7 of 12 voluntary leavers left within six months of joining, all in Customer Support. Action: review the first-month onboarding and workload in that team.

employee attrition ratestaff turnover analysishr analyticsexit interview reasonsretention analysisearly attrition

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