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
5.1K members online now
5.1K 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