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 Google Search works
I watched this video over the weekend. If you haven't yet, this is a great documentary every SEO client should watch. watch?v=tFq6Q_muwG0
Paid Search Marketing | | WebDaytona0 -
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 -
How do I print off Google Adwords Certification certificate through Google Partners?
Hey everyone, How do I print off Google Adwords Certification certificate through Google Partners?
Paid Search Marketing | | jhinchcliffe1 -
Same term and landing page, very different bounce paid vs organic
Hi guys, I have an 85% bounce rate on a ppc term and ad, vs a 51% bounce rate for the same term via organic. Same term, same landing page. Any thoughts why? Cheers, Jez
Paid Search Marketing | | jez0000 -
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 -
Best keyword traffic analysis tool for long tail search terms?
Please bare with me, this might turn into a bit of a waffle, but I'll get to my question... I promise! I've just been looking at our CPC traffic for April and 2 search terms jumped out at me. I recognised them from previous keyword research because they are search terms that I expected to be high traffic (from past experience), but Google Adwords keyword tools showed them to have no potential traffic, and next to no potential traffic (literally 0 local searches and 12 local searches per month). Last month search term A had 46 visits, with 19:25 average time on site and 8.70% bounce rate and search term B had 10 visits with 14:47 average time on site and 0% bounce rate. For very boring reasons we are not currently able to measure conversions on these terms since (they are related to consumer finance and when a customer applies for finance it is all done on our finance providers website) but despite the low volume, these are pretty good figures for on site behaviour and so it got me thinking... Is there a more accurate tool to estimate traffic volume that we should be using rather than the Adwords tools? I appreciate that the estimates are probably made based on historic search behaviour and April's traffic could just be a one off, but these particular terms used to be insanely popular 4-5 years ago when I worked at a competing company.
Paid Search Marketing | | DWJames1 -
Best AdWords Training?
We want to give some adwords training to some of our internal staff with no prior SEO / PPC knowledge. We want to find: A good comprehensive Adwords reference book and A good beginner's Adwords online training course Any recommendations on some good options for the above?
Paid Search Marketing | | Czarto0