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.2K members online now
5.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Include / Exclude without filters but with REGEXP

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone,

 

I want to create a new custom channel grouping with REGEXP_MATCHs.

 

It's easy when you have a simple one to create like :

CASE WHEN REGEXP_MATCH(source/medium, 'facebook / cpc') THEN 'Facebook Ads' END

But I can't find a way to include / exclude, add or substract for some particularities.Here what I want to do :

 

I want to create an unique channel for an email tool :

 

CASE WHENT REGEXP_MATCH(source,'my tool') THEN 'My tool' END

But, I want also exclude this tool from the email channel. And I didn't find a way to do that.

 

Someone can help ?

 

Thanks, and sorry for my english Smiley Wink

Re: Include / Exclude without filters but with REGEXP

Collaborator ✭ ☆ ☆
# 2
Collaborator ✭ ☆ ☆

HI

Please take a look at screenshot below, is that what you are looking for?

FBCPC.PNGFB CPC

Regards, Nik
LinkedIn  |   @nikhilparachure | My Blog

Include / Exclude without filters but with REGEXP

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭

@Théo L

 

I hope you are looking solution for this problem in respective of data stuido, mentioned below links will helps you to solve you problem 

 

Function :

 

https://support.google.com/360suite/datastudio/answer/7064476?hl=en

https://support.google.com/360suite/datastudio/answer/7020724?hl=en

 

System Type :

https://github.com/google/re2/wiki/Syntax

 

 

Include / Exclude without filters but with REGEXP

Collaborator ✭ ☆ ☆
# 4
Collaborator ✭ ☆ ☆

Hey

I am so sorry I didnt even realize this is data studio question.

I think you should use REGEXP_REPLACE(Source / Medium, 'facebook / cpc', 'Facebook Ads')

Hope this helps

Regards, Nik
LinkedIn  |   @nikhilparachure | My Blog