The county has requested some data from us to map ticket buyers and attendance behavior. I’m trying to figure out the best way to approach this.
They are looking for an Excel or CSV file showing:
- Street Address
- Venue of performance
- Year of performance
- Ticket Type (sub vs single tickets)
- number of tickets purchased for that performance
- Genre of performance
The report can be broken down by play. So a subscriber would have multiple entries on the sheet.
I can fill in Venue, Year, and Genre - but I’m trying to find a report that will show the patron’s address, promo code, and # of tickets by play.
“House Report - By Order (With Address)” seems close to something that might work, but it loses the Address field when I export it for some reason.
Any thoughts or ideas to how to gather this data?