OptiSecure Insurance is an end-to-end analytics solution integrating Data Science, Predictive Modeling, and Business Intelligence to forecast policy renewals, optimize marketing campaigns, and enhance customer lifetime value.
The project uniquely features an AI-powered Looker Studio assistant powered by Google Gemini, allowing executives to derive natural-language insights directly from their data dashboards.
This report provides an in-depth analysis of OptiSecure Insurance’s policy renewal trends. The overall policy renewal rate is 14.91%, indicating a moderate level of retention. However, predictive modeling reveals a significant opportunity: a "High Propensity" segment exists that performs at double the average rate.
Critical inefficiencies were detected in Campaign 2, which is statistically failing (1.3% acceptance). Conversely, drivers for renewal include high education levels (PhD/Masters), catalog engagement, and tenure milestones (Year 13).
The analysis consolidated Customer Profile, Purchase Behaviour, and Campaign Performance data. Feature Engineering included creating a "Response Score" (predictive probability) and "Renewal Buckets" to classify customers into High (26%), Mid (24%), and Low (50%) tiers.
Education Impact: Higher education correlates with stability. PhD holders have the highest propensity score (0.29), compared to Basic education holders (0.18).
Tenure Trends: Analysis reveals a "Golden Cohort" at Tenure Year 13, showing outlier loyalty performance. Conversely, Years 11 & 12 represent a churn risk period.
Financial Profile: High Income customers renew at 18%, nearly double the rate of Low Income customers (10%). Retention efforts must prioritize financial value.
Catalog is the strongest differentiator; high propensity customers make 2.3x more catalog purchases. Engagement drops off sharply after 60 days ("Recency"), making the first 20 days critical for retention.
Profile: High income (>£67k), PhD/Master education, active within last 20 days.
Profile: Average income, moderate tenure, selective shopper.
Profile: Low income, inactive >60 days, "Basic" education, zero campaign history.
The Gemini-powered chatbot allows executives to query the data naturally:
Action: Pause Campaign 2 immediately and reallocate budget to Campaign 4. Leverage Catalogs by sending physical mailers specifically to the "High Propensity" bucket.
Action: Implement a "Loyalty Anniversary" reward for the "Golden Cohort" (Tenure 13). Deploy proactive engagement campaigns for the "Risk Years" (Tenure 11-12).
Action: Target the High Propensity group with value-add services. Offer flexible payment options to the Low Propensity group to solve the affordability churn driver.
While the portfolio is stable, leveraging these insights—specifically targeting the educated, high-income segment with Catalog campaigns and retiring the failing Campaign 2—can increase the renewal rate toward 18-20%. Data-driven decision making will maximize marketing ROI and strengthen long-term profitability.
Founded: 2011 | Headquarters: Manchester | Policyholders: 350,000+
Established in 2011, OptiSecure Insurance is a digital-first insurer specializing in personal lines. The firm leverages sophisticated analytics and mobile app-based servicing to maintain award-winning customer satisfaction.