Mixpanel Community Icon
Join Our Community
Community Questions

Creating a Monthly Chart for Subscription Renewal Rates Explained

Avatar of Dave S.Dave S.
·
·

Hello everyone, I'm looking to create a chart that displays the subscription renewal rate in a month-over-month format. I'm not looking for the total number of subscribers that renew, I'm looking for the % of subscribers that started a subscription and renewed on their next renewal date (could be monthly, yearly and bi-yearly). For example, 300 people subscribed in August 2023 and 250 of the renewed their subscription the following year (August 2024). The renewal rate would be 83.33%. How would i do this? Thanks for your help 🙂

3 comments

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    do you mean something like this?

  • Avatar of Dave S.
    Dave S.
    ·
    ·

    Kind of. Is there a way to configure this to not compare to the previous month, but to create a percentage of subscription renewed from started started?

  • Avatar of Dave S.
    Dave S.
    ·
    ·

    im not looking to compare only based on the revious month's totals