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
-
Adwords :what do you think about creating 2 different ad groups for each match type of the same kws into the same campagn?
one modified broad and one exact. ADGR1:
Paid Search Marketing | | pupazzoinfame
+red +cat +buy
+red +cat
+red +cat for +sale ADGR2:
[red cat]
[buy red cat]
[red cat for sale] Am i bidding agains myself without negative kws?2 -
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 -
Adding AdWords Remarketing Pixel to "Partner" Domains?
I have read through the AdWords advertising policies, but there isn't an extremely clear answer to my question: does it break AdWords policy to include a remarketing pixel on a partner website? Example - I own and run 123boats.com, my acquaintance who owns abchotels.com has agreed to put my remarketing pixel on his website, and I plan to show remarketing ads to his website visitors advertising my services at 123boats.com. Is anyone aware of any documentation that explicitly allows or disallows this type of "partner" remarketing tracking?
Paid Search Marketing | | marymerritt0 -
Question regarding Google Adwords?
Just had a question regarding Google Adwords. I have an e-commerce store (kiwimodfurniture.com) in the furniture niche and I originally was planning to create a different ad group for each product. Since I have 1300 products I would have 1300 ad groups. However a lot of the products don't have enough search volume and Google won't display my ads. Then I decided to get a bit more broad. I plan on having an ad group for each sub category on my website. For example, modern lounge chairs, modern arm chairs, modern sofas, etc. Question: Is this too broad? Will the ROI be terrible because of this? Thanks!
Paid Search Marketing | | The_Kiwi_Man0 -
Does anyone know if there are any adwords guideline restrictions against naming a product with the term "Clinically Proven?"
If you do a search for something like "protein powder" there are the sponsored ads where you can shop. Does anyone know if there are any guidelines against naming a product with "Clinically Proven." For example, "Clinically Proven Protein Powder." Any guidance, insight, or links helping to answer this question would be appreciated.
Paid Search Marketing | | jbmac0 -
OK to have a modal pop-up on an AdWords landing page?
We're about to launch an AdWords campaign targeting users who are searching for hand-crafted furniture. The website we're sending users to has a large inventory of furniture, and all if it is hand-crafted. But there currently is no page on the site specifically communicating that all the furniture on the site is hand-crafted. So, rather than dump the user right into browsing the inventory, we want to put an intermediate step in place to say, in essence, "Hey, welcome, yes, we have lots of handcrafted furniture. In fact, all of it is hand-crafted. Here, have a look around." The art director on the project is suggesting that a modal pop-up would be perfect for this scenario. It would greet the user, who could then dismiss the pop-up and move into the site. I have two concerns about using a modal, though: Does a modal violate Google's policy against pop-ups that open new windows? Assuming we trigger the modal using Javascript, will AdsBot have any trouble crawling the content of the modal, such that it could hurt the landing page component of our quality score?
Paid Search Marketing | | ydop0 -
Anyone Think AdWords Campaigns Hurt Organic CTRs, Decreasing Organic Rankings?
Hi All, It seems like just about everyone agrees that AdWords campaigns and SEO campaigns bring additional value when used in conjunction (increasing Impressions, Clicks, Conversions, etc.), but has anyone considered AdWords performance harming organic rankings by decreasing engagement metrics? I've been searching for studies, blog posts, investigations, etc. this morning and haven't been able to find anyone discussing this specific idea. Personally, I think decreased engagement for organic results would be relatively evenly distributed among those results, making engagement drops relative and thus nullifying their impact on rankings. Any other ideas out there? Thanks!
Paid Search Marketing | | mac22330 -
How Can I Increase Conversions from English Speaking Countries in AdWords?
Hello, So here is the gist: Our company provides credit card processing services primarily to e-commerce businesses. I began managing Google AdWords in-house this past April. I started out by not excluding any countries, but received leads from merchants living in countries we could not serve due to risk of fraud. Then, I excluded countries our company could not work with to eliminate unwanted costs. I then took it one step further and targeted only countries our company can serve. My campaigns performed very well. This month, I have been averaging nearly 14 conversions per day. [I should also add that four campaigns are Search and Display, one is remarketing so it is Display only, and two are Search only. Prior to what you will read in the paragraph below, the majority of our conversions came from the Display network, but we had a significantly higher conversion rate with our Search conversions.] However, throughout all of this, we received very few conversion from English-speaking countries--primarily the US, UK, Canada, and Australia. Yesterday afternoon, July 15, I targeted only those four countries. When I came into work this morning, I saw that we received very few impressions and only 7 clicks (as opposed to more than 500,000+ impressions in one day and 1,500-2,400 clicks in one day). I am no Google AdWords expert, but I do understand that searching these terms in the US, UK, Canada, and Australia may be more competitive, which will require a higher CPC. I set it so Google manages my CPC, so I would assume this would adjust while staying within my daily budget. I do not know what to do, but am in dire need of guidance. I do not know where to look online for help and Google AdWords Live Chat is not working. Thank you in advance,
Paid Search Marketing | | Instabill
Meghan0