>CRS Reports > Billing > Attrition

Attrition

 

Report Overview

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.

 

Report Columns

For each month, the report includes the columns in the table below.

Column Description
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. Take the sum of the previous 12 months' negative impact and divide it by the result of dividing the sum of the last 13 months' Ending # Accounts by 12.

Another way of representing this is

 

When to Use the Attrition Report

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:

 

Generating the Report

Use the report's parameters page to select the following:

 

  1. Cycle - When you run the Attrition report, you can choose between viewing all available months or the most recent 13 months of data.

  1. Club(s) - Select one or more clubs to include in the report by moving clubs from the Available Clubs box to the Selected Clubs box.
  2. To add all available clubs to the Selected Clubs box, select the All Clubs check box.
  3. To select specific clubs, click the name of the club you want to move to the Selected Clubs box then click the arrow pointing toward the Selected Clubs box.

  1. Report Format - Select a report format then run or queue the report.

 

Sample Report

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.