Average Session Duration Y/Y

jboniface
jboniface Member
in SQL DataFlows

I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used

SEC_TO_TIME(Avg. Session Duration)

to change the data to time format, but it's still not showing appropriately. Any ideas?

image.png
Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    SEC_TO_TIME should be converting duration in seconds to a time format. It looks like the value is for the average session duration displayed with K, indicating thousands. As in average session duration of 170.85 seconds. The "0" indicates no change from the average in the current month to the same month last year.

    Your data may be aggregated to a different level before calculating…such as monthly. Also check the data type.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    SEC_TO_TIME should be converting duration in seconds to a time format. It looks like the value is for the average session duration displayed with K, indicating thousands. As in average session duration of 170.85 seconds. The "0" indicates no change from the average in the current month to the same month last year.

    Your data may be aggregated to a different level before calculating…such as monthly. Also check the data type.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories