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
-
Can a third-party advertising agency lock me out of Adwords?
Hey all, I've just started at a new company. We spend quite a bit on Adwords and I'm tasked with seeing how that is going and assessing that spend. The problem is, Adwords and Youtube ads have been given to a third-party advertising agency. They are only willing to share the number of clicks, cost and conversions, stuff like that. They refuse to give us access to the account. Is this legal? I mostly want to get in there to look at keyword history, see what we have bid on, how often it was searched, stuff like that. But they won't let us in and I'm wondering if they are required to let us look at our account as I would think they are. Please help!
Paid Search Marketing | | DanDeceuster2 -
Using + in Adwords URL
Hi. I am using keywords in my Destination URL in Adwords. So http://example.com/?football+boots+supplier This was done by someone else and I am trying to understand the full meaning behind this. If I go to the page it links to, it is just the homepage of the website but obviously shows up in Analytics as a landing page that stills out from the general landing page of homepage / Is that the reason so its easier to track the data? I would have though using the Paid referral in Analytics does this better? Any help be great. Thanks
Paid Search Marketing | | YNWA0 -
Why does my google analytics show a massive discrepancy from facebook's reported website clicks?
We're running a Facebook news feed ad that is pointing at our homepage. Facebook says that for yesterday there were 47 website clicks. Google analytics shows 15 total visitors from facebook with 3 of them landing on the homepage. I understand that there is likely going to be some discrepancy with users accidentally clicking and clicking back before the page loads, but this seems a little insane. I tested the ad using a page that pulls the Analytics cookie data using php and it is working properly so I don't understand what's happening. The url isn't tagged with utm parameters, which is going to be fixed. Anyone experience this or have any insight as to what could be this issue? Is this click fraud? Edit: For more clarification I was checking on my completely unfiltered google analytics profile/view.
Paid Search Marketing | | spencerhjustice0 -
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 -
Bing Adwords
Hello Moz Community, I am curious to see if anyone else is experiencing the troubles I am having with Bing Adwords. In the past (not even a month ago), my companies campaigns were driving great traffic, with high CTR, Conv. Rate, and low CPC; but recently (start of February) traffic has increased (not the good kind) and CPC has gone through the roof. When I say not the good kind, I mean the traffic we are getting is not relevant at all to our industry our the campaign/ad groups targets at all. These campaigns have been running for a good year with regular maintenance and great results. I keep up to date with all the negative words, constantly am A/B testing copy and landing pages, and keeping up to date with good SEO/SEM habits. Since February has started like I said traffic has increased (not the good kind) and search queries seem to be more and more outrageous by the day. I guess my question is has anyone else experienced this and is it a possibility that Bing (Microsoft) loosened up their algorithm to drive more (I hate to say it) money into their pockets? I haven't heard/read anything publicly that they made such a change but I have read that they have had an increase in profit and a majority of CPC for accounts have increased without actual search share going up. Please feel free to share you thoughts about this and if you have experienced this in anyway. Thanks All, Brian
Paid Search Marketing | | BrianBar0 -
SEMRush Ads Traffic Price VS their PDF report
I am running a report on a website trying to find their advertising budget online (or at least what I can find and have access to). When I type in the URL and look at the overview section it has the "Ads Traffic Price" at around $2,000/mo. But when I do a full PDF report it has the price at over $11,000/mo for Google USA. What am I missing? Doing wrong? Which is accurate? I'm pretty sure they spend quite a bit more than $11,000/mo in general as they were recently bought by Google and are owned by people from Apple. How do I get the mots accurate estimation in general? Or at least on SEMRush?
Paid Search Marketing | | JoshBowers20120 -
AdWords training resources
Hi guys, Aside from Google certification, can anyone suggest a good training program for Adwords? I'm studying their materials, but more formal training, where I can be tested in my knowledge and improve in certain areas as necessary. I want something with videos with demonstrations. Going from organic SEO to SEM and am frightened! Thanks,
Paid Search Marketing | | SSFCU
Sarah0 -
Does an AdWord campaign affect your rankings?
Say for instance you are in the business of "lawn mower repair," and you are ranking for that keyword. If you were doing an AdWord campaign on that keyword, would that also affect your organic rankings in the SERPs for that keyword?
Paid Search Marketing | | Bill4Time0