Dearest Friends and Fellow Tessiturans--
Our whacky marketing/public relations director has this insane idea to track subscription renewal rates across the years by package. For example, how is the Tuesday Night Series looking versus last year, or over the span of the last decade, what's the retention rate of any given package?
I'm curious--is anyone else doing this already, and if so--how are you doing it?
As I'm thinking about my plan of attack on this, I know that I can pull subscribers by any given year and any given package within list/extraction manager, so I'm not so much worried about that data. My concern is being able to easily (and fairly accurately) filter renewed and newbs.
In my digging, I've found that for each season I have source code for our subs rollover, so I figure I could implent a multi-step process to manually suss out the data and make it presentable. If, for a example, a patron is subscribed to the 2016 season has a source code 2016 Rollover, then I know that they're renewed and can tally them accordingly. I'd need to do this across packages, of course, but the theory still remains the same (right?), and is essentially list/extraction pulling and de-duping.
I'm curious if anyone sees a flaw in my logic or is already doing this in a much more intelligent way. I figure once I do all the grunt work (I have to go back to 2002 with an array of packages), I won't have to do it again historically but rather just for each year as it happens.
Thoughts? Feelings? Criticisms? Suggestions?
Thank you!
Brian Jones