• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 170 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

  • $organization

    Could you use order date in a similar way? 

  • $organization in reply to Madeline Dummerth (Past Member)

    Yes absolutely, but I don't have to sql savvy to build something that would look for Number of Unique Order Dates. Our previous DBA did build a couple of List Builder criteria for Number of Visits During Current Membership and Number of Visits in Record History, I could try to mess with that to get a date range in there. I'd really like to have something in Analytics too.

  • $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
  • $organization in reply to Jennifer O'Neill-Englund

    I thought of another way. In Analytics, you can filter by Lists. You could use your existing List Builder criteria for Number of Visits During Current Membership to create a List. If you can, create a list for each way you want to show. For example, a list for 1 visit, another list for 2 vistis, etc.. Write down the list number for each one.

    After you have your lists, you have to wait for the Analytics data to refresh. Ours happens overnight, so we would have to wait to use the list on the next day.

    You would then create a widget in your dashboard for each List that counts the number of Constituent ID's in the list. Done!