Adwords search term report processing help
-
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).
-
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.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Adwords disapproving ads with the word "Jewish"?
Hi guys, I do marketing for many nonprofits, and one of my clients is a Jewish women's organization. In the past week or so, Google has started disapproving ads and keywords that have the word "Jewish" in them. I know Facebook got called out recently for allowing people to target based on anti-Semitic sentiments, so I'm wondering if this is just Google's terrible execution of caution. It's telling me that keywords with the word "jewish" in them (like "jewish women's organization in boston" is derogatory or dangerous). I've asked for Google's help, and they've been incredibly slow to respond. Is anyone else facing this with other religions or content? Natalie
Paid Search Marketing | | newwhy1 -
Set-up remarketing through Analytics or Adwords?
I am setting up a remarketing campaign and wonder if anyone has any thoughts on whether to do this via Analytics or Adwords? Doing it through Analytics appears to be more straight forward - and I like the idea of broadening the data set that comes from an Analytics report. I therefore I wonder if it comes down to personal preference? Would be grateful to any thoughts for or against.
Paid Search Marketing | | E2E0 -
How Can I Increase Conversions from English Speaking Countries in AdWords?
Hello, So here is the gist: Our company provides credit card processing services primarily to e-commerce businesses. I began managing Google AdWords in-house this past April. I started out by not excluding any countries, but received leads from merchants living in countries we could not serve due to risk of fraud. Then, I excluded countries our company could not work with to eliminate unwanted costs. I then took it one step further and targeted only countries our company can serve. My campaigns performed very well. This month, I have been averaging nearly 14 conversions per day. [I should also add that four campaigns are Search and Display, one is remarketing so it is Display only, and two are Search only. Prior to what you will read in the paragraph below, the majority of our conversions came from the Display network, but we had a significantly higher conversion rate with our Search conversions.] However, throughout all of this, we received very few conversion from English-speaking countries--primarily the US, UK, Canada, and Australia. Yesterday afternoon, July 15, I targeted only those four countries. When I came into work this morning, I saw that we received very few impressions and only 7 clicks (as opposed to more than 500,000+ impressions in one day and 1,500-2,400 clicks in one day). I am no Google AdWords expert, but I do understand that searching these terms in the US, UK, Canada, and Australia may be more competitive, which will require a higher CPC. I set it so Google manages my CPC, so I would assume this would adjust while staying within my daily budget. I do not know what to do, but am in dire need of guidance. I do not know where to look online for help and Google AdWords Live Chat is not working. Thank you in advance,
Paid Search Marketing | | Instabill
Meghan0 -
How can I filter peoples names out in an Adwords campaign?
for example I get all these searches like "dan stoffer painter spokane"
Paid Search Marketing | | Superflys0 -
Adword competition between exact match and related broad match
If I have two company A and B. Company A: bid on key word exact [Nike and Jordan] Company B: bid on broad match Jordan shoesks Considering that broad match use related words I noted that google display both ads if I search Nike and Jordam (shoes is related with Nike). My question is: bid of B is competing with bid of A? therefore CPC of A increase because of B? Tks
Paid Search Marketing | | fabrico230 -
PPC/Adwords in China
I am trying to understand the challenges of running PPC in China. If anyone has any experience with adwords/Baidu/Alibaba I would really appreciate them sharing. I was having a hard time locating the specific polices in Adwords help. Any help is much appreciated. Thanks!
Paid Search Marketing | | JerrodDavid0 -
Google Adwords Conversion Tracking Code Help - Not Showing Conversions
Hi, all. I am having issues with a clients website. They have their website developed by a company http://www.flowerstoreinabox.com.au/ my clients website is http://www.flawlessflowers.com.au the google adwords conversion tracking code has been added to their site. It measures all details as far as ads clicked on, etc.. the only part that is not been measured is the conversions of the adwords campaign. So I cannot see if the ads are successful or what their conversion % is. I have looked at the code on the thank you page and the google adwords conversion code is present on the thank you page after the sale. I am not a coder and so not sure what to look at if all the details on the checkout page exist in the code to measure the adwords conversion ecommerce transactions correctly. I have provided a link to the source code of the competed order page. If someone could look at the code and provide any assistance I would appreciate it. http://dl.dropbox.com/u/16973368/7 may adwords flawless flowers.txt I am also happy to provide you access to the google analytics account if required just give me your email address to set it up. Thanks for all your help Regards Arthur
Paid Search Marketing | | VivaArturo0 -
Adwords Keyword Research - Impressions, CTR
Hello, In my Adwords Keyword Research (spending $300 to find out any keywords I'm missing using mostly exact match keywords) am I looking for impressions or Click Through Rate, or both? Please explain.
Paid Search Marketing | | BobGW0