SEOClerks

How to determine Value of a Keyword - Part 2



Enter a reason for deleting this comment

How to determine Value of a Keyword - Part 2

Finding high paid keywords and using them in your site comes under e-commerce search engine optimization. So, when you are determining keyword value, you are doing SEO for your site ! In part - 1, https://www.seoclerks.com/forum/th...ord-part-1.2676/, I shared a way to determine value of a keyword. In this part, end of duology, I'll share customized way to choose high paid keyword. You can manipulate and use it as per your requirement. Also, note that the procedure which I'm going to discuss is not as accurate as procedure which I shared in part - 1 of this series. So, choose a method based on your requirement.

How to determine Value of a Keyword - Part 2

Before discussing customized way to discover keyword value, let me list down pros & cons of this method over standard way.
How to determine Value of a Keyword - Part 2

  • Pros:
    1. Free : It is free ! You don't have to invest, even a penny, when you are using this trick to find keyword value.
    2. Familiarity : In this method, we use familiar tools like google analytics, MS excel or google spreadsheet, etc. to choose a keyword over another.

  • Cons:
    1. Semi - Automatic : Finding a relatively high paid keyword is not completely automatic. I mean it doesn't involve simple mathematical calculations to find a high value keyword.
    2. Tedious : Here we will deal with more than one tool, so managing and switching among different tools can confuse you.


    To start implementing customize way, you need google analytics, rank checking tool (rank checker plugin, for firefox), wordtracker and google spreadsheet or MS excel. Without further delay let me start sharing the procedure to determine keyword value,
    1. High Traffic keywords : Gather list of at least 500 keyword which brought highest amount of traffic to your site over past few months. You can gather this data from google analytics.
    2. Make a List unique keywords : Import all the keywords in a excel sheet. Remove duplicates, if any, from excel sheet. You can use manual way or some filterto do it.
      How to determine Value of a Keyword - Part 2

    3. Give a score : Give a score to every keyword on a scale of 10, 10 being highest. You have to give score based on ranking of your site on a search engine for that particular keyword. For example, if my site is ranked in range 1-10 for a keyword then I'll give it a score of 10, if my site is ranked between 11-20 then I'll give it a score of 9.5, and so on. I've used histogram/bucket technique, but you can use any techniqueto give assign a score to a keyword.
      How to determine Value of a Keyword - Part 2

    4. Export & Merger result from Rank Checker : Rank checker has limitation of exploring 100 keywords at once. So, grab first 100 keywords and put it in rank checker plugin. Export the result into some excel/csv file. Repeat this procedure until you finish exporting results of all keywords from rank checker. Merge them into one file.
      How to determine Value of a Keyword - Part 2

    5. Find number of Searches : Import all the keywords you got from google analytic into wordtracker tool or any tool which gives number of searches done across the globe and export the result into another excel sheet. The result will have number of searches for a keywordon google.
      How to determine Value of a Keyword - Part 2

    6. VLookup : Do a vLookup (more info about vLookup @ http://office.microsoft.com/en-us/...52093351033.aspx) in excel sheet which has result from wordtracker for a keyword one after the other
    7. Keyword Value : Once you have result from wordtracker, multiply that number with the score (step 3) you gave to that keyword. The result of this multiplication is your keyword value!!
      How to determine Value of a Keyword - Part 2


    What do you have to say about this method ? Let me know your views through your post. Note that, the keyword value which you obtain is not absolute keyword value. The value signifies which keyword will yield more profit. If the keyword value is higher and you use it often then it will maximize your profit. Make sure you don't overuse a keyword which has high value, otherwise it might be considered as keyword stuffing by search engines. So, use the tricks I shared through this tutorial optimally by using your brain ! How to determine Value of a Keyword - Part 2

Comments

Please login or sign up to leave a comment

Join
angie828

Great post on keywords. This does come in quite handy.




Are you sure you want to delete this post?

loulou

Very nice post. Good job.




Are you sure you want to delete this post?

evie

Shek, love that first SEO photo. LOL.




Are you sure you want to delete this post?

blueeyes

Keywords are something that I do not know a lot about so thank you much Shek.




Are you sure you want to delete this post?

tionna

Very nice post. Useful info for sure.




Are you sure you want to delete this post?

tangee

Keywords are something that many have struggled with so this will be handy for many.




Are you sure you want to delete this post?

Miken34

Thanks for this posting. It was an awesome read.




Are you sure you want to delete this post?

evie

Wonderful work you have provided us.




Are you sure you want to delete this post?

haleystar

tank you




Are you sure you want to delete this post?

twilight

Thanks for this wonderful and informative post.




Are you sure you want to delete this post?

ralph101

Great and informative post you have created.




Are you sure you want to delete this post?

mandy

Great post Shek!




Are you sure you want to delete this post?

uhacks

great post buddy




Are you sure you want to delete this post?