How To Tidy Up Your Negative Keywords
April 24, 2013
The unending wisdom of Martha Stewart tells us that “there are few rites of spring more satisfying than the annual clean.” In that spirit, PPC Hero’s April series will cover some aspects of your accounts that are worth a good cleaning. Structure, ads, negatives and more will all be covered.
Negative keywords are an essential part to any PPC campaign. Combing through Search Query Reports to exclude the irrelevant, poor-performing, and occasionally bizarre query is probably one of the highlights of my week. For example: I’m currently auditing an account that makes use of the broad match terms “cats”, “in”, “price”, “sale”, and “parts” in the same ad group. Imagine that search query report.
That being said, it’s easy to get lost in the minutiae of negative keyword management when you’re adding them in at the ad group level on a regular basis. That’s why it’s a good idea to audit your negative keyword list every once in awhile to look for trends, common negatives, and terms that might be better suited to be campaign-level negatives. It’s a surprisingly easy process – and we’re here to remind you how it’s done.
1) Clean Up Your Ad Group Negative Keywords
To start, you’ll want to download a Negative Keyword report for your account at the Ad Group level. Depending on your management style, it may be slightly overloaded with embedded negatives – but that only impacts the length of the list, not the method we’ll be using to examine the prevalence of negative keywords throughout the account.
Using this data, create a Pivot Table using the Negative Keyword as your Row label, and Count of Ad Group as your Value. The result should look something like this:
This is a decent enough snapshot that details the prevalence of negative keywords throughout the account – so for a quick analysis, that should be enough. However, depending on your Ad Group naming structure, this top-level analysis may not be enough for your needs. If you have duplicate campaigns targeted to different geotargets, or still have your mobile campaigns running un-Enhanced, this isn’t going to help you that much.
To that end, I usually like to add a Campaign modifier above the “Negative Keyword” Row Label. This is more of a preference, but it can help guide your decision making process, answering the question “I need to add campaign-level negative keywords, but to which campaigns?”
For the record, here is the result:
Using this breakdown, you have a little more direction to go on when it comes to our next step. If you’ve got a few really common negative keywords, it might benefit you to transition them to Campaign-level negatives using the process outlined above. This isn’t going to work for every instance of duplicate negative keywords, but it can give you a good idea of how tidy your negatives are. That’s the whole point behind spring cleaning, right?
2) Kick It Up a Layer – Campaign Level Negatives and the Negative List
This is a pretty simple tip – just follow the exact process outlined above, but using your Campaign-level negatives. It’s a handy trick to see if you should just make a negative list and apply it to your campaigns. You can download a Campaign-level negative keyword report from the same section of the interface that you got the previous report. Here’s the result, featuring another Pivot Table:
If you’ve got the same Campaign-level negatives applied to seventeen different campaigns, you might just benefit from making those in to a Campaign negative keyword list. It’ll make your life easier, after all.
3) Organize (and Sanitize) Your Broad Match Keywords
This last tip is a method for you to examine just how much control you have over your search queries. Depending on your account structure, you’ll have varying levels of control based on your match type strategy. But this is a quick method for you to see just how well you’re directing your traffic.
Download a Search Query Report and run another Pivot Table, this time selecting “Search Term” as your Row Label, and “Count of Ad Group” as your Value. You can also make some modifications of your own – throwing in Campaign, Match Type, etc. above Search Term in the Row Labels field as you please. Much like the last two tables, this gives you an idea of how many ad groups are gathering impressions for each query you come across:
Now, call me crazy, if you have a single query showing up across 10 ad groups, you might have a problem.
However, this runs in to the previously-mentioned issue regarding campaign structure – duplicate ad groups and different targeting settings can lead to this outcome by design. Luckily, you have the option of double-clicking on that row for a detailed breakdown of which Campaigns and Ad Groups the query triggered:
Auditing your broad match keywords can feel like a game of whack-a-mole at times, so you can use this method to better direct your time and efforts in funneling traffic exactly the way you want. Alternatively, you could just use modified broad match keywords. But then you wouldn’t get the joy of queries like “I am try to put on a resume that I baled hay by hand how would I say that professionally?”
Regardless, depending on what you find in this report, you can then start adding in negatives as needed to tidy things up.
What about you, PPC Heroes and Heroines? Do you have a favorite method to keep your negative keywords in line? Have you found success with broad match “cats”? Let us know in the comments and, as always, thanks for reading!
How Should You Use Display Advertising?
We hear similar questions from clients on a regular basis. One question we hear often is “How do your other clients use Display Advertising?”
Expanded Text Ads: 7 Million Clicks Say They’re Underperforming
Over the past 6 weeks, we have been lucky enough to experiment with expanded text ads, and frankly, I’m not impressed with their performance.
£300 Off Hero Conf London Ends Tomorrow!
Time is nearly gone to reserve your seat for Hero Conf London, 24-26 October at etc.venues St Paul’s, at a huge discount off the regular conference rate!
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Expanded Text Ads Come To Google AdWords Editor
Advertisers have been able to create expanded text ads, but couldn't utilize AdWords Editor. That has now changed with the release of the latest version of AdWords Editor.
Bidding Farewell to Adwords Converted Clicks: Don't Panic
AdWords will soon be saying goodbye to the "Converted Clicks" metric. Learn more about what this means for your account and how to prepare for the transition.
Olympic PPC Ad Strategies
How spectators consume sporting events and a massive expansion in the digital space will prove to shake up who and how advertisers reach their audiences.
Hanapin's PPC Resources Are Now Ungated!
You can now access Hanapin's whitepapers and toolkits without having to fill out a form!
View Ad Creative Through The Eyes Of Your Searchers
Learn to understand that ads do not live in the vacuum of an excel sheet and common practices should be tested.
[New Webinar!] 11 Red Flags To Watch Out For When Working With An Agency
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
How To Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.