Adwords search term report processing help

[k3nn3dy3]

So I've downloaded my 6000 row adwords search term report, and want to analyses brand keywords and variants only....I could do this by brute force, but I'll want to do it again in a month or two. I have a nice regex string which will do the job but can't find a way to implement a solution. Is there a good way to do this? Or is there a better way?

Adwords won't let me filter using regex, Excel needs vb setup to use regex  and I've tried the regex in Libre Calc (doesn't return the correct results).

[john4math]

Excel has a feature called advanced filters that I use to filter these out.  See here for more info: http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx.  It allows you to filter your data by multiple criteria.  You might have to break up your regex a bit into multiple different filters, but you should be able to get it done with this.  They support * and ?.

If you use Google Analytics, you could view this by setting up an advanced filter with a regex to separate branded vs. non-branded paid search queries.