Churn rate feature request

@danceninjas this is a really good topic to cover with many business and technical nuances. I’m going to think out loud and you play along as much as amuses you.

Questions to ask:
– Are these products offering both MONTHLY & ANNUAL subscriptions? Or just monthly? (Or it depends?)

How churn is calculated:
– From business point, simply take remaining users at end of cycle and subtract from total users at beginning of cycle.
– But from programmatic calculations, we have to wait for user’s subscription status to expire when they don’t pay the next cycle.

So that means…annual subscriptions should have only annual churn calculated. And monthly subscriptions can have both annual and monthly churn calculated.

Then gotta decide what date range to calculate the churn. An overall lifetime average monthly/yearly churn rate is easy. But I have a sneaky suspicion you want to have churn rate of the products over any month/year. It’s a lot of calculations…I suppose all is possible if you don’t mind your server doing a ton of crunching.

The last part is how to visually display this.
– To show annual churn rate across many years…user selects ALL TIME date range, and a table displays different churn rates across numerous years.
– To show annual churn rate across many months…user selects YEAR or date range across multiple months, and a table displays different churn rates across numerous years.

Charting issues/questions:
– The issue with annual churn is associating it’s churn year to the time of signup, or time of payment cycle ending. For example….product sign happens in FEB 2021 and wasn’t renewed in FEB 2022. That’s counted towards churn year 2022, right?
– For subscriptions that haven’t finished their first payment cycle yet, we assume these are not calculated in any churn percentages, right? Since we don’t know whether they’ll continue or not.
– You wanted only member churn? Or revenue churn as well?

With these X-Y charting necessities, it absolutely has to be its own tab, I’d say. Is everything I’m saying more or less what you want?

• This reply was modified 2 years, 6 months ago by treeflips.
• This reply was modified 2 years, 6 months ago by treeflips. Reason: adding clarity
• This reply was modified 2 years, 6 months ago by treeflips.

I would like to see something similar, maybe like a customer report that could also be exported as a CSV file.

User Name | Email | Registration Date | Cancelation Date | Expiration Date | Payments | Revenue

Maybe have a filter by membership? and a search by user as well?

for the revenue, it could be calculated with the latest amount collected, as the payments are upfront payments and nothing is added to it past a cancelation date or expiration date.

as for visibility, it could all be in a table form (rows and columns), like the mp reports currently

And maybe a daily report: in a table format again

date | New sales |New REvenue | Recurring Sales | Recurring Revenue (might even have an expired subscription column for the number of expired memberships on that date)

under the date would be the membership sold that day

and then totals for that date

with a summary table as well for the selected time range

with the time range being Last 30 days then you can select by month