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
-
How do companies protect against Adword sabotage?
What's to stop a company from buying a service to click on competitors' adwords thereby frivolously spending companies' ad budgets?
Paid Search Marketing | | Edward_Sturm0 -
Quick Question: Anchor links on Adwords main URL?
Is it OK to use anchor links on the main URL of an advert on Google Adwords? Example: www.example.com/#example Had a little Google, and not much was returned on the topic. Many Thanks, Alex
Paid Search Marketing | | Whittie0 -
AdWords Different Budgets on Different Days
I have a single campaign and this is what I want. Mon, Tues, Thurs, Fri to have a budget of $270 per day
Paid Search Marketing | | UnderRugSwept
Wed to have a budget of $324 per day
Sat, Sun to have a budget of $432 per day Currently, the only way I can see to do this is to have three separate campaigns, which is very disagreeable. Please tell me there's something I'm overlooking. Thanks0 -
Have you used an ad network other than Google Adwords?
We received a cold call from a company called Division-D. They make a lot of promises which sound good (but that's what marketers do 🙂 ). Advertising on a non-Google network probably would have fewer restrictions than an Adwords campaign and they say that they are fully transparent. Would it be worth it to listen to their whole pitch?
Paid Search Marketing | | Linda-Vassily0 -
Is there any reason to add the word "buy" to our Adwords keywords?
Was having a discussion with someone so I am going to write this up as neutral as possible and let you guys decide. We have a large keyword list and they are all setup as phrase. Should we go back and add the word buy in front of all those keywords? Even though they are setup as phrase already. Example: "Widget" (as a phrase) Should we go back and add "Buy Widget" as a keyword?
Paid Search Marketing | | EcommerceSite0 -
Adwords quality score is bull?
Is it me or is Google Adwords quality score a load of bull. I use part numbers as my keywords and have virtually the same landing page for each one. The only difference is the order of the paragraphs in my descriptions, the product attributes and the SKU. so why does one part get an 7 and the other a 5? Surely they should be the same?
Paid Search Marketing | | DavidLenehan0 -
Adwords Quality Score and On-Page SEO
I'm trying to convince a large, multinational company that is very resistant to change, into making my on-page SEO changes. Compounding this resistance is the fact that the Analytics, SEO, PPC, and web dev departments are all under different people and they don't communicate very well. So, in order to get them to work together, I've decided to appeal to the places where they are sensitive; e.g., the PPC department where they surely have the desire to be more efficient with their budget. To appeal to this sensitivity, and with my goal of getting on-page changes done to help the SEO dept, I'm considering making the argument that my on-page changes will raise their quality score which will in turn lower the amount they are spending on PPC. Basically, is this a fair argument? Do you have an evidence to back this up? Best in the Midwest, Phil p.s. Hi, Joanna 😉
Paid Search Marketing | | PapaRelevance0 -
Keyword quota exceeded! Need help with Adwords Strategy
Hello, I was playing around with my Adwords and received a nice message from Google saying "Keywood Quota exceed". Basically I have too many keywords. That made me wonder if I could organize my keywords better. I sell tractor parts online. The majority of traffic is from people putting the part number into Google i.e 0J51MP5ON . It therefore made sense to use the manufactures SKU as keywords. The problem is that we have 30,000 keywords and will be moving to 100,000 - which above the Google limit. Each keyword links to the appropriate page on the website i.e. 0J51MP5ON goes to the 0J51MP5ON page. To make things simpler I could cut down on keywords by redirecting all parts starting with 0J5 to a 0J5 landing page for parts being with 0J5. The would be from the same Tractor manufacturer. However, I am worried this will reduce conversation rates. It will make it easier to manage the keywords. Anyone got any better suggestions?
Paid Search Marketing | | DavidLenehan0