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.
Views
Replies
Total Likes
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.
Here is the link to the doucmentation: https://experienceleague.adobe.com/en/docs/analytics/components/dimensions/days-since-last-visit
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies