I am trying to pull a report that will give me any patron who has attending our Presenting Series (Main stage) shows, but has purchase 3 or more of the events. Whenever I try to run it, it pulls out anyone who has purchased 3 or more TICKETS instead of 3 or more EVENTS. Can anyone help?
Hi Amy -
Did you try using Tickets-Number of Unique Perfs in your criteria? This will give you unique lines in your ticket history. One caveat - if you break out order lines by price type or anything in your ticket history than this criteria will give you inflated (or deflated) numbers.
HTH,
Heather
I will try that! Thanks! I was just so frustrated because it seemed like every way I tried it, I was getting incorrect information...
Hi Carol,
Take a look at the Attendance by Performance report. It lists ticket sales counts without revenue data, and has performance date parameters that you can use to set the report up on a schedule. If you set it to not include constituent detail and include all attendance statuses, it should give you the information you need.
Here’s a link to the documentation on that report: http://www.tessituranetwork.com/Help_System_v121/Content/Reports/Attendance%20by%20Performance.htm
And, in case you need it, here’s a link to the help topic on using relative date options when scheduling a report: http://www.tessituranetwork.com/Help_System_v121/Content/Reporting%20Overview/Relative%20Date%20Options.htm
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Hey Kevin!
Perfect! Thanks so much—this is just what I was looking for!
Thank you,
Carol
Carol Ciulla
Box Office Manager
37 Main St. 01966
978.546.7391 x 102
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kevin Sheehan Sent: Wednesday, December 3, 2014 2:01 PM To: Carol Ciulla Subject: Re: [Tessitura Ticketing Forum] Reports
Here’s a link to the documentation on that report:http://www.tessituranetwork.com/Help_System_v121/Content/Reports/Attendance%20by%20Performance.htm
And, in case you need it, here’s a link to the help topic on using relative date options when scheduling a report:http://www.tessituranetwork.com/Help_System_v121/Content/Reporting%20Overview/Relative%20Date%20Options.htm
From: Carol Ciulla <bounce-carolciull6102@tessituranetwork.com> Sent: 12/3/2014 10:50:30 AM
Hi
We are not yet using T-Stats---hopefully we will be soon. But in the mean time;
I am looking for an auto report that will pull the total number of tickets sold; single and package seats, only, no revenue. I want to isolate the events that are running during that current week only; Monday-Sunday.
Is there a report where in I can make the performance dates relative, based on the current date? So I can set this up once and not have to change the performance dates, each week?
Any suggestions would be helpful.
Thanks
Rockport Music
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!