How can I calculate the Time Spent Per Visit and the Time Spent Per Visitor | Community
Skip to main content
Level 2
December 22, 2021
Question

How can I calculate the Time Spent Per Visit and the Time Spent Per Visitor

  • December 22, 2021
  • 1 reply
  • 945 views

Hi everyone!

I am using the Data Feed and I can´t calculate the "Time Spent Per Visit" and "Time Spent Per Visitor" metrics.

 

I've tried to use the follow tips but I can't obtain the values:

 

Time spent
Hits must first be grouped by visit, then ordered according to the hit number within the visit.

Concatenate post_visid_high, post_visid_low, visit_num, and visit_start_time_gmt.
Sort by this concatenated value, then apply a secondary sort by visit_page_num.
If a hit is not the last one in a visit, subtract the post_cust_hit_time value from the subsequent hit’s post_cust_hit_time value.
This number is the amount of time spent (in seconds) for the hit. Filters can be applied to focus on dimension items or events.

 

Does anynone have an example to calculate these metrics?

 

Thanks everybody!

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

1 reply

Benjienen
Community Advisor
Community Advisor
July 15, 2024

Hi @rodrigopan,

 

I believe this is an Adobe provided component, so no need to create calculated metric. Have you tried searching it on your workspace?