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.
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 Match rule for "&" and "and"
Howdy, folks 🙂 Here is a question - is there way to have an AdWords matching rule, which would cover both "&" and "and"? Here is an example - rule to match both "B & B" and "B and B". Any help appreciated 🙂
Paid Search Marketing | | DmitriiK0 -
What is the best way to update Adwords final URLs if I'm moving to a new CMS?
Hi there - One of my clients is redeveloping its website. That means, the domain is remaining the same, but the whole site is being rebuilt in wordpress so all the adwords final URLs need to change OR be redirected. There are 550 live adgroups and 3400 ads. We haven't set up tracking. I can't find anywhere what the best thing to do is in this case. The key issues seem to be: 1. 301 redirects - given we have to do these anyway as part of migration, this seems to be the easiest path as Google is ok about redirects as long as they don't go to a different domain. From what I'm hearing, you don't get adversely impacted in terms of quality score etc. This has the huge advantage that you don't have to edit the ad therefore no loss of statistical history or risk of downtime whilst you wait for approval. HOWEVER, there is some concern that if you then redirected again IN THE FUTURE, the redirect might not work (in some browsers) or cause a loop. I'm also concerned that it's messy to leave it like that (ie: with the wrong URLs throughout). 2. Buik updating ads - I don't think this is an option as if you bulk download and then reupload, Google will see this as a new ad, and delete all the statistical history - I'm also concerned that that WOULD impact quality score as you'd be starting from scratch! 3. Changing each ad individually - as far as I understand you'd have to create copies of all the ads (so that you keep the history of the old ones) and effectively create new ones with the correct URL - one by one. You end up with a messy account (a lot of paused ads) but you keep the history? This is obviously the most time consuming and I can't see a way of avoiding ads having to go in for approval again, given the urls are all different, so you'd have to do this a an ad level, not an adgroup/campaign level etc. People redevelop their websites (without changing domains) all the time. It seems strange that no one is mentioning this problem! Any ideas?! Many thanks
Paid Search Marketing | | catalystmdc0 -
Set-up remarketing through Analytics or Adwords?
I am setting up a remarketing campaign and wonder if anyone has any thoughts on whether to do this via Analytics or Adwords? Doing it through Analytics appears to be more straight forward - and I like the idea of broadening the data set that comes from an Analytics report. I therefore I wonder if it comes down to personal preference? Would be grateful to any thoughts for or against.
Paid Search Marketing | | E2E0 -
Disparities between AdWords clicks and Analytics sessions
Hi all, Have an Analytics account connected to my AdWords account which is showing HUGE gulfs in clicks and sessions for a CPM campaign. 500 clicks = 0 sessions. Does anyone have any idea why this could be the case? Auto-tagging is on and everything looks to be in place. The website itself is on a 303 so I was wondering could that be impacting things? The CPC is also just 1p so that's got me very suspicious. Thanks in advance.
Paid Search Marketing | | Whittie0 -
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 -
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 -
Bad Adwords Leads and B2B Placement Ideas
Hello, I have two PPC related questions that hopefully someone could help with. My client complains that the majority of leads he is getting are disqualified - mainly due to fake contact info left on the landing page. This happens both in the Display and Search campaigns. We are getting a good number of leads and we checked with Google that there is no fraud involved. What can be done about this? Has anyone encountered that kind of complaint and how did you deal with it? Can you recommend any tools, other than Google's Ad Planner to find good placements for a display campaign? Another client of mine is selling B2B services such as document destruction etc. Where can I find, for example, a list of placements frequented by people from the insurance business? I never had a problem finding placements for B2C but B2B seems to be a lot different. Any insight will be greatly appreciated! Thanks, Michal
Paid Search Marketing | | michalseo0 -
Adwords Confusion - Where are these clicks coming from?
Ok, I posted two images showing that my Google Adwords search settings are to receive clicks only from google's search engine, as we are doing testing on keyword behavior with a few specific keywords. The second image will show that we have somehow 7 total search clicks, but not for any of our specific keywords. I'm confused. . . and hungry. . . I'm 'confungry'. 😉 jk any thoughts are welcomed. search-1.jpg search-2.jpg
Paid Search Marketing | | JerDoggMckoy0