Shawn Collins' Blog

Affiliate marketing and other stuff from Shawn Collins, co-founder of Affiliate Summit.

  • Home
  • About Shawn
  • Contact
  • Learn Affiliate Marketing
  • Disclosure
  • Archives

Keyword Conversion Primer for Affiliates

January 5, 2008 by Shawn Collins

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.

Share this:

  • Twitter
  • LinkedIn
  • Facebook
  • Reddit

Related

Filed Under: Affiliate Resources

Shawn includes advertising links in some posts - these do not influence the content, and they promote products and services he uses.

Social

  • View shawncollins’s profile on Facebook
  • View shawncollins’s profile on Twitter
  • View shawncollinsatx’s profile on Instagram
  • View affiliatetip’s profile on Pinterest
  • View shawncollins’s profile on LinkedIn
  • View affiliatetip’s profile on YouTube

Blogroll

  • Affiliate Manager
  • Austin FC
  • Austin, TX Airbnb
  • Bose Hearing Aids
  • Extra Money Answer
  • Movies That Affected My Life
  • This is Affiliate Marketing

Return to top of page

Copyright © · Shawn Collins Consulting ·