Aaron Wall, the man behind the curtain at SEOBook, has updated one of his ultra helpful tools for your PPCers out there. The tool, called Bad Keyword and Number Stripper, will help you take those long keyword lists you pull from services like Wordtracker and scrub them for keywords and numbers that you don’t want included. As someone who has hand-scrubbed countless keyword lists, I highly recommend using an automated solution like Aaron’s.

Using the tool is pretty simple. First, make sure you have a keyword list. Second, go to the stripper tool’s site. Third, enter your keyword list into the “keyword list” section. Next, enter in keyword terms that you don’t want included in your list. This could include numbers, or off topic words (like “cattle insurance”), or swear words (like…well you know them). In our case, this could also mean trademarked terms that we don’t bid on like AARP, GEICO, Gerber, and GMAC. Once you have them all entered, you hit the “Clean Me Up, Scotty” button (nice touch) and viola! You have a clean keyword list.

Big ups to Aaron for providing this tool, and thanks to Danny Sullivan for pointing out the tool on the Daily Searchcast.

[Semi-related but unrelated note: Make sure you listen to yesterday's Daily Searchcast - Matt Cutts co-hosts with Danny - pretty cool.]

Related posts:

1. Keyword Playground - Another Great Tool at Webconfs.com I just used the Keyword Playground tool over at...
2. Rapid Keyword - 31,000 Keywords in 5 Minutes The same affiliate who suggested the Keyword Tumbler suggested a...
3. SEOBook’s Super Ninja Tool of Keyword Destiny It’s been a while since a tracked down a new...
4. Pick Up Some Low Hanging PPC Fruit with the AdWords Keyword Tool I’ve been playing around with the Google AdWords Keyword Tool...
5. Affiliate Must Do - Listen to the Daily SearchCast If you are reading this blog right now, you...

Related posts brought to you by Yet Another Related Posts Plugin.