Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to calculate avg. consumer return period for a year

Hyeran
Level 2
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  

 

 

2 Replies
fsakjlfdsakljfd
Level 5
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".

pabloc82923542
Level 9
Level 9

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.