Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Session duration range

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey everyone, 

 

I'm a marketing intern and I'm making a standard report for my teammembers to use when I'm gone. I want to put in session duration, but I can not get the 'range' view like in google analytics itself. This is really not clear, so is there a way to make it into an range like google analytics? Or another way? 

 

Thanks! 

Session duration range

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hey Jessica,

 

You have to create a custom dimension. Then enter the following Case Statement into the Formula field:

 

CASE WHEN (Session Duration <= 10) THEN "<10sec" WHEN (  Session Duration >= 11 AND Session Duration <= 30 ) THEN "11-30sec" WHEN ( Session Duration > 30 AND Session Duration < 61 ) THEN "31-60sec" WHEN ( Session Duration > 60 AND Session Duration < 181 ) THEN "1-3min" WHEN ( Session Duration > 180 AND Session Duration < 601 ) THEN "3-10min" WHEN ( Session Duration > 600 AND Session Duration < 1801 ) THEN "10-30min" ELSE ">30mins" END

 

I hope this answers your question. Maybe one day Google will provide this as a pre-built dataset.