Cross-Sell Gap Analysis: Find the Revenue Hiding in Your Book
By Laksh Pujary, Founder of Autoikigai AI Employees for Insurance Agencies
The Money You Already Earned But Never Collected
Your book of business is a goldmine of unwritten premium. The average independent agency has a cross-sell ratio of 1.3 policies per household. Best-in-class agencies sit at 2.4 or higher.
That gap is not a marketing problem. It is a data problem. You already have the clients. You just never systematically identified what they are missing.
What Is a Book-of-Business Gap Analysis?
A gap analysis compares what each client HAS to what they SHOULD have based on their profile. It produces a prioritized list of cross-sell opportunities ranked by likelihood to close and expected revenue.
CLIENT RECORD
|
v
+-------------------+
| CURRENT POLICIES |
| - Auto |
| - (nothing else) |
+-------------------+
|
v
+-------------------+
| PROFILE ANALYSIS |
| - Homeowner? Y |
| - Business? N |
| - Kids? Y (2) |
| - Assets > 300K? |
+-------------------+
|
v
+-------------------+
| GAP IDENTIFIED |
| - NO Home policy |
| - NO Umbrella |
| - NO Life |
+-------------------+
|
v
+-------------------+
| PRIORITY SCORE |
| Home = 95/100 |
| Umbrella = 82/100 |
| Life = 71/100 |
+-------------------+Step 1: Export Your Book Data
From Applied Epic
- Navigate to Reports > Policy Reports
- Select “Active Policies by Client”
- Include fields: Client ID, Name, Policy Type, Line of Business, Premium, Effective Date, Property Address
- Export as CSV
From AMS360
- Go to Reports > Custom Reports
- Build query: All active clients with policy detail
- Include: Client Code, Insured Name, LOB, Written Premium, Status
- Export to Excel
From HawkSoft
- Reports > Client Reports > Policies by Client
- Filter: Active policies only
- Include all lines of business
- Export CSV
Step 2: Build the Gap Analysis Spreadsheet
Column Structure
| Column | Description | Source |
|---|---|---|
| A: Client ID | Unique identifier | AMS export |
| B: Client Name | Full name | AMS export |
| C: Has Auto | Y/N | AMS export |
| D: Has Home | Y/N | AMS export |
| E: Has Umbrella | Y/N | AMS export |
| F: Has Life | Y/N | AMS export |
| G: Has Commercial | Y/N | AMS export |
| H: Has Flood | Y/N | AMS export |
| I: Total Policies | Count | Calculated |
| J: Mono-Line? | Y if I = 1 | Calculated |
| K: Missing Bundle | What they need | Formula |
| L: Priority Score | 1-100 | Formula |
| M: Est. Premium | Dollar value | Lookup |
| N: Last Contact | Date | AMS export |
| O: CSR Assigned | Name | AMS export |
Step 3: Identify Mono-Line Clients
Mono-line clients are your highest-risk AND highest-opportunity segment.
Why They Are Dangerous
- Retention rate for mono-line: 72-78%
- Retention rate for multi-line: 92-95%
Every mono-line client is one competitive quote away from leaving.
Why They Are Opportunity
- They already trust you with one policy
- The relationship exists
- The conversation is warm, not cold
Mono-Line Breakdown Template
TOTAL CLIENTS: 1,200
MONO-LINE CLIENTS: 540 (45%)
- Auto only: 310 (57% of mono)
- Home only: 145 (27% of mono)
- Commercial only: 85 (16% of mono)
DUAL-LINE CLIENTS: 420 (35%)
- Auto + Home: 290
- Auto + Umbrella: 45
- Other combos: 85
TRI-LINE OR MORE: 240 (20%)If 45% of your book is mono-line, you have a retention crisis AND a revenue opportunity.
Step 4: The Gap Identification Matrix
Personal Lines Gaps
| Client Has | They Likely Need | Close Rate | Avg Premium |
|---|---|---|---|
| Auto only | Home (if homeowner) | 35-45% | $1,200-1,800 |
| Home only | Auto | 30-40% | $1,000-1,600 |
| Auto + Home | Umbrella | 25-35% | $200-400 |
| Auto + Home | Life (if family) | 15-25% | $600-1,200 |
| Any personal | Flood (if in zone) | 20-30% | $800-2,000 |
| Any personal | Jewelry/valuable articles | 10-15% | $150-400 |
Commercial Lines Gaps
| Client Has | They Likely Need | Close Rate | Avg Premium |
|---|---|---|---|
| BOP only | Commercial auto | 30-40% | $2,000-5,000 |
| Commercial auto only | GL/BOP | 25-35% | $1,500-4,000 |
| GL + Auto | Workers comp | 20-30% | $3,000-10,000 |
| Any commercial | Cyber liability | 15-25% | $1,000-3,000 |
| Any commercial | EPLI | 10-20% | $1,500-4,000 |
Step 5: Priority Scoring Formula
Score each opportunity 1-100 based on:
PRIORITY SCORE =
(Client Tenure Weight x 25) +
(Policy Count Weight x 20) +
(Premium Volume Weight x 20) +
(Gap Type Weight x 20) +
(Recency Weight x 15)
WHERE:
Client Tenure Weight:
5+ years = 1.0
3-5 years = 0.8
1-3 years = 0.6
Under 1 year = 0.3
Policy Count Weight:
1 policy = 1.0 (most to gain)
2 policies = 0.7
3+ policies = 0.4
Premium Volume Weight:
Top 25% by premium = 1.0
25-50% = 0.7
50-75% = 0.5
Bottom 25% = 0.3
Gap Type Weight:
Auto+Home bundle = 1.0
Umbrella addition = 0.8
Life cross-sell = 0.6
Specialty = 0.4
Recency Weight:
Contact in last 30 days = 1.0
31-90 days = 0.8
91-180 days = 0.5
180+ days = 0.3Step 6: Bundle Opportunity Mapping
The Auto + Home Bundle Play
This is the single highest-ROI cross-sell in personal lines.
How to find candidates:
- Filter: Has Auto = Y, Has Home = N
- Cross-reference with property records (county assessor data)
- If they own a home, they have home insurance somewhere else
- That is your target list
Expected numbers from 1,000 client book:
- Auto-only clients who own homes: ~180-240
- Realistic conversion rate: 35-45%
- Policies written: 63-108
- Average home premium: $1,400
- New annual premium: $88,200 - $151,200
The Umbrella Upsell
How to find candidates:
- Filter: Has Auto = Y, Has Home = Y, Has Umbrella = N
- Filter further: Combined premium > $3,000 (assets worth protecting)
- That is your umbrella list
Expected numbers:
- Dual-line clients without umbrella: ~200-280
- Conversion rate: 25-35%
- Average umbrella premium: $300
- New annual premium: $15,000 - $29,400
Step 7: The Outreach Sequence
Week 1: Warm Email
Subject: Quick question about your [auto/home] policy
Hi [First Name],
I was reviewing your account and noticed you have your
[auto] policy with us but not your [home] insurance.
Many of our clients save 15-25% by bundling auto and home
with the same carrier. Based on your profile, I think we
could save you around $[estimate] per year.
Would you like me to run a quick comparison? Takes about
10 minutes and there is no obligation.
[CSR Name]
[Agency Name]Week 2: Phone Call (if no response)
Script:
“Hi [Name], this is [CSR] from [Agency]. I sent you an email last week about potentially saving on your insurance by bundling. Do you have two minutes? I can run a comparison right now.”
Week 3: Final Touch
Subject: Last check - your potential savings
Hi [First Name],
Just wanted to follow up one more time. I estimated you
could save around $[amount] per year by bundling your
auto and home insurance with us.
If the timing is not right, no worries at all. I will
check back in around your renewal in [month].
[CSR Name]Revenue Lift Calculator
YOUR BOOK SIZE: _____ clients (A)
MONO-LINE CLIENTS (est. 40-50%): _____ (B)
Bundle opportunities (est. 60%): _____ (C)
Conversion rate (est. 35%): _____ (D)
Avg new premium: $1,400 (E)
BUNDLE REVENUE LIFT = C x D x E = $________
UMBRELLA CANDIDATES (est. 25%): _____ (F)
Conversion rate (est. 30%): _____ (G)
Avg umbrella premium: $300 (H)
UMBRELLA REVENUE LIFT = F x G x H = $________
TOTAL ANNUAL REVENUE LIFT = Bundle + Umbrella = $________For a 1,000 client agency, typical total lift: $100K - $180K in new annual premium.
Common Mistakes
- Running the analysis but never acting on it. Assign specific clients to specific CSRs with deadlines.
- Trying to cross-sell everything at once. Pick ONE gap (usually auto+home bundle) and exhaust it before moving to the next.
- Not tracking results. Build a simple dashboard: attempts, conversations, quotes, closes.
- Ignoring timing. The best time to cross-sell is 60-90 days before renewal, not the day they call with a claim.
Next Step
The data is already in your AMS. It just needs to be extracted, scored, and acted on systematically.
I build AI employees that run this analysis automatically and feed prioritized opportunities to your CSRs every morning.
Laksh Pujary | Autoikigai | laksh@autoikigai.space