Hello,
We are conducting an analysis on sales trends for a large hall scaling project. As part of this analysis, we are interested in also including all of the unsold seat locations. I am wondering if someone has queried unsold seats from the database before, and what were the best tables to approach this. I am leaning towards using the seat status, but wondering if that's the best way to approach it.
Thank you!
Sarah
Hi Sarah,
I've been doing something similar to monitor remaining inventory some big ticket releases we've had in the last few months. I've got a query that uses tx_perf_seat and counts when seat status = 0. I'm outputting totals based on date, but that table also includes the row and seat information you'd need to get location instead.
Hope that helps,
Scott
Scott, thank you so much for your response. This was very helpful!