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?
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.