• Replies 6 replies
  • Subscribers 413 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Groups report

Nicola Blackburn
$organization

Hi

I'm fairly new to Tess and we are looking for a quick and easy way to get a list/report of customers who have booked 10 or more tickets for a particular performance so that we can supply our Front of House team with the information. What's the easiest way to achieve this list/report?

Thanks

Nicola

  • $organization

    This is really easy in List Manager.  Click "new list", expand the "ticketing" folder.  Select ticket production name or ticket performance name with the operator "in" and select your particular performance.  Then pull in "Tickets-Number of Seats" (also in the Ticketing folder) with the operator >= 10.  Save and generate the list.  You could then print this list using any number of reports in reports and utilities for the House Manager.

    Chuck Buchanan

    92nd Street Y 

  • $organization in reply to Charles Buchanan

    Thanks Chuck, when I run this it won't let me use 'In' for the Production Name or Performance Name it will only let me use = but when I do that it pulls off a mixed selection of peole including some who have not booked for that performance but have booked 10 or more tickets in the past.

    Nicola

  • $organization in reply to Nicola Blackburn

    That's odd - I use the operator "in" all of the time in conjunction with the "Ticket Production Name". 

    What about trying it this way:

    Ticket Perf Code in {the specific performance]

    Ticket Number of Seats >= 10

  • $organization

    Chuck – I wonder if your Ticket Perf code is a custom list manager element for your organization because that is not an option I have.

     

    Nicola,

     

    Try adding the Ticket Season to your list pull with the performance name and number of seats.  That will give you and extra bit of data to filter on as you pull the list.  I tried it with this seasons Nutcracker and got the desired results. 

     

    Elizabeth Carlock

    Director of Ticketing Services

    The Granada Theatre 

     

    From: Tessitura Group Sales Forum [mailto:forums-groupsales@tessituranetwork.com] On Behalf Of Charles Buchanan
    Sent: Friday, May 11, 2012 9:43 AM
    To: Elizabeth Carlock
    Subject: Re: [Tessitura Group Sales Forum] Groups report

     

    That's odd - I use the operator "in" all of the time in conjunction with the "Ticket Production Name". 

    What about trying it this way:

    Ticket Perf Code in {the specific performance]

    Ticket Number of Seats >= 10

    From: Nicola Cawkwell <bounce-nicolacawkwell6694@tessituranetwork.com>
    Sent: 5/11/2012 11:33:11 AM

    Thanks Chuck, when I run this it won't let me use 'In' for the Production Name or Performance Name it will only let me use = but when I do that it pulls off a mixed selection of peole including some who have not booked for that performance but have booked 10 or more tickets in the past.

    Nicola




    You have been sent this message because you subscribed to the Tessitura Group Sales forum. You may manage your subscriptions on the website in the forums under "Forum Email Subscriptions".

  • $organization in reply to Elizabeth Carlock (Past Member)

    Hi Elizabeth

    We seem to have got a bit closer but are still not getting the data we are looking for - I am getting the people who have booked for that particular performance and who have booked 10 tickets or more however they have not necessarily booked 10 tickets for that performance just a performance at some point in the past. 

    We specifically need people who have booked for a particular show and for that show have booked 10 or more tickets so I think we are either missing a crucial piece of information from the list or we need to do it a different way.

    Thanks for your help with this!

    Nicola

  • $organization

    Thanks to Tony at Tessitura UK this has been resolved. We needed 'Tickets - Seats by Price Type' adding as a criteria so that we could extract people booking for 10 or more seats for a particular show.

    Thanks Tony!

    Nicola