Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

How to calculate avg. consumer return period for a year

Avatar

Level 2

Hi there, somebody help me if you know how to do it

 

I would like to calculate average consumer return period for a year. 

 

As AA provides, there are retention frequency, but it was categorized by small periods, such as ~1 day, 1~3 days, so that it is hard to find the exact avg. of consumer return period T.T 

 

Thanks  

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Looking into processing rules.

 

They could be leveraged to look at days since last visit then create an avg.

 

Basing on Visits or UVs is up to you.

View solution in original post

2 Replies

Avatar

Level 5

There is another variable, 'Days Since Last Visit' that provides the granular days.

Regardless, to solve this you would likely need to use Data Feeds or Data Warehouse in lieu of Analysis Workspace or Report & Analytics.

The primary reason being that both 'return frequency' and 'days since last visit' will count unique visitors in multiple groups.  
This is explained within the help docs:

The date range in this report uses the time in which the visit occurred. For example, a visitor comes to your site in April, then comes back twice in the same day in October. Pulling a Return Frequency report for the month of October would show one visit under "longer than 1 month", and one visit under "less than 1 day".

Avatar

Correct answer by
Community Advisor

Looking into processing rules.

 

They could be leveraged to look at days since last visit then create an avg.

 

Basing on Visits or UVs is up to you.