Hi all,
Has anyone got a widget already created in Analytics or a report that shows you production season sales over time? Ideally to show all production seasons in a season in one report.
We'd like to be able to see % sales taken by week leading up to the performances to proof or disaprove customers are booking later than pre Covid times.
Thanks
Kat
I would also like to see percentage sales by week prior to the performance. I have a relatively basic dashboard I have created that shows running sales, but I have been thus far unable to figure out how to make a coherent graph with percentage sales.
That said, just in case you are curious, we have done plenty of charting in Excel using existing reports and manual work and we have verified that our patrons at least ARE buying closer to the performance date than they were pre-Covid. For whatever that is worth.
John A. Moskal II
Hi Kat,
To clarify, are you looking for a graph that shows percentage sales for each Production Season, broken out by week? As in, "In week 1, we did 10% of our total sales for X Season. In week 2, we did only 5% of X season's sales"? Then, when you'd add up all the weeks, you'd get 100%?
Hi Nathanael
Yes that's right, and I would expect to see the % weighted more heavily closer to the show date.
Hi John,
Yes we are currently looking at things in Excel but it takes a lot of manual input at the moment, a coherent graph would be great!
I think I got something that's a step in the right direction:
I'm not sure how 'Order Weeks Prior to Opening" works with a General Admission Prod Season, but the formulas seem to work consistently, and the numbers line up.
Cool beans. You could take the formulas I put together and run them through different rows to get your multiple Prod Season layout:
Nathanael Pearson,
I was looking to do exactly this. Thank you! And it looks like it can be easily graphed as well, which I know is what our executive team wants (they like graphs and pretty pictures).
Great! I'm glad you're able to use it.