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
-
Finding Average Session Duration for AdWords Campaigns
Happy Holidays Mozzers! Does anyone know how to view 'Average Session Duration' for AdWords campaigns? I can't seem to be able to add it within the AdWords platform and when i try and view it on Analytics, the #/visits isn't matching the #/visits I see when I try and review the campaign via AdWords. Any help on this issue would be great! Thanks for reading!
Paid Search Marketing | | maxcarnage0 -
How do YOU do an AdWords Audit?
Audits Audits Audits! I am overhauling my AdWords Audit Process and the Documentation and I was wondering if any generous souls our there mind sharing a few ideas or learnings that they have had along the way? I aim to make it as thorough but as quick and automated (think scripts) as possible. I'm also 14 pages into the documentation that I will use for some audits that include explanations, recommendations & definitions. I'd love to hear your opinions on what to Audit, how to audit and how to report on it 🙂
Paid Search Marketing | | Singularitie0 -
Impressions data: Google Webmaster Tools VS Google AdWords
Dear community, I was doing some research within Google Webmaster Tools (WMT) keyword data when I noticed that the impressions within this tool are quite different compared to the keyword impression data provided by Google AdWords (ADW). Some specs about the situation: Date: December 2014 (31 days). Keyword: brand + main keyword* (e.g. amazon shoes, if Amazon would have been the client) Visitors come from: the Netherlands (>97%). Search volume: 3,8 K for this branded keyword last year (December 2013), of which >99% came from the Netherlands (source: Google Keyword Planner). Search query data: "impressions" for Google WMT (organic keyword impressions) and “impressions” for Google ADW (paid keyword impressions). Of course the ADW keyword is [exact]. So, what's wrong? The data doesn’t match, while I expected approximately the same amount of impressions assuming the keywords are: both [exact] keywords; (check! ✓) within the same period of time; (check! ✓) the Ad is being displayed "all the time" (check! ✓) the domain/page is being indexed "all the time" (check! ✓) How much of a difference is there? Organic impressions: 7,4 K (source: Google WMT) Paid impressions: 2,1 K (source: Google ADW) Note that the search volume according to Google Keyword Planner of last year is somewhere in between: 3,8K. The search volume from this tool of last December is not available just yet (but I don’t expect much difference here since Google Trends shows a steady search volume). If the difference would have been 10-20%, I wouldn't be surprised at all, but this is huge. **What could explain the differences? ** If a lot of people were using AdBlockers (they do, but not nearly as massively (around 10%)). If we would have made mistakes in AdWords: budget, bidding, targeting etc. - This is not the case, got this confirmed by the manager who double-checked the data and settings. Also: since it’s a branded keyword it’s really cheap for us and easy to get high quality scores. If we would have made mistakes regarding indexing/crawling that would have caused an extreme loss in domain visibility in the SERP's: possibly caused by robots.txt, a noindex-tag, server problems etc. This was not the case and Google WebmasterTools says the average position was 1,0 during the complete month. "Something else" went wrong during that specific period of time with this specific domain. I don’t think so because I checked multiple months and multiple other domains of other clients. These gave me the same relative results (okay, some were a bit closer: 30 K paid impressions vs 62 K organic impressions for instance, still a big difference). What other possibilities are left? The impressions from Google WMT and Google ADW are not the same, even though they are called the same and therefore suggest they should be (about) the same. AdWords just randomly fails to display and/or measure some branded ads (even though there is plenty of budget, bidding is fine and QS is 10/10). Definitions of "impressions" for both tools according Google: AdWords definition of "impressions" WebmasterTools definition of "impressions" Hope someone has some more suggestions or useful links! Thanks in advance! Ektor Tsolodimos
Paid Search Marketing | | BlueMango0 -
Which of my products should I advertise for first using Adwords?
Serious Adwords noob here. I have been reading a great deal in preparation for my first Adwords campaign. Strangely enough, I have not been able to find information that might help me determine which of my 180+ products I should begin with and use in my first campaign. I imagine that there is some sort of general criterion like the highest selling item, lowest, one meeting certain criterion in the popularity of it's keywords/difficulty, one with least competition or, most likely, something that I haven't even thought of. Does anyone have any suggestions or a link to something I might be able to read to solve this? Thanks for your help!
Paid Search Marketing | | machineuser0 -
Have you used an ad network other than Google Adwords?
We received a cold call from a company called Division-D. They make a lot of promises which sound good (but that's what marketers do 🙂 ). Advertising on a non-Google network probably would have fewer restrictions than an Adwords campaign and they say that they are fully transparent. Would it be worth it to listen to their whole pitch?
Paid Search Marketing | | Linda-Vassily0 -
How Can I Target Certain Countries in Google AdWords without Excluding Other Countries?
So, here is the situation: Our company works with merchants worldwide (with the exception of those who live in excluded high-risk countries--mostly in Africa), but most of our Google AdWords leads come from Indian merchants. My CEO wants our campaigns to convert leads from other countries (i.e., the UK, Germany, US, Canada, Australia, etc.), but I have no idea how to do that without excluding India. However, my CEO does not want to exclude India from our AdWords campaigns as the leads are profitable. We simply want more diversity with out leads in terms of geographic location. I am sure there are resources on the Web about how to do this, but I am not an Adwords expert and am unsure of what phrases to search to find the answers. Direct advice or helpful links are much appreciated. Regards,
Paid Search Marketing | | Instabill
Meghan0 -
Adwords Bulk Discount
Had a few calls recently from agencies offering bulk discount on Google Adwords spends if we pass management over to them and spend more than £5,000 ($7,500) a month, they claim they can offer a 5% discount over what we're currently paying... Can't find anything about this, does Google offer such a deal to agencies?
Paid Search Marketing | | digitalarts0 -
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