1. If all tickets are returned for a performance is there anyway to pull a list of patrons who originally had tickets to that performance if ever one in said performance has been returned? (All seats are white in the seat map)
IE- single ticket buyers to come back to see a performance when/if it's remounted.
2. To Gather Peak Revenue:
How could we report on what the revenue of a performance was PRIOR to when cancellations happened and exchanges/returns started to happen?
IE we already are moving patrons out of performances, refunding ,etc - Is there a way to see what the sales to a specific performance was on 3/11/20?
If you have already done some refunds.
You might be able to do some of this "As-Of" reporting through the Finance Cube in Tessitura Analytics. However, you are limited in the kind of ticket information you can pull.
I believe that Kyle Burkert and Mark DuBose from LSC were playing with this on Tuesday or Wednesday.
Just my $0.02. Others may have way better ideas.
The GL Summary Report can give you how much per GL based on a date. And in Detail mode, you can see by day. It won't tell you the who, but you could get that from Transactions by Posting and seeing who you were refunding and it will tell you what the money came from. So, if you combine the info from those reports, you can get there.
Ticket Sales by Period is also a great stock report to capture ticket revenue at a point-in-time (say, midnight of the day before cancellations began). Here in Seattle we had about 12 hours between the first reports of a ban on gatherings and the actual announcement, so I pulled numbers for all of our remaining performances/productions to make sure we had an idea of the overall earned revenue portrait for the foreseeable future.
For seat- or order-level fees (another piece of the revenue puzzle), you can also capture a specific transaction date range with Ticketing Fee Revenue (in the Finance reports folder).
Oh, and for question #1 - I can't think of an easy way to do this using standard reports. However, if you or someone on your team has SQL access, the table you want is called T_ORDER_SEAT_HIST. This table captures every historical action that happens to every seat in every performance, so you can isolate it down to the specific scope you need and then grab the most recent 'Returned' events that were created when the seatmap was emptied out, and the associated order/customer_nos with them. Hope that helps!