Hi all,
I'm looking to find a way to get a count of the number of patrons who bought both an event we had in November and a similar style event that we are hosting in February. We are looking to see for example if the patrons that are buying the event in February already attended a similar style event we had in November. I very much want to do this in analytics, and not just export lists via list manager and do a compare in excel.
Yet as I'm just getting started in analytics, I'm not sure if my focus should be on attendance or on performance.
So 2 events:1115OS0221OS
Total count of tickets for both events and also a total count of patrons that have tickets to both events.
Thank you in advance. I just need a point in the right direction!
Michael Moore Although I suspect you could do what you are trying to do in Tessitura Analytics. I suspect that this would require some Tessitura Analytics formula magic. Some on this list or in the TOMATO group may have already worked this out and can share. This may be worked out in sort of the same way folks were working out Orders with Comps in them. However, this turned out to be some fairly advanced formula work.
That said. It strikes me that you are trying to find a group of constituents. Tessitura Lists are superbly set up to find lists of ticket buyers. Lists like Ticket History Has Performance 1 and Ticket History Does not Have Performance 2. Or other such combinations. I'm not clear what you are planning to do in MS Excel with the resulting information so that may be a reason to try something else. However, I invite you to consider if lists are a quick way to your answers. If you want some Tessitrua Analytics goodness. You can then set up your lists so that the results are available as a filter. In Tessitura List Properties use the "Analytics Check" and wait until the next day. Here are some notes from the documentation:
Analytics – Check to indicate that that the list is for use with Tessitura Analytics and/or T-Stats.
Note: When creating a new list, or changing the status of the Analytics box on an existing list, the list will not be available in Tessitura Analytics until the next time data is loaded into the cubes (which is generally scheduled nightly).
Then your lists are set up so that they are seen over Tessitura Analytics on a nightly basis so you can filter by these groups. And you can look at all sorts of wonderful results about those folks in Tessitura Analytics.
Just my $0.02.
I hope it helps.
If you just want the names and numbers a simple list with Criteria Ticket History performance 1115OS also has Ticket History performance 0221OS
would get you that and you can use that as a filter is you were looking at other things about the buying patterns in analytics.(oops beaten to it by Tom again)
P.S. I've re-read your note. Maybe to answer your question about analytics better.
I'd be looking in the Tickets & seat e-Cube for the kind of data that you seem to be asking about.
I'd start with a pivot table.
I'd filter to the two performances
I'd put in a count of constituent id, and maybe ticket count. That's the easy part.
Attached here is the .dash file which you can import into Tessitura Analytics.
LSCI-SeatsandTickets.dash
The total count of patrons that have tickets to both events is the harder part, wherein lists this is almost trivial to do the union of both sets, and some formula magic may be helpful. Others please feel free to Jump on into the conversation.
Thanks Tom and Heath Wilder for your help. I anticipate in the short future building out more trends like this will help us identify the frequency return of buyers for similar style events that are hosted and visually present the data. However, I realize we don't need to re-invent the wheel if we get some the data via list/extractions as well!