Option #2: Use a Membership Retention Rate KPI: The KPI uses this calculation to calculate an ongoing rate for one of your membership programs. You also have the option to report on only one level or only one reporting group:
Option #3: If your organization calculates retention rate differently, you can use the numbers provided in a canned report or build queries for these calculations. Below are a few suggestions of reports you can use and queries you can build:
- Membership Activity Tab: To access the Membership Activity Tab, go to Memberships and click on your Membership Program.On your membership program record, you will see the Activity Tab which breaks down member transaction activity into Renews and Rejoins, Upgrades, Downgrades, New Members, and Dropped (Cancelled) Members. You can also change the date range on this dashboard to see the activity during a certain date range.
- Membership Count Report: The Membership Count Report will give you the number of active members at the end of each period for which you run the report.
- Query: How to pull a list of members who were active during a specific date range - This is a query you can build to show you members who were active during a specific date range.
- Query: How to create a list of all membership transactions - This query will show you transactions with a certain action that happened during a specific date range. These instructions also contain steps to include the amount of these transactions which you will not need to include for membership retention rate.