← Reports Hub 📚 Library

Dormant Customer List REPORT 9

Customers with no recent service. Segment A/B/C sourced from HCP segment CSVs. DNS customers are excluded automatically.
๐Ÿ“ฅ Audience CSV Export (Google Customer Match ยท Facebook Custom Audience)
๐Ÿ‹ Whales (29) โญ High Value (62) ๐ŸŽ–๏ธ Membership Pilot (42) ๐Ÿงฒ Dormant 12-24mo (1,522) ๐Ÿ’Ž Pure HCP (289) ๐Ÿ‘ฅ All Empire (4,520)
SHA256 hashed ยท Google/FB spec ยท immediate download
๐Ÿ’Ž
Implications (per memory rule 1)
๐ŸŽฏ Bucket touchedPure HCP (247) + Migrated (4,024) over 12+ months no activity
โš ๏ธ ProblemPure-HCP customers are invisible to ST and to Google Ads attribution. They call in as 'new' if they call at all. 247 customers, $401,791 LTV.
๐Ÿ’ฐ $ at stake$401,791 in Pure-HCP LTV + unknown reactivation upside on dormant migrants.
โœ… Action unlockedSegment A reactivation email this week (247 Pure-HCP). Segment B membership pilot (high-LTV migrants).
๐Ÿ“Š Full bucket diagram + 4 data-integrity findings: BSP HCP Intelligence Report (๐Ÿ“Š The Buckets ยท ๐Ÿ“… Timeline ยท ๐Ÿ’ธ LTV ยท ๐Ÿ” Why this matters ยท ๐ŸŽฏ The 4 Findings)
Filtered Customers
...
Total LTV
...
Avg LTV per Customer
...
Active Segment
...
Name Email Phone City, State LTV Segment Last Service Lead Source Actions
Loading...