Reg ex in AdWords filter?

966 views
Skip to first unread message

Jacob Kildebogaard

unread,
Nov 22, 2013, 7:47:14 AM11/22/13
to automate...@googlegroups.com
Am i wrong, or is it not possible to filter campaigns with regular expression? I can only use "contains" or "equals" filters.

Mikael Thuneberg

unread,
Nov 26, 2013, 6:18:27 AM11/26/13
to automate...@googlegroups.com
You're correct, the AdWords API does not allow regex filtering.

Jacob Kildebogaard

unread,
Nov 26, 2013, 9:25:17 AM11/26/13
to automate...@googlegroups.com
Ok, thank you Mikael.

Are there any workarounds? Can you make "OR" filters, or how can it be solved? I need to group campaigns by name, but i dont have the same string in all campaign names.

Cheers,
Jacob

Mikael Thuneberg

unread,
Nov 26, 2013, 9:27:40 AM11/26/13
to automate...@googlegroups.com
Unfortunately, the AdWords API does not support OR combinations either. We would need to add some logic on our side that does this, which is possible, but we can't do it right now due to other projects we're working on.


--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mikael Thuneberg

unread,
Nov 27, 2013, 4:54:10 AM11/27/13
to automate...@googlegroups.com, mikael.t...@supermetrics.com
This was a good feature request so we decided to move quickly after all: you can now use regex filters in the AdWords and Bing Ads modules in v. 1.7061 (supermetrics.com/download). OR combinations is more difficult to implement so that will have to wait.

Jacob Kildebogaard

unread,
Nov 27, 2013, 8:31:01 AM11/27/13
to automate...@googlegroups.com, mikael.t...@supermetrics.com
That is the spirit Mikael :) Totally awesome, it helps me a lot. Just bought it yesterday no matter, but now it is really worth the price! Thanks!

Jacob Kildebogaard

unread,
Nov 28, 2013, 5:43:50 AM11/28/13
to automate...@googlegroups.com, mikael.t...@supermetrics.com
Hi again

I made some tests, and it seems like "Does not match regex" does not work. If I make a simple filter like

Does not match regex brand|generic

the output is the total numbers.

Cheers,
Jacob

Mikael Thuneberg

unread,
Nov 28, 2013, 6:05:01 AM11/28/13
to automate...@googlegroups.com
It works when I try it, are you sure it doesn't for you? If so, can you send me the file with this report for checking.

Note that by default, it's doing case-sensitive matching. If you want case-insensitive, add delimiters and an "i" after the latter delimiter, so for example #brand|generic#i

Jacob Kildebogaard

unread,
Nov 28, 2013, 6:47:59 AM11/28/13
to automate...@googlegroups.com, mikael.t...@supermetrics.com
Case-sensitive was the keyword... It all works now!

You can be sure that this tool will be mentioned to Superweek.hu in my speak :)

Thanks again!

Mikael Thuneberg

unread,
Nov 28, 2013, 6:51:56 AM11/28/13
to automate...@googlegroups.com
Great to hear it works now! Really appreciate if you can mention the tool at Superweek :)

Jay Wilner

unread,
Feb 3, 2014, 8:08:37 PM2/3/14
to automate...@googlegroups.com, mikael.t...@supermetrics.com
I hope its okay to join this thread.

i have been trying to set up a regex filter that is case sensitive for GA data.

i have a situation where there are source names in both cases (Banner and banner). i want to remove the upper case instance.

i have tried this: medium=~none|banner|cpc|email|maps|organic|referral;medium!@companion;medium!@Banner

but it seems to remain the default analytics result (regex ignores case).  can i force it somehow?

Mikael Thuneberg

unread,
Feb 4, 2014, 2:20:18 AM2/4/14
to automate...@googlegroups.com
I don't know, for Google Analytics it's Google that handles these filters so you'll have to see their instructions. For AdWords, we do regex filtering on our side (as Google does not provide it in the AdWords API), so we can control it, and there you can set case-sensitive filters (regex filters in the AdWords module are case-sensitive by default, and can be made case-insensitive by adding "i" after in the end).


Reply all
Reply to author
Forward
0 new messages