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

Top Contributor Alumni
# 2
Top Contributor Alumni

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

Top Contributor Alumni
# 4
Top Contributor Alumni

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