Hello!
I've browsed the forums a bit but I"m not sure I'm finding what I"m looking for so I thought I would ask in my own thread. I'm new to Analytics and mostly self taught by trial and error so please be kind and speak slowly
As we look to FY25 We are trying to pull Renewed (had a subscription last year) vs New (didn't have a subscription last year), and how many dollars and how many tickets and how many plays each patron has done this season (compared to seasons FY18-present).
I was working with what I thought was a good script for number of plays: SUM([Order ID], CASE WHEN [# of unique Performance ID] = 4 then 1 ELSE 0 END)
but what I have learned is that if there is a line in the order that has been returned that it no longer counts the Performance ID, so someone who has a 4 play subscription is being returned as a 2 play.
Please. Suggestions are helpful on the best way to set this up in analytics so that it's in one dashboard that I can present to Senior Leaders.
Thanks!
Have you tried pulling in sub line items (called SLI in Analytics) bucketed by production? I believe that will return tickets even if they are marked as RET or VOO
I haven't, do you know how I would include that in my formula or is it a separate filter?