Average Visits over Rolling Time Period | Community
Skip to main content
October 20, 2022
Solved

Average Visits over Rolling Time Period

  • October 20, 2022
  • 1 reply
  • 1155 views

Hi all,

 

Is it possible to measure average visits over a rolling four week time period? Ideally, the average will automatically update at the end of each week as the time period does. 

 

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by jlinhardt_blueAcorn

@tomopitz 

 

Hello.  Yes, I think you can but it may depend upon how you want to calculate an 'average'.  Meaning say you define the 'average' as total visits divided by 28 days.  Then yes, a calculated metric can be programmed to take total visits divided by 28.  You would then have to apply a 'segment' that only grabs data from the past 4 weeks, rolling weekly.  Adobe has a predefined Last 4 Full Weeks time segment, you just need to convert that into a regular Segment, because you can't use Time segments in calculated metrics, but you can use regular segments.

1 reply

jlinhardt_blueAcornAccepted solution
Level 3
October 20, 2022

@tomopitz 

 

Hello.  Yes, I think you can but it may depend upon how you want to calculate an 'average'.  Meaning say you define the 'average' as total visits divided by 28 days.  Then yes, a calculated metric can be programmed to take total visits divided by 28.  You would then have to apply a 'segment' that only grabs data from the past 4 weeks, rolling weekly.  Adobe has a predefined Last 4 Full Weeks time segment, you just need to convert that into a regular Segment, because you can't use Time segments in calculated metrics, but you can use regular segments.