• Replies 8 replies
  • Subscribers 414 subscribers
  • Views 26 views
  • Users 0 members are here
Related

Mining ticketing data

Michael McNair
$organization

I have found it frustrating to mine constituent ticket data in Tessitura. I just want to generate an excel spreadsheet with constituent general info (name, address, email) and ticket info: event, date of purchase, mos, channel, number of seats, $ paid.

Does anybody have any tips?

Parents
  • $organization

    Not for everyone, just on a per performance or production basis.

     

    Michael McNair

    Box Office Manager

    Vancouver Playhouse Theatre Company

    301-601 Cambie St.

    Vancouver, BC   V6B 2P1

    mmcnair@vancouverplayhouse.com

     

    TICKETS: 604 873 3311 | vancouverplayhouse.com

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: June 9, 2011 5:13 PM
    To: Michael McNair
    Subject: RE: [Tessitura Ticketing Forum] Mining ticketing data

     

    So you want all ticketing history per patron?
    I see you guys are in your 49th season so that's going to be a lot of info.

    From: Michael McNair <bounce-michaelmcnair5669@tessituranetwork.com>
    Sent: 6/9/2011 6:48:39 PM

    Thanks Ryan, I will have a look at the output sets.

     

    I just basically want to generate an excel document with constituent info (name, address, email) and ticket info (event name, ev date, transaction date, mos, sales channel, num of tickets, total paid).

     

    Michael McNair

    Box Office Manager

    Vancouver Playhouse Theatre Company

    301-601 Cambie St.

    Vancouver, BC   V6B 2P1

    mmcnair@vancouverplayhouse.com

     

    TICKETS: 604 873 3311 | vancouverplayhouse.com

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: June 9, 2011 4:27 PM
    To: Michael McNair
    Subject: RE: [Tessitura Ticketing Forum] Mining ticketing data

     

    Also, here are some resources you might find helpful.

    Output Set Documentation
    T-Cast
    Output Set Cookbook

    From: Ryan Rowell <bounce-ryanrowell5634@tessituranetwork.com>
    Sent: 6/9/2011 6:13:40 PM

    Hi Michael,

    What would be the parameters for the ticket information you need?
    Meaning, do you need it by date, by production, by season, etc. etc.
    I've got a couple custom ones for ticketing information set up, so depending on what you are looking for I might be able to give you the entries that you, or your IT person would need to get you going.




    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!




    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!

Reply
  • $organization

    Not for everyone, just on a per performance or production basis.

     

    Michael McNair

    Box Office Manager

    Vancouver Playhouse Theatre Company

    301-601 Cambie St.

    Vancouver, BC   V6B 2P1

    mmcnair@vancouverplayhouse.com

     

    TICKETS: 604 873 3311 | vancouverplayhouse.com

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: June 9, 2011 5:13 PM
    To: Michael McNair
    Subject: RE: [Tessitura Ticketing Forum] Mining ticketing data

     

    So you want all ticketing history per patron?
    I see you guys are in your 49th season so that's going to be a lot of info.

    From: Michael McNair <bounce-michaelmcnair5669@tessituranetwork.com>
    Sent: 6/9/2011 6:48:39 PM

    Thanks Ryan, I will have a look at the output sets.

     

    I just basically want to generate an excel document with constituent info (name, address, email) and ticket info (event name, ev date, transaction date, mos, sales channel, num of tickets, total paid).

     

    Michael McNair

    Box Office Manager

    Vancouver Playhouse Theatre Company

    301-601 Cambie St.

    Vancouver, BC   V6B 2P1

    mmcnair@vancouverplayhouse.com

     

    TICKETS: 604 873 3311 | vancouverplayhouse.com

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: June 9, 2011 4:27 PM
    To: Michael McNair
    Subject: RE: [Tessitura Ticketing Forum] Mining ticketing data

     

    Also, here are some resources you might find helpful.

    Output Set Documentation
    T-Cast
    Output Set Cookbook

    From: Ryan Rowell <bounce-ryanrowell5634@tessituranetwork.com>
    Sent: 6/9/2011 6:13:40 PM

    Hi Michael,

    What would be the parameters for the ticket information you need?
    Meaning, do you need it by date, by production, by season, etc. etc.
    I've got a couple custom ones for ticketing information set up, so depending on what you are looking for I might be able to give you the entries that you, or your IT person would need to get you going.




    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!




    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!

Children
No Data