Hi there! Has anyone made a sales pacing chart? I was tasked with creating an 11 weeks out pacing chart for single ticket sales. I am not seeing how I can input specific goal amounts into pivot tables that do not already live within Tessitura. When I use Order Weeks Prior to Performance, weeks without any activity don't appear (despite needing them for tracking). I'm also just struggling to see how this can be created as a Dashboard, but can easily see how this would be an Excel document/Google sheet. Does anyone have an example of widgets, or dashboards, that might help me along this? Any advice is appreciated. Thanks,
Try breaking out each part of the formula in a pivot table and then piecing it all together; that's helped me before. It looks like your parentheses are all in the right place, but with formulas it's easy to mix up something or forget to update a filter so breaking it down can help.
Hi Heath! Will there be a recording? Thanks!
Definite maybe (depending on how many spoons I have by then. Split attention is not one of my maxed skills). If it works I can do it again as a recording.
Thanks for Sharing this Christine! I was able to implement for SCT today. It solidified what I always thought about the importance of choosing comps that are in the same time frame of the season when we're forecasting. Our first show of the season appears especially behind because the comps were more toward the end of the season. You've provided a good visual for allowing me to argue that point going forward. Thanks again!
Hey Christine,This is awesome. I do most of my work outside of Tessi because I haven't really delved into it so will definitely steal this idea also! :DI'd be curious if you (or anyone else) have attempted to do more sophisticated forecasting/targeting then averaging a selection of past productions. Because of the variations from production to production I find it typically isn't a good representation. E.g. is there a way to map a line of best fit straight into Tessi Analytics?
That's a great point, Kanani! It's not just about being a similar show but the time of the season it's produced.
Hi Kanani! I'm so glad you were already able to put this to use! Using a combination of productions based on content or time of year for the index, and using the "weeks prior to closing" field certainly helps with understanding how current sales are going.
Using the season fiscal year offset in the formula has made it easier to play around and tweak which productions I have selected since that is on the whole dashboard rather than having to modify the formula. Something I found helpful too when choosing and tracking against productions, was to pair the sales pacing widget next to one that breaks out each of the selected productions, which has also helped in the past with seeing if the selections made sense and if we're pacing closer to certain shows, which can sometimes help with rough projections. It also shows if there was an anomaly in a particular previous production's sales pattern (something we talked a bit about last night on Analytic Coffee).
Hi Phillip! I would love to find a more sophisticated way to forecast and target and I'm curious to hear if others have come up with ideas! I'm especially excited for v16 Analytics to check out the new forecasting tools and to dig into understanding how they work.
Hi All!
I want to echo a hearty thanks to Christine Wingenfeld for this dashboard, I flagged this to play with when it came up 9 months ago and finally spent some time with it yesterday. It really is a thing of beauty once you get it going. I had some successes and wanted to share in case they are useful:
To Philip Booth's question, this dash fits fairly nicely into our Goal/Budget modeling and I adapted the dash to fit. I ran two sets of columns for the pacing, one for 100% (gross) and one at 70% (budget).
I also made a version to filter down just to premium seating, which has been nice! This was easy enough by adding an additional [Zone] filter into the formula.
When I showed this to our marketing team, they were happy but pushed me a bit further- we are using this to examine a subset of our productions- seated theater with a long run. The next step for us was not this/prior years, but working it to match pre/post covid buying trends, which for us have been drastically different. I achieved this by dropping the Fiscal year Offset and running my Production Season filter inside of the formula because we have had other theater productions in the current FY. Less dynamic certainly, but we usually need one or two per year. It worked like a charm, and now I have a tuned post-covid pacing dash for our summer run, with Gross and Budget figures.