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 Duplicate Keywords with Different Match Types - Good or Bad?
If you have the following keywords in an Ad Group advertising for a product, let's for example call it "target" product [target product] "target product" +target +product I've found that the exact match keyword has the highest conversion rate in almost all circumstances. So it would make sense to have a higher max bid on the exact match then phrase or broad batch. Even with lots of negative search terms to maximize conversion on the broader matches, if the bid is the same as exact match, the cost per conversion will be much higher (too high.) However in chatting with an Adwords Support Rep (on a different matter) they stated after looking through my account at the end of the chat: " duplicate keywords will impact on quality score. your all keywords will compete with each other" However many of the ad groups in question these duplicate keywords have quality score of 9 and 10. So obviously if there is an effect it seems it may be minimal. I thought it was pretty common for people to bid higher on more exact match and lower on more broad match. What's the real story here? Was this support rep not seeing the big picture?
Paid Search Marketing | | JCCMoz1 -
Does having redirects in a Adwords text ad destination URL hurt quality scores?
I recently noticed that one of my clients had several redirects in their Adwords text ad destination URLs. I updated the destination URLS to land on the final location (thereby losing all the text ad history). However I'm wondering if this could have any impact on the text ad quality scores (none of them were disapproved).
Paid Search Marketing | | RosemaryB0 -
OK to have a modal pop-up on an AdWords landing page?
We're about to launch an AdWords campaign targeting users who are searching for hand-crafted furniture. The website we're sending users to has a large inventory of furniture, and all if it is hand-crafted. But there currently is no page on the site specifically communicating that all the furniture on the site is hand-crafted. So, rather than dump the user right into browsing the inventory, we want to put an intermediate step in place to say, in essence, "Hey, welcome, yes, we have lots of handcrafted furniture. In fact, all of it is hand-crafted. Here, have a look around." The art director on the project is suggesting that a modal pop-up would be perfect for this scenario. It would greet the user, who could then dismiss the pop-up and move into the site. I have two concerns about using a modal, though: Does a modal violate Google's policy against pop-ups that open new windows? Assuming we trigger the modal using Javascript, will AdsBot have any trouble crawling the content of the modal, such that it could hurt the landing page component of our quality score?
Paid Search Marketing | | ydop0 -
Wordwatch Software: PPC Adwords campaign managers heard of, tried, or actively using this?
I've been trialing WordWatch for about a month. I'll admit I've been skeptical from the start. I don't quite understand the results they're delivering or how it works. So I did a search for "Wordwatch review" hoping someone out there could shed some light or help me decide whether this software was worth keeping. But all I can find are two suspicious and badly written posts, immediately raising red flags. (Penuguin should have eliminated crap sites using the Flesch-Kincaid reading level, but I digress.) **Wordwatch premise: **They take over keyword bidding to maximize budgets and clicks. They monitor the Adwords campaign to find an "optimal" bid price. Two questions about this premise: How is it different than using the Google settings for optimize for clicks or conversions? Since Google Adwords is based on a Vickery auction, wouldn't lowering my bid only lower my position? Bearing everyone has the same QS, then lowering my bids to the range between 2 positions does not increase my actual cost. I have Wordwatch enabled for a few of my campaigns. Their interface leaves a lot to be desired. They don't report the activity or the changes they make to the campaigns from the dashboard. I had to go into my Adwords Change History to track what they were doing. And lo and behold they're also adding long tail keywords to my ad groups. Bottom line I didn't notice any huge impact, and I don't see how it's better than Google's own version of campaign settings. I don't know that they're really legit. But their marketing was so convincing, and they raised $1.4M that I need other opinions. Any one with some pro/cons, or yay/nays?
Paid Search Marketing | | flowsimple0 -
Can anyone recommend a talented multilingual paid search agency or consultant?
We need a multilingual SEM agency for a campaign thats going to span multiple non english speaking markets at a decent monthly spend. Any recommendations?
Paid Search Marketing | | freepeople0 -
New v Returning in Google Analytics with Adwords
I am trying to figure out an issue with Google Analytics. What i am stumped on is I see traffic from AdWords coming in (accounts linked) and I see new v returning user. Does the return visit still show even if a user came back in via direct or organic? Or is it that these return visits are clicking on the ad again to come back as visits and clicks match in the reports?
Paid Search Marketing | | RadicalMedia0 -
Anyone sad to see Adwords Position Preference Go?
Is Google saying, "Why keep offering a service that doesn’t work?" or "Let's make more money."?
Paid Search Marketing | | Thos0030 -
How accurate is the Google´s keyword tool regarding monthly searches?
How correct is Google´s keyword tool regarding the estimated number of Global Monthly Searches? Judging from my adwords campaigns the real number of impressions is 1/3 compared to the estimated number for an exact match. What is your experience?
Paid Search Marketing | | europeandomaincentre0
