In this guide, you'll learn more about the various charts displayed on the dashboard.
Where does the data in the graphs come from?
The data displayed is aggregated data, not real-time data. It is processed daily and shows a snapshot of the previous day.
This is intentionally designed to limit the load on the servers and keep the application’s performance stable and fast.
For some charts, there is a limitation that allows you to look back a maximum of 2 years. This prevents excessive load when retrieving and processing historical data, ensuring that the Club Planner continues to run smoothly.
Tab: Overview
Graph
Description
Recent registrations
Here you’ll find the most recent new member sign-ups.
Active Members
This chart shows the number of active members.
Retention
This chart shows the number of new members and members who left during the specified period.
Reservations
This chart shows the number of reservations and the number of no-shows.
Check-In
This chart displays the number of check-ins.
Employees
This chart shows the number of staff members and their breakdown by gender.
Tab: Member
Graph
Description
Map with active members
Visualization of the location or distribution of active members.
Active Members iOS/Android
Displays the number of active members, broken down by platform (iOS and Android).
Gender ratio
Shows how members are distributed across different age groups.
Breakdown by gender
Shows the distribution of members by gender.
Tab: Membership
Graph
Description
Active memberships
Displays the number of active subscriptions.
Subscription per gender
Shows the breakdown of subscriptions by gender.
Division membership type
Shows the breakdown between subscriptions and single-use passes.
Tab: Check-In
Graph
Description
Unique Check-ins
Displays the number of unique check-ins.
Check-ins per hour
Shows the number of check-ins, broken down by hour of the day.
Graph
Displays the number of check-ins per time slot.
Tab: Engagement
Graph
Description
Reservations
Shows the distribution of active members based on the number of reservations made (e.g., 0, 1–3, 4–5, …).
Retention status
Here you can see how many members have a specific retention status.
Rating per employee
Shows the average rating per employee.
Rating per activity type
Displays the average rating by activity type.
Rating per employee per activity type
Shows the average rating per employee, broken down by activity type.
Check-ins frequency
Shows how many active members have made a certain number of check-ins, broken down into categories (0, 1–3, 4–5, …).
Tab: Leads
Graph
Description
New leads
Shows the number of leads with a status of “Scheduled” or “Completed” within the selected time period.
Leads per source
Displays the breakdown of leads by source (e.g., website, social media, etc.).
appointments per coach
Shows the number of scheduled appointments per coach.
Results
Provides an overview of lead results.
Tab: Financial
Graph
Description
Revenue
Displays the total revenue for the selected period.
Remainder
Shows the total outstanding amount that has not yet been paid.
Outstanding months
Displays the number of months with an outstanding balance.
Revenue group past month
Shows the revenue per group for the past month.
Revenue per hour
Shows revenue broken down by hour of the day.
Revenue per active client
Shows the average revenue per active customer.
Top 10 most sold article with amounts
Shows the 10 best-selling items with corresponding quantities.
Subscriptions and revenue: the key figures and how to read them
You find these figures on the analytics screen of Club Planner (tabs Memberships, Financial and Members & Retention) and in the Club Planner desktop app under Members > Subscriptions > Dashboard. Every chart has an (i): hover over it for the same explanation as below.
Chart
What do you see?
How do you read it?
Active members
Members who today have at least one running membership that counts as an active member (punch cards and family members included). The line shows the count at the end of each month.
An arrow up means more active members than at the end of last month. Compare with this month's joiners and leavers to see where the difference comes from.
MRR (Monthly Recurring Revenue)
Your predictable monthly revenue from running subscriptions. Annual and quarterly subscriptions are spread over their months; punch cards, day passes and retail sales are not included. The percentage compares with the end of last month.
This is the revenue you can count on every month without new sales. Example: an annual subscription of € 600 counts as € 50 per month. A rising line means your recurring income is growing.
Net MRR change
How your MRR changed each month, looked at per member. Green: all increases (new members, more expensive subscriptions). Red: all decreases (leavers, cheaper subscriptions). A normal renewal does not count.
Green minus red is exactly the rise or fall of your MRR that month. A positive result means more recurring revenue came in than went away. A large red bar usually points to leavers or to members moving to a cheaper plan.
Churn rate
The percentage of members who were active at the start of the month and left during that month (leavers ÷ active at start × 100). Someone who takes a new membership within 15 days after the previous one ended does not count as a leaver.
Example: 400 active members on 1 March and 8 leavers in March gives 2 % churn. The lower, the better. The current month is not over yet, so look mainly at the last complete month.
Membership type distribution
How your running memberships are split by type today. Memberships are counted, not people. Only types that count as an active member are included. Updated by the nightly calculation.
This shows which plans run the most. The total can be higher than the number of active members, because one member can have several memberships.
Avg membership duration
How long members stayed on average, in days, for memberships that ended in the selected period. Consecutive memberships with at most 14 days in between count as one; running memberships are not included. The line shows, per month, the average over the preceding 12 months.
The higher, the longer your members stay. Below the number you see how many ended memberships it is based on and how many days it differs from the period of the same length before. A short duration often comes from many short plans, such as punch cards or monthly subscriptions that are not renewed.
Avg monthly billed amount per active member
The average monthly value per active member of the memberships and punch cards that count as an active member. The price is spread evenly over the months the membership is valid. It is the agreed price, not what was actually paid; retail sales are not included.
What an active member brings in per month on average according to their plan. M0 = this month, M-1 = last month, Y-1 = the same month last year. If this amount rises, members choose more expensive plans or your prices went up.
