Filter 2 Variables
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
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.