Calculating days since last visit | Community
Skip to main content
Dan_N
Dan_N
April 22, 2024
Question

Calculating days since last visit

  • April 22, 2024
  • 2 replies
  • 1248 views

Good day everyone.  I wonder if anyone has a formula for calculating "Days since last visit" out of clickstream data?  I did not see a calculation of this sort in either the documentation or the community.  Thank you.

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

2 replies

pradnya_balvir
Community Advisor
pradnya_balvirCommunity Advisor
Community Advisor
April 22, 2024

This is not metrics. This is dimension. The number of days between a visitor's current visit and their most recent visit. This can help you understand visitor behavior after visiting the site.

 

 

    RobertBlakeley
    Community Advisor
    RobertBlakeleyCommunity Advisor
    Community Advisor
    April 23, 2024

    Here is the link to the doucmentation: https://experienceleague.adobe.com/en/docs/analytics/components/dimensions/days-since-last-visit

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    April 22, 2024

    In clickstream data you should have the field last_hit_time_gmt, this is the timestamp of the prior hit... 

     

    So on the first hit in a session (visit_page_num), you should be able to take this, and the timestamp of that hit to calculate the number of Days since the last visit.

    Terms & ConditionsAccessibility statement

    Loading footer...