💎 HCP Reports — Implications Diagram
10 sources → 22 reports + R23 ★ → 5 owners → ~$2.4M/yr unlocked. Standalone shareable view of the HCP cluster's full implication graph. Generated 2026-04-15 from live psql + 9 JSON sources.
TL;DR. The HCP cluster ships
23 reports across
5 implication loops (Pure HCP reactivation · Migrated conversion · Engine 2 membership · Era integrity · Attribution + Ops). Total annual implication ceiling =
$2,393,000/yr + $26K 1x. Biggest single $ win =
R23 Dismissed Estimates Recovery ($781K/yr) — discovered via Apr 15 multi-source pull. 3 hard blockers + 1 build action sit on Robert's queue.
📥 The 10 Sources Feeding This Diagram
📂 HCP CSV
4,271
cust · $5.76M LTV
🔌 titan.jobs
10,509
completed · $2,119 avg
📋 titan.estimates
8,395
$6.42M open · $15.6M dismissed
👥 titan.customers
5,470
115 whales · 0 active members
💰 Big Sale Tracker
$70K
/wk · $134K EOW
📊 QuickBooks
$573K
YTD income · $79K net
🤖 Daniel AI
✅
HEALTHY 5:30 AM today
📞 3CX
18,743
calls/365d (telemetry suspect)
🎯 LSA
100%
booking rate (low volume)
💳 Ramp
932+
COGS txns · commission cross-ref
🧩 The Master Bucket Truth (R1 Intelligence Report)
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: $5.35M ST era: ~$1.48M
ST era: $3.24M
👻 Ghost revenue 👥 ST "Existing Customer" 🆕 Post-cutover
📞 Call in as "new" 📞 73.6% of ST book 📅 Since 2025-07-15
🔕 Invisible to ST ⚠️ Attribution severed ✅ Clean attribution
💰 Re-engage target 🎯 LTV / membership target 🚀 Smart Bidding target
Naive HCP $5.76M + ST $4.72M = $10.48M is wrong by ~$5.4M. The 4,024 migrated customers appear in both systems. R15 Revenue By Month splits this correctly by era.
🚀
Revenue Hierarchy · Line 4 · DORMANT VALUE
NEW · APR 15
4. DORMANT: $1.18M one-time + $413K/yr recurring (outreach engine + memberships + zero-invoice recovery)
• Zero-invoice recovery: $771,751 one-time (252 jobs)
• Outreach engine: $305,400/yr ($288K + $17.4K savings)
• Membership pilot: $108,000/yr (Segment B · 277 cust × $29.99)
Sources:
/api/money/find ·
/api/outreach/stats ·
/api/memberships/stats · verified 2026-04-16 00:15 UTC.
Full entry →
Master History.
🌐 Sources → Cluster → Owners (the macro view)
📥 10 SOURCES IN 🧠 REPORT CLUSTER ⚡ IMPLICATIONS OUT (5 owners)
════════════════════ ═══════════════════ ════════════════════════════════
📂 HCP CSV ─────────┐ ┌─► 👩 STEPHANIE
🔌 titan.jobs ──────┤ │ • Approve $73K/yr
R19 send
📋 titan.estimates ─┤ │ • Membership pricing tiers
👥 titan.customers ─┤ ┌─────────────────────────┐ │ • Q1 close-rate 40→50% goal
💰 Big Sale ────────┼──►│ 🧠
R1 INTELLIGENCE │ 247 / 4024 / │ • Reactivation send authorize
📊 QuickBooks ──────┤ │ REPORT (master) │ 1441 truth │
🤖 Daniel AI ───────┤ └─┬──┬──┬──┬──┬───────────┘ ├─► 👨 ASHTON
📞 3CX ─────────────┤ │ │ │ │ │ │ • 37 hot-bucket calls/wk
🎯 LSA ─────────────┤ ▼ ▼ ▼ ▼ ▼ │ • HCP-context quote prep
💳 Ramp ────────────┘ 🔴 🟡 🟢 📊 🎯 │ •
R20 reactivation outreach
ZONES (22 reports +
R23 ★) │ •
R23 ★ re-quote queue work
│
🔴
R5 R9 R20 ├─► 👨 KALEN
🟡
R6 R21 R23★ │ • Tier strategy pricebook
🟢
R7 R8 R10 R11 R12 R13 │ • 115 whales hand-touch
📊
R14 R15 R16 │ •
R22 commission decisions
🎯
R17 R18 R19 R22 │
├─► 🤖 SMART BIDDING
│ •
R8 lead-source backfill
│ • $35K/mo Ads optim recovers
│
└─► 👨 ROBERT (build queue)
• ★ Build
R23 workflow
• ESP webhook → email_track
• ST sold_at API backfill
• Stripe + tier defs (
R19)
• $6.07M phantom recon rerun
247 cust · $401,791 dormant LTV · Owners: 👨 Ashton + 👩 Stephanie
📞
R5 Customer 360 ──call ID──► 🌙
R9 Dormant Seg A 247 ──segment──► 📨
R20 Reactivation
▲ │
│ ▼
└─── 4,033 ST emails ◄── 🚫
R7 DNS pre-send sync (53 flagged excluded) ──► 💰 $26K 1x + $402K LTV (24mo)
────────────────────►
👨 ASHTON works inbound replies
👩 STEPHANIE approves the send
⚠️ Problem
247 Pure HCP customers carry $401K LTV. They never migrated. Call in as "new" or not at all. Invisible to ST + Ads.
🛠️ Solution
R5 Cust 360 surfaces HCP history on phone-key match. R9 segments. R20 sends reactivation email. R7 gates against DNS list.
💰 $ at stake
$26K first-touch (5% × 247 × $2,119) + $402K LTV uplift over 24 months.
⚠️ BLOCKERS: 3CX trigger un-wired for
R5 (
R5 shipped but inert) · email_tracking = 2 rows total (
R20 send is measurement-blind without ESP webhook).
4,024 cust · $1.10M annual lever · Owners: 👨 Ashton + 👨 Robert
💰
R6 Open Estimates ($6.42M live) ──┐
├──► 🔻
R21 Funnel ──► 🎯
R17 Close 40.5% ──► 💰 $321K + $610K
💸
R23 ★ Dismissed ($15.62M) ◄────────┘ ────────────────►
⭐ BIGGEST SINGLE $ WIN ──► 5% re-quote = $781K/yr ──► 👨 ROBERT builds workflow
👨 ASHTON works re-quote queue
⚠️ Problem
$6.42M open estimates (memo $4.88M was undersized $1.54M). $15.62M dismissed pile NEVER tracked. Loss ratio in $$ = 2.91:1 (lose $2.91 for every $1 closed).
🛠️ Solution
R6 sortable + callable open queue. R21 per-stage funnel. R17 close-rate dial. R23 ★ NEW dismissed re-quote queue.
💰 $ at stake
R23: $781K/yr · R17→R21: $610K/yr · R6: $321K/yr · combined Engine 2 lever ~$1.7M/yr ceiling.
⚠️ BLOCKERS: R23 workflow not built · sold_at + dismissed_at NULL on all 8,395 estimates (no per-stage timing) · Ashton needs HCP-context attached to migrated re-quotes.
$73K/yr recurring · Owners: 👩 Stephanie + 👨 Kalen
🎯
R17 Close 40.5% ──pool──► 💎
R18 LTV pyramid ──TAM=632──► 🏆
R19 Membership ──remap──► 🥇
R22 Tech Rank
5% × $2,119 +Ramp xref
= $73K/yr (6× memo)
│ │
▼ ▼
💰 $73K/yr recur ⚖️ Reconciled commission
👩 STEPHANIE prices 👨 KALEN visibility
⚠️ Problem
Memo math (277 × $75/mo = $12K/yr) was wrong. 0 active members today — the program literally doesn't exist.
🛠️ Solution
R18 surfaces real LTV pool. R19 RESTATED with TAM=632 (Maintenance Mike 272 + Renovation Rachel 245 + whales 115) × 5% × $2,119 = $73K/yr (6× memo).
💰 $ at stake
$73K/yr recurring + reconciled commission accuracy via R22 (Kalen visible after Ashton-creates-Kalen remap + Ramp cross-check).
⚠️ BLOCKER: member_status='active' = 0 across all 5,470 ST customers.
R19 is greenfield product → needs Stripe + tier defs + recurring invoice template + Audrey copy + Stephanie pricing approval BEFORE first send.
Stops $5.4M double-count brief · Owners: 👨 Robert + 👨🔧 Kalen
🛡️
R14 Quality Audit ──gates──► 📆
R15 Rev/Mo ──era split──► 👨🔧
R16 Rev/Tech (+Kalen remap)
│ │ │
▼ ▼ ▼
CSV row-delta gate HCP|ST split @ 2025-07-15 Commission accuracy
⚠ $6.07M phantom in Stops $5.4M dbl-count 13 distinct sold_by_id
Apr 5 QB-ST recon brief landing on Stephanie Kalen remap unlocks visibility
(pre-Apr 12 quarantine)
⚠️ Problem
Naive HCP+ST sum = $10.48M is wrong by $5.4M. Apr 5 QB-ST recon still shows $6.07M phantom (pre-quarantine). Kalen has no ST login — his sales attribute to Ashton.
🛠️ Solution
R14 gates bad CSV pre-deploy. R15 splits revenue by era. R16 applies Ashton-creates-Kalen remap rule.
💰 $ at stake
Stops $5.4M wrong number reaching Stephanie's brief. Unlocks accurate per-tech commission decisions (currently invisible for Kalen).
$215K/yr stack · Owners: 👨 Ashton + 🤖 Smart Bidding + 👨 Robert
📈
R8 Lead Src ──HCP backfill──► 🤖 SMART BIDDING ──► 💰 $35K/mo Ads optim
🚫
R7 DNS ──gates──► 📨
R20 send ──► protects brand
📅
R11 Warranty 30/60/90 ──► 💰 $180K/yr recurring ──► 👨 ASHTON 30d call
🔍
R12 Nick Welty ──Ramp×ST──► reconcile before paying ──► 👨 ROBERT
🩺
R13 Cross-System ──±100 alert──► drift = pipeline bug ──► 👨 ROBERT cron
🏢
R10 Comm vs Res ──tier pricing──► whale upside ──► 👨 KALEN
📈 R8 Lead Source
48% "Existing Customer" lie. Only 11 cust with real lead_source. HCP backfill un-starves Smart Bidding. $35K/mo Ads optim.
📅 R11 Warranty Cal
30/60/90-day auto-touch on expiring warranties. ~50/mo × $300 = $15K/mo recurring ($180K/yr).
🚫 R7 DNS · 🩺 R13 Match · 🔍 R12 Nick · 🏢 R10 Comm
Gate + brand protection + drift alarm + tier visibility. Each small lever, combined = brand + integrity moat.
👥 Customer Intelligence Overlay (powers R18 / R19 / R20 dynamic targeting)
🏔️ LTV Pyramid (5,470 cust)
| 🐋 $10K+ | 115 | $2.32M (36% rev) |
| ⭐ $5-10K | 153 | $1.12M |
| ⭐ $1.5-5K | 305 | $876K |
| 🔁 $500-1.5K | 332 | $286K |
| 1️⃣ $0-500 | 566 | $123K |
| 🌑 $0 | 3,999 | silent 73% |
🧬 Persona Distribution
| Emergency Eric | 4,887 | 89.3% |
| Maintenance Mike | 272 | 5.0% ⭐ |
| Renovation Rachel | 245 | 4.5% ⭐ |
| Unclassified | 62 | enrich gap |
| Bus Owner Bob | 4 | classifier broken |
| ⭐ R19 TAM = 632 (Mike+Rachel+whales) |
📧 Email · Phone · Geo
| 📧 With email | 4,033 | 73.7% |
| 📞 With phone | 4,563 | 83.4% |
| 📍 With zip | 5,426 | 99.2% |
| 🚫 Unsubscribed | 1 | ESP healthy |
| 🏆 Top zip 66062 | 358 | Olathe-S |
| ⚠ email_tracking = 2 rows total |
🎯 Dynamic Targeting Matrix — 16 micro-campaigns from one pool
│ 🐋 Whales │ ⭐ Repeat │ 🔁 Single-job │ 🌑 Silent
│ ≥$10K (115) │ $1.5-$10K (458)│ $500-1.5K (332)│ $0 (3,999)
──────────┼────────────────┼────────────────┼────────────────┼────────────────
Mike (272)│ HAND-TOUCH 50 │ MEMBERSHIP 120 │ Member-lite 60 │ Re-engage 42
Rachel (245)│ HAND-TOUCH 40 │ Membership 80 │ Project quote 70│ Email C 55
Eric (4,887)│ VIP same-day 25│ Annual mtnc 258│ Standard 202 │ DARK pool 3,902
⚡ DYNAMIC SEGMENTS (sent to ESP as):
• SEG_VIP_WHALE_MAINT_50 (Kalen personally)
• SEG_MEMBERSHIP_PILOT_120 (
R19 launch cohort)
• SEG_PROJECT_RENOV_80 (Audrey kitchen/bath copy)
• SEG_EMERG_VIP_SAMEDAY_25 (3CX priority routing flag)
• SEG_DORMANT_DARK_3902 (suppress — too low signal)
✨
16-cell dynamic matrix replaces R20's single-blast send. Expected lift: 4-6× open rate · 8-12× CTR per BSP_Email_Campaign_System. Audrey copy x16 variants needed.
🏛️ Cross-Source Revenue Authority (single-source = forbidden)
🥇 BIG SALE TRACKER
$70,180/wk
Ashton Slack postings · most accurate · leading indicator of QB by ~7 days
$70K/wk × 52 = $3.65M annualized (booked) · DOES NOT match QB $1.86M annualized (collected). Gap = TBC lag + 100Y share 21.6% ($788K/yr) + financing/cancels. Kalen 100Y reveal Apr 15.
🥈 QUICKBOOKS (financial SOT)
$573K YTD
Bank-truth · $79K net income · annualized $1.91M
0/99 deposits have job_id — attribution chain broken downstream
🥉 ST CLEAN (broken)
$93K (Mar)
71% zero-invoice phantom · cannot use alone
$6.07M phantom still in Apr 5 recon — re-run after Apr 12 quarantine
💰 Total $ Implications — Running Ledger
| # | Lever | $ unlocked | Owner | Status |
|---|
| 1 | 💸 R23 Dismissed re-quote (5% × $15.6M) | $781,000/yr | 👨 Robert | ★ build |
| 2 | 🎯 R17→R21 close-rate 40.5% → 50% | $610,000/yr | 👨 Ashton | in flight |
| 3 | 📨 R20 LTV uplift on reactivated (24mo) | $402,000/yr | 👩 Stephanie | blocked |
| 4 | 💰 R6 Open estimate recovery (5% lift) | $321,000/yr | 👨 Ashton | in flight |
| 5 | 📅 R11 Warranty 30/60/90 auto-touch | $180,000/yr | 👨 Ashton | ready |
| 6 | 🏆 R19 Membership pilot (632 × 5% × $2,119) | $73,000/yr | 👩+👨 KS | ★ blocked |
| 7 | 🤖 R8 Smart Bidding un-starve | $35,000/mo | 👨 Robert | ready |
| 8 | 📨 R20 Reactivation 1x | $26,000 1x | 👩 Stephanie | blocked |
| TOTAL ANNUAL CEILING | ~$2,393,000/yr + $26K 1x | |
👨💻 Robert's Action Queue (the 4 things blocking)
1️⃣ Build R23 workflow
Re-quote queue UI + ST custom field re_quote_attempt + outreach automation.
Unlocks: $781K/yr
2️⃣ ESP webhook → email_tracking
Wire opens/clicks/replies into titan.email_tracking table (currently 2 rows).
Unlocks: R20 = $26K + $402K LTV
3️⃣ ST sold_at + dismissed_at backfill
Pull from ST API into titan.estimates so R21 funnel + R23 priority can sort by age.
Unlocks: per-stage timing for $1.7M lever
4️⃣ Stripe + tier defs (R19)
Membership product greenfield: pricing, recurring invoice template, signup flow.
Unlocks: $73K/yr recurring
🔗 Read the Underlying Reports
Generated 2026-04-15 06:00 UTC · sources: live psql (titan.* tables) + 9 JSON files (big_sale_tracker, qb_pl_latest, qb_st_reconciliation, daniel_monitor_latest, 3cx_monitor_latest, ga4_latest, lsa_booking_rate, google_ads_audit, hcp_segment_*) · multi-source pull verifies all $ figures · single-source ST = forbidden per CLAUDE.md revenue hierarchy.