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
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 TheatreFrom: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com>Sent: 9/30/2016 10:15:32 AMHappy 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 BILLMANNDirector of Marketing & Communicationsp 734-763-0611 e sarabill@umich.edu www.ums.org / 2014 National Medal of Arts
From: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com>Sent: 9/30/2016 10:15:32 AM
SARA BILLMANNDirector of Marketing & Communicationsp 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:
From: Nicole Wetzell <bounce-nicolewetzell3052@tessituranetwork.com> Sent: 9/30/2016 10:15:32 AM
-- 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 p 734-763-0611 e sarabill@umich.edu www.ums.org / 2014 National Medal of Arts
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