Day 10: Summarise and Act on Exit Interview Data
The Concept
Most organisations collect exit interview data. Very few do anything useful with it. The notes sit in a folder, sometimes on a shared drive, sometimes in an HR system, and they are revisited occasionally when turnover spikes and someone in leadership asks why people are leaving. By that point, the data is months old, the patterns have been visible for a while, and the employees who might have been retained are long gone.
The gap between collection and insight is not usually a resources problem — it is a methodology problem. Qualitative data from exit interviews is genuinely difficult to analyse by hand. Each interview is different. The language is inconsistent. One person says "I didn't feel supported by my manager" and another says "there was no clarity about what success looked like" and another says "I felt like I was always flying blind." These are all expressions of the same underlying problem — inadequate management — but without a systematic way to aggregate them, they read as three separate anecdotes.
The Purpose of Exit Interviews
Exit interviews exist to generate organisational learning, not to manage the departure experience. That distinction matters because it changes how you conduct them, what questions you ask, and what you do with the output. When exit interviews are designed primarily to make the leaver feel heard, they tend to produce polite, vague feedback that is difficult to act on. When they are designed to extract specific, usable intelligence — why did you start looking, what was the tipping point, what would have changed your decision — they produce data that is worth analysing.
The power of the data increases with volume. A single exit interview is an anecdote. Twelve exit interviews from the same function over six months are a pattern. Twenty exit interviews that all reference the same manager, or the same career development concern, or the same structural frustration, are an organisational problem — and one that leadership has an obligation to address.
How AI Extracts Patterns From Qualitative Data
AI is particularly well suited to the kind of thematic analysis that makes exit interview data useful. When you paste a collection of interview notes — even rough, inconsistently formatted notes — into a well-structured prompt, the model can identify recurring language, cluster similar concerns, count how many interviews reference each theme, and surface individual statements that are representative examples. It can also flag by segment: are the themes consistent across the organisation, or do they cluster in a particular department, at a particular level, or among employees who joined at a particular time?
What AI cannot do is interpret the organisational context behind the patterns. If twelve people mention uncertainty about the company's direction, the AI can identify that as a theme. Whether that uncertainty is well-founded, whether it reflects a specific leadership communication failure, or whether it was triggered by a recent announcement — that contextual interpretation requires someone with knowledge of the organisation.
Presenting Findings in a Way That Prompts Action
The failure mode of exit interview reporting is producing a document that describes what people said without connecting it to what the organisation should do differently. Leadership reads a list of themes — career development, management quality, work-life balance — and nods, because these are always the themes, and then nothing changes.
Findings that prompt action are findings with specificity and consequence. Not "management quality was a recurring concern" but "eight of twelve leavers referenced a lack of clarity about expectations or feedback from their manager, with six of those coming from the same department. This suggests a systemic issue in that function rather than isolated individual management failure." Paired with a concrete recommendation — a management effectiveness review, a structured feedback programme, an L&D intervention for the relevant team leads — that finding creates an obligation to act. The AI can help you build that structure. The judgment about which recommendations are feasible sits with you.
Prompt of the day
Copy this into your AI tool and replace any bracketed placeholders.
Prompt
You are an HR analyst specialising in employee insights and people data. I have exit interview notes or transcripts from a number of recent leavers and I need you to extract themes, identify patterns, and turn this into an actionable recommendation for leadership. Here is the context: - Number of exit interviews included: [e.g. 12 exit interviews from the past six months] - Roles or departments the leavers came from: [e.g. mix of individual contributors and team leads across the engineering and product functions] - Format of the data I have: [e.g. written notes taken by HR during 30-minute conversations — not verbatim transcripts] - Any known context I want you to be aware of: [e.g. we had a significant restructure in Q2 and three of these leavers were affected by it] Here are the exit interview notes: [PASTE YOUR NOTES OR TRANSCRIPTS HERE] Please do the following: 1. Read through all the notes and identify the top five recurring themes. For each theme, note how many interviews it appeared in and quote one or two direct examples from the notes. 2. Identify whether any themes cluster by department, tenure, seniority, or timing — and flag this if so. 3. Flag any individual concerns that are serious enough to warrant immediate follow-up (e.g. allegations of misconduct, legal risk, safeguarding issues) and recommend they are reviewed separately. 4. Write a one-page summary brief for a leadership audience, structured as: key findings, patterns worth noting, and three recommended actions with rationale. 5. Suggest two questions HR should be investigating internally as a result of these findings.
Your 15-minute task
Pull together the exit interview notes you have from the past three to six months — even if they are rough, partial, or inconsistently formatted. Paste them all into the prompt. Do not pre-filter or summarise them before pasting; let the AI do the initial analysis. After you review the output, look specifically at whether the themes match what you already believed to be true, and pay attention to anything that surprises you — that is usually where the real signal is.
Expected win
A one-page exit interview findings brief you can share with leadership, with the top themes identified and evidenced, patterns called out by segment where they exist, and three specific recommended actions that go beyond the obvious.
Power user tip
After the initial summary, send this follow-up prompt: 'Based on these exit interview themes, draft a short set of five stay interview questions HR could use with current employees to understand whether the same risks are present in the retained population. The questions should be open-ended, non-leading, and suitable for a 15-minute conversation with an employee's manager present.' Exit interview data tells you why people left. Stay interview data tells you why people might leave — and that is where the intervention still has time to work.