How do you calculate Retention?

Webster’s defines retention (ri-tent-shun) as, the act of keeping in your possession.

Retention certainly receives a tremendous amount of discussion and press in our industry, rightfully so because of the key role it has in the financial success of every club. However:

  • Do you know what your club’s retention numbers are?
  • Do you know how to accurately calculate retention?
  • Do you know how to measure the financial impact of retention?

Let’s start with some retention statistic fundamentals:

  • It is referred to in a percentage format and tells you what portion of your members stayed members in the past year.
  • To calculate your retention percentage accurately you should be using 12 concurrent months of data. However, this does not need to be January -December, it can be calculated from June to May, July to June, etc.
  • The median membership retention for clubs is 66% (as reported in IHRSA’s, 2003 Profiles of Success). This means that for every 100 members, 66 members stayed and 44 of them cancelled in a 12 month period.

The most common misconception is that the retention percentage is derived by adding total cancellations in a year and dividing by the year end membership total. But this does not take many variables into consideration. The following steps outline the generally accepted method of accurately calculating your retention:

Make a 12 month chart and record in each month the following

Beginning Monthly Membership for each of the last 12 months. This is calculated as follows:

Previous Months beginning MembershipPlus Number of Sales Previous Month and Number of Reinstated (or unfrozen) Memberships

Minus Number of Cancelled Memberships and Number of Frozen Memberships

Total Cancelled Memberships for the last 12 months

Total the Beginning Monthly Memberships column over the last 12 months then Divide by 12 to derive an Average Beginning Monthly Membership

Total the Cancelled Memberships for Last 12 Months

Divided by

Average Beginning Monthly Membership

Equals

Annual Attrition, to convert that to retention take 1 minus attrition.


Sample Club Retention Calculation:

 

Month Beginning Membership Cancellations
Jan 1000 25
Feb 1050 25
Mar 1060 30
Apr 1040 30
May 1035 30
Jun 1030 35
Jul 1025 35
Aug 1005 35
Sep 995 25
Oct 995 25
Nov 1010 25
Dec 1015 25
Total 12260 345
Avg 1022  

 

Total Cancelled Members (345) / Average Beginning Membership (1022) = Attrition of .3375 or 33.75%

The Retention percentage is 1 - .3375 = .6625 or 66.25%

Your retention percentage is an important management tool and should be measured monthly on a rolling 12 month basis. Why is this important?

  • What gets measured is more likely to be acted upon.
  • Your retention numbers are an excellent indicator of your operational success and can validate or direct you to areas that need more attention.
  • It can help you to develop future operational strategies.
  • You can better track trends in your club membership over time.

Finally, and this is extremely important, knowing your retention numbers will enable you to budget, justify and then evaluate the cost of your retention improvement initiatives.

Take for example the 345 annual cancellations listed above. Let’s say you have a program that you believe would result in retaining or saving 3 members per month (36 members annually) but would cost $5,000 in additional supplies and payroll to run annually, it is a simple process to determine if the increased expense would be a worthwhile investment:

Multiply the number of members you project to save (36) by the individual dues revenue of each member (let’s say $50) and multiply that by 12 months:

(36 Members X $50 Dues) X 12 Months = $21,600 in revenue

Many clubs prefer to take it one step further and also take into account the revenue per member generated from ancillary services (personal training, massage, pro shop, etc.) the formula would be:

[(36 Members X ($50 Dues + $10 Non Dues)] X 12 Months = $25,920 in revenue

For simplicity, we used data from a relatively small club and yet the increased revenue generated from saving just a few members per month demonstrate that a big impact will be made on revenue and ultimately net profit. The seemingly large $5,000 investment would yield $25,920 in additional revenue -a worthwhile investment in any industry!

Investing in retention makes good business sense. However, knowing your numbers is the first step in determining what action to take and is a key indicator on the success of actions taken.

Please Note: If you would like assistance in calculating your clubs retention, calculating the financial impact retention will have or would like to discuss methods for improving retention feel free to contact me.

Chris W

Date:

Chris W

Published Articles