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
-
What is the best way to update Adwords final URLs if I'm moving to a new CMS?
Hi there - One of my clients is redeveloping its website. That means, the domain is remaining the same, but the whole site is being rebuilt in wordpress so all the adwords final URLs need to change OR be redirected. There are 550 live adgroups and 3400 ads. We haven't set up tracking. I can't find anywhere what the best thing to do is in this case. The key issues seem to be: 1. 301 redirects - given we have to do these anyway as part of migration, this seems to be the easiest path as Google is ok about redirects as long as they don't go to a different domain. From what I'm hearing, you don't get adversely impacted in terms of quality score etc. This has the huge advantage that you don't have to edit the ad therefore no loss of statistical history or risk of downtime whilst you wait for approval. HOWEVER, there is some concern that if you then redirected again IN THE FUTURE, the redirect might not work (in some browsers) or cause a loop. I'm also concerned that it's messy to leave it like that (ie: with the wrong URLs throughout). 2. Buik updating ads - I don't think this is an option as if you bulk download and then reupload, Google will see this as a new ad, and delete all the statistical history - I'm also concerned that that WOULD impact quality score as you'd be starting from scratch! 3. Changing each ad individually - as far as I understand you'd have to create copies of all the ads (so that you keep the history of the old ones) and effectively create new ones with the correct URL - one by one. You end up with a messy account (a lot of paused ads) but you keep the history? This is obviously the most time consuming and I can't see a way of avoiding ads having to go in for approval again, given the urls are all different, so you'd have to do this a an ad level, not an adgroup/campaign level etc. People redevelop their websites (without changing domains) all the time. It seems strange that no one is mentioning this problem! Any ideas?! Many thanks
Paid Search Marketing | | catalystmdc0 -
How to improve the Search Lost IS (rank) & Search Impr. share ?
Hi guys, I have PPC campaign that gets more or less good results I noticed that i have high percentage of: Search Lost IS (rank) & Search Impr. share, although
Paid Search Marketing | | EdmondHong87
that my quality score is high (6-8) and the average position also very high (1.5-2.5). What can i do to decrees these numbers ? Ohh and also the bids are more than the top page number... Any help are welcome!0 -
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 -
Adding Coremetrics Tags with Google Adwords
Hello, I would like to know if it's possible to add Coremetrics tracking tags in Google Adwords while the auto tagging functionnality is on. The point of doing this is to be able to track in both Analytics systems the performance of the PPC campaigns while still having Adwords to use Google Analytics conversion data. Thanks, Guillaume
Paid Search Marketing | | guiberube0 -
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 -
Google Adwords Conversion Tracking Code Help - Not Showing Conversions
Hi, all. I am having issues with a clients website. They have their website developed by a company http://www.flowerstoreinabox.com.au/ my clients website is http://www.flawlessflowers.com.au the google adwords conversion tracking code has been added to their site. It measures all details as far as ads clicked on, etc.. the only part that is not been measured is the conversions of the adwords campaign. So I cannot see if the ads are successful or what their conversion % is. I have looked at the code on the thank you page and the google adwords conversion code is present on the thank you page after the sale. I am not a coder and so not sure what to look at if all the details on the checkout page exist in the code to measure the adwords conversion ecommerce transactions correctly. I have provided a link to the source code of the competed order page. If someone could look at the code and provide any assistance I would appreciate it. http://dl.dropbox.com/u/16973368/7 may adwords flawless flowers.txt I am also happy to provide you access to the google analytics account if required just give me your email address to set it up. Thanks for all your help Regards Arthur
Paid Search Marketing | | VivaArturo0 -
How to set up Adwords Account for Keyword Research
Hello, At the advice of some knowledgable people around here, we are setting up a $200-$300 Adwords campaign to determine keyword research. Our site is already doing well but we want to make sure we are targeting all the appropriate terms. What do we need to keep in mind in setting up this campaign. I assume we would do some broad match terms with a bunch of negative matching. Thanks!
Paid Search Marketing | | BobGW0 -
Adwords ban
my client has 2 adwords accounts - one banned in 2009 and one where 9 of 11 ads are suspended - the other 2 ads run and he pays 6k per month for traffic - he still has net60 terms with no limit on ad spend b/c his offer converts so well. he wants to clear his name so we can proceed further without risk of being banned - he is paying me a pretty penny to turn his 4/10 qual scores into 9's and 10's - he will get 2x the traffic at 1/2 the price and i am looking to make a major 6 figure bump to his bottom line this year so he can jstify paying my exhorbitant fee. lol. i am not getting much help from the folks over at the Big G - to be expected - they have suspended 9 of his ads for "artificial ad traffic" - at least that is their reason - any way he is legit - in biz for 12 years online - with 60,000 customers on his list and over 1000 testimonials on his site - my question is is there any way GG will connect the dots in 4 months once i have his adwords campaign fully optimized and running smoothly and say "hey arent you the guy who we suspended twice over the past 2 years???" or are we to be judged simply on what we do from here forward with this new account? i am having his designer create 100 new landing pages to match the 100 unique ads for the 100 exactmatch kw's for the 100 unique ad groups - lotta work - but once its done its 10/10 across the board - with no mention of artificially boosting someone's traffic -- although isnt that what everyone is doing when they buy visits to their sites? this goes on all day long and no o ne seems to care - except GG but my client sells real human traffic not bot generated crap. all love, EZ
Paid Search Marketing | | ezubkov0