Jaaxy Keyword Scores Once Again

bySteadfast61

317 followers

6 years ago

Well, I think I've got this sorted now. Perhaps this exercise should be saved for a post about the difficulties of writing a blog post in WA. So, here goes again:

We are taught here at WA that the use of Keywords is vital to the success of our website posts and pages. We are also shown how to use Jaaxy and what the keyword scores tell us. That is:

Avg = The average number of searches the keyword receives per month. For this, the figure should be >50

QSR (Quoted Search Results) = The number of competing websites ranked in Google for this exact keyword. For this, the score should be < 100

KQI (Keyword Quality Indicator) = This will be revealed as either Great, Normal or Poor

SEO (Search Engine Optimization) = A score based on traffic and competition, the higher the score out of 100, the more likely you will rank for this keyword on the first page of Google.

My particular niche is Options For Seniors To Make Money Online and I have entered a number of Keywords into Jaaxy for it and some examples of the results are:

But which keyword will give me the greatest opportunity of ranking in Google? Which score carries more weight? How can I tell?

I have come up with a formula that works for me and which you may find useful too:

• The first step is to only accept those Keywords with the Jaaxy KQI of “Great”. Eliminate every other keyword. (If that doesn’t leave you with any Keywords or very few then you need to find better ones although you can still perform this activity on any list of keywords);
• Save those Keywords into a Jaaxy Keyword List and then Export the list to Excel (or similar) as a CSV file;
• In Excel, add the following column headings alongside the Jaaxy downloaded list:

Then, on the first line under each of the new column headings insert the formulae as follows:

• Copy each line's formulae to every line that holds a Keyword
• Sort the data for Total Score, Largest to Smallest
• The list will then be in the order that the Keywords are most likely to be successful:
  

For those of you interested in my algorithm it is:

- Avg Score = the actual data in the Avg Monthly Searches column;

- Because the QSR needs to be lower than 100 - the lower the better - the QSR Scorewill be valued at (100 minus the actual QSR recorded). So, a QSR of 1 produces a QSR Score of 99. Any QSR over 100 will produce a negative answer;

- QSR/Avg Score = Divide the QSR Score by the Avg Score. This reflects the number of websites receiving the actual number of searches each month. (So, for example, 6 websites receiving 50 searches a month will be obviously better than 100 websites receiving 50 searches a month. It is not so clear however if you compare 6 websites receiving 50 searches a month against, say, 9 websites receiving 87 searches a month)

- SEO Score = The actual data in the SEP Power column;

- Total Score = SEO Score x QSR/Avg Score

The extrapolated Total Score is then your best guide to the Keywords with the greatest opportunity of ranking.

I hope this all makes sense to you. Please let me know in the comments if you need clarification of any point or, even, if you disagree with my findings. Otherwise I wish you well with it.

Adrian