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?
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!