When you manage a large AdWords pay-per-click account with tens of thousands of keywords, you learn to appreciate anything that can save you time. When you make a strategic decision, like to cut budget or work to improve CTR for better account quality scores, you want to do it quickly. Get in, get out, get on with your day. Thankfully, AdWords has developed a lot of functionality to do just that – and many of its features revolve around slicing and dicing data, aka Filters.
I often use third party tools for campaign and bid management (and I won’t give away all the ingredients in my secret sauce), but here are a few of my favorite filters available to all advertisers through AdWords.
AdWords Editor (AWE) Advanced Search
AdWords Editor has been making our lives as pay-per-click marketers easier for years now, and one of my favorite tools is Advanced Search. You can save searches that help you quickly drill down to campaign elements that you might want change, pause, increase/decrease bids, or use as a starting point for expansion. At the top of AdWords Editor next to the search box is a link to Advanced Search.
This is an example saved Advanced search looking for keywords with zero clicks. Name it, save it for re-use, then you can select it as your View in AWE any time. You can use this view across tabs: keywords, placements, ads, ad groups, etc. and across AdWords accounts. Other Advanced Search views that I use are:
- Zero Conversions
- 1+ Clicks
- QS <=4
- GDN Campaigns
- CTR <1.0, Imp>500
- Avg Position>5
- Disapproved
You’re mostly only limited by your own creativity. Most common metrics are available as criteria and it’s fun to select multiple criteria to see what floats to the top (or in the case of poor performers, what sinks to the bottom.) Note: you can only save up to 8 custom advanced searches to re-use in AWE views, so choose the ones you use most often or can use as a base to fine tune with column sorts.
AdWords UI – Keyword Filters
You don’t need to be in AdWords Editor to use Filters to work your PPC magic. In the Keywords tab in the AdWords web UI, you can create and save lots of different filters that can help optimize or improve an account. Just go to the Keywords tab and open Filters.
Below are just a few of the many ways you can set up keyword filters. (Personally, I would never have all of these criteria in just one saved filter; this is just to show some possibilities for filters you might find helpful.)
_After your filters are set up and saved, you can adjust the date range and optimize from there. Quick changes can be made right in the UI, or for more involved edits you can download selected items, make your changes in Excel, and then upload into AdWords Editor (or into your third party management tool).
Now that you’ve got your keyword filters set up and saved just the way you like them, you can go to the Ads tab and do the same thing.
AdWords UI – New Home Dashboard
Recently AdWords launched a new version of the Home dashboard that allows you to use Google-created Modules or customize your own Modules based on your Saved Filters. (Don’t worry – if you love the previous version of the dashboard you can still toggle between the old and new versions, at least for now.) For the example below, I created a saved filter for keywords with quality scores of 4 or lower. Then I can select that Saved Filter to display on my Home tab dashboard every time I log in.

Once you have custom modules set up, you can click “View Saved Filter” for each module from the Home tab, and go directly to the appropriate Campaign, Ad group, Keyword or Ad filter, and do what you need to do to get the job done in just a few clicks. Pretty smart, pretty efficient.
While much of data analysis in pay-per-click marketing is science and statistics, there’s definitely an art to setting up and using filters for your AdWords account. There’s also an art to how you name campaigns or ad groups so you can set up useful filters. Also, filters can be VERY account specific. A reasonable filter for one advertiser might be ridiculous or just irrelevant for another. With experience, you’ll definitely get a feel for the filters that work on most campaigns and then can mold them for your account’s unique needs.
Spending a little time testing some filters out and playing around in Editor and the AdWords UI can save you tons of hours in the long run. Trust me. The less time I have to spend downloading CSVs and then manipulating columns in Excel, the better.
***********************************
Lisa is a data driven online marketing enthusiast and Senior Client Manager at Point It, one of the Pacific Northwest’s largest search marketing agencies. Lisa leads a team of account managers on a large global brand account. Lisa has a deep background of online retail marketing, traditional advertising and market research experience, for large and small b2c and b2g growth companies.










