Modeling the transition from wellness stays to digital membership
A wellness resort concept needed one pro forma to connect a phased occupancy ramp, two guest programs, membership conversion and a later digital offering. The digital layer also carried clinical and concierge staffing ratios, so software growth could not be modeled independently from service delivery.
Resort-led conversion creates the first membership cohorts before broader digital acquisition begins.
Occupancy had to become unique participants before any membership conversion could be applied.
Membership tiers carry different price points and expected shares of the paying base.
Concierge and clinical capacity grow at member thresholds rather than disappearing inside software overhead.
WHY THIS WASN’T A TEMPLATE EXERCISE
The model had to respect
how the business actually moved.
The model turns occupied rooms into unique guest cohorts before applying program conversion and tier mix, then connects digital member growth to concierge, clinical, product and infrastructure requirements.
Occupancy was not the conversion denominator
Room-nights could not be treated as people. Average stay, guests per room, repeat visits and program participation were needed before membership conversion made sense.
The digital product still carried human delivery
Concierge and clinician ratios made support headcount grow with membership, limiting the operating leverage expected from pure software.
Two businesses had to share one capital story
Resort operations, membership economics and later platform development needed separate schedules but one consolidated cash and funding view.
MODEL ARCHITECTURE
From operating activity
to a decision-ready view.
Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.
Resort capacity and occupancy
Available room-nights and a phased occupancy ramp establish the property-level activity available to feed the program funnel.
Guest cohorts and program mix
Stay length, party size and repeat behavior translate occupied rooms into unique guests, who are then assigned to the two wellness programs.
Membership conversion and tiers
Program-specific conversion creates new members, while tier mix and pricing build recurring membership revenue.
Retention and recurring base
Renewals, churn and cohort aging separate new sign-ups from the paying membership base carried into each period.
Digital platform and support capacity
External acquisition expands the platform beyond resort guests, while concierge, clinical, product and infrastructure resources follow explicit drivers.
Consolidated P&L and cash
Property operations, membership contribution, platform investment and support overhead meet in one funding and scenario view.
WHAT THE ANALYSIS SURFACED
Useful answers,
without exposing client data.
The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.
Room occupancy did not yet explain member volume
The forecast needed a bridge from occupied room-nights to unique eligible guests. Without stay length, party size and repeat-visit assumptions, the same occupancy could imply very different membership cohorts.
Tier mix alone did not define member value
A weighted entry price was only a starting point. Billing frequency, renewal behavior, churn and the cost to serve each tier were still needed to explain lifetime contribution.
A nominal SaaS layer behaved like a high-touch service
Because member growth triggered additional concierge and clinical capacity, support headcount rose with users. That made service design and staffing productivity central to digital operating leverage.
Digital expansion needed its own acquisition logic
After the resort-created membership base, the broader platform required separate leads, conversion, retention and channel costs rather than simply extending the hotel funnel.
MODELING APPROACH
The working system
behind the answer.
- Occupancy and available room-night schedule
- Unique-guest bridge with stay length, party size and repeat-visit controls
- Guest-program mix and membership conversion schedule
- Tier mix, pricing, recurring revenue and renewal cohorts
- Digital member acquisition, retention and growth schedule
- Concierge and clinician threshold staffing plan
- Platform investment, maintenance, infrastructure and support overhead
- Consolidated resort, membership and digital P&L, cash and funding scenarios
CASE CONFIDENTIALITY
This anonymized case explains the operating and capital logic without naming the resort, platform, market, dates, room count, conversion rates, prices or member targets. The source documents, prior pro forma and proprietary assumptions remain private. The illustration is an original fictional wellness ecosystem rather than a real property, interface or client model.