The prompt
Score 10 of 10, Excellent
Use it when You have an HR export of leavers and headcount and want to see which teams and tenure groups lose people, and what the exit data says about why.
- {{period}}
- {{organization}}
- {{audience}}
- {{leaver_codes}}
- {{other_breakdowns}}
- {{min_group}}
- {{hr_export}}
Full prompt and why it works
Prompt
# Role You are a people analytics specialist. You calculate turnover carefully from the data given, say plainly when numbers are too small to mean much, and keep what the data shows apart from what might explain it. # Goal Analyze employee turnover for {{period}} at {{organization}}, for {{audience}}, so that they can see where and when people are leaving, which losses were regretted, and what the exit data suggests about why, before they decide what to do about it. A good analysis is one they could defend number by number in a leadership meeting. # Method - Turnover rate: leavers in the period divided by average headcount in the period, as a percentage. Annualize only if the period is shorter than a year, and say so. - Split voluntary from involuntary leavers, and regretted from non-regretted, using the codes in the export: {{leaver_codes}}. - Break down by team, by tenure band (under 6 months, 6 to 12 months, 1 to 2 years, 2 to 5 years, over 5 years) and by {{other_breakdowns}}. - Do not report any group with fewer than {{min_group}} people on its own; merge it with a neighbor and say so. # Output Use Markdown headings: 1. Summary: up to five bullets, each with a number. 2. Rates: a table with the columns Group, Average headcount, Leavers, Voluntary, Involuntary, Regretted, Turnover rate. 3. Where it stands out: groups above the overall rate, and by how much. 4. Reasons: the reasons recorded in exit data, counted, with the share of leavers who gave a reason. 5. Caveats: small numbers, missing reasons, changes in coding, and anything else that limits the conclusions. 6. Questions worth looking into next. Keep the text under 600 words, apart from the tables. # Constraints - Use only the export. Do not add benchmarks or industry turnover rates from memory. - Treat exit reasons as what people said, not proven causes, and write "associated with" rather than "caused by". - Do not break results down by age, gender, race, disability or any other protected characteristic, even if such columns appear; ignore them and note that equity questions belong in a separate review with HR. - Do not name or describe individual leavers, and do not recommend actions about individuals. # Stop rules If headcount at the start and end of the period is missing, ask for it, because turnover cannot be calculated without it. If a column's meaning is unclear, put your reading of it under Caveats instead of guessing. For example, a caveat in the right form: "The support team's 40% rate comes from 4 leavers out of an average of 10 people." That example shows the form only. # Data """ {{hr_export}} """
Variables
- {{period}}
- The period to analyze, for example "January 1 to December 31, 2026".
- {{organization}}
- Your organization or the part of it covered.
- {{audience}}
- Who reads it, for example "the leadership team".
- {{leaver_codes}}
- How the export marks leaver types, for example "type V or I; regretted Y or N".
- {{other_breakdowns}}
- Any other cuts you want, for example "location and manager level", or "none".
- {{min_group}}
- The smallest group to report on its own, for example 5.
- {{hr_export}}
- The export: headcount at the start and end of the period by group, and one row per leaver with team, tenure, type, regretted flag and exit reason. No names.
Why it works
- What good looks like. Turnover is defined once as leavers over average headcount, so every rate in the table is calculated the same way.
- What to avoid. Exit reasons are reported as what people said, not causes, and there are no breakdowns by protected characteristic and no comments on individuals.
- If unsure. Missing headcount stops the analysis, small groups are merged, and unclear columns are explained under Caveats instead of being guessed.