T-Stats Recipe

Happy Friday - Could anyone provide a T-Stats recipe that pulls the number of people who were in your venue for the first time for a particular show? Thanks!

  • Hi Nicole.

    As my brain thought about this, I think you may have to create a list in Tessitura first and then use that as a filter in T-STATS. You could create a list of patrons who only have that one performance run on their account. From there as you set up a tickets or seats cube, you could use that list as a filter and see how many tickets were sold and how much revenue you gained from them.

    Sadly, I can't think of way to make a criteria (without some custom work) to be able to do all this right in T-STATS.

    Best,

    Christopher Cuhel, The 5th Avenue Theatre

  • Conversely, you could create a dynamic list in Tessitura with "Unique Performances = 1" and then load that list into t-stats as a filter and be able to automatically look at each performance and how many new buyers/tickets/revenue you gained from that event.

    You might need to narrow that list by season to stay within the filtering threshhold on T-Stats (our threshhold is now 25,000 but it started at 10,000, which was too limiting). You'd have to define what "first time" means -- is it first time ever? First time in five years? Three years?  But that would be another way to get at that info and not have to create a new list for each performance/production.

    Hope that helps.
    Sara Billmann, UMS

    On Fri, Sep 30, 2016 at 12:42 PM, Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> wrote:

    Hi Nicole.

    As my brain thought about this, I think you may have to create a list in Tessitura first and then use that as a filter in T-STATS. You could create a list of patrons who only have that one performance run on their account. From there as you set up a tickets or seats cube, you could use that list as a filter and see how many tickets were sold and how much revenue you gained from them.

    Sadly, I can't think of way to make a criteria (without some custom work) to be able to do all this right in T-STATS.

    Best,

    Christopher Cuhel, The 5th Avenue Theatre

    From: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com>
    Sent: 9/30/2016 10:15:32 AM

    Happy Friday - Could anyone provide a T-Stats recipe that pulls the number of people who were in your venue for the first time for a particular show? Thanks!



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/16827/50744.aspx#50744 or reply to this message

    SARA BILLMANN
    Director of Marketing & Communications
    734-763-0611   e  sarabill@umich.edu

    www.ums.org 
    / 2014 National Medal of Arts

         

  • Hi Sara,

     

    What did you do to increase your T-Stats threshold? I find 10,000 to be way too limiting as well. We’re on RAMP.

     

    Jason Paddock
    Director of Event Marketing
    State Theatre New Jersey

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Sara Billmann
    Sent: Friday, September 30, 2016 1:20 PM
    To: Jason Paddock
    Subject: Re: [Tessitura Marketing Forum] T-Stats Recipe

     

    Conversely, you could create a dynamic list in Tessitura with "Unique Performances = 1" and then load that list into t-stats as a filter and be able to automatically look at each performance and how many new buyers/tickets/revenue you gained from that event.

    You might need to narrow that list by season to stay within the filtering threshhold on T-Stats (our threshhold is now 25,000 but it started at 10,000, which was too limiting). You'd have to define what "first time" means -- is it first time ever? First time in five years? Three years?  But that would be another way to get at that info and not have to create a new list for each performance/production.

    Hope that helps.

    Sara Billmann, UMS

     

    On Fri, Sep 30, 2016 at 12:42 PM, Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> wrote:

    Hi Nicole.

    As my brain thought about this, I think you may have to create a list in Tessitura first and then use that as a filter in T-STATS. You could create a list of patrons who only have that one performance run on their account. From there as you set up a tickets or seats cube, you could use that list as a filter and see how many tickets were sold and how much revenue you gained from them.

    Sadly, I can't think of way to make a criteria (without some custom work) to be able to do all this right in T-STATS.

    Best,

    Christopher Cuhel, The 5th Avenue Theatre

    From: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com>
    Sent: 9/30/2016 10:15:32 AM

    Happy Friday - Could anyone provide a T-Stats recipe that pulls the number of people who were in your venue for the first time for a particular show? Thanks!



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/16827/50744.aspx#50744 or reply to this message

    SARA BILLMANN
    Director of Marketing & Communications
    734-763-0611   e  sarabill@umich.edu

    www.ums.org / 2014 National Medal of Arts

          Image removed by sender.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!

  • Hi Nicole,

    I think Christopher's idea is the way to go if you want to identify people whose first visit was to a particular show (rather than them only having been to that show).  When I was Opera Australia, I wrote a view that returned the details of the first show a constituent had been to (from ticket history) and then created a few List Manager/Extraction criteria based on that view.

    Happy to share........

    Martin