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 Express Vs Adwords for small business
Hi there I specialise in helping Local businesses with their online visibility through SEO. More recently I have been thinking about delving into Google AdWords so i can offer an additional service to my small business owner but was wondering what the best approach would be.
Paid Search Marketing | | coolhandluc
Should I use Google AdWords express or just Google AdWords? Should I set up individual accounts for each of my clients so they are somehow "portable" or should they all sit under the same master account? As you can see my knowledge is somehow limited and any help would be welcome. If you can point me in some easy to follow tutorial directly aimed at PPC for small businesses that would be awesome. Many thanks0 -
How To Assign Pricing Based On User Location (Traffic Coming From Adwords)
Hi Mozzers, this may be more of a web development/analytics question than SEO, but hopefully someone has the experience to help me out. My company is currently conducting an Adwords campaign targeting B2B clients for products and services across Canada. Ideally each customer is registered as a client in our system when they make purchases, but this limits our customer base to those willing to create an account with us and wastes our Adwords budget. Now we are moving towards a "walk-up" e-commerce platform which would allow non-members to make purchases without setting up an account first. However, pricing for our products and services differs based on province (different taxes, transportation costs, etc.) and the system currently requires a user to login in using their postal code (zip code) to help the platform generate products, services and pricing specific to their area. This has caused an enormous bounce rate and I am looking for a way to generate said product/service/pricing lists based on some form of automated system which identifies their location and reacts accordingly. In other words, I want our system to recognize where a user is searching from and provide them with the relevant information without them having to input any data (in this case, their postal code). I had thought that using a Google Geolocator API might do the trick, but I'm unsure as to whether it is useful for what I have in mind. Has anyone had this experience before and if so, what solutions did you come up with? Looking forward to any insights and suggestions! Rob
Paid Search Marketing | | RobCairns0 -
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 -
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 -
No paid results for specific search term?
Just doing some research for a potential PPC campaign. For the search terms I'm looking to target, no paid results appear wither above or to the right of the organic SERPs. Does anyone know the reason for this? Search term "Cigar Merchants" Is this because the search term is smoking related? Thanks!
Paid Search Marketing | | underscorelive0 -
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 -
Super weird stuff in Adwords!
Sup people, Check this out, I found a keyword from the search query report in Adwords, its had over the last month 120,000 impressions and its long tail ish (4 words). Now when I check the keyword tool it says less then 10, when I check Google insights nothing. So I check if EMD is free and it is, so now im really interested! Speak to Google account manager about it he says yeah its super weird, checks account to make sure its not coming from display network and it isn't, so we add the keyword from search query report as a exact match and let it run, this is the second day, yestarday when we added it it done 4000 impressions, today so far its done 500. Whats the score, does it sound like it is doing the traffic or do you think its some sort of bug in Adwords as other tools (keyword tool, Google insights) dont show the same result. The only thing I can think of is, its just kicked in on Google suggestions but not 100% other then that I don't know.
Paid Search Marketing | | activitysuper0 -
In Google Adwords, can I create negative dollar-amount keywords?
example of negative keywords: -$40 driving lessons -35 dollar driving lessons The driving lessons I'm selling are $55 an hour, so I obviously don't want unqualified leads chewing through my budget when they clearly don't want to spend $55 on a lesson. I already have the price mentioned in my ads, but I want to negative out the dollar amounts because people are still stupid enough to click without reading the ad. Any help will be appreciated! Matt
Paid Search Marketing | | strilliams0