📌 Method: ActiveMemberships
This article explains how we count the total number of active memberships within a given period.
How are active memberships calculated?
Retrieving Memberships
We extract all memberships that were active during the selected time period.
Calculating the Number of Active Memberships Daily
We check each day and count how many memberships are still active.
Filtering by Minimum Duration
Only memberships that have lasted for a specific period (e.g., minimum 30 days) are included.
Grouping and Visualizing Data
Data is presented as a candlestick chart 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: March 1 – March 31
Minimum Membership Length: 30 days
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 | ✅ |
106 | March 5 | March 25 | ✅ |
Now we count the number of active memberships each day:
March: 3 active memberships
March: 3 active memberships
March: 4 active memberships
March: 4 active memberships (104 is too short and is not counted)
Monthly Summary:
Opening: 3 memberships
Closing: 4 memberships
Highest count: 4 memberships
Lowest count: 3 memberships
These values are used to draw the candlestick chart.
Why is this important?
Businesses with subscriptions and memberships use this calculation to understand how many memberships are in use. If the number of active memberships declines, it may indicate that customers are leaving, requiring strategic actions to retain them.
💡 Result: A visual overview of how the number of memberships changes over time.
Have any questions? Contact us via Intercom chat! 😊