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
I'd come up with a widget to break down the numbers by performance in specific seasons. The distance between May and September is a lot smaller than September and June of the next year: if you're correct and people are not booking as far out, then most of your bookings will be for September, and that will skew your overall average _shorter_.
Thanks Gawain - yes I see what you mean. I also realised I don't fully understand how the Order Days prior to performance works - a lot of our bookers for the 22-23 season will have booked for the whole Sep 22- Jun 23 period in one order, perhaps booking one or two concerts in each month. Does the Order Days prior to performance mean prior to the first performance in that Order I wonder?
Each ticket has its own value for Order Days Prior to Performance. Multiple tickets with different performance dates in the same order will not skew. Put another way, "Order Days Prior to Performance" is a property of the ticket, not of the order.
Thanks - good to know!