📌 Method: ActiveMemberships
This article explains how we count the total number of active memberships within a given period.
How are active memberships calculated?
Get memberships
We will deduct all memberships that were active during the selected time period.
Calculating the number of active memberships daily
We look at each day and count how many memberships are still active.
Filtering by Minimum Duration
Only memberships that have lasted for a certain period of time (e.g. minimum 30 days) will be included.
Grouping and visualising data
Data is presented as a candlestick graph showing opening, closing, highest and lowest number of active memberships per month.
Example calculation
Let's assume we have the following membership data for March:
period: 1 March – 31 March
Minimum membership length: 30 days
Member ID | Start Date | End date | Active in March? |
101 | January 1 | 5 March | ✅ |
102 | February 10 | 15 April | ✅ |
103 | March 1 | March 30 | ✅ |
104 | March 20 | March 25 | ❌ (for short) |
105 | January 1 | December 31 | ✅ |
106 | 5 March | March 25 | ✅ |
Counting active memberships every day:
March: 3 active memberships
March: 3 active memberships
March: 4 active memberships
March: 4 active memberships (104 are too short and not counted)
Monthly Overview:
Open: 3 memberships
Closing: 4 memberships
Maximum number: 4 memberships
Lowest number: 3 memberships
These values are used to plot the candlestick chart.
Why is this important?
Businesses with subscriptions and memberships use this metric to understand how many memberships are in use. If the number of active memberships decreases, it could be an indication that customers are leaving the company, requiring strategic actions to retain them.
💡 Result: A visual overview of how the number of memberships evolves over time.
Do you have any questions? Contact us via the Intercom chat! 😊