What is the difference, month by month, in the churn rate (how many members join minus how many quit) between members who pay monthly and members who pay yearly.
Problems:
Quit date is not stored in the database like join date is. We would have too loop through a member's entries in the membership table to find the date when their status changed from active to inactive. This may require a new module, as many other cases have similar requirements.
If the payment interval is not stored in the membership database, then this exact report is not possible, but it is still an interesting case study...
What is the difference, month by month, in the churn rate (how many members join minus how many quit) between members who pay monthly and members who pay yearly.
Problems: Quit date is not stored in the database like join date is. We would have too loop through a member's entries in the membership table to find the date when their status changed from active to inactive. This may require a new module, as many other cases have similar requirements.
If the payment interval is not stored in the membership database, then this exact report is not possible, but it is still an interesting case study...