Hi there!
I am attempting to use this report for some YOY season sales analysis and I've scoured the forums and have a bit better understanding what this report is telling me. But I am still struggling with Actual vs. Home vs. Base pricing specifically. Actual is pretty self-explanatory, but Home and Base are tricksy. I have a few questions for anyone who understands this report:
1. Base: Where is this amount pulled from? Often, we have different Base prices depending on the performance day, price type and price zone. Is this an average?
2. How is Potential calculated for both Home and Base price? If my Home price is $10 and I sold 10 tickets, I would assume my Potential would be $100; but more often than not, the math doesn't reflect this. Same thing for Base.
3. Would all price layers be considered for this report?
My apologies if these questions seem relatively straightforward, but I have been looking at this data for about a week and my eyes are getting a bit crossed.
Cheers,
Kristine
Hi Kristine
1. When a performance is setup a price type is selected as the Base price - for most people this is the Standard price ticket - if you look at Pricing in Performance Information etc this is the one shown in Bold. If you are aggregating by Season or Production season the calculated values will be correct but the Price may not be as it will show one of the prices as the price in the report but will ave used the actual Base price on the performance/zone for calculation purposes.
2. Potential is just Home Price (or Base Price) x Number of tickets sold - this i calculates per price type, per zone, per performanceHowever if you are grouping by Production Season or Season then if the price for a Price Type/Zone varies across performances then the matsh will look wron as they pick one of the prices but have actually calculated correctly
You can confirm this by looking at just one performance where the maths normally makes sense.
For example if report shows that for
performance 1 you sell 25 tickets in zone 1 with home price of £53 then your potential is £1,325performance 2 you sell 28 tickets in zone 1 with home price of £55.50 then your potential is £1,554
however, when you look at both performances together and group by Production season you are likely to see that you have sold 53 tickets (25+28) in zone 1 with a home price of £53 and a potential of £2,879 (£1,325 + £1,554) which is not equal to 53 * £53 which would be £2,809
3. According to the help page you can select which Price Categories to show (must admit I am not seeing that parameter in Tessitura) and so this would allow you to limit the price layers seen. Looks like by default this is set to All as when I run the report it shows Price Categories(All) in the parameter listings and therefore all Price Layers would be included
Hope that helps
Mark