Enhanced Membership Reports
planned
Isaak
Create a dashboard to help with illustrating to a committee or board what is happening with memberships.
Date/Period
Be able to define the period we want to report on (like Finance reports)
Have it compare with the same, previous period
Growth
Monthly Recurring Revenue (MRR) from Memberships. It can be thought of as the total amount of revenue you can reliably expect to receive on a recurring basis. It is one of the most important metrics for a Membership organisation to track, as it provides a forward-looking measure of growth and predicted revenue. We can calculate the approximate MRR by summing the monthly normalized amounts of all subscriptions from which payment is being collected at that time. For example, an annual subscription for $1,200 only counts $100 towards your MRR. This includes subscriptions in the status=active and status=past_due states.
MRR Growth
Net Revenue
New Members - This occurs when a new or existing customer starts a new active subscription, or upgrades from a free subscription to a paid subscription.
Products
MRR by M'Ship Level
Retention
Member churn rate - The churn rate is measured by the sum of churned members/subscribers in the past 30 days divided by the number of active members/subscribers as of 30 days ago, plus any new members/subscribers in those 30 days.
Churned Revenue - The churned revenue for a given period is a sum of lost Monthly Recurring Revenue ("MRR”) from churned members/subscribers. If a customer has two subscriptions and cancels both, we will count each cancellation as a churned member/subscriber.
Member retention by cohort
Revenue retention by cohort
Members
Average Revenue Per Member (ARPM) - is total Monthly Recurring Revenue (MRR) divided by the number of active members/subscribers.
Lifetime Value (LTV)
Recently Churned Members
New Members
Log In
Isaak
Merged in a post:
Membership Reports - remember settings
C
Carl Agar
Membership Reports to have the same functionality as Contacts to remember the displayed fields.
A
Alison Banks
Looking forward to this development as we have a great need for this data for our planning and reporting to the board.
Isaak
planned
Isaak
Merged in a post:
Enhancement to Indication on top left-hand side where Active Member stats are listed
A
Alison Banks
Currently this snapshot lists "New this month" and "Expired this month" but to establish if any expired members have since renewed, you need to run reports for each of these groups and then cross-reference which is time consuming and reduces the value of this snapshot data when this isn't taken into account. An enhancement that factors renewals of any expired memberships into this data would increase efficiency and the value of this snapshot information greatly. We would be most appreciative of your serious consideration of this improvement.
Isaak
Alison Banks would this help? https://tidy.canny.io/feature-requests/p/enhanced-membership-reports
A
Alison Banks
Isaak: Looks like this would be very helpful indeed Isaak... is it likely to get up do you think?
Isaak
Alison Banks: Yes, very keen to make this happen. I don't have a timeline for it, but it's a 'no brainer' for us to push forward with it.
Isaak
Part of our thinking was to move more functionality to the Contacts Table so you start using the Contacts Table in a similar way to what you're doing (I think) with the membership report table?
I'm assuming you're talking about adding extra columns and then saving that view?
C
Carl Agar
Isaak: Yes, every time I go to the report I have to turn on the same fields I want to display so that I can sort the records. We are using custom membership number fields that you added. The obvious sort is to find the next member number. There is also one element of functionality that the membership report has that the contacts does not; the ability to show the records grouped by membership. The majority of our membership are family - By the time I add a male adult, a female partner with children from her previous relationship(s), their children, children in foster care, etc. I can have memberships comprising 4 or more surnames. So from that point of view the contacts search fails as I search by one surname and find the membership, but cannot find the others people in the membership. I then have to go to membership reports to determine all of the people in the membership.