Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!

Calculating days since last visit

Avatar

Level 1

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.

3 Replies

Avatar

Level 4

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.

 

prads_0-1713797818648.png

 

Avatar

Community Advisor

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.