Keyword research calculations

5 replies
So for a niche I'm going to get involved in, I started doing some keyword research.

I've identified about 30 keywords that have decent search volume with low competition.

However, I wanted thoughts regarding two questions...


1) What do you guys do or think about keywords that when searched, have say 300,000 competing sites, but when searched with quotes, have like 1,000?

2) I've made an excel sheet of keywords, searches per month, google results, and google results when using "". Anyone have any cool formulas to maybe calculate a "value" number from these 4 columns? For example, (Results/Searches)
#calculations #keyword #research
  • Profile picture of the author TCrosby
    anyone else?
    {{ DiscussionBoard.errors[1745190].message }}
  • Profile picture of the author SPress
    Here's the simplest piece of advice:

    You can basically ignore how much "competition" there is, whether it be with or without quotes.

    If you want to be found, then you want to be on the first page of google. So, focus on that. Check out the top 10 for each keyword that interests you and see if the competition looks like it can be beat in an acceptable timeframe.

    Defining the acceptable timeframe is important as well. Some keywords can be had in a matter of days, and other can take months if not years to compete for.

    Bottom line though is to not let a number like 500,000 "competitors" scare you away. You'd be surprised at how often you can find weakness in the top 10 when you stop to look.
    {{ DiscussionBoard.errors[1745415].message }}
    • Profile picture of the author Groovy99
      THE TIME VALUE OF MONEY

      If you are persistent enough and have enough resources you can master nearly any keyphrase but the question is what is the best use of your time?

      I've ranked for keywords with millions of competing pages in SEO rich environments and keywords with 10,000 with non-existent SEO. It's often easy, trivial, to get the second on page 1 but the first requires more serious investments of time and money.

      If I had to do it all over again I would have rather done my first SEO work on a site that had 10,000 pages not because I could not get ranked but because I would have made more money sooner.

      I've bought my fair of internet marketing products. Its always seemed to me a central theme in the best ones that you should always pursue the low hanging fruit of SEO at the beginning. When you get up to doing it full time then you will be better positioned to go after the other offers.

      Patrick
      Signature

      Patrick
      "The business that considers itself immune to the necessity for advertising sooner or later finds itself immune to business."
      connecticut internet marketing - Get in, TAKE OFF!
      business card printing

      {{ DiscussionBoard.errors[1745579].message }}
  • Profile picture of the author harry12
    the keyword density in a a content should be in between 5-6% and you also need to do the search for finding the appropriate keywords.
    {{ DiscussionBoard.errors[1746517].message }}

Trending Topics