Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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.