Skip to main content

How to calculate membership lifetime

Ronny Christensen avatar
Written by Ronny Christensen
Updated this week

📌 Method: MemberLifetime

This article explains how we calculate how long a member has had a membership on average.

How is the lifespan calculated?

  1. Retrieves membership data

    • We find all members who have had an active membership during the period.

  2. Combines membership periods

    • If a member has had multiple memberships, the periods are merged to find the total active time.

  3. Calculates lifetime per segment

    • We can see the lifespan broken down by:

      • Gender (men, women, not specified)

      • Age groups (divided into intervals)

  4. Calculates average and median

    • Average: The total average lifespan per member.

    • Median: The middle value of all members' active periods.


Example calculation

Let's say we want to calculate the average lifespan of members between January and March.

Member ID

Start Date

End date

Total Membership Length

101

January 1

5 March

63 days

102

February 10

15 April

64 days

103

March 1

March 30

30 days

104

March 20

March 25

5 days (not counted)

  1. We sum up the valid membership lengths:

    63+64+30=157 days63 + 64 + 30 = 157 \text{ days}63+64+30=157 days

  2. We divide the sum by the number of members:

    1573=52.33 days (average)\frac{157}{3} = 52.33 \text{ days (average)}3157=52.33 days (average)

  3. The median value is 63 days (the midpoint of the sorted values).


Why is this important?

The lifespan of a membership is a crucial indicator of member retention. Shorter lifespans can indicate that customers are not satisfied or quickly cancel their memberships.

💡 Result: A graph showing the average lifespan of memberships by gender and age.

Do you have any questions? Contact us via the Intercom chat! 😊

Did this answer your question?