Goal of the analysis:
Measure the percentage of new hires who remain employed 90 days after their start date, identify the drivers of early attrition (voluntary and involuntary), and implement targeted fixes across recruiting, onboarding, and frontline leadership. The 90-day window is the most vulnerable period for new hires: gaps in role clarity, provisioning, scheduling, training, and culture fit often surface quickly. Executives use this metric to reduce expensive re-hiring cycles, stabilize operations (overtime, service levels), improve quality and safety, and raise the ROI of Talent Acquisition by converting accepted offers into productive, engaged employees.
Data required:
- HRIS/Payroll:
- New hire records: employee ID, start date, job family/level, location, FTE/part-time, union status, shift, pay rate.
- Termination data: end date, voluntary vs involuntary, reason codes, transfer/internal move flags, leave-of-absence indicators.
- ATS/Talent Acquisition:
- Requisition metadata; source channel (referral, job board, agency, internal); Time to Hire/Fill; Offer Acceptance Rate; hiring manager and recruiter.
- Candidate notes on expectations (shift, pay, remote/on-site), start-date delays.
- Onboarding and provisioning (LMS/IT/Facilities/HR Ops):
- Onboarding checklist completion (I-9, benefits enrollment, policy acknowledgments), orientation attendance.
- IT/Facilities readiness: device/access request and completion timestamps; system log-in first-use; badge/access.
- Buddy/mentor assignment; manager 30-60-90 plan documented.
- Training and role readiness (LMS/Operations):
- Required training assignments and completion dates; assessment scores; certification milestones.
- Early productivity proxies (units/hour, tickets closed, calls handled) and quality (error rate, rework) where applicable.
- Scheduling and workload (WFM/Time & Attendance):
- Assigned shifts vs promised shifts, schedule stability, overtime hours, weekend/night allocation, commute distance (if available).
- Engagement and employee relations:
- New-hire pulse surveys at 7/30/60 days (role clarity, manager support, belonging), eNPS; ER cases or performance warnings during first 90 days.
- Exit interview summaries where available.
- Normalization and policy:
- Counting rules for transfers, leaves, rehires; definition of “retained” at day 90; cohort definition (start-date month).
Detailed step-by-step instruction on how to conduct the analysis:
- Define cohorts and counting rules.
- Define a monthly cohort of new hires by start date. Exclude interns/seasonal if managed separately.
- 90-Day Retention Rate (%) = (Number of cohort hires still employed on day 90) ÷ (Total hires in cohort) × 100.
- Also compute: Voluntary Retention (exclude involuntary separations), Early Attrition Rate = 100 − Retention, and splits by voluntary/involuntary.
- Set rules for leaves (count as retained if still employed) and internal transfers (retained if still with company).
- Extract and align data.
- Pull 6–12 months of HRIS hires/terminations; join to ATS (source, TTF, recruiter, hiring manager), onboarding checklists, LMS completions, IT provisioning, and scheduling/attendance.
- Normalize job families/levels, locations, and shift codes; ensure one row per hire with day-90 status.
- Compute retention and time-to-exit.
- For each cohort, compute Retained/Not retained at day 30/60/90 and days-to-exit for leavers.
- Plot a simple survival curve (Day 0→90) to expose when exits cluster (e.g., before first paycheck, after week 2 training).
- Segment and localize.
- Break out retention by job family, site, shift (day/evening/night), pay band, manager, source channel, remote vs on-site, union/non-union.
- Compare internal vs external hires where relevant.
- Link to onboarding and readiness.
- Compute Onboarding Completion Index (% of checklist done by Day 0 and Day 5), IT readiness on Day 1, training completion by 30/60 days.
- Correlate these with 90-day retention and time-to-exit; flag gaps (e.g., incomplete access on Day 1 predicts early exits).
- Assess scheduling, pay, and expectation alignment.
- Compare schedule stability (changes/week), overtime burden, and promised vs assigned shift to retention.
- Overlay pay rate vs market midpoint (if available) and commute time bands against retention.
- Identify top drivers.
- Build a driver bridge using categorical comparisons: source channel, manager, shift, onboarding readiness, training completion, schedule stability, pay band.
- Quantify each factor’s delta to retention (e.g., “buddy assigned” +6 pts vs no buddy).
- Qualitative insights.
- Review exit interviews and new-hire pulse verbatims for themes: role clarity, manager support, culture/Belonging, workload, commute, flexibility, benefits understanding.
- Set targets and forecast impact.
- Define targets by role/site (e.g., frontline ≥85%, professional ≥95%).
- Model savings: reduced backfills × Cost per Hire, less overtime/premium labor, stabilized productivity/quality.
- Integrity checks.
- Ensure headcount reconciliation (hires − separations = net change ± transfers/leaves). Validate termination reasons and dates.
- Suppress results where counts are small to protect privacy; avoid using protected-class data except in compliant, aggregated analyses.
Format of the output of analysis:
- Executive scorecard: 30/60/90-Day Retention %, voluntary vs involuntary splits, cohort size, early attrition hotspots (week bands), trend vs target.
- Heatmaps: retention by site × job family/shift; by source channel; by hiring manager.
- Survival curve: cumulative retention over 0–90 days with annotations (orientation, first paycheck, end of training).
- Onboarding readiness panel: Day-0/Day-5 checklist completion, IT readiness, training completion vs retention (scatter/box plots).
- Driver bridge: contribution of scheduling, buddy assignment, pay band, source, and manager practices to retention deltas.
- Action tracker: prioritized fixes, owners, due dates, expected retention lift and cost impact.
How to interpret results:
- High 90-day retention with strong Day-0 readiness and training completion: Onboarding design and manager execution are effective; sustain and codify standards.
- Attrition spikes in first 1–2 weeks: Provisioning/expectations gap—fix Day-1 readiness, realistic job preview, and manager touchpoints.
- Night/weekend shifts materially lower retention: Schedule hardship—improve predictability, rotate fairly, and add differentials; bolster on-shift supervisor support.
- Agency/job board hires churn more than referrals/internal: Sourcing quality/fit gap—tighten screening and use realistic job preview; grow referrals.
- Manager-specific gaps: Coaching/coverage issue—enable managers with 30-60-90 plans and check-in templates; rebalance spans if needed.
- Remote hires lower retention: Strengthen virtual onboarding, buddy cadence, equipment logistics, and community-building.
Steps a company can take to improve on this measure:
- Preboarding and Day-1 readiness:
- Lock provisioning SLAs (devices, system access, badge) before start; confirm schedule, pay, and role expectations in writing; assign buddy/mentor pre-Day 1.
- Structured onboarding and training:
- Implement a 30-60-90 plan per role; modular, job-relevant training with practice; verify skill with checklists; track completion and coach quickly.
- Manager enablement and cadence:
- Require manager 1:1s at Day 1/7/30/60/90; provide conversation guides; monitor completion; recognize managers with top retention.
- Realistic job preview and selection:
- Add videos/job shadowing; be explicit on shift patterns, physical demands, and KPIs; calibrate screening to reduce mismatches.
- Scheduling and support:
- Stabilize schedules for first 4–8 weeks; limit overtime; place new hires with experienced leads; ensure on-shift coaching.
- Comp/benefits clarity and equity:
- Align pay to market; explain benefits and enrollment early; offer timely sign-on payouts where used; monitor pay compression for internals.
- Community and inclusion:
- Welcome rituals, cohorts, and chat groups; solicit pulse feedback at 7/30/60 days and close loops (“you said, we did”).
- Example scenarios:
- If 90-day retention for night shift pickers is 74% with low Day-1 readiness, set provisioning SLA and add a night onboarding lead; target +8–12 pts within 2 months.
- If agency-sourced CSRs churn at 30% by Day 60, add realistic job previews and a 2-week nesting program; expect attrition −10–15 pts and faster ramp.
- If managers with spans >20 show low retention, add coordinator support and mandated check-ins; aim +6–8 pts in two cohorts.
Benchmark comparisons:
General benchmarks (directional):
- Frontline/hourly (warehousing, manufacturing, contact centers): 90-day retention often 75–90% depending on market, shifts, and onboarding quality.
- Retail/hospitality: 60–85% with high variability; strong onboarding and scheduling discipline push toward the upper end.
- Professional/exempt roles: typically 90–98%; lower values suggest selection/onboarding or role clarity issues.
Constructing internal benchmarks:
- Track monthly 30/60/90-day retention by role family/site/shift and by source; publish quartiles and set guardrails (e.g., 90-day retention below internal P25 triggers action plan).
- Measure and target onboarding KPIs: Day-0 readiness ≥95%, buddy assignment ≥95%, manager check-ins ≥90% on time; link improvements to retention lift.
- Pair retention with Time to Productivity, Cost per Hire, Offer Acceptance, and quality/defect rates to ensure improvements deliver operational value.
- Rebaseline after onboarding redesigns, provisioning SLA changes, or scheduling policies; codify best-site playbooks.