Excel Negative Keyword Tool

UPDATE: I created a NEW, better Excel Negative Keyword Tool

If you've ever wondered how to identify negative keywords in Excel, I'm about to give you a tool that will help you see which one-word, two-word and three-word phrases are associated with ZERO conversions in your account.  In other words, you will be able to identify those particular words within your keywords that are costing you a lot of money.

Someone recently asked me: "How would you automated identifying negative keywords"?

I was intrigued by the idea and started thinking about how to actually do it.

There are two problems when trying to automate negative keyword detection:

  1. Some keywords that are clearly negatives usually lack sufficient volume to identify using data.
  2. Ideally, the goal is to be pro-active rather than reactive.  A good algorithm would detect negative keywords BEFORE any significant cost accrues.

Unfortunately, my tool solves neither of these problems.  I haven't figured out how to identify low-volume negative keywords algorithmically.  I have theories but don't have the technology or programming skills to make it happen.

My tool can help you identify high-cost phrases that have historically performed at either a high CPA or have NEVER been associated with a conversion.  This can help you 'stop the bleeding' so-to-speak.

What further fueled my curiosity for automating negative keyword identification is that I came across a site called QueryMiner.  I tried it out and it did accurately identify words within my account that I knew were poor performing.  The issue I had with their tool was cost - it costs hundreds of dollars per month.

I'm not saying that this free Excel tool is better than QueryMiner.  But, if you don't have hundreds of dollars to spend per month on a tool that identifies negative keywords then why not give my free tool a try!

Download Now

Have questions? Leave a comment below!

Build PPC Campaigns Faster With

PPC Campaign Generator

Build PPC campaigns in 5 simple steps!
Simple enough for beginners, powerful enough for advanced users
Training videos and support
FREE stand-alone version of my Keyword Grouper software with purchase (Limited-time!)

3 Responses to “Excel Negative Keyword Tool”

  1. Joe October 18, 2012 at 3:58 pm #


    Great tool and a great idea. I added one step that is very useful. If you explode all of your search terms in to single words you can start to see trends that you could not see before. I can mail you the instructions if you want.

    • Jarad Collier October 22, 2012 at 1:28 am #

      Yes, please Joe! I agree, computing cost and conversions associated to a whole word vs a text string would be much more valuable but I didn't know how to achieve this in Excel. Do you have a solution? I would love to see it.


  1. Free Negative Keyword Tool for Excel - PPC Campaign GeneratorPPC Campaign Generator - December 18, 2012

    [...] is the new and improved version of my initial Excel negative keyword tool.  That tool was not very good because it could only identify strings, not whole [...]

Leave a Reply