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 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

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