| 🎯 Bucket touched | Pure HCP (247) — invisible to ST and to Google Ads attribution |
| ⚠️ Problem | 247 Pure-HCP customers carry $401,791 in HCP-era LTV. They never migrated. They call in as 'new' if at all. No reactivation campaign has been tracked end-to-end. |
| 💰 $ at stake | $2,425 (2%) → $12,125 (10%) first-touch recovery. Each reactivated customer adds $1,627 LTV uplift over 24 months. |
| ✅ Action unlocked | Audrey ships email. Stephanie approves send. Tracker measures send → reply → ST job → paid invoice for every recipient. |
247 Pure-HCP customers — invisible to ST, invisible to Google Ads attribution. They were active customers in HCP era, never migrated, and have not appeared in ST since cutover (2025-07-15). Target: surface them with a "we still service your area" reactivation email.
/opt/nexus/nexus/scripts/output/hcp_segment_a_pure_hcp_reengagement.csv — built Apr 14. DNS customers excluded automatically.| Stage | Count | % | Owner | Status |
|---|---|---|---|---|
| 1. Pool identified | 247 | 100% | Robert | ✓ Done |
| 2. Email copy drafted | — | — | Audrey | Pending |
| 3. DNS scrub re-applied | — | — | Robert (cron) | ✓ Auto |
| 4. Email sent | 0 | 0% | Stephanie approval | Awaiting |
| 5. Replies / call-ins | 0 | 0% | Ashton | Tracking ready |
| 6. New ST job created | 0 | 0% | ST sync | Tracking ready |
| 7. First invoice paid | 0 | 0% | QB sync | Tracking ready |
| Scenario | Reactivation Rate | Customers | Avg Job | Recovered Revenue |
|---|---|---|---|---|
| Conservative | 2% | 5 | $485 | $2,425 |
| Realistic | 5% | 12 | $485 | $5,820 |
| Optimistic | 10% | 25 | $485 | $12,125 |
Closes the loop on Dormant Customer List. The dormant list identifies WHO is dormant — this tracker measures whether outreach actually reactivates them. Without this, Segment A is a CSV. With it, every dollar of recovered revenue is attributable.