If your customer count looks stable but revenue feels unpredictable, or you’re constantly asking, “Are we actually growing?”, this dashboard gives you a straight answer. Instead of guessing from occupancy or scanning memberships one by one, you can see who stayed, who left, who expanded, and what that did to your revenue.
The Retention & Churn Dashboard aggregates your membership and revenue data monthly and organizes it into clear retention, churn, and growth metrics. It helps you understand stability, risk, and long-term customer value across all plans and locations, so you can act before churn impacts your numbers.
Before you start
How is retention data calculated?
All reports aggregate data monthly. Selecting any date within a month returns data for the entire month. For example, filtering a dashboard to show data from March 15 to May 2 will display aggregated data for March, April, and May.
Interacting with the dashboard
You can drill into each metric and visualization shown on the dashboard. For example, if 5 members have left in one month, you can click on the value -5 to get a list of those 5 churned customers.
You can control which customer types are considered "new" when calculating the dashboard metrics. If you wish to include returning customers in the calculations, set "Consider Returning Customers New" to Yes.
Dashboard overview
At the top of the dashboard, there are 4 widgets with summarized membership information for the selected time period:
Average Lifetime Value (LTV) – The all-time membership revenue generated from active customers to date divided by the all-time number of customers with an active membership. Please note that this KPI aggregates revenue from all service types.
Average Length of Stay in Months – Considering the start date of a customer's first membership and the end date of their last membership (or the current date if the respective membership is still active), we estimate that number in months for your whole customer base and divide it by the number of customers that had (or currently have) an active membership.
Average Monthly Value – The Average Lifetime Value (LTV) divided by the Average Length of Stay in Months.
Churning Customers Next Month – The total number of customers churning in the next month. These are customers whose last remaining memberships end this month and have no active memberships next month. Clicking on the number will show the exact customers who could be approached now to help prevent their loss.
The "Date Range" filter does not affect these widgets, and the averages (the first 3 widgets) are not affected by Plan filters.
How is data calculated?
All reports aggregate data monthly. Selecting any date within a month selects the data for the whole month. For example, filtering a dashboard to show data from March 15 to May 2 will display aggregated data for March, April, and May.
About membership price adjustments
When a price adjustment is applied to a membership, the existing membership is ended, and a new membership record is created with the adjusted price, effective from the specified date.
However, this change does not count as a new or expiring membership—it is treated as a continuation of the same membership for retention and churn calculations.
Membership Revenue Retention
This visualization compares retained revenue to total active revenue for the selected time period, broken down by month. Retained revenue includes only memberships that were active in the previous month and remain active in the current month, while total active revenue includes all active memberships in the month, including new, retained, expanded, contracted, and lost revenue. This comparison helps track revenue stability and growth trends over time.
Customer Retention
This visualization compares retained customers to total active customers for the selected time period, broken down by month. Retained customers are those who were active in the previous month and remain active in the current month, while total active customers include all customers with an active membership in the current month, including new, retained, returning, and lost customers. This comparison helps track customer retention and overall growth trends over time.
Membership Revenue, Net Growth
This chart shows a monthly outline of the net growth of your membership revenue, broken down by bucket:
New Revenue – Тhe total revenue from customers considered "New" in the month.
Lost Revenue – Тhe (negated) total revenue from customers lost in the month. Lost customers are those whose last membership ended in the previous month. This revenue is recognized in the month it is actually lost, i.e., in the month following the customer’s last active month.
Expansions – The sum of increases in customers' total membership revenue from the preceding month.
Contractions – Тhe (negated) sum of decreases in customers' total membership revenue compared to the preceding month.
Net Effect – Тhe sum of contractions and lost revenue subtracted from the sum of new revenue and expansions.
You can also control the metrics shown on the column charts. For example, suppose you are only interested in comparing the new and lost revenue for the selected timeframe. In that case, you can click the names of the other metrics on the chart legend to deselect them and remove them from the visualization.
Remember that the Membership Revenue visualized on this graph is intentionally not prorated. It shows you a realistic breakdown of each category. For example, suppose you have a company that starts mid-month; we prorate it. In that case, we might mislead you that the New revenue is significantly lower this month, but that the Expansion revenue next month is considerably higher.
Customers, Net Growth
This chart shows the monthly number of new and lost customers.
Customers are considered:
New – If they started a membership for the first time in the month, or if they are returning and "Consider Returning Customers New" is set to Yes.
Returning – If they had a membership, they were without an active one for at least a month and are now starting a new one.
Churned – If their last remaining membership ended in the previous month and they have no active memberships in the current month. They are counted as churned in the month they are actually lost - the month following their last active month.
Net Effect – The sum of lost (churned) customers subtracted from the sum of new and returning customers, showing the net change in the total customer base for the month.
You can click each tile value to see more details about the data that makes up the total.
Retention Insights by Plan Type (Section)
The Retention Insights by Plan Type section combines retention and customer value metrics to provide a comprehensive view of plan performance. It includes Retention Insights by Plan Type, showing retained, new, returning, and lost (churned) customers, along with revenue movements such as new, expansion, contraction, and lost revenue.
It also incorporates Lifetime Value & Tenure Metrics by Plan Type, summarizing total membership revenue to date, plan average lifetime value per customer, plan average length of stay, and plan average monthly revenue. Together, these visualizations help teams analyze how different plans contribute to customer retention, longevity, and overall revenue generation over time, offering both behavioral and financial insights.
Retained Revenue by Plan Type
Retained revenue for the selected time period, broken down by month and plan type. It includes only revenue from memberships that were active in the previous month and remain active in the current month. It does not include new revenue, expansions, contractions, or lost revenue.
New Revenue by Plan Type
Total revenue from new customers for the selected time period, broken down by month and plan type.
Lost Revenue by Plan Type
Total revenue from lost customers for the selected time period, broken down by month and plan type. A customer is considered lost in the month with no active memberships—the month following their last active month.
Revenue Expansion by Plan Type
The total expansion revenue for the selected time period, broken down by month and plan type. Calculated by subtracting each customer’s plan membership revenue in the previous month from their plan membership revenue in the current month, then summing these differences across all customers.
Revenue Contraction by Plan Type
The total contraction revenue for the selected time period, broken down by month and plan type. Calculated by subtracting each customer’s plan membership revenue in the current month from their plan membership revenue in the previous month, then summing these differences across all customers.
Retained Customers by Plan Type
Retained customers for the selected time period, broken down by month and plan type. This includes only customers who had an active membership in the previous month and remain active in the current month. It does not include new, returning, or lost customers.
New Customers by Plan Type
New customers for the selected time period, broken down by month and plan type. This includes only customers who joined for the first time in the month (returning customers can be included if the “Consider Returning Customers New” filter is applied).
Lost Customers by Plan Type
Total number of lost customers for the selected time period, broken down by month and plan type. A customer is considered lost in the month with no active memberships—the month following their last active month.
Lifetime Value & Tenure Metrics by Plan Type
A summary view of customer value and behavior by plan type, including total membership revenue to date, plan average lifetime value per customer, plan average length of stay, and plan average monthly revenue. This table helps compare how different plan types contribute to retention, customer longevity, and overall revenue generation over time.
Note: Plan Average Lifetime Value is expected to differ from overall Average Lifetime Value per Customer (summary chart at the top of the dashboard) because a single customer can have memberships in multiple plans. For example, if Customer A was on both Plan X and Plan Y, they are counted in the averages for each plan, while the overall LTV counts each customer only once. Plan averages can be compared to the overall customer average at the top of the dashboard as a benchmark for plan performance.
Retention Totals
This table summarizes the totals shown across the dashboard visualizations and provides a monthly breakdown. Each total can be clicked to see a list of members who make it up.
The table cells are highlighted in different colors based on the identified trend. For example, if the active memberships revenue for the current month is greater than the revenue for the previous month, the cell will be formatted in a darker shade of green.
The metrics included in the table are:
New Customers – The number of customers whose first membership has started in the month. If “Consider Returning Customers New” is set to Yes, returning customers will be included.
Returning Customers – The number of customers returning in the month. These are customers who had an active membership in the past, did not have an active membership in the preceding month, but have an active membership in the current month. If 'Consider Returning Customers New' is set to 'Yes', returning customers are included in the New Customers calculation and excluded from the Returning Customers calculation.
Churned Customers – The number of customers whose last remaining memberships have expired in the previous month.
Customers Net effect – The difference between the number of new / returning customers and the number of churned customers.
Active Customers – The number of customers with at least 1 active membership in the month.
Active Customers (Beginning of Month) – The number of customers with at least 1 active membership on the 1st of the month.
Customer Churn Rate – The ratio of churned customers and the number of active customers at the beginning of the month.
New Revenue – The revenue generated from memberships of customers who are considered new in the month.
Revenue Expansion – The increased customers' total membership revenue compared to the preceding month.
Lost Revenue – The revenue generated from the memberships of customers who are churning in the month. They are counted as churned in the month they are actually lost, i.e., the month following their last active month.
Revenue Contraction – The negated decrease in customers' total membership revenue compared to the preceding month.
Revenue Net Effect – The sum of contractions and lost revenue subtracted from the sum of new revenue and expansions.
Active Memberships Revenue – The revenue generated from memberships that were active for at least 1 day during the month.
Active Memberships Revenue (Beginning of Month) – The revenue generated from memberships that were active on the 1st of the month.
Revenue Churn Rate – The ratio of lost revenue during the month and the active memberships' revenue at the month's beginning.
Recent changes
February 2026
The whole dashboard has been recently reworked and significantly enhanced.
New filters added:
Plan Type
Plan Name
Customer Status
New visualizations for both Revenue Retention and Customer Retention, providing clearer visibility into how retained revenue and customers compare to total active figures month over month.
New section added: Retention insights by plan type.
This section allows filtering by Plan. It combines retention and customer value metrics to provide a more comprehensive view of plan performance.
It also introduces Lifetime Value & Tenure Metrics by Plan Type, summarizing:
• Plan total membership revenue to date
• Plan average lifetime value per customer
• Plan average length of stay
• Plan average monthly revenue
January 2026
In the Retention Totals table:
The following rows have been added:
Returning Customers
Revenue Expansion
Revenue Contraction
The following row has been renamed:
Net New/Lost Revenue→Net Effect






