Calculating days since last visit

3 replies
1237 views
Translate

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.

Analytics

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

Jennifer_Dungan

Level 2

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

pradnya_balvir

New Participant

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.