Well, it’s time to get back to work folks… and what better way to start your new year than by getting organised with your keyword strategy?

A nice chap called Ian Fernando dropped me a wee line recently to see if I might be interested in taking a look at a tool he had created to help work out which keywords are converting within your PPC campaigns. He’s created this tool with newbies in mind, but I reckon a lot of people would find his excel-based solution useful.

Whilst I was fiddling around on his site I found another great video tutorial in which he explains how he uses Google’s Keyword Research Tool to identify potential keywords and then uses excel to analyse them to work out which search terms are likely to deliver traffic at a reasonable CPC.

They say you learn something new every day… and I must say I liked how he was using the Google data. I’m a bit more of a seat of the pants gal myself (but then you sort of get a “feel” for keywords after a few years!). I think this tutorial is an excellent look at how to get your keyword strategy organised.

Once you’ve gotten your keywords into a nice PPC campaign, you’ll be needing to analyse them to see how your precious PPC spend has fared. Ian has come up trumps again with this great video tutorial on how to work out which keywords are bringing in the bling: -

Even better, Ian has uploaded his great spreadsheet to Google Docs so that you can log on in there, have a good old fiddle about with it and chat with other users (possibly the man himself as well) about how to use it.