Example 1 - [US State] Weight Loss ($2159.69/Month Keyword)

For this first example, I purposely selected a smaller list, because I wanted to validate the effectiveness of this method. 

After the initial "Keyword List Comparison" check, I Manually checked the Top 10 Results ALL Keywords in this list, to see if I would have missed out on any Favorable Keywords by using our method. 

So first, I searched for a list of all the US States.

I found a list of exactly 50 States to work with.

[US State] = Variable 

Next, I need to think of a suitable Keyword to append to each State. 

Examples: 

• - [US State] Cancer Lawyer 
• - [US State] Chiropractor 
• - [US State] Gym Trainer
• - [US State] Real Estate 
• - [US State] Auto Dealer 
• etc... 

I recommend that you explore Keywords/Niches which you have some Experience or Knowledge in. 

Good Content is what Google is looking for, it's what they prefer to rank higher in their SERPs. 

You're going to be able to provide better Content or Services in something you have experience in.

I just picked "Weight Loss" from the top of my head. I do know a lot about Fitness and Weight loss, but I'm not going to personally try to Rank for that niche now, I'm just doing this to provide a live example. 

So now, pasting my list of 50 US States into our Keyword Results Tool, I make use of the "Add Suffix" Function. 

I typed " Weight Loss" into the Lower-Right box, and press "Add Suffix", to append that phrase to all my Keywords. 

(Notice the extra space " " before "Weight Loss", for separation)

I Copy and Paste this list into Google Adwords Keyword Tool: https://adwords.google.com/o/KeywordTool

Since we want to focus on US Traffic for these Keywords, we select "United States" in the Filter Options. (It didn't make a difference in this case, because the Global and Local results matched) 

Once your list of keywords is processed, Download the "My Keyword Ideas" Speadsheet after selecting your results. 

Press: Save All > Download > My keyword ideas > CSV for Excel > Download 

After opening the CSV for excel, you should Save it in .XLSX format to Preserve Formatting.

This is what my Spreadsheet usually looks like after formatting: 

I usually: 

- Trim out some unneeded Data 

- Paste the Number of Search Results for each Keyword in a new column 

- Then in another column, I apply the Formula given earlier in this post: 

(Search Volume / Search Results) x 100 = Keyword Value 

To get the "Number of Search Results for each Keyword", we use the Keyword Results Tool. 

To get certain Columns in those fancy colors (Green to Red), I use the "Conditional Formatting" Option in Excel. 

Once the Speadsheet is finished, it's now time to start examining it to find Potentially Lucrative Keywords. 

I usually start by examining the "Keyword Value" Column. 

This column has the most important metric for comparison, since it takes into account both the Volume of people searching for that Keyword and the Number of Results for that Exact Phrase in Google (which is a Slight Indicator of the Competition Level). 

The Conditional Formatting Color Scale will help you to pick out more quickly, which Keywords have a higher KWV. 

Start from the Highest KWV going downwards. 

Examine the Top 10 Search Results for Each Keyword Manually, as I explained earlier.

You can make a little rating scale in a new Column, which says how difficult the Competition is. 

Your scale can be "0 - 10" "No Competition" to "Impossible" 

Whatever you choose. 

It's just a good way of keeping note of your progress. 

For my examples, I'll use this scale: 

No Competition - All PR</acronym> 0 Results 

Very Easy - Mostly PR</acronym> 0 Results, Especially in the Top 3-5 Results 

Easy - Mostly PR</acronym> 0-1 Results, Especially in the Top 3-5 Results 

Normal - Mostly PR</acronym> 1-2 Results, Especially in the Top 3-5 Results 

Anything over Normal (Hard, Very Hard, etc...), I exclude from consideration of targeting those keywords. 

I may also mark Keywords with No Search Volume as N/A. 

They are not applicable to our study, because it makes no sense trying to rank high in SERPs for a keyword with 0 Search Volume. 

Search Volume = Potential Traffic

Keep note, that for my ratings, I try to look at the "Average PR</acronym>" for all 10 results on that page. 

For example, there may be 6 x PR0 and 4 x PR3 in a SERP. 

In this case, "Most" of the results are PR0, but the "Average" PR</acronym> is above 0. In such a case, I may consider the Competition level as "Hard" or "Very Hard". 

So just use your own Logic and Reasoning when doing this. 

There is No Perfect Formula when it comes to this. Also, note that I am always taking into consideration, the number of Backlinks each result has (even though I didn't mention that in the scale above). 

As I begin going through my Top Prospect Keywords for "[US State] Weight Loss", I come across this one that seems very Favorable to me:

Between positions 6-10, you will find One PR4 Result, and Two PR2 Results.

Not to worry though! 

The PR4 and the Higher PR2 don't even have "Texas Weight Loss" in their Page Title, so it won't be very hard to overtake them in the Top 10 Results. 

It is EXTREMELY IMPORTANT to have the EXACT Keyword you are Targeting, in your Title Tag.