Average time between visits

Hi Chris,

Great, thank you so much! I now have calculated this, but when doing so I realized that I also need to know the distribution of our customers in terms of how often they visit us, i. e. how large share visit us every year, every second year, every third year etc. Again I need help. Do you, or anyone else, know how I should go about getting this result?

Best,

Sofia

Hi Chris,

Great, thank you so much! I now have calculated this, but when doing so I realized that I also need to know the distribution of our customers in terms of how often they visit us, i. e. how large share visit us every year, every second year, every third year etc. Again I need help. Do you, or anyone else, know how I should go about getting this result?

Best,

Sofia

Hi Sofia,

Is that switching from calculating days between to years between visits to get an average?

SUM ( [Constituent ID] ,
  MAX( [Performance Date Calendar Year] ) - MIN( [Performance Date Calendar Year] )
) 
/ SUM ( [Constituent ID] , [# of unique Years in Performance Date] - 1 )

Or do you need to bucket / segment by counts of visitors that come with each frequency? If so, create a value called Every Year that takes the total distinct count of years in which constituents visited, and divides that by the count of years between their first and last visit. Only counting for constituents that attended in more than one year. This could be adjusted down if you want someone who attended 9 years in the last 10 to count as every year.

SUM ( [Constituent ID] ,
  IF ( ( [# of unique Performance Date Calendar Years] - 1 )
       / ( MAX( [Performance Date Calendar Year] ) - MIN( [Performance Date Calendar Year] ) )
       >= 1.0
  , 1
  , NULL
  )
)

While Every Second Year might be constituents who attended in a count of years that is between 50%-99.9% of all years between their first and last year. If you adjust the Every Year value down to less than 1.0, then adjust this percentages in this one to align with your preferences as well.

SUM ( [Constituent ID] ,
  IF ( ( [# of unique Performance Date Calendar Years] - 1 )
       / ( MAX( [Performance Date Calendar Year] ) - MIN( [Performance Date Calendar Year] ) )
       < 1.0
       AND 
       ( [# of unique Performance Date Calendar Years] - 1 )
       / ( MAX( [Performance Date Calendar Year] ) - MIN( [Performance Date Calendar Year] ) )
       >= 0.5 
 , 1
 , NULL
 )
)

For the Every Third Year value, you might do < 0.5 AND >= 0.333, etc.

Best,
Chris

Hi again Chris,

(For some reason I can only reply to my message, not to yours.)

This was very helpful, thank you. I need to bucket the visitors so the  Every year, Every second year formulas is exactly what I'm after. I've tried to set it up in analytics. However, I have difficulty with the Performance date calendar year - could you tell me exactly which one to use?

The only one that I have gotten to work is Calender Year To Date Flag (but I actually don't know what that is so it might be completely wrong...). 

Thanks for all your help!

Sofia

Hi Sofia,

I'm trying, poorly , to reference the [Calendar Year] field under that [PERFORMANCE DATE] dimension in your screenshot.

And the [# of unique Years in Performance Date] is meant (also easier with a screenshot) to direct you to this value:

I have that same problem with "reply" sometimes, which I'll raise with our website team, but as a work around, clicking on the date of the post in its header will refresh the page and often fix it to present the "reply" link.

Thanks Chris for clarifying that (and for the tip of clicking on the date to get the "reply" link to appear - worked great). I'm doing something wrong though because I'm still not getting a value. This is how my formula looks:

When choosing Calendar year I select # All Items - perhaps that's where I go wrong? 

Sorry for taking up so much of your time. I get the logic of the formula, but I'm not fluent in Analytics yet 

Thanks,

Sofia

Not a problem at all Sofia, and my apologies, as I had a typo in my formula above. I'm going to correct it up there too, but we need more parentheses around the numerator and denominator content...

SUM ( [Constituent ID] ,
 IF ( ( [# of unique Years in Date] - 1 )
 / ( MAX( [Calendar Year] ) - MIN( [Calendar Year]) )
 >= 1.0
 , 1
 , NULL
 )
)

As it is now, I led you to take the number of unique years, minus (1/max calendar year), minus min calendar year. I'm attaching a sample as well.

EveryNthYear.dash

That did the job! Thank you so much Chris - this will give us important insights. 

Best,

Sofia