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?
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])
([# 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