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 Bidding
I'm just reaching out to get some help with regards to Adwords bidding. I find we are great at comprehensively setting up a campaign but struggle to know exactly what to do regarding setting the bid at the right amount for a keyword. Our current strategy is to maximise Impression share for keywords and therefore we generally look to endeavour to adjust bids to maximize this metric. Is there are good process to use for Adwords bidding or something someone can direct me to in order to uncover the things to consider when adjusting this bidding amount?
Paid Search Marketing | | Gavo0 -
Adword San Francisco Reach number
Hello, I have noticed in Adwords, when I select San Francisco or San Francisco county as a location for the campaign, it shows the reach as 7,220,000 Now I know that reach may be different from census data and depends largely on number of google signed-in users. But this number is waaay of. According to census there are only about 850,000 people in SF county, lets add as much that commute to SF for work, then we still have only 1,700,000 - not even close to 7,220,000 google is reporting. Also note that for the rest of the Bay Area counties the Adwords reach numbers match very closely census data. Any ideas?
Paid Search Marketing | | SirMax0 -
AdWords & Iframes?
We have a client that has syndicated content across a variety of domains. They have no access to the domain/hosting for the site that the content is being syndicated on, but would like to run PPC campaigns to these pages. The page is a header, footer and then the main page content is inside of an iframe, and I was wondering if Google will even allow that to be used as a landing page for a PPC campaign? Thanks!
Paid Search Marketing | | RCDesign740 -
Potential problems with multiple users of an adwords MCC
Morning all, I have had a query regarding granting access to an MCC account for people using various platforms. Now this a pretty specific query for an area outside my expertise, and conveniently both our PPC guys are on holiday so thought i would reach out to the community. Full request is this: "On the mcc I am slightly concerned about that, from experience I have run into problems especially with granting access for usage of API’s on an account, so if for example we wanted to use marin they would need access then another wanted to use adobe they would need another and if they are all sat under the SSM teams mcc that could be problematic or we would have to set up another." Any help would be appreciated. Thanks, Tom.
Paid Search Marketing | | Sarbs0 -
Adwords Keyword Quality Score changes when keyword is paused
Today I was pausing a bunch of low quality score keywords for a client, the thing is, once I paused the keywords, the quality score would immediately change. For example, a number of keywords that had a QS of 3 while they were running, immediately changed to 1 once paused. Out of curiosity I un-paused one of them and it remained at 1. Has anyone else experienced this and/or have an explanation? Cheers
Paid Search Marketing | | David_ODonnell0 -
Adwords Bulk Discount
Had a few calls recently from agencies offering bulk discount on Google Adwords spends if we pass management over to them and spend more than £5,000 ($7,500) a month, they claim they can offer a 5% discount over what we're currently paying... Can't find anything about this, does Google offer such a deal to agencies?
Paid Search Marketing | | digitalarts0 -
AdWords question on text ads
Hey all, I have a certain format I want to follow on my text ads across several ad groups. I deleted all the past ads and only three ad groups remain with ads that follow this format. When I hit add new ad group, the ad come pre-populated with the text of a now deleted ad and I cannot for the life of me change it. I would love for one of my active ads to come up as I only have to change one name and one number in each ad. How do I control what that default ad is? How can I make it stop being an ad I have deleted. Please help!
Paid Search Marketing | | DanDeceuster0