Calculate total seconds spent using data feeds

[abhishekj484272]

How can I calculate Total Seconds Spent using Data Feeds?

[Asheesh_Pandey · Accepted solution]

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.