Executive Brief · 2026-04-14 · For Stephanie

🎯 What the HCP Discovery Changes

Three-hour cross-match against 4,271 Housecall Pro customer records ended six separate blind spots in one pass. Here is what it means for revenue, the ServiceTitan renewal, and the roadmap — in order of decisions you'll be asked to approve.

📌 Executive Summary

Bright Side is bigger than the $2.44M ST number shows. True lifetime customer book = 5,712 people with $6M+ in proven revenue, not the ST-only slice.
Email campaigns and a membership pilot can ship this month. Previously blocked on list quality and customer-spend data. Both now exist: 3,637 deployable emails and 298 pre-qualified $5K-plus spenders.
The "ST data is unreliable" concern is partly structural, not a bug. Nearly three of every four ST "Existing Customer" records are actually HCP migrants with their acquisition source severed. The dashboard needs reframing, not rebuilding.

Problem

Six blind spots that kept leadership guessing

Before today, six questions had no defensible answer — so every strategic conversation (ST renewal, hiring, marketing spend, membership rollout, lender conversations) was running on belief instead of numbers:

Why is the "Existing Customer" bucket nearly half of ServiceTitan revenue? BSP is a recent business; organic loyalty at that scale did not add up.
Why does Smart Bidding never optimize? We suspected missing conversion data but could not size the gap.
Why does the HCP subscription cost $1,521/month with no visible ROI? Nobody owned the question.
Where is the 100 Year / HCP revenue? The Mar 19 experiment flagged it; it stayed vague.
How do we pitch memberships without spend history? We could not segment.
Will email campaigns work? No validated audience, no confidence to invest.

Each blind spot fed the next. The one underneath all of them: two customer systems, never reconciled.

Solution

One cross-match. Six answers.

We pulled the HCP customer export (4,271 records, $5.76M lifetime value) and joined it against the 5,465 ServiceTitan customers on phone and email. Four hours of work produced a reconciled picture:

BSP CUSTOMER UNIVERSE — TRUE COUNT: 5,712 ════════════════════════════════════════════ 🟨 PURE HCP 🟩 MIGRATED (BOTH) 🟦 PURE ST 247 customers 4,024 customers 1,441 customers $401,791 LTV HCP era + ST era combined Post-cutover book Never moved to ST 73.6% of ST "Existing" Net-new since 2025-07-15 👻 Ghost revenue ⚠️ Attribution severed ✅ Clean acquisition

What each blind spot now says, with numbers

Question	Answer
Why is "Existing Customer" so large?	Because 4,024 of 5,465 ST customers are HCP migrants. Not loyalty — legacy.
How big is Smart Bidding's data gap?	~1,800 Google-acquired HCP customers whose conversions never reached Google's algorithm.
What is HCP worth keeping?	System of record for 247 pure-HCP customers and historical reference for the 4,024. Do not cancel until Pass 3 finishes.
Where is the 100 Year revenue?	$5.76M lifetime in HCP. $5.35M belongs to customers now in ST. $401K is truly outside the ST picture.
How do we segment for membership?	298 customers already have $5,000+ lifetime value. 279 of them have email. That is the pilot cohort.
Do we have an email audience?	3,637 HCP customers with valid email (85.2% coverage). 98.8% are marketable (not Do-Not-Service).

Data

The numbers, reconciled

5,712

True unique customers

$6.24M

HCP + Pure-ST LTV (no double-count)

3,637

Deployable emails

298

$5K+ LTV membership targets

Bucket	Customers	LTV	What it unlocks
🟨 Pure HCP (never migrated)	247	$401,791	Ghost re-engagement campaign
🟩 Migrated (in both systems)	4,024	$5.35M HCP era + $3.24M ST era	Lead Source backfill; membership pitch; LTV expansion
🟦 Pure ST (post-cutover)	1,441	~$1.48M	True acquisition rate since 2025-07-15
Combined	5,712	$6M+ lifetime	The real size of Bright Side

Bigger — Beyond Email and Membership

What this changes at the strategic level

1. The ServiceTitan renewal conversation changes shape

Contract ends May/June 2027. The current "BSP is a $2.4M business" framing undersells the lifetime customer relationship. True lifetime revenue across both systems is $6M+ across 5,712 customers. That supports a different conversation with ST — and a different negotiating position.

2. The "growth rate" story becomes honest

Net-new customers since the HCP-to-ST cutover (2025-07-15) = 1,441 in roughly nine months ≈ 1,900/year pace. That is the real acquisition engine. Previously the Existing Customer bucket made the business look loyalty-heavy; actually it is acquisition-active with a large legacy book attached.

3. Kalen's sewer close-rate benchmark needs re-basing

The 30–35% sewer close rate Kalen tracks is measured on a customer base that is 74% HCP legacy. The close rate against truly new ST customers (the 1,441 Pure-ST) may be different. Worth isolating before setting sales targets for new hires.

4. Valuation / financing narrative gains ground

If Bright Side is ever presented to a lender, buyer, or investor, the numbers that matter are: unique customer count (5,712), lifetime value ($6M+), acquisition pace post-cutover (~1,900/yr), and the re-engagement upside ($401K ghost book). All now defensible with source data.

Deeper — The Pattern Beneath

Unreconciled sources are the real risk

HCP was one unreconciled source. It hid six business questions. We know of several more sources that have not been cross-reconciled to the same standard:

Source	Status	Risk
Big Sale tracker	SSoT claimed, not reconciled to QB line-by-line	Revenue figures diverge week-to-week
QuickBooks ↔ ServiceTitan	Manual reconciliation; invoice_total vs job_total ambiguity in history	Profit figures carry footnotes
Ramp COGS	932 transactions categorized, not yet linked to jobs	Margin per service line unknown
Vapi call logs ↔ ST leads	Bridge partial; Daniel AI conversions not fully attributed	Daniel ROI claim was false for weeks
Google Ads offline conversions ↔ ST jobs	Wrong bucket; fix scoped but not deployed	Smart Bidding starved
HCP ↔ ST	✅ Reconciled today	Six blind spots closed

The meta-recommendation: source reconciliation becomes an ongoing discipline, not one-off projects. Budget 4 hours per source per quarter. The HCP example shows the payoff scale.

✅ Decisions Requested

Approve email pilot this week. Target: 247 Pure-HCP customers + segment of high-LTV. Audrey to template, Robert to build segment, pitch reviewed before send.
Approve membership pilot in two weeks. Target: 298 customers with $5K+ lifetime value. Discount-container framing (pre-existing policy), no paid subscription tier.
Approve HCP subscription retention ($1,521/month) through the end of Pass 3 reconciliation and the re-engagement campaign. Early cancellation orphans the 247 customers and erases historical reference for the 4,024 migrants.
Flag ST dashboard "Existing Customer" bucket to be relabeled "Includes HCP migrants" so leadership does not misread as organic loyalty.
Schedule Pass 3 reconciliation (HCP jobs + invoice export). Two-week follow-up. Produces defensible combined revenue figure and settles the $5.4M overlap double-count question.

Live at https://morpheus.callbrightside.com/documents/BSP_HCP_Executive_Brief.html. Technical detail report: BSP_HCP_Intelligence_Report.html. Supporting sections: Master Session History #bsp-apr14-verification-pass-1, #bsp-apr14-verification-pass-2, #bsp-apr14-hcp-data-sufficiency. Source data: BrightSidePlumbing_customer_export.csv (2026-04-13 20:58) + bsp_analytics.titan.customers.