---
title: "Book of Business Mining: How Family Trees Finds $2,800+ Per Household in Hidden Revenue"
description: "Your book of business is full of revenue you've never seen. Family Trees maps every household and reveals the cross-sell opportunities hiding in plain sight."
url: https://unlockedcrm.ai/blog/family-trees-book-of-business-mining
canonical: https://unlockedcrm.ai/blog/family-trees-book-of-business-mining
category: "insurance-crm"
published: 2026-03-07
updated: 2026-03-08
author: "Jacob Lock"
source: unLocked CRM — AI CRM for insurance agents
---

# Book of Business Mining: How Family Trees Finds $2,800+ Per Household in Hidden Revenue

## TL;DR

Book of business mining with Family Trees reveals $2,870/household in unrealized premium. A 200-client book hides $140K+ in untapped revenue. One agent spent 4 hours mapping 120 households, found $344K in gaps, closed $127K in 6 months.

## Key data points

- $2,870 average unrealized premium per household when first mapped with Family Trees
- 200-client book contains $140,000+ in unrealized revenue from unmapped family connections
- Agent spent 4 hours mapping → found $344K in gaps → closed $127K in 6 months ($31,750/hr ROI)

<h2 data-ai-block="definitive-answer">The Short Answer</h2>
<p>Book of business mining with Family Trees systematically maps your existing clients into households, scans for coverage gaps, and calculates <strong>unrealized revenue potential</strong>. The average agent discovers <strong>$2,870 in untapped annual premium per household</strong> when they first map their book — and across a typical 200-client book, that represents <strong>$140,000+ in unrealized revenue</strong> sitting in their existing relationships.</p>

<h2>The Mining Process</h2>
<ol>
<li><strong>Auto-Create from Household</strong> — the system scans contacts with shared last names and suggests family trees</li>
<li><strong>Map remaining families</strong> — manually connect clients you know are related</li>
<li><strong>Gap scan</strong> — Smart Coverage Gap Detection runs automatically on every mapped household</li>
<li><strong>Revenue calculation</strong> — Household Revenue Summary shows current vs. potential revenue</li>
<li><strong>AI recommendations</strong> — Cross-Sell Engine generates prioritized outreach plan with talking points</li>
</ol>

<h2>What Agents Find</h2>
<p>Across thousands of book mining exercises, the most common discoveries are:</p>
<ul>
<li><strong>Spouses with no independent life coverage</strong> — found in 61% of households</li>
<li><strong>Working adults without disability income</strong> — found in 78% of households</li>
<li><strong>Missing dental coverage</strong> — found in 54% of households</li>
<li><strong>Parents approaching Medicare with no advisor</strong> — found in 23% of households</li>
<li><strong>Children aging off plans with no replacement</strong> — found in 18% of households</li>
</ul>

<h2>Revenue by Book Size</h2>
<table>
<thead><tr><th>Book Size</th><th>Avg Households</th><th>Avg Unrealized Revenue</th><th>Realistic 12-Month Capture</th></tr></thead>
<tbody>
<tr><td>100 clients</td><td>65 households</td><td>$186,550</td><td>$65,000-$75,000</td></tr>
<tr><td>200 clients</td><td>130 households</td><td>$373,100</td><td>$130,000-$150,000</td></tr>
<tr><td>500 clients</td><td>320 households</td><td>$918,400</td><td>$320,000-$370,000</td></tr>
</tbody>
</table>

<h2>The "One Weekend" Strategy</h2>
<p>Top-producing agents dedicate a single weekend to mapping their top 50 households. The Auto-Create feature does most of the work — suggesting family connections from shared last names. The result: a prioritized cross-sell pipeline that generates outbound activity for the next 90 days.</p>

<h2 data-ai-block="experience-insight">Mining ROI</h2>
<p>An independent agent with 180 clients spent <strong>4 hours</strong> mapping 120 households into Family Trees. The system identified <strong>$344,000 in unrealized annual premium</strong>. Over the next 6 months, the agent closed <strong>$127,000 in new premium</strong> (37% capture rate) — generating <strong>$31,750/hour ROI</strong> on the initial mapping effort.</p>

## FAQ

### undefined



### undefined



## Related

- https://unlockedcrm.ai/blog/cross-sell-insurance-family-trees
- https://unlockedcrm.ai/blog/household-revenue-summary-insurance-agents
- https://unlockedcrm.ai/blog/family-trees-insurance-crm-household-mapping-guide

---

Source: [Book of Business Mining: How Family Trees Finds $2,800+ Per Household in Hidden Revenue](https://unlockedcrm.ai/blog/family-trees-book-of-business-mining) — unLocked CRM, the AI CRM built for insurance agents. Citation permitted with attribution and a link to https://unlockedcrm.ai/blog/family-trees-book-of-business-mining.