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