📌 Method: MemberLifetime
This article explains how we calculate how long a member has had a membership on average.
How is lifetime calculated?
Retrieving Membership Data
We find all members who have had an active membership during the period.
Combining Membership Periods
If a member has had multiple memberships, the periods are merged to find the total active time.
Calculating Lifetime per Segment
We can view lifetime distributed by:
Gender (men, women, unspecified)
Age groups (divided into intervals)
Calculating Average and Median
Average: The total average membership lifetime per member.
Median: The midpoint value of all members' active periods.
Example Calculation
Let’s say we want to calculate the average membership lifetime for members between January and March.
Member ID | Start Date | End Date | Total Membership Length |
101 | January 1 | March 5 | 63 days |
102 | February 10 | April 15 | 64 days |
103 | March 1 | March 30 | 30 days |
104 | March 20 | March 25 | 5 days (not counted) |
We sum up the valid membership lengths:
63 + 64 + 30 = 157 days
We divide the sum by the number of members:
157 ÷ 3 = 52.33 days (average)
The median value is 63 days (midpoint of the sorted values).
Why is this important?
The lifetime of a membership is a crucial indicator of retention. Shorter lifetimes may indicate that customers are dissatisfied or cancel their memberships quickly.
💡 Result: A graph showing the average membership lifetime distributed by gender and age.
Have any questions? Contact us via Intercom chat! 😊