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.
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
-
Does paid search get more traffic compare to organic search now?
does paid search get more traffic compare to organic search now? todays we have four ads link in google that cover all screen of mobile. should we invest more on adwords and organic isn't important like before??
Paid Search Marketing | | Pintapin1 -
Would you launch a paid search campaign with 'Exact Match' only keywords
Hi Mozzers, I'm building a new campaign for a business start-up, and search volumes with the industry are HUGE! I want to target high commercial intent keywords, to maximise the number of conversions / sales from my paid search campaigns. Using the forecasting tool in Adwords, it looks like I can [exact match] these high commercial intent keywords and still get the click volume I'm aiming for. Would you, therefore, use this approach - where you only match at an exact level to control the quality of traffic coming through from the paid search campaigns? I plan to achieve relevance by having ad groups broken down into clear themes with around 10 - 15 exact match keywords per ad group. Let me know your thoughts... Thanks!
Paid Search Marketing | | Zoope1 -
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 -
Do Adwords affect organic rank?
I used to rank 2 for "guitar outlet" I just dropped to under 50th. Only change I made was to pause a Adwords campaign where I was including that keyword. Oddly enough, I believe I ranked high for that keyword BEFORE I added it as a keyword, but I cant be 100% sure due to lack of timing notes. But is it common for adwords to affect organic? If not...where do I start to look for the answer as to why it dropped?
Paid Search Marketing | | Retail_Endeavors0 -
Why you should never use Google Adwords To Conduct Key Word Research
Buongiorno from 22 degrees C too damn humid Wetherby UK, The other day a client wanted to know how much a ppc campaign would cost with a specific bank of keywords. So off i went and loaded in the key words and set the ads thinking it was not live.... A week later i get a tap on the shoulder asking why weve been invoiced for £xxxx oh dio mio!! The damn campaign went to live. So ive got two questions: 1. Do Google adwords automatically go to Live once youve loaded up phrases and ads, i really thought it would have made it more obvious, A " Would you like your campaign to go live" prompt would have been appreciated. 2. As a safety measure is configuring a Google Alert in Analytics to ping when paid traffic is picked up not a bad idea just so ive got a warning sytem set up so to speak. Grazie tanto,
Paid Search Marketing | | Nightwing
David1 -
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 -
How Can I Target Certain Countries in Google AdWords without Excluding Other Countries?
So, here is the situation: Our company works with merchants worldwide (with the exception of those who live in excluded high-risk countries--mostly in Africa), but most of our Google AdWords leads come from Indian merchants. My CEO wants our campaigns to convert leads from other countries (i.e., the UK, Germany, US, Canada, Australia, etc.), but I have no idea how to do that without excluding India. However, my CEO does not want to exclude India from our AdWords campaigns as the leads are profitable. We simply want more diversity with out leads in terms of geographic location. I am sure there are resources on the Web about how to do this, but I am not an Adwords expert and am unsure of what phrases to search to find the answers. Direct advice or helpful links are much appreciated. Regards,
Paid Search Marketing | | Instabill
Meghan0 -
Adwords "Display Network" tab buggy?
Anyone else notice the new Display Network tab in Google Adwords is buggier than a cheap NY motel bed? Everytime I load it in firefox I end up twiddling my thumbs for several minutes before hard closing the program. Very frustrating morning... In case anyone else is feeling this pain, I just tried it in opera and it finally loaded ok.
Paid Search Marketing | | AdoptionHelp0