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,
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.