Does anyone know how I can export a report with time metrics (like average time on page or average load time) to Csv/Excel? I tried it several times and it didn’t work. Instead of the time metrics I get long strings of numbers.
For example, when I export these time on page statistics:
1m 20s
52s
30s
I see the following numbers in Csv/Excel:
7.970.991.192.736.350
5.150.466.923.208.900
29.954.506.997.567.500
Does anyone know how I can convert these strings of numbers to time durations in a readable format, like 1:20 or 80 sec?
This doesn’t seem to solve the issue in my case. The decimals seem to get messed up with the export or creating seperate columns. What should show 44s, shows the number 4418783930510310 in my case. The decimals are gone. Any advice on how to proceed?