Why Most Studios Track the Wrong Things
The most common studio "dashboard" is a single number: total members. It goes up when someone joins and down when someone cancels, and it's almost useless for making decisions. Total members doesn't tell you whether your base is healthy or eroding. It doesn't tell you whether new members are forming habits. It doesn't tell you which members are about to leave. It's a lagging indicator of outcomes rather than a leading indicator of risks.
Studios that manage retention well track a small set of metrics that are forward-looking — they tell you what's likely to happen in the next 30–60 days based on what's happening now. Building a dashboard around these metrics doesn't require a CRM subscription or a data analyst. It requires a weekly 30-minute ritual with a spreadsheet and a booking system export.
The Five Metrics That Predict Churn
1. Days Since Last Visit (DSLV) Distribution
Pull a report from your booking system of every active member and their last check-in date. Calculate the days since that date. Then bin your members: 0–14 days (healthy), 15–30 days (watch), 31–60 days (at-risk), 60+ days (critical).
The number you care about is the percentage of your active base in the at-risk and critical buckets combined. In a well-managed studio, this should be under 20%. If it's 30%+ you have a retention problem that's about to express itself in cancellations. Track this weekly. A week where your at-risk percentage increases by 5+ points is a week to act — check who moved into that bucket and trigger your absence automations immediately.
The DSLV distribution is more actionable than overall churn rate because it's predictive — you're seeing the problem 3–6 weeks before the cancellation happens, which gives you time to intervene. Overall churn rate tells you what already happened.
2. Visit Frequency Trend
For each active member, track their average visits per month over the last 90 days vs. the prior 90 days. Are they attending more or less than they were? A member who attended 6 times/month in Q1 and is now at 2 times/month in Q2 is in visible decline even if they're still within the "0–14 days since last visit" healthy zone. The trend predicts what DSLV will look like in 30 days.
Frequency benchmarks: 4+ visits/month is committed. 2–3 visits/month is habitual but not deeply embedded. 1 visit/month is fragile — this member is one disruption away from non-attendance. Under 1 visit/month on an unlimited membership is a strong churn signal, particularly if they've been a member for more than 3 months (new members often start slow and ramp up, so early low-frequency is less alarming than sustained low-frequency).
The ideal intervention is frequency-based rather than DSLV-based: catch a member whose frequency is dropping before they cross the 14-day absence threshold. Your CRM's behavioral triggers (see the lifecycle automations guide) should include a "frequency declining" trigger, not just a "days absent" trigger.
3. Intro-to-Membership Conversion Rate
Track this monthly: of all intro offers that expired in the past month, what percentage converted to a paying membership? This metric is a leading indicator of two things — acquisition efficiency (are you attracting the right buyers?) and experience quality (are first-time visitors having a good enough experience to commit?). A declining conversion rate in January often predicts a February churn spike as low-quality conversions from a weak intro offer experience reach their first renewal.
Healthy benchmarks: 25–35% conversion for a standard 14-day intro offer, 20–30% for a 30-day offer. Anything below 20% warrants examining both the intro offer design and the first-class experience. See the trial conversion sequence guide for the contact cadence that moves this number.
4. Membership Tenure Distribution
Track what percentage of your active members are in each tenure bucket: under 3 months, 3–6 months, 6–12 months, 12–24 months, 24+ months. A healthy studio has a relatively smooth distribution across these buckets. Warning signs: if your under-3-month segment represents more than 40% of your base, you're on an acquisition treadmill — churning through members faster than you're building a stable base. If your 24+ month segment is under 15%, you have a long-term retention problem.
Members in the 12–24 month bucket have typically survived the major churn windows and are likely long-term members. The 6–12 month bucket is a transition zone — members who make it to 12 months are significantly more likely to stay indefinitely. The 3–6 month window is the second major churn window after the first-month wave, and it's the one most studios don't have specific interventions for. A 6-month anniversary acknowledgment (even a simple email recognizing the milestone) meaningfully reduces churn in this window.
5. Month-over-Month Active Member Count
Define "active" consistently: members who attended at least once in the past 30 days and whose membership is in good standing. Track this number monthly and calculate the percentage change. Positive growth means you're acquiring faster than you're churning. Negative growth means the reverse. Flat growth in a studio with a 5% monthly churn rate means you're acquiring roughly 5% of your base per month just to stay even — that's a heavy acquisition burden that gets more expensive over time.
The goal is not to minimize churn to zero — that's unrealistic. The goal is to keep monthly churn under 4–5% while maintaining enough acquisition to grow the base by 1–2% per month net. That growth rate, compounded over 24 months, is the difference between a 200-member studio and a 280-member studio on the same cost base.
Calculating and Improving LTV
Member LTV = average monthly revenue per member × average member tenure in months. For a studio averaging $110/month per member with an average tenure of 14 months, LTV is $1,540. To grow LTV, you either increase monthly revenue per member (add-ons, higher-tier memberships, workshops) or extend average tenure (better onboarding, retention automation, deeper community integration).
Getting average tenure above 18 months is the most leveraged single metric improvement most studios can make. A studio moving from 14-month average tenure to 18-month average tenure at $110/month and 200 members increases annual revenue by approximately $88,000 with no increase in acquisition cost. The first-90-days onboarding work and the member segmentation work together are the primary drivers of tenure extension.
Cohort Retention Analysis
Once per quarter, pull the retention curve for each of the past four monthly cohorts of new members. For each cohort (e.g., everyone who joined in January), track what percentage is still active at month 1, month 2, month 3, and month 6. Plot these curves together. If your most recent cohort is retaining at a lower rate than cohorts from 6 months ago, something changed — a class schedule reduction, an instructor departure, a decline in onboarding quality. If it's retaining better, something you changed is working.
The cohort curve typically looks like a rapid early drop (30–40% churn in months 1–2) followed by a plateau (members who survive to month 3 tend to stay for 12+ months). Studios with effective onboarding see a shallower early drop. If your month-3 survivors are still churning at 8–10% per month, you have a mid-stage retention problem that onboarding improvements alone won't fix — this typically points to programming, schedule, or community issues.
Vanity Metrics to Stop Tracking
Total members listed in your system (includes inactive, paused, expired members — a meaningless number). Class count (volume of classes offered says nothing about whether they're filling or whether they're meeting member needs). Social media followers. Revenue without profit context. Average class size without occupancy context. These metrics feel good to look at because they tend to go up regardless of whether the business is healthy.
The Review Cadence
Weekly: DSLV distribution, new members added, cancellations, active member count. 15 minutes. Use this to trigger interventions before they become emergencies. Monthly: visit frequency trends, intro-to-membership conversion rate, tenure distribution, LTV calculation, cohort retention update. 60–90 minutes. Use this to evaluate whether your retention programs are working. Quarterly: full cohort analysis, campaign performance review, annual calendar planning update. Half day. Use this for strategic adjustments.
Building Without Expensive Software
Your booking system almost certainly has an export function that produces a CSV of all members with their last check-in date and visit history. That CSV, imported into a Google Sheet with a few calculated columns (days since last visit, monthly visit average, tenure in months), gives you most of the dashboard above. The calculation takes about 30 minutes to set up the first time and 15 minutes to refresh weekly. If your current booking system doesn't export member visit data in a usable format, that's a reason to evaluate alternatives — your ability to manage retention depends on it.
.avif)
