1 Reply Latest reply on Oct 15, 2013 5:26 AM by Matt Lutton

    How do I convert average visit duration in GA into minutes?, How do I convert average visit duration in GA into minutes?

    Tim Harrison

      I've trying to convert the Google Analytics API data into minutes and seconds and getting quite stuck.

       

      So at the moment I have visit duration as one measure and visits as another. I created a calculated field which divides the sum of visit duration by 60 (seconds essentially) to give a minute and then divided that by the sum of visits.

      It doesn't look wildly wrong but I know it is, then when I try and change the format to mm:ss it turns them in to time of day which I don't want!

       

      Any help greatly appreciated

       

      thanks

      Tim