← Reports Hub 📚 Library

Commercial vs Residential Breakdown REPORT 10

Split by HCP customer_type (business vs homeowner), cross-joined to ST revenue. Commercial sewer opportunity highlighted.
💎
Implications (per memory rule 1)
🎯 Bucket touchedCross-cut across all three
⚠️ ProblemCommercial customers concentrate revenue but get same outbound treatment as residential. No tier in messaging.
💰 $ at stakeTop 5% commercial customers = ~30% of LTV. Tiered membership pricing could capture $X.
✅ Action unlockedStephanie + Kalen review tier breakdown before quarterly pricing decision.
📊 Full bucket diagram + 4 data-integrity findings: BSP HCP Intelligence Report (📊 The Buckets · 📅 Timeline · 💸 LTV · 🔍 Why this matters · 🎯 The 4 Findings)
HCP Business Customers
...
HCP Homeowners
...
ST Commercial Revenue
...
ST Residential Revenue
...
Loading method note...

HCP Customer Type Split

TypeCustomersTotal LTVAvg LTV
Loading...

ST Completed Jobs by Resolved Type

Type Customers Jobs Revenue Avg Ticket
Loading...

Sewer Work Comparison (job_type contains 'sewer')

Type Sewer Jobs Sewer Revenue Avg Sewer Ticket Avg Rev / Customer
Loading...