• Replies 1 reply
  • Subscribers 414 subscribers
  • Views 61 views
  • Users 0 members are here
Related

Visitor Count versus ticket count

Samantha Wilson
$organization

Hi everyone! 

I have a question regarding the best route to tracking attendance in a museum environment. We have a few different offerings each day so we have found that we cannot use the ticket sales, or the NSCAN attendance reports for accurate reporting on attendance (bodies) in the museum for the day. We have found with these reports that some guests are counted twice if they are attending multiple things and have tickets scanned. I am looking for an overall attendance (bodies in the museum) for a day that does not double count anyone who has attended multiple events. 

I am assuming the best way to do this is in List Manager. Does anyone have something like this that they are already tracking and wouldn't mind sharing? Your criteria or analytics info would be super helpful! 

Thanks! 

Samantha Wilson
Senior Database Manager 
The Neon Museum 
Las Vegas, NV

Parents
  • $organization

    Hi Samantha,

    You could try a formula in Analytics that counts the ticket count for each constituent's maximum performance ticket count. If a constituent holds tickets to 5 different events on the same day, and they hold 3 tickets to most of those events, but only 2 tickets to a couple of them, then you'd want to count that constituent as 3 bodies.

    With the event date (performance date) on rows, a pivot might have a formula like:

    SUM ( [Constituent ID] ,
      MAX ( [Performance ID] ,
        [Total Ticket Count]
      )
    ) 

    Sum total across each constituent hold tickets on the date of a given row of the pivot table, sum the ticket count from only the event with the greatest number of tickets. 

    If you needed to do this on a higher grain than in a pivot with the event date on rows, then we'd need another level in the formula so that if a constituent attended on multiple dates, we'd still count those as separate body counts.

    SUM ( [Days in Performance Date] ,
  SUM ( [Constituent ID] ,
        MAX ( [Performance ID] ,
          [Total Ticket Count]
        )
      )
    )

    Sum total across each event date of each constituent's maximum ticket count from among their ticketed events on that date.

Reply
  • $organization

    Hi Samantha,

    You could try a formula in Analytics that counts the ticket count for each constituent's maximum performance ticket count. If a constituent holds tickets to 5 different events on the same day, and they hold 3 tickets to most of those events, but only 2 tickets to a couple of them, then you'd want to count that constituent as 3 bodies.

    With the event date (performance date) on rows, a pivot might have a formula like:

    SUM ( [Constituent ID] ,
      MAX ( [Performance ID] ,
        [Total Ticket Count]
      )
    ) 

    Sum total across each constituent hold tickets on the date of a given row of the pivot table, sum the ticket count from only the event with the greatest number of tickets. 

    If you needed to do this on a higher grain than in a pivot with the event date on rows, then we'd need another level in the formula so that if a constituent attended on multiple dates, we'd still count those as separate body counts.

    SUM ( [Days in Performance Date] ,
  SUM ( [Constituent ID] ,
        MAX ( [Performance ID] ,
          [Total Ticket Count]
        )
      )
    )

    Sum total across each event date of each constituent's maximum ticket count from among their ticketed events on that date.

Children
No Data