I have started working with data feeds and I am not re-creating segments that we use for reporting, whilst I do not have any issues with visit and visitor level segments, I am somewhat struggling with hit based ones.
Below is an example where we exclude some hits based on the following criterias:
Any idea on how to get time spent per visit - granular and content time spent in data feeds?
Hypothesizing that 'content time spent' is a custom measure within your organization - but looking at the data feed metrics docs it walks through what is required for time calculations.
What are you using to query the clickstream data? If you group by the concatenation in step 1 and subtract min(hit_time_gmt) from max(hit_time_gmt) you would likely get the visit duration.