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.
- 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 .
- Subtract the last hit post_cust_hit_time value in a visit from the visit_start_time_gmt value calculated in first step.
- This number is the amount of total time spent (in seconds) for the visit.