AdWords Tips

Deduping Keywords: How to Identify & Remove Duplicate Keywords from Your PPC Account

By Erin Sagin December 31, 2013 Posted In: AdWords Tips Comments: 19

Around this time last year, I had a pretty ambitious list of New Year’s resolutions cued up for 2013. I’m ashamed to report that I did not successfully complete a single item during the course of the year. In retrospect, my problem was that I set the bar far too high—I mean really, who loses 20 pounds and masters the Spanish language in only 365 days?—and as a result, I gave up pretty quickly. When it comes to managing PPC accounts, I face a similar problem. I tend to bite off more than I can chew and then get too discouraged to complete it.

This year, I’ve learned my lesson. I’m setting more manageable goals and am determined to complete them. The first item on my checklist is to identify and remove duplicate keywords, so I can start the New Year with a nice, clean account.

Why You Need to Clean Up Your Duplicate Keywords

It’s nearly impossible to maintain a PPC account that is free of duplicate keywords, particularly if you have multiple managers working in one account, or are frequently adjusting match types and account settings. Some advertisers even set duplicates intentionally, thinking that their ad will appear twice for the same auction. Do not be fooled by this common misconception. AdWords will only show one ad per advertiser for each search.

Believe me, duplicates are dangerous. Not only can they have a detrimental impact on your Quality Scores, but they can also cannibalize your budget. If you are bidding on the same keyword twice, both will be entered into the same auctions and you will compete with yourself, driving up your own CPCs. Taking some time to dedupe an account every few months is a critical (albeit rarely executed) activity.

There seems to be a lot of confusion among advertisers regarding what constitutes a harmful duplicate keyword. Let’s set the record straight—duplicate keywords can hurt your account if they are identical keywords with the same match types, targeting the exact same audience. There is one caveat to this definition, which comes into play with broad match keywords. Be cognizant that broad match keywords are duplicates if they contain the same words, even in different orders. For example, chocolate cupcake frosting on broad match and frosting chocolate cupcakes on broad match are considered duplicates.

When Is It OK to Have Duplicate Keywords in PPC?

There are some situations in which it is perfectly acceptable to have duplicate keywords. For example:

  • You can use duplicate keywords in campaigns set to serve ads to different geographical locations. This is a common practice, as many advertisers segment their account by region. In this case, it is fine to bid on the same keyword in each campaign, as they will never compete in the same auction.
  • You can use the same keywords in search campaigns and display network campaigns. Since these keywords will be utilized in different circumstances, they will not hurt your account performance.

How to Find and Remove Duplicate Keywords in Your AdWords Account

Identifying all duplicate keywords in an account may sound like a daunting task, but with a little AdWords Editor magic, you can tick it off your to-do list pretty quickly. Here’s all you need to do:

Step 1

First things first, if you don't already have it, download AdWords Editor. This is Google’s free, offline tool and a must-have for all serious PPC-ers (even if Larry thinks it’s eventually going the way of the dodo).

Step 2

Once you’ve downloaded your account, head to the Tools dropdown and select “Find duplicate keywords.”

Duplicate Keywords

Step 3

As we discussed earlier, different types of duplicates have different impacts on an account. Select exactly what types of duplicates you want to catch based on word order, match types and location. You can also filter out those in deleted or paused campaigns, which will clutter your list.

Deduping PPC Keywords

There you have it, my fellow PPC-ers—all of your duplicate keywords in just a few clicks!

Now, all you need to do is review the list and make some executive decisions. I recommend nixing or editing any duplicate keywords that are in the same campaign and have the same match type.

WordStream clients: Please note that, for the time being, you cannot run this deduping process through WordStream. However, WordStream Advisor will identify any duplicate keywords created within your work session and automatically delete them before your changes are posted live to AdWords.

AdWords Performance Grader




If you enjoyed this post, please consider leaving a comment.

Comments

Thursday January 02, 2014

Michael Bian (not verified) Said:

Thank you for sharing this informative article..

Thursday January 02, 2014

Erin (not verified) Said:

You bet!  I'm glad you found it to be helpful.

Thursday January 02, 2014

Simon Gare (not verified) Said:

