HCP Reports Hub

23 reports + 1 implications diagram covering Housecall Pro and ServiceTitan customer intelligence. 💎 Implications Diagram (start here) · Build Playbook

💎

START HERE → HCP Implications Diagram

Sources → 23 reports → 5 owners → ~.4M/yr unlocked. Single-page view of the entire HCP cluster's implications.

OPEN DIAGRAM →

💎

Implications (per memory rule 1)

🎯 Bucket touched	ALL — index of HCP cluster
⚠️ Problem	21 HCP reports scattered across the playbook directory with no central index. Stephanie can't navigate without grep.
💰 $ at stake	Indirect — every minute spent searching is friction Stephanie pushes back on.
✅ Action unlocked	Use this hub as the single landing page. Each card links to the deeper report.

📊 Full bucket diagram + 4 data-integrity findings: BSP HCP Intelligence Report (📊 The Buckets · 📅 Timeline · 💸 LTV · 🔍 Why this matters · 🎯 The 4 Findings)

All reports read from titan.* (PostgreSQL) and the HCP export at /opt/nexus/nexus/scripts/output/hcp_*.{csv,json}. Revenue queries enforce job_status='completed'. Missing data is shown as "Not captured yet" rather than fabricated.

P1 Critical P2 Management Visibility P3 Strategic Data Gap Pending Deployment

Membership Pilot Tracker

Segment B (277). $21K/mo recurring target. Funnel pool → signup → recurring charge.

Reactivation Email Tracker

Segment A (247 Pure-HCP). $401K LTV. Send → reply → ST job → paid invoice.

Conversion Funnel

Lead → Booking → Estimate → Sent → Response → Won. $4.88M open, 39% close = $2.97M leak.

Tech Ranking Card

Per-tech P&L with Kalen-remap + sold_by_id + Ramp cross-check.

23★

💸 Dismissed Estimates Recovery

$15.62M walked away. 5% re-quote = $781K/yr. BIGGEST $ WIN.

💎

Implications Diagram (v2)

Sources → 23 reports → 5 owners → $2.4M/yr ceiling. Standalone.