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 -
Adwords Conversions - Trying to track button clicks that fire when Bootstrap modal contact form clicked/opened
Hi there, I'm trying to implement google adwords conversions on a particular client's website. They have used bootstrap as the framework for their site and mainly open up contact forms within a bootstrap modal, after a button is clicked. See here: http://www.gtwstorage.co.uk/ I thought I had successfully implemented the adwords conversion tracking however it has been a week now, and my conversions still say they are "unverified". I wonder if anyone else has encountered this before and knows what I might be doing wrong. Thank you in advance, Darren
Paid Search Marketing | | SEODarren0 -
Adwords negative keywords / keyword lists conflicting?
Does any of you had any experience on large 5k+ shared negative keyword lists impacting normal campaign negative keywords in Adwords even if they are not selected on these campaigns? And a second question; does anyone know how selected negative keyword lists can be removed from a campaign? I seem to be able to add them but not to remove them... Cheers!
Paid Search Marketing | | hellemans0 -
KeyWord Spy Expert Needed: Will Pay $100 For A Report
I need someone with a KeyWord Spy subscription and experience (or a similar tool that has Canadian data) to do a one time CPC report that answers these questions: (1) Who are my client's main competitors in paid search? (2) What is the estimated ad spend by the the five top competitors? (3) What keywords and ads are working best for the competitors? (4)) What is the CPC for the top 20 keywords in the niche. (5)) Any topline suggestions for my client re: next steps. That's it! I don't want to be overwhelmed with masses of extraneous detail. This should be an easy assignment for someone with required expertise. Possibility of more work to implement and/or optimize CPC campaign. Reply via PM with experience. Ideally, send a sample past report (okay to black out client names)
Paid Search Marketing | | DanielFreedman0 -
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 -
Adwords "seller reviews" not showing
We have been building up our reviews (with trustpilot) over the last few months, which has been picked up by google's reviews, and on the 2 July we passed the 30 reviews mark, (takes about a week or two before it shows the reviews on google reviews). So we have had + 30 reviews for over 6 weeks now, our score is 4.8/5 but are "Seller Reviews" is still not showing on our adwords. Is there any other reason our seller reviews would not be showing yet?
Paid Search Marketing | | PaddyDisplays0 -
Can I pass keyword match type through the Adwords dest URL?
Hi guys, I'm currently using duplicates of the same keyword with different match types, and I'd like to pass the keyword match type through the query, the same way I can pass the keyword and creative. ie. http://my.site.com/?kw={keyword}&kwmt={matchtype}&aid={creative} As far as I can tell, Google allows you to pass the keyword, creative (ad id), network and a mobile flag. Microsoft allows you to pass the match type and and ad id, and I want to be able to do the same in my Adwords. Is this is possible, or is the only way to create different ad groups for each match type and pass a custom query? Cheers, Jez
Paid Search Marketing | | jez0000 -
Adwords "Display Network" tab buggy?
Anyone else notice the new Display Network tab in Google Adwords is buggier than a cheap NY motel bed? Everytime I load it in firefox I end up twiddling my thumbs for several minutes before hard closing the program. Very frustrating morning... In case anyone else is feeling this pain, I just tried it in opera and it finally loaded ok.
Paid Search Marketing | | AdoptionHelp0