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
-
Finding Average Session Duration for AdWords Campaigns
Happy Holidays Mozzers! Does anyone know how to view 'Average Session Duration' for AdWords campaigns? I can't seem to be able to add it within the AdWords platform and when i try and view it on Analytics, the #/visits isn't matching the #/visits I see when I try and review the campaign via AdWords. Any help on this issue would be great! Thanks for reading!
Paid Search Marketing | | maxcarnage0 -
Have you had success using adwords to promote blog content?
From time to time I see an ad pop up in search results for blog content and have often wondered how much success these ads have had in promoting the specific post. Does anyone have experience with this? What results did you see?
Paid Search Marketing | | unikey0 -
Should You Buy Your Name in Adwords?
While I definitely see the pros to buying your name in Adwords, should you still do this if you have a small monthly budget? I get why large companies like Tiffany's would buy their name because they have the excessive funds to do so in addition to buying keywords. Any guidance or strategy on this?
Paid Search Marketing | | SEOhughesm1 -
Have you used an ad network other than Google Adwords?
We received a cold call from a company called Division-D. They make a lot of promises which sound good (but that's what marketers do 🙂 ). Advertising on a non-Google network probably would have fewer restrictions than an Adwords campaign and they say that they are fully transparent. Would it be worth it to listen to their whole pitch?
Paid Search Marketing | | Linda-Vassily0 -
Why you should never use Google Adwords To Conduct Key Word Research
Buongiorno from 22 degrees C too damn humid Wetherby UK, The other day a client wanted to know how much a ppc campaign would cost with a specific bank of keywords. So off i went and loaded in the key words and set the ads thinking it was not live.... A week later i get a tap on the shoulder asking why weve been invoiced for £xxxx oh dio mio!! The damn campaign went to live. So ive got two questions: 1. Do Google adwords automatically go to Live once youve loaded up phrases and ads, i really thought it would have made it more obvious, A " Would you like your campaign to go live" prompt would have been appreciated. 2. As a safety measure is configuring a Google Alert in Analytics to ping when paid traffic is picked up not a bad idea just so ive got a warning sytem set up so to speak. Grazie tanto,
Paid Search Marketing | | Nightwing
David1 -
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 -
Will PPC elsewhere on my domain help my organic SEO?
I have an e-commerce site with a small product line which an on-going organic SEO campaign. As a side project, I'm planning on doing some PPC testing with a highly converting product squeeze page, which I'll run Google ads to gain traffic. (this is PPC only and for this page I am not concerned with organic SEO traffic - although of course the page itself will be fully optimized). I am wondering whether to run this squeeze page on a sub-domain or sub-directory of the existing site, OR to host it on a completely fresh domain? I would like to know if as side-effect my existing Website benefit 'organically' from some of the PPC traffic, helping with it's domain authority, etc.,? or could this possibly do any harm? p.s. Bear in mind this is not going to be a page visible on the on the main site itself, it's a separate entity for PPC. Would be great to have some expert Moz eyes on this and opinions. Thanks!
Paid Search Marketing | | GregDixson0 -
Adwords Bulk Discount
Had a few calls recently from agencies offering bulk discount on Google Adwords spends if we pass management over to them and spend more than £5,000 ($7,500) a month, they claim they can offer a 5% discount over what we're currently paying... Can't find anything about this, does Google offer such a deal to agencies?
Paid Search Marketing | | digitalarts0