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

Filter 2 Variables

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello you all,

 

I want to put in a filter for my adwords data.

 

I want to make a report of all the search terms - which are activated by google and want to exclude the keywords which are an exact match to the search term. This way I can find new oppurtunities.

 

But can't find a way to filter this into the account of datastudio.
Can someone help me?

Re: Filter 2 Variables

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

If you create a calculated field as "Activated" and "Other" it could work?

CASE WHEN REGEXP_MATCH(Search keyword, '(keyword1|keyword2|keyword3).*') THEN "Activated" ELSE "Other" END

Add in additional keywords as required.

Once you've created the field you can add a filter and toggle between the two.