Tracking Renewal Rates

Hi! I'm relatively new to Analytics. We've just launched our renewal period and I'm trying to build a pivot table that allows me to track renewal rates. I've built out a table that shows me a comparison of the number of subscribers year to year. But what I'd love to see is the actual percentage of renewals. Does that make sense? 

  • I achieve this by saving a list of the previous year's subscribers in List Manager and checking the "Analytics" box so it can be pulled into there for analysis. Then I simply built out a widget that looks at subscribers for the current season, using last year's list as a filter! That gives me the total count (or %, depending on your formula) of renewing subscribers.

    There may be a more elegant solution for this, but it works well for my needs.

  • That's an interesting approach! Do you think that would still let me break it down by the count years as a subscriber? So that I could see that x% of our 5-year subscribers renewed, etc?

  • Hi Bridget, one way to segment to look at renewals is filtering by the "solicitor" name for "Subscription RollOver." You should be able to use a filter to only include that solicitor name for your renewals and then exclude that solicitor name for new acquisitions.

    Here is the formula I use for subscription renewal rate, with notes about the filters:
    ([# of unique Package Seat Key], [Package Season - filtered to current season], [Solicitor Display Name - filtered to Subscription RollOver]) / ([# of unique Package Seat Key], [Package Season - filtered to last season])

    There's also a formula at the end of this post that you might want to try out if the Solicitor filter doesn't work or if you consider your renewals more broadly than one year to the next.

    I hope that helps!
    Christine

  • I do the same thing Anh describes and that historical look is doable, but I find it needlessly complicated sometimes to try to do it all in one widget. Instead, I make a few copies of the same renewal % widget and use different lists for different subscriber segments (1st Time Subscribers, 3+ Years Subscribers, Members who also Subscribe, etc). I lean on the list as a filter a lot, since we had a pre-Analytics habit of defining our subscriber segments in lists.

  • How do you do this? And what filers do you use?