Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.

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 6

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.