Retention Target 85%, Forecasted 72%: How Pipeline Analytics Identify the 5 Renewals That Close the Gap
How a Cyber underwriting manager uses InsightUW's pipeline forecast to discover that 5 specific renewals — out of 15 expiring policies worth $4.2M — account for the entire retention gap, and uses stage-based analysis to take targeted action before the quarter closes.
The Problem
Every underwriting manager has a retention target. And every quarter, the gap between that target and reality becomes visible too late.
The typical retention management process looks like this:
- Retention is measured after the fact. The manager learns the quarterly retention rate when finance publishes the report — 6 weeks after the quarter ends. By then, the lost policies are gone.
- No pipeline visibility. The manager knows which policies are expiring but has no structured view of where each renewal stands: quoted, negotiating, at-risk, or already lost. They call underwriters one by one to ask for updates.
- No gap quantification. The manager knows retention is "trending below target" but cannot answer: "Which specific renewals, if saved, would close the gap? How much premium is at stake? What stage are they in?"
- No prioritization framework. All at-risk renewals feel equally urgent. The manager cannot distinguish between a $50K policy where the broker has a competing quote and a $600K policy where the insured is dissatisfied with claims handling.
- Action is reactive, not surgical. The manager sends a blanket email: "Everyone focus on renewals this week." This is not a strategy — it is a plea.
The result: retention targets are aspirational numbers that the team hopes to hit rather than operational targets they manage toward with data.
The InsightUW Approach
InsightUW's Pipeline Analytics module provides a real-time retention forecast by aggregating renewal work items across stages, computing expected retention using stage-based probability weighting, identifying the gap to target, and surfacing the specific renewals that — if retained — would close that gap.
The Pipeline Forecast API
The forecast API returns a complete view of the renewal pipeline: every expiring policy, its current stage, the probability-weighted expected outcome, and the aggregate retention forecast.
The Gap Calculation: Which 5 Renewals Close the Gap?
The gap analysis is the critical output. It identifies the specific renewals that — if moved from their current stage to BOUND — would close the $541,800 gap between the forecasted 72.1% retention and the 85% target.
Stage-Based Retention Analysis
The Scenario
Catherine Walsh manages the Cyber underwriting team at Atlantic Mutual. Her Q2 2026 retention target is 85% across 15 expiring policies worth $4.2M in premium. It is April 21, and she opens the Pipeline Analytics dashboard to see where she stands.
The Manager's Monday Morning View
Catherine sees the retention gauge: 72.1% forecasted against an 85% target. The gauge is amber, indicating the gap is closable but requires action. Below the gauge, the pipeline funnel shows the stage distribution:
| Stage | Policies | Premium | Expected Retention | Contribution to Forecast |
|---|---|---|---|---|
| Bound | 5 | $1,480,000 | $1,480,000 (100%) | 35.2% of expiring |
| Quoted | 3 | $920,000 | $782,000 (85%) | 18.6% of expiring |
| Negotiating | 3 | $1,050,000 | $630,000 (60%) | 15.0% of expiring |
| At-Risk | 3 | $580,000 | $116,000 (20%) | 2.8% of expiring |
| Lost | 1 | $170,000 | $0 (0%) | 0% of expiring |
| Total | 15 | $4,200,000 | $3,028,000 (72.1%) | 72.1% |
The Gap Closure Plan
Catherine clicks "Show Gap-Closing Renewals" and sees the 5 policies ranked by premium impact. The system tells her:
"Retaining just GlobalReach ($450K) and any one of Sentinel ($320K), EverBright ($260K), or Quantum ($280K) closes the $541.8K gap."
She takes action:
| Day | Action | Renewal | Expected Outcome |
|---|---|---|---|
| Monday AM | Call Marsh broker re: GlobalReach rate | GlobalReach Logistics ($450K) | Reduce rate from +15% to +10%, match market |
| Monday PM | Email Lisa Kim: restore ransomware sublimit on Sentinel | Sentinel Healthcare ($320K) | Address coverage concern, move to Quoted |
| Tuesday AM | Schedule claims review meeting for PrimeData | PrimeData Analytics ($190K) | Address claims handling complaint |
| Tuesday PM | Approve social engineering endorsement for Quantum | Quantum Computing Labs ($280K) | Coverage expansion closes deal |
| Wednesday AM | Multi-year proposal for EverBright | EverBright Energy ($260K) | 2-year deal at +12% vs competing +10% |
Two Weeks Later: Updated Forecast
| Renewal | Previous Stage | New Stage | Premium Impact |
|---|---|---|---|
| GlobalReach Logistics | NEGOTIATING | BOUND | +$450,000 retained |
| Sentinel Healthcare | NEGOTIATING | QUOTED | +$128,000 expected |
| Quantum Computing Labs | NEGOTIATING | BOUND | +$280,000 retained |
| PrimeData Analytics | AT_RISK | NEGOTIATING | +$76,000 expected |
| EverBright Energy | AT_RISK | LOST | $0 (moved to Coalition) |
Updated forecast: 84.2% retention — within 0.8% of target. Catherine saved 3 of 5 gap renewals, exactly matching the system's "realistic case" prediction.
Metrics: Before and After Pipeline Analytics
| Metric | Before InsightUW | After InsightUW | Improvement |
|---|---|---|---|
| Retention forecast visibility | End-of-quarter report (6 weeks late) | Real-time daily forecast | 100% faster |
| Time to identify at-risk renewals | Weeks (manual broker calls) | Instant (stage-based classification) | 95% faster |
| Gap-closing renewals identified | Never (no gap analysis existed) | Top 5 ranked by premium impact | New capability |
| Actionable recommendations per renewal | None (generic "focus on renewals") | Specific (rate concession, coverage adjustment) | New capability |
| Quarterly retention rate | 78% average | 84% average | 8% improvement |
| Premium retained per quarter (Cyber) | $3.28M of $4.2M | $3.53M of $4.2M | $250K incremental |
| Manager time on retention analysis | 4–6 hours/week (manual tracking) | 30 min/week (dashboard review) | 88% reduction |
| Retention target achievement rate | Hit target 40% of quarters | Hit target 75% of quarters | 88% improvement |
Key Takeaways
-
Retention is a pipeline management problem, not a measurement problem. Measuring retention after the fact is accounting. Managing retention in real-time using pipeline stages, probability weighting, and gap analysis is underwriting strategy.
-
The gap is always closable if you know which renewals to focus on. A 12.9% gap sounds insurmountable. "$541.8K across 5 specific policies with specific actions" is a Tuesday morning to-do list.
-
Stage-based probability weighting turns guesswork into math. Instead of "I think we'll retain about 75%," the pipeline says "BOUND policies contribute $1.48M certain, QUOTED contribute $782K at 85% probability, NEGOTIATING contribute $630K at 60% probability." The forecast is decomposable and auditable.
-
Recommended actions are the bridge from analysis to execution. The gap analysis does not just say "save this renewal." It says "reduce rate from +15% to +10%" or "restore the ransomware sublimit." The manager knows exactly what lever to pull.
-
Trend tracking creates accountability. When the retention forecast is visible daily, the team cannot hide behind "we didn't see it coming." The gap was visible 8 weeks before quarter-end, and the system recommended specific actions.
Ready to turn retention targets from aspirational numbers into operational dashboards? InsightUW's pipeline analytics show you the exact renewals, the exact gap, and the exact actions needed to close it.