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 -
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 -
Why would a business want to cap their Adwords budget?
If a business has an unlimited supply of product and an unlimited capacity to distribute that product why would they want to limit their Adwords campaign budget? If your Cost per Acquisition for a conversion is lower than the Customer Lifetime Value for any given keyword bid, why would you want to prevent your campaign from reaching as many people as possible? Thanks in advance Danny
Paid Search Marketing | | richdan3 -
Seeing lots of 0 seconds session duration from AdWords clicks
Does anyone have more information on one why this might be? Thanks in advance! GyuYc5F.png
Paid Search Marketing | | Whittie0 -
Blocking google adwords on google.com?
Is there any chance to block google adwords (not google adsense) firefox/chrome/internet explorer 🙂
Paid Search Marketing | | FCRMediaLietuva0 -
What is a good CTR for a Google AdWords Remarketing banner campaign?
Hello there, given that in the banners we offer a promotion with "some bonus if you sign up", what is from your experience a good CTR for a Google AdWords Remarketing banner campaign? Many thanks to everyone that answers. YESdesign
Paid Search Marketing | | YESdesign0 -
Does anyone else get a crazy amount of misdials to your AdWords call extension?
Not sure how many people here also do PPC, but I thought it couldn't hurt to ask. Since we added a call extension to one of our AdWords campaigns a few months ago, we have gotten a crazy amount of misdials/wrong numbers. I'm wondering if anyone else has experienced this. Here's what happens: We choose one of the numbers we own, say 888-123-4567, and set it up so it displays ADWORDS on the phone's screen when it rings. This way, our customer service and sales reps will know when they are taking an AdWords call. We type that number into the call extension settings. AdWords then assigns a different number to us, which will appear on our ads and forward to our number. Say it's 888-234-5678. Then for months, every "ADWORDS" call we get is someone trying to reach a different company at 888-234-5679 or 888-235-5678. In other words, the number they're trying to dial is one digit off from the number AdWords assigned to us. When we first reported this to AdWords before Christmas, they simply assigned us a new number. It did not help. Now we just get misdials for different companies. So are we alone in this wrong-number phenomenon?
Paid Search Marketing | | CMC-SD0 -
Google Adwords Clicks v.s. Google Analytics Visits
Hi Guys, This question has been asked several times before but after doing some research, I haven't really found the right solution and/or explanation. I'm currently seeing a 30-50% discrepancy in Adwords Clicks and Analytics Visits, where there are more clicks than visits in most situations. E.g. 74,127 clicks v.s. 46,845 visits (34 add-to-carts, 67 initiated orders, and a revenue of $12,000). Can anybody in the forum help explain this? Thank you, Jurgen P.S. I've also looked at all the tracking codes and everything seems to be alright, I've checked if any internal redirects are stripping off parameters but to no avail. Lastly, I'm not sure if this is a behavioral issue here in SEA--will first click (Adwords) and last click attribution (Analytics) be the only explanation? P.S.S. I'm seeing the same discrepancies with Facebook ads and Analytics.
Paid Search Marketing | | JurgenEstanislao0