Mining ticketing data

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
  • Hi,

    Thanks Amanda, I’ve tried most of the reports including Single Sale Order Listing, they usually give me separate parts of what I need, not the whole.

     

    Haven’t tried output sets, where can I find info on that?

     

    Much appreciated.

     

    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 Amanda Freeman
    Sent: June 9, 2011 3:42 PM
    To: Michael McNair
    Subject: Re: [Tessitura Ticketing Forum] Mining ticketing data

     

    For that specific info, it seems like running the Single Sale Order Listing report and saving it to excel might give you what you're looking for. In a more general sense, have you tried output sets?

    From: Michael McNair <bounce-michaelmcnair5669@tessituranetwork.com>
    Sent: 6/9/2011 5:10:26 PM

    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?




    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
  • Hi,

    Thanks Amanda, I’ve tried most of the reports including Single Sale Order Listing, they usually give me separate parts of what I need, not the whole.

     

    Haven’t tried output sets, where can I find info on that?

     

    Much appreciated.

     

    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 Amanda Freeman
    Sent: June 9, 2011 3:42 PM
    To: Michael McNair
    Subject: Re: [Tessitura Ticketing Forum] Mining ticketing data

     

    For that specific info, it seems like running the Single Sale Order Listing report and saving it to excel might give you what you're looking for. In a more general sense, have you tried output sets?

    From: Michael McNair <bounce-michaelmcnair5669@tessituranetwork.com>
    Sent: 6/9/2011 5:10:26 PM

    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?




    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