I would like to be able to track tickets purchased by all constituents associated with one constituent. This would help me to track how involved the staff of our Corporate Partners have become with our programme.
eg tickets purchased by all constituents associated with Big Corp - ideally with the option to limit by order date or performance date
is there a standard report which addresses this which I am missing or does anyone have a nifty solution?
Thank you
Katherine
Hi Katherine,
You could first create a list with parameters including the performance date or order date and the Constituent ID of Big Corp. Before closing the parameters window, click on the Associations button in the bottom right corner. In the window that opens up highlight all of the applicable association types for Big Corp. If you don't want the Big Corp ID in the list make sure that the Keep Base IDs box is unchecked. The list that then generates is all IDs associated to Big Corp with tickets for this date.
Then to determine number of tickets booked or orders by these constituents, as far as canned reports with a list parameter you could run the Performance Seating Book or Single Sale Order Listing to determine these numbers.
Duane
Hi Katernine,
There isn’t a report built specifically to do this, but you might be able to get what you need by plugging a list into one of the standard reports so that the only sales listed are those belonging to corporate partner employees. There is functionality to create lists of associates that might help you build your list. Take a look at the Associations section of the Criteria Seats document for details: http://www.tessituranetwork.com/~/media/Documentation/Extractions%20and%20Lists/Criteria_Sets_for_Lists_and_Extractions.ashx
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Thank you both, I will run some experiments.