Joseph Kershbaum at SearchEngineWatch penned two great articles on Automated Rules for Google AdWords. Everyone should use automated rules, but getting started is kid of intimidating. Here are two articles that can help break the ice:

Part I: http://searchenginewatch.com/3641760

Part II: http://searchenginewatch.com/3641909