Personalized renewal presentations across a multi-group captive portfolio.

They faced a monthly bottleneck: generating personalized plan performance review decks for each client from spreadsheet data. The portfolio team spent roughly two hours per deck — seventy hours per cycle just to communicate plan performance, claims trends and renewal recommendations.

Critical work, but highly repetitive.

The team uploaded their Excel file: group names, enrollment numbers, claims history, premium levels, stop-loss thresholds, pharmacy spend, network utilization rates, renewal dates.

Within five minutes, thirty-five channels were created — one per employer group — each populated with that group's specific metrics and the captive's branding standards.

All thirty-five groups running in parallel. Each presentation came with customized slides showing plan overview, cost performance against captive benchmarks, pharmacy spend analysis, network utilization metrics and recommendations.

The quality was polished enough to send directly to clients — annual review decks that previously took weeks to produce were now ready for review and refinement.

Preferences stored after client feedback became templates for the next cycle. When the team requested a captive benchmarks comparison slide, stop-loss proximity callouts on recommendations and specialty pharmacy breakouts, these became automated rules that applied to all thirty-five groups in the next regeneration.

Cycle two took the same forty-five minutes but required zero instruction — the system remembered exactly how to build each deck.

Regenerating all thirty-five decks with new metrics — and automatically emailing them to HR contacts — took the same time, but now included intelligence the system had gathered. It identified four groups with claims ratios above 80% that needed intervention, spotted two renewals approaching within sixty days, flagged six groups with specialty pharmacy spend above 35% where the captive's partnerships could drive savings, and caught a new group whose stop-loss threshold looked misaligned with their peer group.

They could now see which groups would benefit most from specific offerings like virtual primary care (by analyzing ER utilization patterns), which groups were at risk during renewal (by tracking trend data), and which partnerships were underutilized (by comparing actual to projected pharmacy savings).

What took three hours of manual analysis per group now happened across all thirty-five simultaneously.

The captive's relationship with clients deepened because the team could address questions with current plan performance context already in hand. The seventy hours of manual work per cycle compounded into capacity for the work that actually moved the business: client conversations, network design and renewal strategy.