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

Create a sum of direct traffic & serch traffic generated by a spécific keyword

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi 

I'm trying to improve my understandig of Data studio, but I can't find the way to sum visits of Direct sessions and Search sessions.

 

I'm trying to create a metrics who calcul only one of the channel sessions about :  direct channel sessions

 

case when REGEXP_MATCH(Groupe de canaux par défaut, "direct") Then Sessions end 

 

May someone could help me ?? Smiley Wink :s :s

 

 

 

1 Expert replyverified_user

Re: Create a sum of direct traffic & serch traffic generated by a spécific keyword

Google Employee
# 2
Google Employee

Hi Laura,

 

Try something like this:

 

SUM(CASE WHEN REGEXP_MATCH(Default Channel Grouping, ".*Direct.*") THEN 1 ELSE 0 END)

 

 

Screen Shot 2016-12-29 at 12.14.21 PM.png

 

Hope this helps!

 

Rick