Executive Brief · 2026-04-14 · For Stephanie
Discovered tonight while fixing a stale sync pipeline. What it means for revenue, Q1 recovery, and the ServiceTitan contract conversation. In order of decisions you'll be asked to approve.
For months we have measured the business by what comes in: ad spend, calls, booked jobs. We have never measured what is sitting in the middle of the funnel that never closes.
Tonight's sync fix surfaced the real number: 1,749 Open estimates worth $4,887,216 in proposed work. Every one of these customers already invited a Bright Side technician onto their property, talked through the problem, and received a proposal. The sales work is done. The close is missing.
Why this has been invisible:
| Tier | Age | What To Do | Target |
|---|---|---|---|
| 🔥 HOT | 0-7 days | Personal call from Ashton or assigned CSR. "Following up on the quote we sent you, any questions?" No pressure, just presence. | 37 estimates, $553K. Aim 30% close = $166K. |
| 🌡️ WARM | 8-30 days | One follow-up call + text. Offer to walk the scope. If price is the objection, offer a staged approach not a discount. | 88 estimates, $277K. Aim 15% close = $42K. |
| ❄️ COLD | 30+ days | Mass re-engagement email (reuse the Audrey Segment A framework). Light touch, no phone call. Revive a few, drop the rest. | 1,514 estimates, $4.06M. Aim 5% close = $203K. |
Pilot: Ashton takes the HOT bucket directly, working his way through 37 customers in 5 business days (7-8 per day, 10 minutes each). If he closes even 10 of them, the program pays for itself. Once proven, decide whether to expand with a dedicated follow-up CSR hire or let Daniel AI handle the warm-up call.
Weekly dashboard: each tier, calls attempted, calls connected, closed + won, closed + lost, still open. Present at Monday standup. Stephanie sees the revenue curve moving or she does not.
| Age Bucket | Count | Value | Recovery Priority |
|---|---|---|---|
| 🔥 0-7 days (hot) | 37 | $553,595 | THIS WEEK — highest close probability |
| 🌡️ 8-14 days (cooling) | 26 | $125,946 | This week too, same priority |
| 🌡️ 15-30 days (cold) | 62 | $151,045 | Next week |
| ❄️ 30+ days (frozen) | 1,514 | $4,056,630 | Mass re-engagement, light touch |
| Value Tier | Count | Total Value |
|---|---|---|
| Under $1,000 (quick wins) | 815 | $338,394 |
| $1,000 to $4,999 (bread and butter) | 594 | $1,438,137 |
| $5,000 to $9,999 (bigger repairs) | 137 | $975,323 |
| $10,000 to $24,999 (remodel tier) | 82 | $1,169,043 |
| $25,000+ (whale deals) | 11 | $966,320 |
| Estimate | Value | Last Modified |
|---|---|---|
| 100 Hall Full Re-Pipe | $231,641 | 2026-01-02 |
| La Casita Trailer Park (Option B: Reroute) | $194,229 | 2026-04-09 🔥 |
| La Casita Trailer Park (Option A: Trailer Move) | $186,042 | 2026-04-09 🔥 |
| 100 Hall Half Re-Pipe | $147,850 | 2026-01-02 |
| Job 2188 (unnamed, historical) | $41,356 | 2025-06-20 ❄️ |
| Job 2844-2 (historical) | $31,850 | 2025-06-20 ❄️ |
| Job 1136 (historical) | $30,160 | 2025-06-20 ❄️ |
| Job 1045 (historical) | $26,807 | 2025-06-20 ❄️ |
| Job 520 (historical) | $26,384 | 2025-06-20 ❄️ |
| Commercial toilet upgrade | $25,000 | 2026-03-10 |
100 Hall Re-Pipe (full $231K or half $148K) is the same customer choosing between two scopes. Not dead if revisited. La Casita Trailer Park (Options A+B) is one property with $380K combined, modified this week — hot deal actively being negotiated. The five 2025-06-20 estimates are archival (pre-sync-fix); worth reviewing if legit still-open or should be dismissed to clean the book.
| Status | Count | Value | Avg Ticket |
|---|---|---|---|
| Dismissed (lost) | 2,146 | $10,918,807 | $5,088 |
| Open (in flight) | 1,639 with $> 0 | $4,887,216 | $2,982 |
| Sold (won) | 1,386 | $3,770,084 | $2,720 |
Current close rate = Sold / (Sold + Dismissed) = 1,386 / 3,532 = 39.2%. If we improve close rate to 55% (industry benchmark with structured follow-up), the historical $10.9M of Dismissed would have produced +$1.74M more revenue.
Q1 2026 closed at $333K income, -$18K net. Even a conservative 15% recovery on Open ($732K) delivered across Q2 would take the business from a $18K quarterly loss to well over $300K in Q2 net, without adding any operating cost.
Contract ends May/June 2027. If by renewal Bright Side can demonstrate +$500K/quarter in recovered estimate revenue directly attributable to ST data flows, the ST conversation shifts from "expensive software" to "revenue-producing system." Defensible leverage.
Every Open estimate is a customer we already spent money to acquire (ad, lead, dispatch, tech time). Closing one of these costs almost nothing compared to finding a new customer through Google Ads. Recovered revenue effectively lowers our blended CAC.
Weather-watching landing pages (Friday): unknown payoff, depends on Audrey + CRO. Sewer budget up (tonight): pending attribution verification. HCP re-engagement email (shipped tonight for Audrey): unknown conversion. Estimate recovery: known audience, known price points, known product fit, only the close is missing. Lowest risk, fastest cash.
Three data points tonight say the same thing:
The acquisition engine is working. Calls come in. Techs go out. Quotes get written. Something between "quote written" and "contract signed" is where revenue leaks. That is a follow-up muscle gap, not a marketing gap.
The structural implication for staffing: next hire decision is not "another tech" or "another CSR." It is a dedicated sales follow-up role. Could be part-time. Could be Daniel AI-enhanced. Could be a morning shift for an existing CSR. But a seat whose job is to own Open estimates end-to-end.
The structural implication for dashboards: Monday standup report needs three metrics going forward: Open estimate count, Open estimate value, and conversion velocity (Sold this week / Open-to-Sold average days). Everyone should see these numbers every week.
The structural implication for ServiceTitan configuration: estimate stages and follow-up reminders need to be configured so no new estimate goes 14 days without a task on someone's calendar. That is an Ashton + Kalen workstream, 2-hour setup.
Live at https://morpheus.callbrightside.com/documents/BSP_Open_Estimate_Recovery_Report.html. Source data: titan.estimates_full freshly synced 2026-04-14 via zeus_st_module_sync.py after tonight's pipeline fix (master history bsp-apr14-sweep-1-estimates-2026-unblocked and bsp-apr14-sweep-3-sync-estimates-permanent). Paired documents: BSP_HCP_Executive_Brief.html (complementary existing-customer segments), BSP_4_Broken_Pipes_Battle_Plan.html (ops plan), BSP_Revenue_Pipeline_War_Room.html (operational dashboard).