Your friend and mine, Michael Moore (Hi, Michael ) emailed asking me about retention and churn rates in Analytics. It reminded me very much of this great thread:
Booking churn Subscribers in Analytics? - Reporting & Analytics - Forums - Tessitura Network
I just love the season-over-season retention segmentation in that widget, but Michael was asking more about retention and churn from a given starting season. What happened to just those constituents from that starting season. How many did we retain for how long, and how quickly did they churn out? So, my gift to you (and Michael) as we close out 2023 (3 business days for me) is the attached sample ticketing Churn from Base Season dashboard.
Notes regarding the dashboard filters and limitations can be found in the text widgets at the top and bottom of the dashboard.
ChurnfromBaseSeason.dash
Do you think this and something like the widget in the linked thread should show up in the pre-built dashboards or samples?
Absolutely - seconding what Michael and Mary said, we would love churn widgets to be in the pre-built dashboards!
We report on churn, and at the moment I do it all in Extractions, get my numbers for the segments, then build it out in a chart in Excel. I will be taking a look at your churn dashboard in due course to get away from Excel if poss!
We currently look at churn for 'new this season' and then 'lapsed new from last season', plus then 'existing customer prior to this season' and 'lapsed existing customer', so for any one season, our graph has two segments above the line and two below the line. We break it out like that because we know the churn rate for existing customers is quite a bit lower than for new customers, and one of our strategic ambitions is to reduce the rate of churn for new customers. I'm not sure if this would be a common theme among Tessitura clients, but we find it useful to see.