Displaying Seconds as Time

Data Pipeline

In order to display seconds in a time format, for example, to be able to see the average time per page from Google Analytics, add a step in the Pipeline. Choose Custom formula and type in

strftime(‘%H:%M:%f’, “ga:avgTimeOnPage” ,’unixepoch’).

Note: Replace “ga:avgTimeOnPage” with the column that contains your seconds.

Related Data Pipeline Help Articles

See more