The Attrition report lists the monthly attritionThe reduction in the number of memberships. percentages for the selected time frame. You can view a list of several months at once, and also view details for individual months. This report can be generated for one or multiple clubs.
Numbers on this report are rounded throughout.
For each month, the report includes the columns in the table below.
|Monthly Attrition||The negative impact divided by the average number of beginning and ending accounts.|
|Monthly Attrition Annualized||
The monthly attrition multiplied by 12.
|Rolling 12 Month Attrition||
Uses a history of data in its calculation, including the negative impact and the ending number of accounts. Follow these steps to calculate Rolling 12 Month Attrition:
Use the Attrition Report to compare a club's attrition rate across months and clubs. Use drill-down reports to view one month of data and compare attrition for recurring and Cash/PIF accounts.
Use these reports in conjunction with the Attrition report to gain further details:
Use the Account Reconciliation report to compares the different explanations for positive and negative impact and to see individual accounts categorized. Use the Attrition report strictly to compare months to one another.
The parameters page of the report allows you customize the data provided by selecting:
The parameters page is displayed below.
When you select multiple clubs, the report will include an aggregate report as well as individual club reports. The aggregate report shows the average attrition rate for all selected clubs. To view attrition for a specific club, navigate to the individual club report. For help navigating to an individual club report, click here.
Below you can view a sample aggregate report.
To see monthly attrition details, click a month. The aggregate report will generate monthly details for all clubs selected.
Please note that negative impact includes transferred accounts, expired accounts, cancelled accounts, and accounts in RFC status.
In some cases, the Net Ending # Accts will not be equal to the Beginning # Accts + Positive Impact - Negative Impact. This occurs when a member renews to a new type. For example, a member may have been categorized as Cash/PIF previously, then renewed to Recurring. In such cases, the member did not exit the club or re-join the club, which would have been classified as positive or negative impact. Instead, that member is simply accounted for under a different category.
In the image below you can see how this scenario would be represented in the report. Recurring accounts are down by three, while Cash/PIF accounts are up by three. No members were lost; however, three members renewed from Recurring to Cash/PIF.