Hello everyone,
We would like to start analysing ticket sales by individual seller and I was wondering what options are available in Tessitura to do this.
As far as the canned reports I only find the seller's name generated in two reports - Single Sale Order Listing and Package Order Listing, neither of which produce all of the information we would like - including sales by production, date range, price type.
Is it possible to input Seller as a List Manager parameter in T_KEYWORD and T_KWCODED_VALUES? We could then run the generated lists against some of the sales reports that we use in Tess. I do not have SQL (we have no internal IT department) and would not know what tables to view, so if this is possible would someone be able to assist with the info needed in each column for this parameter in T_KEYWORD?
Any other suggestions you may have or letting me know other reports that I have missed would be greatly appreciated.
As always, thank you fellow Tessiturians!
Duane
If your local ticket history table includes solicitor, then it would be pretty easy to create a keyword that references that. (I'm assuming that the order solicitor is how you determine seller.) You could tell if your ticket history table includes solicitor by looking at the Ticket History tab. If it's in the table, it'd show on that tab.
Or you can analyze this using tstats, if you have tstats.
Hi Amanda,
Exactly, I am looking at Order Solicitor referring to ticket seller. This solicitor is showing up in the constituent Order tab, but not in our Ticket History tab.
We do have T-Stats and I have heard today that this will be a parameter in 2.0, so I think this is probably the route that we will end up going.
Thank you very much for your input, we will consider updating the local ticket history table to include this.