Sometimes a data source will give you a time in seconds as an integer. If you need the time in the standard MM:SS format, you can use the following SQL statement to convert seconds as an integer to a MM:SS format

SELECT strftime('%M:%S',datetime(`ga:avgSessionDuration`, 'unixepoch')) as AvgSessionDuration

FROM report

If you have any questions please email or chat in on the site.

Did this answer your question?