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.
How do you do this? And what filers do you use?