📌 Method: ActiveMembers
This article explains how the system calculates the number of active members within a given time period.
How are active members calculated?
To determine how many members were active on a specific day, we do the following:
Retrieving Membership Data
The system pulls all memberships that are valid within the selected period.
Counting Active Members Daily
We check for each day in the period how many members still have an active membership.
Filtering Based on Membership Length
Members with a membership shorter than the specified minimum length (e.g., 30 days) are not counted.
Grouping Data Per Month
To make the data more comprehensible, it is grouped into a candlestick chart showing:
Opening value (first day of the month)
Closing value (last day of the month)
Highest and lowest number of active members in the period
Example Calculation
Suppose we want to calculate the number of active members for March.
Period: March 1 – March 31
Minimum membership length: 30 days
Members and their membership periods:
Member ID | Start Date | End Date | Active in March? |
101 | January 1 | March 5 | ✅ |
102 | February 10 | April 15 | ✅ |
103 | March 1 | March 30 | ✅ |
104 | March 20 | March 25 | ❌ (too short) |
105 | January 1 | December 31 | ✅ |
Now, we count day by day how many members have an active membership:
March: 3 active members (101, 102, 105)
March: 2 active members (102, 105) (101 leaves)
March: 3 active members (102, 103, 105) (104 is too short and is not counted)
Monthly Overview:
Opening: 3 members
Closing: 3 members
Highest count: 3 members
Lowest count: 2 members
These values are used to draw the candlestick chart.
Why is this important?
This calculation shows how many members are active on a given day. If the number of active members decreases over time, it may indicate low engagement, increasing the risk of churn. It provides the company with insights into when most members are active, allowing them to plan campaigns or adjust opening hours.
💡 Result: A graph showing changes in the number of active members over time.
Have any questions? Contact us via Intercom chat! 😊