Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (1)

Answers (1)

asheeshp
MVP
31-12-2019

Total seconds spent metric is available only in Analysis Workspace, Reports & Analytics, Report Builder (called ‘total time spent’), Data Warehouse, Ad Hoc Analysis.

 

In data feed you can do following to get time spent:

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

  1. Concatenate post_visid_high , post_visid_low , visit_num , and visit_start_time_gmt .
  2. Sort by this concatenated value, then apply a secondary sort by visit_page_num .
  3. Subtract the last hit post_cust_hit_time value in a visit from the visit_start_time_gmt value calculated in first step.
  4. This number is the amount of total time spent (in seconds) for the visit.