Good article, never thought of the competing keyword raising CPC, thanks.

Thursday January 02, 2014

Erin (not verified) Said:

Hi Simon--don't worry,  you're in the majority!  The good news, this is a super simple fix to make.  Good luck!

Thursday January 02, 2014

Dana Tan (not verified) Said:

Hey Erin,

Thanks for te hepful and informative post! What a great way to start 2014. I manage two Adwords accounts bidding on about 6,000 keywords. I was able to de-dupe them in about 45 minutes. 45 minutes very well spent. Happy New Year!

Monday January 06, 2014

Erin (not verified) Said:

Dana, That's fantastic!  Told ya it was quick and easy wink.  Best of luck to you in 2014! -Erin

Friday January 03, 2014

AdwordsRobot (not verified) Said:

I think deduping is a good idea - even if it's just to have less clutter in your account. Are you sure the below is true?

>> If you are bidding on the same keyword twice,

>> both will be entered into the same auctions and you will compete with yourself

 

I though only one keyword per account is selected for the action.

Friday January 03, 2014

SEO Manager (not verified) Said:

What happens if you have multiple accounts due to billing rescrictions and management.   I still want to check for dupes accross accounts.

Monday January 06, 2014

Jorge (not verified) Said:

Excel will be your friend, download all the Keywords and use the conditional formating to find duplicate cells...

It takes longer than the Google Adwords editor but in this case you can check accros multiple accounts.

 

 

Monday January 06, 2014

Erin (not verified) Said:

Thanks for jumping in Jorge, that sounds like a good method!

Saturday January 04, 2014

Harry (not verified) Said:

Thanks for a great article but before I start the process are dupe keywords measured at Campaign or a Adgroup level. Is it OK to have some of the same keyword in different adgroups (especially with regard to broad match terms)? 

Monday January 06, 2014

Erin (not verified) Said:

Hi Harry, usually we consider a word to be a duplicate if it appears within the same campaign (and is therefore targeted to the same audience).  I wouldn't recommend having the same keyword in different ad groups, if they are housed under one campaign.  Hope that helps!

Monday January 06, 2014

Stephanie (not verified) Said:

Great post Erin Sagin! This is an awesome.

Monday January 06, 2014

Erin (not verified) Said:

happy to hear that you enjoyed it, stephanie!

Monday January 06, 2014

Matt (not verified) Said:

Hi there, This article has been great to read has some really good points on PPC techniques hope to see more from you in the future.

Thanks again,

Matt for Sulmax Marketing.

Monday January 06, 2014

Erin (not verified) Said:

hi matt, thanks for commenting.  glad you enjoyed the post!

Monday January 06, 2014

Niroshan Samuel (not verified) Said:

I have a doubt about the conclution. Could you please explain the statement that you made "both will be entered into the same auctions". How do you prove that? I have following questions

  • If my CPC goes up, competitor CPC also need to go up.
  • If my account has multiple duplicates then my CPC will sky high (Including competitor's duplicates)

 

Base on above questions I feel Google will select only one keyword from an account and will decide the CPC with the QS and BID, Competitor metrics. If you have clear facts that prove your statment then it will be a clear path to us.

 

Regards,

Niroshan

 

 

Friday January 10, 2014

Floral (not verified) Said:

Great post and amazing tips. The one thing which I want to add is we can also use software like deduplication software for identifying duplicated data and efficiently removing it.

Wednesday April 23, 2014

Ivan (not verified) Said:

Hi Erin,

We've created some RLSA campaigns which are duplicates of our existing campaigns except targeted to people who have already been on our site. Would you consider the keywords in this campaign as duplicates which would negatively impact the original keywords?

Thanks,

Ivan

Leave a Comment

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
 
Free Keyword Tool

Get thousands of relevent keyword suggestions - more,
faster, free!

Free Keyword Niche Finder

Discover profitable pockets of keywords for your
business.

Free Negative Keyword Suggestion Tool

Identify wasted spend before it happens and increase
your paid search ROI.

Contact Us | Company | Support | Site Map | Trademarks | Privacy Policy © 2007-2014 WordStream, Inc. All rights reserved.