Executive & Operational AnalyticsWarehouse v7.0
Unified business intelligence, explainable churn diagnostics, BigQuery-modeled event facts, and GL parity.
Double-Entry General Ledger ≡ Analytics Parity
Analytical fact revenue reconciled against General Ledger Trial Balance down to the exact integer cent.
Monthly Cohort Retention Curves
Percentage of new joiners who remain active members after 1, 3, 6, and 12 months.
| Cohort Month | Initial Size | Month 1 | Month 3 | Month 6 | Month 12 |
|---|---|---|---|---|---|
| Jan 2026 | 210 members | 94% | 81% | 73% | 61% |
| Feb 2026 | 185 members | 95% | 83% | 75% | — |
| Mar 2026 | 198 members | 93% | 79% | — | — |
| Apr 2026 | 172 members | 96% | 84% | — | — |
| May 2026 | 165 members | 94% | — | — | — |
| Jun 2026 | 204 members | 95% | — | — | — |
Explainable Churn Risk Register
Inspectable behavioural signals: days absent, visit drop vs baseline, and failed charges. No black-box AI.
Gym OS Attention Engine
Prioritised operational anomalies requiring management action.
Membership revenue down 8.2% in Lead Sector
Monthly course and coaching renewals experienced an unseasonal dip following completion of Summer Lead Leagues.
31 high-frequency members inactive > 30 days
Explainable churn risk triggered for previously active members (averaging 8.4 visits/month) with zero scans since August.
V6 routes on Comp Wall averaging unusually low attempts
Competition Prow #22 recorded only 26% send rate with community grade sentiment at V6.7 vs setter V6.
Chalk Cartridges & Rental Shoes below reorder threshold
SendrLabs Friction Chalk Blocks (12 units left) and Scarpa Origin 42EU (1 pair left) need supplier replenishment.
Facility capacity operating within optimal flow
Current facility density is at 42% (147 / 350 climbers inside). Mat turnover velocity in Zone 1 is safe and fluid.
Facility Utilisation & Congestion Heatmap (7 Days × 5 Operational Blocks)
Identifies gym bottlenecks, peak climber density, and underutilised off-peak hours across 35 time cells.
Climbing Intelligence & Grade Consensus Analytics
Community ratings vs routesetter intention. Flags sandbagged or soft routes and tracks wall reset velocity.
| Route Name & Wall | Setter Grade | Community Consensus | Attempts / Sends | Send Rate | Community Stars | Status |
|---|---|---|---|---|---|---|
The Cave Overhang #14 Cave Wall (Zone 1) • 28 days active | V5 | V5 | 1284 att / 526 sends | 41% | ★★★★★(4.7) | Consensus |
Delicate Slab #07 Slab Wall (Zone 2) • 35 days active | V4 | V4 (Soft) | 1102 att / 639 sends | 58% | ★★★★★(4.5) | Disagreement |
Competition Prow #22 Comp Wall (Zone 1) • 14 days active | V6 | V7 (Hard V6) | 712 att / 185 sends | 26% | ★★★★★(4.8) | Disagreement |
Roof Lip Traverse #03 Roof Sector • 42 days active | V7 | V7 | 421 att / 72 sends | 17% | ★★★★★(4.9) | Consensus |
Multi-Location Performance Benchmarking
Consolidated operational and financial comparison across Dublin, Cork, Belfast, Galway, and Limerick facilities.
| Location Name | Monthly MRR | Active Members | Monthly Churn | Visits / Climber | Avg Occupancy | Peak Congestion |
|---|---|---|---|---|---|---|
| Dublin Central (Flagship) | €84,420 | 1,284 | 2.4% | 8.4 | 42% | 98% |
| Cork Bouldering Hub | €61,200 | 940 | 3.1% | 7.8 | 71% | 94% |
| Belfast Climbing Centre | €55,800 | 880 | 2.7% | 8.7 | 64% | 88% |
| Galway Bouldering Loft | €42,700 | 650 | 1.9% | 9.1 | 36% | 82% |
| Limerick Climbing Wall | €31,400 | 490 | 4.2% | 6.2 | 78% | 96% |