• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 70 views
  • Users 0 members are here
Related

Ticket Sales by Zip Code

Michelle Wiesel
$organization

Hi everyone:

I'm very new to Tessitura having just finished implementation and I'm being asked to pull a list of all tickets buyers for the season, with number of tickets purchased, with the show listed and their zip codes.  I understand T-Stats works for this which will come later for us.

I've created a number of different list criteria and am struggling with getting the criteria correct. I end up with too much information and not of the right kind or not enough.

I'm wondering if there's anyone out there who might be willing to point me to an existing report (I'm not seeing one) or share their criteria / method outside of TStats for accomplishing this?  In the meantime I'll keep plugging away!!!

Thanks much!

Michelle Wiesel

Ticket Services Manager

Wallis Annenberg Center for the Performing Arts

 

 

 

 

  • $organization

    Unknown said:

    [...] I'm being asked to pull a list of all tickets buyers for the season, with number of tickets purchased, with the show listed and their zip codes.[...]

    I'm not sure there's a good way to do this outside of a custom report. Happy to share mine. Please e-mail offline if interested.

  • $organization

    If this is a one time thing.

     

    You might try the standard “Order export utility” to filter and get the raw data.  And then import this into MS Excel.  If you need to do some reporting from there you could create a pivot table to do bit of summarizing of the data.

     

    --Tom Brown

    tbrown@bam.org

     

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Wednesday, December 18, 2013 10:28 AM
    To: Thomas Brown
    Subject: Re: [Tessitura Ticketing Forum] Ticket Sales by Zip Code

     

    Michelle Wiesel:

    [...] I'm being asked to pull a list of all tickets buyers for the season, with number of tickets purchased, with the show listed and their zip codes.[...]

    I'm not sure there's a good way to do this outside of a custom report. Happy to share mine. Please e-mail offline if interested.

    From: Michelle Wiesel <bounce-michellewiesel7133@tessituranetwork.com>
    Sent: 12/18/2013 8:38:37 AM

    Hi everyone:

    I'm very new to Tessitura having just finished implementation and I'm being asked to pull a list of all tickets buyers for the season, with number of tickets purchased, with the show listed and their zip codes.  I understand T-Stats works for this which will come later for us.

    I've created a number of different list criteria and am struggling with getting the criteria correct. I end up with too much information and not of the right kind or not enough.

    I'm wondering if there's anyone out there who might be willing to point me to an existing report (I'm not seeing one) or share their criteria / method outside of TStats for accomplishing this?  In the meantime I'll keep plugging away!!!

    Thanks much!

    Michelle Wiesel

    Ticket Services Manager

    Wallis Annenberg Center for the Performing Arts

     

     

     

     




    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!

  • $organization

    Once you have T-Stats I'm not sure that is the answer to this particular query.  T-Stats will provide you raw numbers i.e. X number of constituents bought X tickets to X list of performances not a listing of customer names and their zip codes.  It sounds like you want a listing of customer names and their purchases which would be accomplished through a combo of lists or custom reporting with the right output set. 

    Just as an FYI you can get a break-down of number of constituents within each zip code for a given performance or group of performances but this again isn't as granular as what you are looking for.

    T-Stats does allow you to save any report to List Manager which would give you the list of names but you would still need the right output set to add on the purchasing data you want in the output.