• Replies 7 replies
  • Subscribers 958 subscribers
  • Views 206 views
  • Users 0 members are here
Related

Counting unique individuals for which tickets are purchased at a multi-venue General Admission destination

Bob Oliver
$organization

Hello:

We are a multi venue general admission destination as the questions hints. I'm trying to find a way in analytics to determine (approximately) the number of unique ticketed individuals an order or collection of orders represent. For example,an individual order could include:

  • 3 tickets for the castle
  • 2 for the tower
  • 2 for one of the galleries.

Whilst this could represent tickets for anything from 3 to 7 separate individuals, a reasonably safe assumption is that it is 3 individuals, but one of them has decided not to go tower and has no interest in art. I'm struggling to find a way in analytics to aggregate ticket counts per line to return just the maximum number of tickets on any 1 line in the order (which then I could sum per month, etc) so that I can then use my assumption. As anyone with the same issue solved this?

We do offer packages that are easier to work out, but many tickets sales are still individual tickets. We also don't yet have NSCAN - so stuck trying to solve it as above.

Thanks,

Bob.

  • $organization

    Hi Bob,

    Does using the Constituent ID and selecting Count Unique work for you.  That'll be one value per Order though if you have individual recipients attached to Sub Line Items you could Try the same with Recipient Constituent ID & Count Unique

    Cheers,

    H

  • $organization
    Thanks Heath.
     
    Unfortunately we only collect the purchaser details on the order, so just the one constituent. The only way I think we can manage this is to either find away of finding the highest ticket count of any line on an order and then being able to aggregate that by whatever facts we need.
     
    May take a look at the widget script editor and see what that may allow…
     
     
    Bob.
     
  • $organization
    Hello,
     
    Actually think I’ve got it. Didn’t realise MAX had two modes of operation, including one whereby you can pass in a group by criteria.
     
    So
     
    max([Performance Date and Code],sum([Ticket Count])) seems to work as below, first showing the group by and then without. Will need to test behaviour in additional aggregations. Coming back the next day and looking again often seems the best way with Analytics.
     
     
    This I hope the business will agree is a fair approximation of total individuals buying tickets.
     
    Thanks all!
     
    Bob.
  • $organization

    Hi Bob,

    You have the right idea with that GROUP BY approach. It's especially good if you're using Order ID in your pivot table Categories. You can also group within Performance Date if there are many performances and you don't want to see that detail. More generally, when not grouping by Order ID you can SUM ( [Order ID] , MAX ( [Ticket Count] ) ) so that you are getting the max ticket count within each order rather than within each performance.

    Best,
    Chris

    Chris Wallingford
    Director, Business Intelligence
    Tessitura Network
    office: +1 888.643.5778 x553
    chris.wallingford@tessituranetwork.com
  • $organization
    Thanks Chris.
     
    The way I had worked fine in a pivot whereby was showing each order on a line, but if you then applied a further aggregation (say grand total, or just used formula in an indicator) it would return the single highest ticket count, not a sum of what was shown in pivot. Make sense I think if I now understand it properly.
     
    Think your suggestion should allow be to sum the set of maxes. Will try.
     
    Thanks again.
     
    Bob.
     
  • $organization
    Hello.
     
    Still had issue with that, but applying the same logic, came up with sum([Order ID],max([Performance Date and Code],sum([Ticket  Count]))), which allows me to aggregate the highest number of tickets per performance (used as effective per order line), per order. All checks out with excel pivots of the raw the data in Tessitura, so think that works and gives me a reasonably accurate estimate of visitors represented across a group of orders. Not sure if there a more efficient route however… Will test further…
     
     
    Thanks for all your help – please do shout out if I’m being an idiot however.
     
     
    Bob.
     
  • $organization in reply to Bob Oliver

    Bob!
    You win my Internet today. And actually... helped me out on this post.

    Thanks,
    Chris