Dear all,
Apologies if this question has been asked and answered elsewhere!
As I'm sure is similar elsewhere, our corporate sponsors all have various contracted ticket allocations based on the way they benefit from their partnership with them and/or how much they are worth to us.
For example, our "Bank Partner" might have 200 tickets where as our "Community Partner" may only have 20. Since this is not uniform, I find myself constantly keeping tables of who's used how many tickets. In an excel document, which is not very efficient, especially tracking over 20 sponsors.
I would love to have a functionality in Tessitura which could show how many tickets a corporation has used in total YTD. I know this functionality is encapsulated in our Sales Summary report. However, apart from the bank's 200 tickets, they occasionally receive complimentary tickets, or tickets to our opening concerts, and those tickets also show up on the sales summary without differentiation.
Can anyone advise if they have a better way to see used ticket allocations in Tessitura? So far all we've come up with is changing the billing type but that has a fair amount of scope for confusion...
Grateful if anyone has any suggestions.
Janine Harris, Sydney Symphony Orchestra
Hey Janine,
Are you just after something you can look at with a glance? Maybe you can get an element added to your constituent pop-up.
An entry goes in TR_FLEX_HEADER_ELEMENT:
select sum(num_seats) from LVS_TKT_HIST where (perf_dt between '1 Jan 2014' and GETDATE()) and customer_no = @customer_no
(depending on any customisation to the ticket history table)
Then an entry goes in TR_FLEX_HEADER to create a field in the header to point to this element. You just amend the start date at the beginning of each year.
cheers,
Kev