Jaaxy Keyword Scores Once Again
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
Recent Comments
5
Jaaxy provides so much solid data that you really don't need the extra equations and formulas. Here's a great walkthrough by Jay to show you exactly how he uses Jaaxy. I've found it really helpful and there's no need for spreadsheets that may complicate things a bit. Jaaxy 2017: A Walkthrough by Jay
You're so right about the quality of Jaaxy, Eric, but just sometimes I need a bit more help in making keyword choices and feeling comfortable knowing which ones to try to rank for.
We are so lucky having such a tool available to us here at WA.
Adrian
Makes things easier on yourself and simplify where you can :) Use the 50/50 rule or 100/100 rule and you really can't go wrong. QSR less than 50 with traffic over 50, or QSR less than 100 with traffic over 100. When you see two keywords with roughly the same traffic, just choose the one with less competition.
See more comments
Hello Adrian,
Thank you for such a thorough break down of Jaaxy and your formula for Excell. I have to admit I was a bit lost when you went into Excell, I have a Microsoft office version 7 - an antique by today's standards. But I received the package when I started college and have stuck with it. I don't remember how to use the formulas, we were taught that, but the Dummy books I bought seem to be more for those who already know what they are doing and just need a few tips. Definitely not for the lost..... LOL.
I am going to reread your post to see if it makes more sense to me. Thanks again for all of your information and help.
Blessings,
Rae Anne
Thanks Rae Anne. Let me know if I can explain things further for you.
Adrian