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 -
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 -
Have you had success using adwords to promote blog content?
From time to time I see an ad pop up in search results for blog content and have often wondered how much success these ads have had in promoting the specific post. Does anyone have experience with this? What results did you see?
Paid Search Marketing | | unikey0 -
World Localities in AdWords?
If I target the topic "World Localities>San Antonio", what type of sites my ads will be display? Are they sites about San Antonio, like tourism guides or event listings? Or are they related to San Antonio, like a university or flower shop in San Antonio?
Paid Search Marketing | | howlusa0 -
Search Term in Contact Email
Can anybody help me with this? Our enquiries come through by email with certain details added by the potential customer e.g name, email address, phone number etc. I would also like to have the search term that triggered the conversion to appear in the email we receive. I've seen this done before. Can anybody tell me hoe this is done? Thanks
Paid Search Marketing | | RobSchofield0 -
Good Adwords resources/ Guides
I'm going to be taking over the PPC for my company. A 3rd party currently does it but I have done a review and they have not been doing a great job ( I spotted a few very basic mistakes), so we want to switch it to in house I have experience with PPC, and I'm confident on the basic of it, but I was looking for a good (recent) PPC resource or guide so I can make sure I'm doing it right, basicly a ppcmoz 😉 For example current the campaigns are set to accelerated, but I have been told that is very wasteful, but the 3rd party explanation is:"We set the campaigns to be accelerated to avoid missing out on potential sales. These can be set to standard if you wish however there is a higher chance that sales could be missed." Which is correct?
Paid Search Marketing | | PaddyDisplays0 -
Content Network Clicks Not Count as Paid Search
So I've been noticing that the "searches" being recorded in Omniture for my paid search campaigns are closer to the total number of clicks that I get on my "search" campaign. However, when I look at the total number of clicks the discrepancy between the two is high...I'm talking 30 to 40% difference.... So I was thinking that perhaps neither Omniture nor Google Analytics really count clicks coming from the "Content Network" as searches or visits? Would anyone agree to this, or does anyone have any other clever ideas? Thanks!! -Margarita
Paid Search Marketing | | MargaritaS0 -
Adwords how to's and tools
Hi mozzers. I have questions. 1. Can you Share tools for google and msn adwords,example templates,etc.. 2. Any project Management Software or Template for ppc 3. The Best Book from A to Z about ppc advertisement 4. Share your MOS Importanz Stepps to Build really competitive campaign and to Be Number 1 on pair Search results. Thanks
Paid Search Marketing | | leadsprofi0