Goal of the analysis:
Assess how effectively the organization captures feedback from departing employees by measuring the percentage of eligible leavers who complete an exit interview or survey. For executives, a strong completion rate ensures robust, unbiased insight into root causes of attrition, enabling targeted retention actions and risk mitigation. Low or uneven completion rates undermine decision quality, introduce bias (e.g., only dissatisfied or only office-based staff respond), and can lead to misallocation of retention investments.
Data required:
- Core HRIS data (Workday, SAP SuccessFactors, Oracle HCM):
- Employee ID, termination date, termination category (voluntary vs involuntary), sub-reason, retirement flag.
- Job family/role, level/grade, department, manager, location/site, geography, employment type (hourly/salaried, union), shift.
- Contactability details at exit (personal email, phone/SMS consent, language preference).
- Exit interview administration data (survey/interview platforms):
- Invite date/time, channel (email, SMS, phone, in-person, virtual), reminder cadence, number of attempts.
- Completion status (completed, partial, declined), completion timestamp, interviewer ID (if applicable).
- Survey mode (anonymous vs confidential), questionnaire version and language.
- Quality and representativeness indicators:
- Item completion rate, open-text response presence/length, average time to complete.
- Respondent vs non-respondent distributions across role, level, tenure band, location, manager, and performance rating.
- Process and compliance context:
- Offboarding checklist completion, policy on eligibility (e.g., include voluntary only; treat RIFs and terminations separately), works council/union requirements.
- Consent and privacy rules (data retention, access controls, anonymity thresholds).
- Historical and benchmark data:
- 12–24 months of historical completion rates by segment and channel.
- External reference ranges where available; otherwise internal top quartile benchmarks.
Detailed step-by-step instruction on how to conduct the analysis:
- Define scope and counting rules:
- Eligibility: typically include voluntary separations; report involuntary/RIF/retirements separately if collected.
- Completion definition: “completed” when respondent answers all mandatory items and submits; track “partial” separately.
- Observation window: measure completions within X days of termination (commonly 30 days) to maintain comparability.
- Extract and integrate data:
- From HRIS, pull all eligible exits with demographics and job attributes for the analysis period (e.g., latest 12 months rolling).
- From survey/interview platform, extract invite logs, status, timestamps, and channel data. Join on employee ID or unique token.
- Standardize channel and status codes; de-duplicate records where multiple invitations exist (use the final status).
- Compute core metrics:
- Exit Interview Completion Rate = Number of completed exit interviews / Number of eligible exits.
- Partial Completion Rate = Number of partials / Eligible exits (useful for diagnosing survey length/UX issues).
- Contactability Rate = Number reached (valid email/phone and invite sent) / Eligible exits.
- Completion Within SLA = Completed within 7 days of invite / Completed.
- Channel Conversion = Completed via channel / Invites sent via that channel.
- Segment the metrics:
- By job family, level, location/site, geography, employment type (hourly vs salaried), shift, tenure band (0–3, 4–12, 13–24, 25–60, 60+ months), manager, and termination sub-reason.
- By channel (email, SMS, phone, in-person), language, and survey mode (anonymous vs confidential).
- By timing (pre–last day vs post–last day interviews) and by reminder count.
- Assess representativeness and bias:
- Compare respondent mix versus total eligible exits across segments; flag >5–10 percentage point gaps.
- Check whether high-risk segments (e.g., frontline, certain sites) are underrepresented; if so, insights may be biased.
- Optionally compute response propensity models to identify factors associated with non-response (channel, timing, manager).
- Process diagnostics:
- Funnel analysis: Eligible → Contactable → Invited → Opened → Started → Completed; quantify drop-offs.
- Timeliness: median days from termination notice to invite; completion within 7/14/30 days.
- Quality: item completion rate and average completion time by segment; long surveys can depress completion.
- Trend and benchmark:
- Plot monthly completion rates and 12-month rolling averages; annotate process changes (e.g., new channel, reminder cadence, questionnaire length change).
- Compare to internal top quartile sites/managers and any available external ranges.
- Synthesize insights and actions:
- Highlight 3–5 hotspots (e.g., low completion among hourly night-shift, certain geographies, or specific channels).
- Link drivers to actions (e.g., add SMS outreach, schedule interviews before last day, switch to confidential third-party collection).
Format of the output of analysis:
- Executive summary slide with current completion rate, trends, key gaps in representativeness, and prioritized actions.
- Funnel dashboard from eligibility to completion with conversion percentages and drop-off points.
- Segmented heatmaps (by site, job family, level, shift, channel) highlighting below-target completion.
- Timeliness charts (invite and completion SLAs) and channel performance (email vs SMS vs phone vs in-person).
- Representativeness comparison tables showing respondent vs eligible distributions.
- Process KPI panel: contactability rate, bounce rate, partial completion rate, average time to complete.
How to interpret results:
- High completion (with balanced representation across segments) signals strong process and credible insights; use with confidence to inform retention strategies.
- High overall completion but skewed by role or location may still be biased; insights should be weighted cautiously or complemented with targeted outreach.
- Low completion indicates process friction (contactability, timing, channel, survey length) or trust concerns (confidentiality). Insights are at risk of non-response bias.
- Channel differences matter: SMS/phone often lift frontline response; email-only can underperform for field roles.
- Improving trend over multiple months post-process changes validates approach; stagnation suggests deeper trust or access issues.
- Short time-to-invite and completion within 7 days typically correlate with higher rates; long lags reduce recall and response.
Steps a company can take to improve on this measure:
- Process and policy:
- Make exit interview part of the offboarding checklist; schedule before the last day when feasible (especially for exempt roles).
- Define eligibility and SLAs (invite within 48 hours of notice; three reminders over 10 days; keep window open 30 days).
- Offer multiple modes: short mobile-friendly survey, SMS link, phone interview, and optional live debrief.
- Trust, confidentiality, and experience:
- Use confidential or third-party administration; communicate clearly that managers will see only aggregated themes.
- Keep surveys concise (10–15 questions, 5–7 minutes) with targeted routing; provide multilingual options.
- Avoid manager presence during interviews to reduce social desirability bias.
- Data, systems, and automation:
- Trigger invitations automatically from HRIS upon resignation entry; pass personal email/SMS with consent.
- Use unique tokens to track status; enable reminder automation and channel switching if unopened.
- Monitor real-time dashboards for contactability, bounces, and completion by segment; alert HRBPs for manual follow-up when needed.
- Capability and governance:
- Train HR/Recruiting/HRBPs on outreach scripts, neutrality, and privacy commitments.
- Set monthly review cadences with targets by business unit/site; spotlight top quartile units to share practices.
- Establish minimum n thresholds for reporting and suppress segment breakouts that risk re-identification.
- If X high, Y low scenarios:
- If completion is high overall but frontline is low, add SMS/phone outreach, shorten survey, and schedule interviews during final shifts.
- If partials are high but completions low, simplify questions, reduce mandatory items, and improve mobile UX.
- If contactability is low, capture personal contact details at resignation, confirm consent, and send invites pre–last day.
- If email conversion lags, test alternative channels (QR codes in offboarding materials, kiosks at site HR, WhatsApp where compliant).
Benchmark comparisons:
General benchmarks:
- Overall electronic exit survey completion commonly ranges 40–60% with standard email outreach; best-in-class programs achieve 70–85% via multi-channel, fast invites, and reminders.
- Live scheduled exit interviews often achieve 60–80% completion for exempt/salaried roles when booked before the last day; lower for hourly or shift-based roles without paid time.
- Completion within 7 days: 60–80% of all completions in high-performing programs.
Segment- or industry-specific benchmarks:
- Professional services, technology, corporate functions: 60–80% typical; top quartile 75–85%.
- Financial services and pharmaceuticals: 55–75% typical; compliance-oriented cultures can reach 70–85%.
- Manufacturing, logistics, field operations: 30–55% typical; top quartile 55–70% with SMS/phone outreach and onsite scheduling.
- Retail, hospitality, call centers (hourly): 20–45% typical; top quartile 45–60% with multi-lingual, mobile-first, and paid time to complete.
- If external benchmarks are limited, construct internal targets by:
- Comparing business units/sites and channels; set targets to internal top quartile performance.
- Tracking 12–24 month trends, adjusting for seasonality and major policy/process changes.
- Normalizing by role mix and tenure; ensure representativeness thresholds before drawing conclusions.