google-analytics - How to get a time format with Google Analytics add-on on google sheets

Question

I'm trying to import from GA to google sheet with the add-on : ga:sessionDuration ga:avgSessionDuration and my problem is that my data are converted as number and so not with a time format...

Do you have any idea to convert it easily ?

Thank you for your help !

标签： google-analyticsgoogle-sheets-api

Answer 1

ga:sessionDuration ga:avgSessionDuration 的单位默认为秒。如果您希望单位是“x 分和 y 秒”或纯粹的“分钟”，那么您可以在另一个单元格中编写一个公式进行转换。如果您希望数据采用“时间格式”，例如 12:00 pm，那么请了解您实际上是在寻找时间戳，而不是会话持续时间。