Ian Fernando made a helpful post on his blog on keyword conversions. This hashes it out for affiliate newbies.
So my excel video did pretty good that I got emails to help with excel and keyword manipulation. I think I should get a job with the infomercial guy “The Video Professor!†So there were some emails on creating excel formulas on keywords and how to track and how to see conversion and all that stuff. Well Google AdWords gives you all that information, impressions, clicks, CTR, etc.
But I decided there were a lot of noobs out there that want to learn how PPC keywords work. There were emails where someone asked about how to determine CTR and CPC, I simply redirected them to the Google AdWords section or Wikipedia. What is the point of asking when you do not know the basics? I learned by reading and understanding how these functions worked, thus creating excel tools for my benefits.
Well since there are newbies out there that want to learn I decided to go ahead and create a simple Google Docs file for everyone to view and learn from. Everyone needs examples and actual tools to look at. Some people learn by looking while other learn by reading. I learn by taking what I read and just playing around and testing.
Check out Ian’s spreadsheet on Google Docs: http://www.ianfernando.com/suggests/keywordclicks.