Mining ticketing data

Michael

Yes you could create Output Set Elements to do the job (and some with parameters if you want to limit by season etc). Hopefully you have the basic ticketing information you are after in your Ticket History screen.

Here’s a link to the Output Set training material on the Tessitura Network website. There are 3 T-Casts and a Cookbook. The first T-Cast is about how to use Output Set Builder and parts 2 and 3 go into making custom Elements and Parameters. The Cookbook gives the code for a variety of Elements and Parameters and any custom views that might be required.

http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx

Plus if you are going to the Conference this year you can attend this session

http://www.tessituranetwork.com/network/Conference/Conference%20Schedule/3%20L%20Output%20Set%20Builder%20P1.aspx

Cheers

Sandra

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

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?

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!

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!

Michael

Yes you could create Output Set Elements to do the job (and some with parameters if you want to limit by season etc). Hopefully you have the basic ticketing information you are after in your Ticket History screen.

Here’s a link to the Output Set training material on the Tessitura Network website. There are 3 T-Casts and a Cookbook. The first T-Cast is about how to use Output Set Builder and parts 2 and 3 go into making custom Elements and Parameters. The Cookbook gives the code for a variety of Elements and Parameters and any custom views that might be required.

http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx

Plus if you are going to the Conference this year you can attend this session

http://www.tessituranetwork.com/network/Conference/Conference%20Schedule/3%20L%20Output%20Set%20Builder%20P1.aspx

Cheers

Sandra

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

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?

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!

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!