How to create a calculated metric to find "average time between customer revisits" | Community
Skip to main content
Level 2
June 23, 2023
Solved

How to create a calculated metric to find "average time between customer revisits"

  • June 23, 2023
  • 1 reply
  • 803 views

How to create a calculated metric to find "average time between customer revisits"

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 Jennifer_Dungan

I don't believe this is possible in Adobe alone... if you were to do raw data extracts, you could get the last timestamp recorded for each visit of each visitor and compare to the timestamp of the next visit for said visitor... calculate each timespan, then average it... but that is too complex for the calculated metric builder....

 

The closest you can get out of the box is "Days since last visit" (if the visitor came back with the same day, it will be "0 Days", if they come back the next day it will be "1 Days", etc...) It's not so much "time between visits", but it's at least a simple gauge of the returns...

 

Or you can use Return Frequency, which buckets users into groups:

  • Less than 1 day
  • 1 to 3 days
  • 3 to 7 days
  • 7 to 14 days
  • 14 days to 1 month
  • longer than 1 month

 

Just remember that the same user will show under multiple "Days since last visit" or "Return Frequency" for each different span they had between multiple visits.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
June 23, 2023

I don't believe this is possible in Adobe alone... if you were to do raw data extracts, you could get the last timestamp recorded for each visit of each visitor and compare to the timestamp of the next visit for said visitor... calculate each timespan, then average it... but that is too complex for the calculated metric builder....

 

The closest you can get out of the box is "Days since last visit" (if the visitor came back with the same day, it will be "0 Days", if they come back the next day it will be "1 Days", etc...) It's not so much "time between visits", but it's at least a simple gauge of the returns...

 

Or you can use Return Frequency, which buckets users into groups:

  • Less than 1 day
  • 1 to 3 days
  • 3 to 7 days
  • 7 to 14 days
  • 14 days to 1 month
  • longer than 1 month

 

Just remember that the same user will show under multiple "Days since last visit" or "Return Frequency" for each different span they had between multiple visits.