Skip to main content
Dan_N
Dan_N
Apr 22, 2024 2:20 PM UTC
Question

Calculating days since last visit

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.

3 replies

pradnya_balvir
Adobe Champion and Community Advisor
pradnya_balvirAdobe Champion and Community Advisor
Adobe Champion and Community Advisor
Apr 22, 2024 2:56 PM UTC

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.

 

 

Translate
    RobertBlakeley
    Community Advisor
    RobertBlakeleyCommunity Advisor
    Community Advisor
    Apr 23, 2024 2:43 PM UTC

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

    Translate
    Jennifer_Dungan
    Adobe Champion and Community Advisor
    Jennifer_DunganAdobe Champion and Community Advisor
    Adobe Champion and Community Advisor
    Apr 22, 2024 4:51 PM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...