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
-
Do IP and/or DNS changes impact Paid search (Adwords, Bing, etc.)
What impact (if any) does IP or DNS changes, have on paid search campaigns? We recently performed an upgrade to our sites that required a datacenter change (but within the same region East US) and DNS change. We believe there may have been an impact to our ad campaigns in the form of suppression of our ads following the change, specifically - Google Adwords. Is there any information regarding this issue or has anyone experienced this before? Thanks
Paid Search Marketing | | MWM37721 -
Search Volume, Organic Rankings and Adwords
Hi, I hope you can help. And if this has been answered before, I apologise. Just spent two hours searching but couldnt find much at all. So I have this website, and it ranks in the top 10 for around 150 keywords. Its fairly niche market for targeting the UK market, but subject is for a local area, its got a good optimised site, no link issues, works well, good UI etc. Problem I have is this. It used to get a fair amount of organic traffic a few years ago to generate around 30 leads a day, and back then that was from just one keyword. Today, we may get one a lead a day from organic even though we rank for a lot more keywords and our exposure all round is good. However, we also pay for adwords to make up for the lost leads, the same keywords we are ranking for organically! So we bid on adwords and get our 30 leads with the same keywords and monthly search volume as we have organically, yet we dont get any leads for those keywords organically. So Adwords produces leads, organic doesn't, but they are the same keywords and rank next to each other. How does that work? So my question is, why do our organic keywords that rank just under the adwords that we bid for, with the same monthly searches, only give us 1 lead a day (when they used to give us 30) and adwords now give us 30 leads a day? Thanks James
Paid Search Marketing | | jaimo6930 -
Is there way to have several AdWords Ad for the same keyphrase?
Hi guys. Can I have 2-3-4 ads come up for the same keyphrase? The situation is: I'm bidding for client's company name, there is no other competition (nobody else bids for client's company name), I'm bidding only for exact match and phrase match. Is there way to have, let's say 4 ads come up when somebody searches for exact matched company name? P.S. I know it's weird question, all this is done under reputation management for this company, I'm trying to occupy as much space at the top of the 1st SERPs, so people don't see ROR article in organic position #4. If you have other suggestions - please feel free to put it here. (SEO is being done, not-index pages are being optimized to try to come up as several organic results, backlink building is in process, Social media profiles are being optimized as well). I'm just trying to have some temporary "fix".
Paid Search Marketing | | DmitriiK0 -
Session and conversion data missing from AdWords campaigns in Analytics
Hi all, For a client of ours, we're not seeing session & conversion data for AdWords campaigns in Analytics. We are seeing click & cost data. Adwords and Analytics are linked and autotagging is enabled. The site where we're experiencing this problem is www.maxifleur-plantes-artificielles.fr. It's a Magento-based store with the Web Cooking Universal Analytics extension installed. The bulk of AdWords traffic is landing on the page www.maxifleur-plantes-artificielles.fr/plantes-artificielles, which has no active redirects that could remove the ?gclid parameter for as far as I can tell. Yet, click IDs that I manually tested won't show up in the reports either. Mid April, all traffic aside from direct traffic just disappeared from the reports. Google's Tag Assistant gives a lot of errors, but in the source code the snippet looks just fine and we don't have problems with other web shops that use the aforementioned extension. Suggestions as to what could be the problem are most welcome. Thanks! Bas
Paid Search Marketing | | Evoworks0 -
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 -
Redirecting AdWords Display URLs
I feel it's a best practice (from a user experience POV) to create a 301redirect when using a fictitious display URL in your PPC ads. And according to the AdWords help page (http://support.google.com/adwordspolicy/bin/answer.py?hl=en&answer=175906&rd=2) Google doesn't have an issue using a redirect. "Redirects used for tracking purposes are fine as long as the final landing page has the same domain as the display URL." I'm curious if there is ad score penalty if one does not ionclude a redirect - i.e. the user types in your display URL and gets a 404. Has anyone seen an evidence of this?
Paid Search Marketing | | legalseo0 -
Adwords Dynamic Keyword Insertion for Location keywords
Hi Guys, I'm managing a campaign targeting multiple cities across the country. The campaign is using DKI to display locations in ad titles. Is the following example the best way to handle it (example data only): Ad headline: {KeyWord: Local Chocolate Delivery} Keywords: chocolate delivery chocolate delivery Dallas chocolate delivery Austin Etc etc?
Paid Search Marketing | | David_ODonnell1 -
Adwords quality scoring change?
Has there been a chance in the adwords quality score/review thing recently? We have noticed our score up and competitors down by quite alot and wondered if there had been an update perhaps?
Paid Search Marketing | | pauledwards0