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
-
How to access bing adwords?
Hi Guys, One of my friend using bing adwords, he want to give me user access for that account for that i have create one microsoft outlook mail like abcd@outlook.com, now he has given access to me but confuse how to access the account? Is this a url - http://advertise.bingads.microsoft.com/en-us/sign-up ? Thanks! Dev
Paid Search Marketing | | devdan0 -
AdWords quality score of landing pages and subdomains popularity
Hello, I have an AdWords account whose landing pages point to (i.e.) http://www.domain.com/landing01.php I've been using this account for ages, it has a good score and history, so I want to keep it. The first question is: may I use landing pages on different subdomains within the same AdWords account (and in the same root domain)? I.E. (http://cheese.domain.com/landing01.php and http://wine.domain.com/landing02.php) 2nd question: the www subdomain has good subdomain metrics (authority /trust and, generally, links) while the "cheese" subdomain has not (no backlinks at all). Do I get any benefit in Adwords (like quality score or other) if I publish my landing pages under a subdomain with better subdomain metrics (or number of links)? Or should I just go with http://cheese.domain.com even it has no authority at all? Thank you, DoMiSoL Rossini
Paid Search Marketing | | DoMiSoL0 -
Changing Adwords campaign titles still mess up Analytics data?
Recently, Google announced an update in de Google Analytics Adwords integration that should wield out the ancient trouble caused by changing your campaign titles in Adwords. http://analytics.blogspot.nl/2013/07/new-adwords-integration-platform.html?utm_source=buffer&utm_medium=twitter&utm_campaign=Buffer&utm_content=buffer6bfb4 Two months have passed, but I still see double entries for the same campaign after a (minor) title change. Are they still busy rolling out the update to all Analytics account or is there something wrong with our Adwords<>Analytics integration? What's your experience? iO9Vafz.png?1
Paid Search Marketing | | RBO0 -
Google Adwords
Hi, Is there any tool that tells you if a domain has paid results in Google? I need to find out if a certain domain is showing in the paid search results for any keyword. I tried to from the question clear enough, I don't know how to explain it better.
Paid Search Marketing | | cvissi0 -
A question for Google Adwords experts
Hi Google Adwords experts, We own the trademarks to some keywords. When you search for these keywords, only our ads will ever appear but they don't appear every time a search is made. They're hardly ever appearing now that we've dropped our bid from $1+ to the minimum first page bid (1 cent in some cases). My question is; are the ads showing less because our bid has dropped so low? If so, why is this? If we own the trademark to the keyword and no one else can display ads, any bid that we submit should be accepted by Google, shouldn't it? If you can include a link to any articles that will give me more info, i'll vote for your answer. Thanks!
Paid Search Marketing | | HamiltonIsland0 -
Best AdWords Training?
We want to give some adwords training to some of our internal staff with no prior SEO / PPC knowledge. We want to find: A good comprehensive Adwords reference book and A good beginner's Adwords online training course Any recommendations on some good options for the above?
Paid Search Marketing | | Czarto0 -
Is PPC worthwhile for a product with no search volume?
I'm working on a PPC campaign for a client who provides a luxury service. He has very little search volume in general, and there's one product that has no volume at all. I'm wondering if it's worthwhile to run a campaign for this product using the general keywords. I estimate that 95% of the population has no intention of using our service and can't afford it even if they did. For example, say we're a concierge doctor service. When people search for 'medical doctor' or 'medical treatment' they are looking for doctors, and we probably could help them, but they won't want us when they could go to the doctor's office down the street and pay a fraction of the price. Obviously I'd tailor the keywords so it would be as relevant as possible. Yay: If my ads are clear, then whoever clicks them is interested in my product, so my money is being well spent. I'll just have a very low CTR. Nay: Spend the money on advertisement tailored to the target market, both people with existing interest, and those who would want it if they knew we existed. Yay or nay?
Paid Search Marketing | | 5225Marketing0