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

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.

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.

What Is Book of Business Mining?

The systematic process of mapping existing CRM clients into household units using Family Trees, scanning for coverage gaps, and calculating unrealized revenue potential across the agent's entire book of business.

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)

The Short Answer

Book of business mining with Family Trees systematically maps your existing clients into households, scans for coverage gaps, and calculates unrealized revenue potential. The average agent discovers $2,870 in untapped annual premium per household when they first map their book — and across a typical 200-client book, that represents $140,000+ in unrealized revenue sitting in their existing relationships.

The Mining Process

  1. Auto-Create from Household — the system scans contacts with shared last names and suggests family trees
  2. Map remaining families — manually connect clients you know are related
  3. Gap scan — Smart Coverage Gap Detection runs automatically on every mapped household
  4. Revenue calculation — Household Revenue Summary shows current vs. potential revenue
  5. AI recommendations — Cross-Sell Engine generates prioritized outreach plan with talking points

What Agents Find

Across thousands of book mining exercises, the most common discoveries are:

  • Spouses with no independent life coverage — found in 61% of households
  • Working adults without disability income — found in 78% of households
  • Missing dental coverage — found in 54% of households
  • Parents approaching Medicare with no advisor — found in 23% of households
  • Children aging off plans with no replacement — found in 18% of households

Revenue by Book Size

Book SizeAvg HouseholdsAvg Unrealized RevenueRealistic 12-Month Capture
100 clients65 households$186,550$65,000-$75,000
200 clients130 households$373,100$130,000-$150,000
500 clients320 households$918,400$320,000-$370,000

The "One Weekend" Strategy

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.

Mining ROI

An independent agent with 180 clients spent 4 hours mapping 120 households into Family Trees. The system identified $344,000 in unrealized annual premium. Over the next 6 months, the agent closed $127,000 in new premium (37% capture rate) — generating $31,750/hour ROI on the initial mapping effort.

From Experience

  • 4 hours mapping → $344K identified → $127K closed in 6 months — $31,750/hr ROI
  • Most common gaps: Disability (78% of households), Spousal life (61%), Dental (54%)

Frequently Asked Questions

How much hidden revenue is in a typical book of business?

Average of $2,870 per household in unrealized premium. A 200-client book (130 households) typically hides $140,000+ in untapped cross-sell opportunities.

How long does book mining take?

Auto-Create handles most connections. Top agents map their top 50-100 households in 2-4 hours. The ROI: one agent spent 4 hours and closed $127,000 in new premium over 6 months.