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