Hi,
We are looking into the booking churn for our subscribers at Malmo Opera.
Parameters we want to look into on a seasonal level:
In what packages? Other patterns?
In what packages? Other patterns for drop offs?
Anyone got any tips and tricks on how get started with this in Analytics, reports or in List Manager/ Extraction Manager?
We dont know if Analytics is the right place for this since there is no Data set for Subscribers?
Thanks a lot for your help!
Josefin
Chris Wallingford - this has been a huge help for my organization - thank you for providing both the dashboard and chart.I was wondering if you know how I can get the same new/returned/lapsed/churn information, but instead for the total number of subscription packages, instead of constituents? I've tried different formula options, but I can't seem to find one that works. Thanks in advance!
So this is great! One more question: i am trying to find which subs from 2020 and 2021 didnt renew in 2022 but bought single tickets to performances in the 2022 season. Which dashboard would be best for that? I have imported all the dashboards and they all have great info but not sure I am seeing exactly what i need quite yet. This might be just a simple adjustment of a formula. Unfortunately, I am pretty darn new at this so thanks for all the help!
Hi Robert,
I think we'd just add a couple of conditions to the Returned formula above...
IF ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2020] ) > 0 AND ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2021] ) > 0 AND ISNULL ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2022] ) ) AND ( [Total Ticket Count] , [Season Fiscal Year=2022] ) > 0)
...if they have packages in 20 and in 21, and not in 22, and otherwise have tickets in 22... Does that sound right?
That sounds exactly right!!!!
I am getting a syntax error when I replace the formula in the returned
Yes Robert, sorry, I used some shorthand in my reply... the full formula would be
SUM ( [Constituent ID] , IF ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2020] ) > 0 AND ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2021] ) > 0 AND ISNULL ( ( [Total Ticket Count] , [Package ID>0] , [Season Fiscal Year=2022] ) ) AND ( [Total Ticket Count] , [Season Fiscal Year=2022] ) > 0 ) , 1 , NULL ) )
And unfortunately copy / paste from the text here into the formula editor will not work. A valid formula in the text editor is much more than the text that's visible, and pasting this text into the formula editor doesn't include that additional information. Instead it needs to be recreated in the formula editor.
So Ive tried to recreate this a number of times. I always get an error. First, if i add that last ) after the NULL line, I get "Function Syntax Error: End of formula expected. ')' found instead. If i delete that last ')' , I get a different error that I will attach below. I am not sure if i need to type the [Season Fiscal Year =2020] or if editing the filter and selecting 2020 and so on works. Same with the Package ID >0. I just used the filters. Thanks for your help! I am sure this is something i am simply doing wrong.
This ")" corresponds to the "IF (", so it should be after the results if true or false. You can just move it to the very end and the formula should allow you to save...