AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.7K members online now
1.7K 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.