A Couple Of Great Affiliate Keyword Analysis Tutorials
Affiliate Tools, Beginners Affiliate Marketing Add comments
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.
January 11th, 2008 at 3:24 pm
[...] list using a tool such as Google Adword’s Keyword Suggestion Tool, there’s a great keyword video tutorial I posted about the other day that’ll show you exactly how that works and which also has some [...]
January 12th, 2008 at 9:13 pm
The vids are showing as not available anymore. Do you know where we might go to find them?
January 14th, 2008 at 12:53 am
thanks! for the mention! I hope this helps everyone with PPC
> jonathan – not too sure if Youtube is having issues currently – but you can view more videos of mine at youtube.com/iantrepreneur
July 30th, 2008 at 5:44 pm
So how does one go about getting this document from Google Docs then?
I’m not sure I’ve used that before and I can’t seem to find Ian’s name on there at all …
February 5th, 2009 at 12:35 pm
First of all, i love this site! I’m running through Ian’s superb keywords video step by step (I’m even using the same keywords – how lazy). The problem im having is when i download the .csv the ‘Approximate Average Search Volume’ figure is massive when compared to Ian’s. I noticed his where mostly around 0.40-ish. My figures in this columns range from approx 22 to 78000. Its the same case for the average search volume for the month also. Any help would be much appreciated!
Thanks
February 10th, 2009 at 12:50 pm
Excellent tutorials. I use Google’s Keyword tool at the moment and do something similar analyzing the competition and search volume – there’s no point targeting a heavily competative search term that doesn’t have a lot of traffic.