Four Wall
Road to 80 + Reengagement Challenge
Team-based, by location. Both trackers count from 2026-07-13 forward, day over day — not a lookback window. A team winning both the rebooking and reengagement challenge gets both rewards.
Same-Day Rebooking — ranked by Growth vs. YTD
Top 3 by Growth get access to Shawna's reward list — pick 1 only, does not stack across locations.
◆How this is calculatedshow formula & sources
Same-day % = COUNT(guests whose next appointment was created the
same calendar day as their payment, with a future start time)
/ COUNT(visits in the period)
YTD % = same formula, over Jan 1 - Jul 12, 2026 (before program start)
Period % = same formula, over 2026-07-13 forward (day over day)
Growth = Period % - YTD %, in percentage points
Ranked by Growth, not raw Period %. Top 3 by Growth get access to
Shawna's non-cash reward list - pick exactly 1 per location, does not
stack across locations. Growth needs both a YTD and a Period figure to
rank; locations without enough Period data yet don't rank until they
have it - they aren't scored as zero.
Color band (informational, separate from ranking): green >=80%,
yellow 70-79%, red <70% on Period %.Reporting sources
- Invoices: Corral amp-organization → use_dataset(39)
- Appointments (completed/confirmed/checked-in): Corral amp-organization → use_dataset(1106)
Known data gaps
- Program start is backdated to Monday 2026-07-13 (2 days before this was built) so the leaderboard shows real accumulated days instead of hours — a fixed calendar anchor, not a sliding lookback.
- Zenoti has duplicate center_name records for several locations (an old state-prefixed code alongside the current Brand-City name). YTD figures merge known duplicates by city match (see CENTER_ALIASES in scripts/build-data.mjs); H-MD-Chisholm Creek vs. H-MD Medical Spa is ambiguous and deliberately left unmerged — worth confirming against the master location list.
| Location | YTD % | Period % | Growth | Status | Reward |
|---|---|---|---|---|---|
| #1 Avelure-Waterford | 54% | 73.1% | +19.1 pts | Approaching · 70–79% | 🏆 pick 1 |
| #2 Avelure-Greenwood | 55.7% | 73.8% | +18.1 pts | Approaching · 70–79% | 🏆 pick 1 |
| #3 H-MD-Tulsa | 48.8% | 66.7% | +17.9 pts | Needs Support · <70% | 🏆 pick 1 |
| #4 Ever/Body-Greenwich Village | 6.8% | 20% | +13.2 pts | Needs Support · <70% | |
| #5 Ever/Body-Logan Circle | 21% | 33.9% | +12.9 pts | Needs Support · <70% | |
| #6 Avelure-Novi | 40.6% | 53% | +12.4 pts | Needs Support · <70% | |
| #7 Avelure-Creve Coeur | 50.2% | 61% | +10.8 pts | Needs Support · <70% | |
| #8 Curate Murfreesboro | 51.5% | 61.9% | +10.4 pts | Needs Support · <70% | |
| #9 Ever/Body-Williamsburg | 13.2% | 23.4% | +10.2 pts | Needs Support · <70% | |
| #10 Destination Aesthetics - Napa | 48.8% | 58.6% | +9.8 pts | Needs Support · <70% | |
| #11 SkynBar | 26.3% | 35.6% | +9.3 pts | Needs Support · <70% | |
| #12 Glo - Winterville | 54.7% | 62.9% | +8.2 pts | Needs Support · <70% | |
| #13 Pur Skin Clinic - Seattle | 29.2% | 36.2% | +7 pts | Needs Support · <70% | |
| #14 Nouveau Day Spa | 19% | 25.8% | +6.8 pts | Needs Support · <70% | |
| #15 Synergy - Kennewick | 48.9% | 53% | +4.1 pts | Needs Support · <70% | |
| #16 22 Spa MD | 51.7% | 53.7% | +2 pts | Needs Support · <70% | |
| #17 Avelure-Rochester | 46.8% | 48.6% | +1.8 pts | Needs Support · <70% | |
| #18 Avelure-Ocala | 49.6% | 51.4% | +1.8 pts | Needs Support · <70% | |
| #19 Avelure-Sunset Hills | 50.4% | 52.2% | +1.8 pts | Needs Support · <70% | |
| #20 Ever/Body-Hartford | 43.3% | 44.7% | +1.4 pts | Needs Support · <70% | |
| #21 Ever/Body-Colleyville | 50.7% | 52% | +1.3 pts | Needs Support · <70% | |
| #22 Pur Skin Clinic - Kirkland | 38% | 39.2% | +1.2 pts | Needs Support · <70% | |
| #23 Ever/Body-North Haven | 41.5% | 41.5% | 0 pts | Needs Support · <70% | |
| #24 Curate Knoxville | 40% | 39.6% | -0.4 pts | Needs Support · <70% | |
| #25 Avelure-O'Fallon | 58.2% | 57.5% | -0.7 pts | Needs Support · <70% | |
| #26 Ever/Body-Flatiron | 10.2% | 9.4% | -0.8 pts | Needs Support · <70% | |
| #27 Avelure-Grand Rapids | 36.6% | 34% | -2.6 pts | Needs Support · <70% | |
| #28 Glo - Wilmington | 39.7% | 37% | -2.7 pts | Needs Support · <70% | |
| #29 Avelure-Buffalo | 50.6% | 47.6% | -3 pts | Needs Support · <70% | |
| #30 Avelure-Zona Rosa | 49.1% | 45.8% | -3.3 pts | Needs Support · <70% | |
| #31 H-MD-Chisholm Creek | 52.2% | 48.8% | -3.4 pts | Needs Support · <70% | |
| #32 Curate Nashville | 52.5% | 46.5% | -6 pts | Needs Support · <70% | |
| #33 Ever/Body-Gaithersburg | 40.9% | 34.9% | -6 pts | Needs Support · <70% | |
| #34 Mainline Center for Laser Surgery | 42.2% | 34.9% | -7.3 pts | Needs Support · <70% | |
| #35 Back to 30 - Highway 14 | 40.6% | 32.5% | -8.1 pts | Needs Support · <70% | |
| #36 Back to 30 - Boiling Springs | 46.6% | 38.5% | -8.1 pts | Needs Support · <70% | |
| #37 Aesthetic Clinique - Santa Rosa | 32.7% | 24.5% | -8.2 pts | Needs Support · <70% | |
| #38 Living Young - Seminole | 65.9% | 57.1% | -8.8 pts | Needs Support · <70% | |
| #39 22 Plastic Surgery | 14% | 4.4% | -9.6 pts | Needs Support · <70% | |
| #40 Destination Aesthetics - Elk Grove | 42.5% | 32.6% | -9.9 pts | Needs Support · <70% | |
| #41 Pur Skin Clinic - Edmonds | 45.9% | 35.9% | -10 pts | Needs Support · <70% | |
| #42 Curate Chattanooga | 51% | 41% | -10 pts | Needs Support · <70% | |
| #43 Destination Aesthetics - Roseville | 39.4% | 28.9% | -10.5 pts | Needs Support · <70% | |
| #44 Curate Ooltewah | 45.9% | 35% | -10.9 pts | Needs Support · <70% | |
| #45 Living Young - Palm Harbor | 46% | 34.8% | -11.2 pts | Needs Support · <70% | |
| #46 New Radiance - Palm Beach Gardens | 46.5% | 34.5% | -12 pts | Needs Support · <70% | |
| #47 Destination Aesthetics - Folsom | 37.3% | 25% | -12.3 pts | Needs Support · <70% | |
| #48 Avelure-Indy | 44.6% | 32% | -12.6 pts | Needs Support · <70% | |
| #49 Ever/Body-South Windsor | 40.9% | 28.3% | -12.6 pts | Needs Support · <70% | |
| #50 New Radiance - Port St. Lucie | 38.4% | 25.5% | -12.9 pts | Needs Support · <70% | |
| #51 EsthetixMD - Bend | 51.2% | 38.2% | -13 pts | Needs Support · <70% | |
| #52 H-MD-Gaillardia | 42.9% | 29.6% | -13.3 pts | Needs Support · <70% | |
| #53 New Radiance - Wellington | 47.8% | 33.3% | -14.5 pts | Needs Support · <70% | |
| #54 Blush - Orange | 48.5% | 33.8% | -14.7 pts | Needs Support · <70% | |
| #55 Blush - East Longmeadow | 52.9% | 37.8% | -15.1 pts | Needs Support · <70% | |
| #56 Back to 30 - Simpsonville | 44.2% | 28.8% | -15.4 pts | Needs Support · <70% | |
| #57 Blush - Avon | 53.9% | 38.2% | -15.7 pts | Needs Support · <70% | |
| #58 Living Young - St. Petersburg | 60% | 42.5% | -17.5 pts | Needs Support · <70% | |
| #59 Synergy - Yakima | 56% | 36.6% | -19.4 pts | Needs Support · <70% | |
| #60 Back to 30 - McBee | 46.2% | 25.6% | -20.6 pts | Needs Support · <70% | |
| #61 Blush - Glastonbury | 54.9% | 34% | -20.9 pts | Needs Support · <70% | |
| #62 New Radiance - Boca Raton | 49.5% | 28.6% | -20.9 pts | Needs Support · <70% | |
| #63 Living Young - Odessa | 62.7% | 38.5% | -24.2 pts | Needs Support · <70% | |
| #64 Destination Aesthetics - El Dorado | 52.6% | 21.7% | -30.9 pts | Needs Support · <70% | |
| #65 Blush - Enfield | 58.5% | 25.6% | -32.9 pts | Needs Support · <70% | |
| #66 The Ageless Center | 47.3% | 13.6% | -33.7 pts | Needs Support · <70% | |
| #67 Destination Aesthetics - Sacramento | 49.5% | 13.1% | -36.4 pts | Needs Support · <70% | |
| Ever/Body-Bethesda Row | 41.3% | % | pending | No data |
YTD window: 2026-01-01 – 2026-07-12 (before program start). Program start is backdated to Monday 2026-07-13 so Growth reflects a couple of real days rather than a few hours — it's still early, so keep tracking day over day. See the methodology box above for the full caveat.
Reengagement Challenge — Recovered Patients
Recovered = patients from the starting lapsed/dormant pool who now have a future appointment on the books, checked against the same frozen patient list day over day (persisted in Supabase, not re-snapshotted).
◆How this is calculatedshow formula & sources
Lapsed = seen in the last 90 days, no future appointment Dormant = not seen in 90+ days, no future appointment Starting pool = lapsed + dormant, snapshotted 2026-07-23 (frozen list) Recovered = COUNT(starting-pool patients who now have a future appointment) Recovery rate = Recovered / Starting pool Recovered is structurally 0 right now — the snapshot and the check happen at the same instant. It moves once the daily refresh re-checks that same frozen patient list on later days.
Reporting sources
- Patient last-seen / last-appointment status: Corral amp-organization → zenoti_corp.transformed_guest_v
Known data gaps
- This is the SECOND starting-pool snapshot, not the original one. The first was taken 2026-07-15; because no persistent store existed to hold that frozen patient list (see below), the refresh mechanism went unresolved for 8 days, and when data was refreshed on 2026-07-23 there was no way to tell who from the original pool had been recovered in between. That gap reset to a new pool dated 2026-07-23 rather than fabricate a recovery count — the fix is provisioning persistent storage before this happens again, not just refreshing more often.
- Day-over-day recovery tracking needs the frozen starting-pool patient list stored persistently (some locations exceed 40,000 patients) and re-checked daily — not yet provisioned (recommended: Supabase, matching every other AMP repo's pattern)
| Location | Starting Pool | Recovered | Recovery Rate |
|---|---|---|---|
| Avelure-Waterford | 513 | not yet tracked | — |
| Avelure-Greenwood | 397 | not yet tracked | — |
| H-MD-Tulsa | 582 | not yet tracked | — |
| Ever/Body-Greenwich Village | 1,010 | not yet tracked | — |
| Ever/Body-Logan Circle | 2,838 | not yet tracked | — |
| Avelure-Novi | 696 | not yet tracked | — |
| Avelure-Creve Coeur | 581 | not yet tracked | — |
| Curate Murfreesboro | 202 | not yet tracked | — |
| Ever/Body-Williamsburg | 637 | not yet tracked | — |
| Destination Aesthetics - Napa | 4,380 | not yet tracked | — |
| SkynBar | 2,206 | not yet tracked | — |
| Glo - Winterville | 1,465 | not yet tracked | — |
| Pur Skin Clinic - Seattle | 149 | not yet tracked | — |
| Nouveau Day Spa | 10,555 | not yet tracked | — |
| Synergy - Kennewick | 4,725 | not yet tracked | — |
| 22 Spa MD | 2,568 | not yet tracked | — |
| Avelure-Rochester | 331 | not yet tracked | — |
| Avelure-Ocala | 863 | not yet tracked | — |
| Avelure-Sunset Hills | 578 | not yet tracked | — |
| Ever/Body-Hartford | 1,162 | not yet tracked | — |
| Ever/Body-Colleyville | 143 | not yet tracked | — |
| Pur Skin Clinic - Kirkland | 1,521 | not yet tracked | — |
| Ever/Body-North Haven | 1,046 | not yet tracked | — |
| Curate Knoxville | 850 | not yet tracked | — |
| Avelure-O'Fallon | 375 | not yet tracked | — |
| Ever/Body-Flatiron | 47,845 | not yet tracked | — |
| Avelure-Grand Rapids | 798 | not yet tracked | — |
| Glo - Wilmington | 13,057 | not yet tracked | — |
| Avelure-Buffalo | 705 | not yet tracked | — |
| Avelure-Zona Rosa | 842 | not yet tracked | — |
| H-MD-Chisholm Creek | 510 | not yet tracked | — |
| Curate Nashville | 772 | not yet tracked | — |
| Ever/Body-Gaithersburg | 626 | not yet tracked | — |
| Mainline Center for Laser Surgery | 3,653 | not yet tracked | — |
| Back to 30 - Highway 14 | 5,936 | not yet tracked | — |
| Back to 30 - Boiling Springs | 2,461 | not yet tracked | — |
| Aesthetic Clinique - Santa Rosa | 6,616 | not yet tracked | — |
| Living Young - Seminole | 3,576 | not yet tracked | — |
| 22 Plastic Surgery | 2,295 | not yet tracked | — |
| Destination Aesthetics - Elk Grove | 4,941 | not yet tracked | — |
| Pur Skin Clinic - Edmonds | 6,067 | not yet tracked | — |
| Curate Chattanooga | 1,004 | not yet tracked | — |
| Destination Aesthetics - Roseville | 5,717 | not yet tracked | — |
| Curate Ooltewah | 4,518 | not yet tracked | — |
| Living Young - Palm Harbor | 5,939 | not yet tracked | — |
| New Radiance - Palm Beach Gardens | 5,729 | not yet tracked | — |
| Destination Aesthetics - Folsom | 2,840 | not yet tracked | — |
| Avelure-Indy | 760 | not yet tracked | — |
| Ever/Body-South Windsor | 615 | not yet tracked | — |
| New Radiance - Port St. Lucie | 3,955 | not yet tracked | — |
| EsthetixMD - Bend | 7,409 | not yet tracked | — |
| H-MD-Gaillardia | 9,278 | not yet tracked | — |
| New Radiance - Wellington | 3,305 | not yet tracked | — |
| Blush - Orange | 792 | not yet tracked | — |
| Blush - East Longmeadow | 442 | not yet tracked | — |
| Back to 30 - Simpsonville | 2,579 | not yet tracked | — |
| Blush - Avon | 989 | not yet tracked | — |
| Living Young - St. Petersburg | 1,747 | not yet tracked | — |
| Synergy - Yakima | 3,404 | not yet tracked | — |
| Back to 30 - McBee | 3,070 | not yet tracked | — |
| Blush - Glastonbury | 1,822 | not yet tracked | — |
| New Radiance - Boca Raton | 5,897 | not yet tracked | — |
| Living Young - Odessa | 1,018 | not yet tracked | — |
| Destination Aesthetics - El Dorado | 1,356 | not yet tracked | — |
| Blush - Enfield | 2,529 | not yet tracked | — |
| The Ageless Center | 5,810 | not yet tracked | — |
| Destination Aesthetics - Sacramento | 9,221 | not yet tracked | — |
| Ever/Body-Bethesda Row | 391 | not yet tracked | — |