Cross-Sell Gap Analysis: Find the Revenue Hiding in Your Book
By Laksh Pujary, Founder of Autoikigai AI-native systems 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-native systems that run this analysis automatically and feed prioritized opportunities to your CSRs every morning.
Laksh Pujary | Autoikigai | laksh@autoikigai.space