• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 172 views
  • Users 0 members are here
Related

Number of Visits During Membership

Jennifer O'Neill-Englund
$organization

Hello All,

I think I've asked this in other forums in previous years, but not here. We're trying to figure out a way to use Analytics to see how many members have visited 1 time during their membership, or 2-4 times, or 0 times, you get the picture. For our organization "Number of Unique Perfs" doesn't work for this purpose since a visitor can have as many as three perfs in one visit. One for our exhibits, one for our theater, and one for our special exhibits. We're really looking for how many times did they come through the door during their membership.

We had something built for us to use in T-Stats, but I just can't quite get to this in Tessitura.

Thanks for any insights!

Jenny

Parents
  • $organization

    Hello Jennifer,

    I was thinking you could use a concept that Chris Wallingford posted in "[TAMATO Discussion] Bucketing Order Hour and Attended Hour." If basically does an Excel equivalent of a SUMIF function.
    Here is a quote from that Post:
    Some flavor of the following may work for you... grouping by SLI ID (so a per-ticket evaluation), if the attended hour = order hour, then add 1 to the SUM, else 0 or NULL
    .
    SUM( [SLI ID] ,
    IF ( MAX( [Attended Hour] - [Order Hour] ) = 0
    , 1 , NULL ) )
    ------
    The concept looks like:

    SUM ( [Group by Field] , IF ( <Aggregation> = 0, 1, NULL) )
    It will Sum all of the 1's that meet the criteria of the first part of the IF statement. This is the "Count" of how many meet the criteria.
    In your case, to get the number of constituents with zero visits could be:
    SUM( [Constituent ID] ,
    IF (COUNT([Days in Date]) = 0
    , 1 , NULL ) )
    Where the "Days in Date" part is the Performance Date.
    If this is not exactly what you need, it hopefully will give you a jump start.
    Neil
Reply
  • $organization

    Hello Jennifer,

    I was thinking you could use a concept that Chris Wallingford posted in "[TAMATO Discussion] Bucketing Order Hour and Attended Hour." If basically does an Excel equivalent of a SUMIF function.
    Here is a quote from that Post:
    Some flavor of the following may work for you... grouping by SLI ID (so a per-ticket evaluation), if the attended hour = order hour, then add 1 to the SUM, else 0 or NULL
    .
    SUM( [SLI ID] ,
    IF ( MAX( [Attended Hour] - [Order Hour] ) = 0
    , 1 , NULL ) )
    ------
    The concept looks like:

    SUM ( [Group by Field] , IF ( <Aggregation> = 0, 1, NULL) )
    It will Sum all of the 1's that meet the criteria of the first part of the IF statement. This is the "Count" of how many meet the criteria.
    In your case, to get the number of constituents with zero visits could be:
    SUM( [Constituent ID] ,
    IF (COUNT([Days in Date]) = 0
    , 1 , NULL ) )
    Where the "Days in Date" part is the Performance Date.
    If this is not exactly what you need, it hopefully will give you a jump start.
    Neil
Children
No Data