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!
Hi Carolyn,
Here are a couple posts that I hope might be helpful:
Thanks, Chris.
Does anyone have any other suggestions on ways to pull subscribers by number or performances in their order? That seems to be the part of my formula I am most struggling with.
I'm confused by this learning...
Do you mean strictly returned here, or is this an exchange where a performance ticket within a package is returned and a performance ticket for a different performance is issued to the package holder? If it's the latter, I'd expect the returned ticket to still be in Analytics. It will have a Ticket Count = 0, but the Performance ID will still be there.
That said, the [Package Size] field in Analytics may be helpful, but it too is counting distinct [Performance ID] in the Package.