topic Re: Calculate total seconds spent using data feeds in Adobe Analytics Questions
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/calculate-total-seconds-spent-using-data-feeds/m-p/350814#M8668
<P><SPAN>Total seconds spent metric is available only in </SPAN>Analysis Workspace, Reports & Analytics, Report Builder (called ‘total time spent’), Data Warehouse, Ad Hoc Analysis.</P><P> </P><P>In data feed you can do following to get time spent:</P><P>Hits must first be grouped by visit, then ordered according to the hit number within the visit.</P><OL><LI>Concatenate <EM>post_visid_high</EM> , <EM>post_visid_low</EM> , <EM>visit_num</EM> , and <EM>visit_start_time_gmt</EM> .</LI><LI>Sort by this concatenated value, then apply a secondary sort by <EM>visit_page_num</EM> .</LI><LI>Subtract the last hit <EM>post_cust_hit_time</EM> value in a visit from the <EM>visit_start_time_gmt</EM> <EM>value </EM>calculated in first step.</LI><LI>This number is the amount of total time spent (in seconds) for the visit.</LI></OL>Wed, 01 Jan 2020 06:49:01 GMTAsheesh_Pandey2020-01-01T06:49:01ZCalculate total seconds spent using data feeds
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/calculate-total-seconds-spent-using-data-feeds/m-p/350664#M8667
<P>How can I calculate Total Seconds Spent using Data Feeds?</P>Thu, 26 Dec 2019 08:46:57 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/calculate-total-seconds-spent-using-data-feeds/m-p/350664#M8667abhishekj4842722019-12-26T08:46:57ZRe: Calculate total seconds spent using data feeds
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/calculate-total-seconds-spent-using-data-feeds/m-p/350814#M8668
<P><SPAN>Total seconds spent metric is available only in </SPAN>Analysis Workspace, Reports & Analytics, Report Builder (called ‘total time spent’), Data Warehouse, Ad Hoc Analysis.</P><P> </P><P>In data feed you can do following to get time spent:</P><P>Hits must first be grouped by visit, then ordered according to the hit number within the visit.</P><OL><LI>Concatenate <EM>post_visid_high</EM> , <EM>post_visid_low</EM> , <EM>visit_num</EM> , and <EM>visit_start_time_gmt</EM> .</LI><LI>Sort by this concatenated value, then apply a secondary sort by <EM>visit_page_num</EM> .</LI><LI>Subtract the last hit <EM>post_cust_hit_time</EM> value in a visit from the <EM>visit_start_time_gmt</EM> <EM>value </EM>calculated in first step.</LI><LI>This number is the amount of total time spent (in seconds) for the visit.</LI></OL>Wed, 01 Jan 2020 06:49:01 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/calculate-total-seconds-spent-using-data-feeds/m-p/350814#M8668Asheesh_Pandey2020-01-01T06:49:01Z