Do you sell via Ticketmaster (or another third party)? How do you get those sales into Tessitura and report back on them? How often do you do the import? How do you handle returns/reselling? I want to hear as much as you're willing to tell me.
Hi Maery,
We have Tickets.com (for the time being) that the venue box office uses. This is the system that we had prior to Tessitura. We pull reports on daily sales that I combine with pivot reports on the same Excel sheet. To get the data into Tessitura I use Alteryx Designer approx. 2 hours before the performance. This way any exchanges can only be done at the venue if they originally sold the ticket and then by us only after the import has been completed and our representatives are at the venue. It also allows us to only use one scanner for all tickets no matter where the patron purchased.
Alteryx is still a program that I am learning but basically we run a report from tickets.com that includes the barcode for each individual ticket. I run the report through Alteryx that changes the format of the information to what Tessitura needs. It is looking for any patron records that are already in Tessitura (via the patron ID that is set up as an attribute). We pull a list from the back end that gives us our full data base to compare to. It compares phone numbers, names, and email addresses too.If it doesn't find any record we will do a constituent import first, re-pull the data base, and then run it through Alteryx again. Once it is a clean list, which can take a few cleanings and re-pulling of the data base, we then import it into Tessitura.
My predecessor did the programming in Alteryx for our first season (last year was our first on Tessitura and not on the same ticketing as the venue). We have a new venue this year so I will be learning it more in the next couple of months.
Hope this helps.
Sally
I'm not familiar with Alteryx at all, but this sounds promising. Is there any difficult with not seeing those Sales in Tessitura until two hours before the performance?