Hi folks
We're asking the question (like a lot of you will be no doubt, post-pandemic) - are audiences generally booking later than they used to? We're pretty sure the answer is yes, from watching sales curves etc, but I'd like to be able to put some numbers on this.
So I'm trying to build a widget which will show the average number of days before a performance that people booked per season.
I thought I got what looked like a reasonable result (that people were tending to book a little later in 18-19 and 19-20 than they had in 17-18, then they had to book a lot later during 21-22 as we split our season in two, and put each half on sale very late, but then I get to the 22-23 value and my chart doesn't make any sense, so I'd question whether the earlier season results were correct as well.
We've put the 22-23 season on sale in May 22, and that is for concerts from Sept 22 - June 23. We saw a big rush for onsale, then much slower sales from Jun - Aug 22 onwards, so I would expect this value of average days before performance for orders to be pretty high at the moment - well into the 100s days, but I'm getting a value much lower than that.
No doubt I'm not using the formulas/ breaks correctly and need to group each season's orders together before working out the average for each? - can anyone on here who is great with formulae help me out?
Best wishes
Melanie
Ah I see! Glad to hear that TLCC came back after covid with a bang!