Column
|
Description
|
Month
|
Month for the reported data. |
Terminated During Month
|
Customers that were active prior to the month, and terminated during the month, and did not renew during the month
|
Currently Terminated
|
Customer’s Phone number.
|
Newly Active Members
|
Customers that are active in the club during this month who were not active last month (this includes Newly Joined Members).
|
Newly Joined Members
|
Customers that were never part of the club and are new signups during the month.
|
Total Active
|
The total number of active club memberships at the end of the month.
|
Declined and Renewed During Month
|
Customers who were active in the club last month, declined this month, then later renewed this month.
|
Declined and Renewed To Date
|
Customers who were active in the club last month, declined this month, then later renewed as of the current date.
|
Declined and Terminated During Month
|
Customers who were active in the club last month, declined this month, then later terminated this month.
|
Declined During Month and Currently Terminated
|
Customers who were active in the club last month, declined this month, and are currently terminated.
|
Declined and Not Renewed During Month
|
Customers who were active in the club last month, and declined during the month, and did not renew during the month.
|
Declined During Month and Currently Terminated
|
Customers who were active in the club last month, and declined during the month, and did not renew during the month.
|
Declined During Month and Not Renewed During Month
|
Customers who were active in the club last month, and declined during the month, and did not renew during the month.
|
Declined During Month and Not Currently Renewed
|
Customers who were active in the club last month, and declined during the month, and did not renew during the month.
|
Total Members Before 1st |
The number of active members going into the month.
|
Members Lost |
Number of members ending their club membership (“Terminated During Month” + “Declined During Month And Not Renewed During Month”). |
Ending Members
|
Number of members in clubs (“Total Members Before 1st” + “Newly Active Members” – “Members Lost”).
|
Lasted a Month, Lasted 3 Months, Lasted 6 Months, Lasted a Year |
These columns represent the period in which a club membership was maintained before the customer chose to opt out. It should be noted that these columns represent lost memberships so their sum is equal to the number of Members Lost (“Members Lost” = (“Lasted a Month” + “Lasted 3 Months” + “Lasted 6 Months” + “Lasted a Year”).
|
Lasted a Month |
Never renewed. |
Lasted 3 Months |
Had membership 2 to 3 months.
|
Lasted 6 Months
|
Had membership 4 to 6 months.
|
Lasted a Year |
Had membership for 7 months or more.
|
Churn Rate
|
The rate at which members leave the club (“Members Lost” ÷ “Total Members Before 1st”).
|
% Churn
|
The percentage of membership lost (“Members Lost” ÷ ((“Total Members Before 1st” + “Ending Members”) ÷ 2)).
|
% Monthly Growth
|
The percentage of growth this month (("Ending Members" - "Total Members Before 1st") ÷ "Total Members Before 1st").
|
% Annualized Growth |
The percentage of growth projected annually (% Monthly Growth * 12).
|