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
-
Broad Match Modifier - Adwords Experts
Hi All, Looking for a little feedback from anyone running/managing ppc campaigns. I'm trying to decide if Broad Match Modifier search terms are actually helping. I see many instances where they have a low quality score, high cpc and low CTR. This leads to me think that these terms are actually bringing all my other ads down due to these negative signs. I have most search terms as "Phrase Match" and [Exact Match] so i'm not sure why i need the Broad Match + Modifier terms as well. Looking for some advice from the experts ... Do you guys agree with my assessment and what is your overall opinion on the usefulness of Broad Match Modifier terms. Thanks
Paid Search Marketing | | Prime850 -
How to Preserve Capitalization of Specific Letters in AdWords?
I've used dynamic keyword insertion variations in Google Adwords, but here's one that's a bit tricky and I'm starting to think the only way to do it is to create a unique campaign group for this keyword without DKI to pull it off. Trying to dynamically insert the keyword actiNOS, but see no way to over-ride DKI in the campaign for this term. Any ideas or suggestions, or do I need to create a separate adgroup without DKI for this term?
Paid Search Marketing | | Prospector-Plastics0 -
AdWords training resources
Hi guys, Aside from Google certification, can anyone suggest a good training program for Adwords? I'm studying their materials, but more formal training, where I can be tested in my knowledge and improve in certain areas as necessary. I want something with videos with demonstrations. Going from organic SEO to SEM and am frightened! Thanks,
Paid Search Marketing | | SSFCU
Sarah0 -
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 -
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 -
Questions about Adwords Display network.
I am starting up an Adwords campaign that is set to run in the Display (content) network only. In the past I have meshed search and content together, but after reading Brad Geddes book I see that I need to separate them. I can't see my quality score for my keywords - it just has a dash in place of QS. Is this normal? Additionally, I can't see how much I am paying per keyword. I only have one text ad and it is still pending approval. I have several image ads that have so far had a good CTR. I'm assuming that I can't see QS because my text ad is not running yet. But, if this is the case, then how do you optimize your campaign for image ads? I'm currently paying about 45 cents per click. (Previously when I had a poorly optimized quickly thrown together campaign I was paying twice that), but I believe that I could get this down significantly. Any help is greatly appreciated! You guys rock!
Paid Search Marketing | | MarieHaynes0 -
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