Hi,
I was just looking for a bit of advice on something...
We have 4 venues at the RNCM (plus we sometimes sell for performances at outside venues) and I'm looking into how we can break down sales reports/summaries by venue. I'm wondering how anyone else goes about this, as I don't currently have the venue-space as a criteria I can report on. I imagine some venues pull this information from different sections, so just to explain how we record it...
- Our Season structure is broken down by period/promotion, not by venue. (eg. 'Spring 2014 RNCM', 'Spring 2014 RNCM External', 'Summer 2014 RNCM'...) We need to retain this as it's a preferred method of reporting for some departments.
- In Facility Manager, we have Facilities set-up for our 2 reserved-seated venues, but everything else currently goes in our 'General Admission' map (basic grid for unreserved seating). I don't know if it might be better to have separate General Admission maps for each venue, but it's not something I've needed so far.
- I do include the Venue as: a Ticket Text line in 'Performance Details', as a TNEW Keyword in each performance, and I've recently started specifying the venue in FacilityManager>PriceMap>Category.
I'm yet to look into setting up/importing custom reports, but before I do this I'm starting to think about whether I'm storing venue information in the right way and whether I ultimately need to look into reporting this by Facility, Keyword, Price Category or something else.
(The ideal end result would be a report for finance featuring a table of: Event name / Date / Venue / Paid Tickets / Free Tickets / Total Tickets Issued / No. of Available Seats / Total Income and possibly searchable by Season / Event Date / Transaction Date.)
Thanks in advance for any advise/suggestions!Cheers,Rog