• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 72 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

 

 

 

 

Parents
  • $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!

Reply
  • $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!

Children
No Data