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

Engagement Report in Data Studio

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

Hi,

I would like to get Engagement report based on session duration, Similar to the one below in google data studio

 

Capture.JPG

1. How to get a similar report in Google Data studio ?.  

2. Should i add new custom field to calculate this session duration range?

3. Should i use CASE function?

4. If so , please check if the syntax is fine     

 

CASE

WHEN (Session Duration > 0 And Session Duration < 11 ) THEN “<10sec” 

WHEN ( SESSION DURATION >10 AND SESSION DURATION < 31 ) 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”

 

Engagement Report in Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Have the same question

Engagement Report in Data Studio

Explorer ✭ ✭ ✭
# 3
Explorer ✭ ✭ ✭

I tested this and it works just fine, you do need to add "End" to your Case statement.

Engagement Report in Data Studio

Follower ✭ ✭ ✭
# 4
Follower ✭ ✭ ✭

HI Mike,

Thank you for your suggestion. But for some reason, I am getting an error message " could not parse the formula.   Any suggestion will be appreciated

Engagement Report in Data Studio

Explorer ✭ ✭ ✭
# 5
Explorer ✭ ✭ ✭

Just copy/pasted this directly from DS, see if that'll work.  

 

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

Engagement Report in Data Studio

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Thanks Mike.