Keywords for Your Blog – Filter Your List of Keyword Down to Size

Please Comment

Keywords for Your Blog – Filter Your List of Keywords

Filter the Keywords for Your Blog

Filter the Keywords for Your Blog

This is the third in a series of posts about keywords for your blog.   In the first post, Keywords for Your Blog- A Realistic Approach, I talked about how keywords are important for bloggers, but they are not the end-all that they are for niche marketers. Bloggers provide useful information to a niche group.  Niche marketers hammer a few pages with backlinks to rank on a very few keywords.  In the second post, I talked about Keywords for You Blog – Create a Massive List of potential keywords.  Now we are going start to pare the list down to something you can use.


  1. Develop a list of potential keywords for your blog.
  2. Use one (or more) of the phrases from your list.
  3. Do On-Page SEO
  4. Promote your post.

The Steps were covered in a little more detail in the first post.   We are still working on step 1 here.

Paring Your List of Keywords for your Blog down to Size


We are going to use Market Samurai here.  This tools is well known and does cost $97.  You can download it and try it for free for 12 days.   What most do not know is that the Keyword Research Module is FREE forever.  It continues even after your trial period has expired.

Create a Project in Market Samurai

The first step is to create a new project.

Enter your keys words and then click on the Create button.  You can leave the rest alone.

market Samurai

On the next screen you select the Keyword Research Module.

TEACHING TIP:   Market Samurai costs about $100.   They give you a 12 day free trial.   The Keyword Research module is free forever.

market Samurai-1

The first time you use this module, it will ask for you Google Adwords Account information.  It needs this information to get the best results from the Google Keywords Tool.


market Samurai-2


The Keyword Research screen is where we enter our lists of keywords.   Market Samurai will automatically remove the duplicates.  It will also remove the broad, phrase and exact versions leaving just one unique long tailed keyword per line.

Copy and Paste

We are going to copy and paste keywords into the box on the left indicated by the red arrow.  These words will move to the right column and the count will increase after you press the “Add Keywords” button.


This is where you go to the folder you used to save your CSV files full of keywords.   Clicking on the first one should open it in Excel (or another spread sheet program.   I use this set of key strokes:

  • Click on the A1 cell (the one in the upper left hand corner of the spreadsheet)
  • Press CTRL-A  (to select All Cells
  • Press SHIFT-Left-Arrow three times until use the left column is highlighted
  • Press CTRL-C to copy the highlighted column (or right-click–>Copy)

This is how the spreadsheet looks when you start.

Excel-Open cvs list


After the CTRL-A (and dragging the right side of the first column – in the header line – to the right to make it wider) the screen looks like this.


After the Shift-Left Arrow presses, you end up with just one column highlighted.  CTRL-C to copy the column and change to the Market Samurai screen.


Paste them into the box on the left and then press the “Add Keywords” button.   Then you need to CRTL-A and Delete to clear the box for the next set.

Rinse and Repeat until you have entered all of your CSV files into Market Samurai.


I also do a CTRL-A and DELETE to clear the “Add Keywords” box above after I have pressed the “Add Keywords” button.

In the next screenshot, you can see I have 14,289 unique keywords

TEACHING TIP:  I tried with about 20,000 keywords and Market Samurai never finished.   There is a limit.  It probably has to do with how much memory your machine has.  Just be aware.

market Samurai-7-new

How Competition here differs from the Google Adwords Keywords Tool

TEACHING TIP:   Competition means different things in different places.   It is critical that you understand the difference here.

In the Google Adwords Keywords tool “Competition” means “how many people are paying for this keyword?”

Here “Competition” means “How many web pages are competing for the top 10 spots in Google Searches on this keyword?”

Once you have clicked on the Keyword Analysis Button, you will see the screen below.


We are going to look for keywords that meet two criteria:

  • We do NOT want keywords that have many, many webpages competing for the keyword.
  • We do NOT want keywords that have virtually no one searching for the keyword.

As the red arrows below show, I’m asking for at least 30 searches PER DAY and fewer than 60,000 pages to compete with.  Then I press the button at the bottom.


market Samurai-8-new


Can I really compete with 60,000 web pages?

TEACHING TIP:  There are many “duplicate” pages (according to Google) on the Internet.  Here is how to tell how many pages you are actually competing against.

I’m going to do a search in Google for the keywords “Online Lead Generation”.  Here is the results:

Google Search1

That is 137,000,000 results.  Can I really compete?   Note at the top, I have shown you the keywords that were searched for.  They are separated by plus signs and have an ampersand after them.

Replace everything after the ampersand with “start=990”  (Note the lower case.)   This is what it looks like.

Google Search2


The 137,000,000 still looks the same.   However if you scroll down the page, you will see this.


Google Search3

Okay.  Maybe I can compete against 800.!


Export the Full List of  Keywords for Your Blog

Once you have your keywords entered, it is time to Export them, Save them and start to Analyze them.


Lets look what the Keyword Analysis Button gives us.

market Samurai-9-new

This shows that Market Samurai has taken the 20,000 keywords and found that only 1378 actually met the criterion of having at least 30 requests per day and less than 60,000 pages with that keyword on it.

There are still quite a few of these that I can’t reasonably compete for.  We’ll look at how to find out which one I can compete for in the next post.

 We are almost there – Finding Keywords for Your Blog That You Can Compete for.

Until next time, you have a Great Day!

Dr Hale

↓ ↓ If this post gave you some ideas – Go ahead & comment below.  ↓ ↓

Hale Pringle

Hale Pringle Ed. D.


Hale Pringle – Hale Yes!

Skype hale.pringle



P.S. If you are working to move your business online and it all seems overwhelming, I can help!  Take a look at, or sign up for the free coaching call. You can email me or give me a Skype call. I’ll give you the benefit of my years of experience and many thousands of dollars in training and searching the rabbit hole called Internet Marketing and Network Marketing. I can help you with Lead Generation, the feeling of overwhelm, blogging, and even career change. Add that to the finest mentoring on the Internet (Ann Sieg’s Team and Inner Circle) and you have a Winner!

Print Friendly, PDF & Email
About Hale Pringle

Dr. Hale is an Internet Entrepreneur and Network
Marketing expert. His greatest pleasure is
helping people and he does just that, drawing
upon the immense resources that he has gathered
over the years in his unquenchable thirst for

Dr. Hale lives in beautiful, sunny Florida with
his wife, two dogs and a cat. His four children
are grown and are scattered around the state.

An eternal optimist you will hear him say
regularly: “Is this a Great Day?” The answer is
always, “Hale Yes!”

If you need help with your online marketing or a
network marketing opportunity Dr. Hale is the go
to man. “Hale Yes!”


  1. I’m crazy about this blog. I have visited this website so often. I
    discovered this website on the internet. I have received an excellent stuff of information. Many thanks.
    Shelley recently posted..ShelleyMy Profile

  2. Annabell Moya says

    Excellent article – I Appreciate the info . Does someone know where my business would be able to find a sample a form form to work with ?


  1. […] post Keywords for Your Blog – Filter Your List of Keyword Down to Size appeared first on Hale Pringle | Online Lead Generation and […]

  2. […] third post showed you how to use the FREE section in Market Samurai to take the massive list of  Keywords for Your Blog and Pare it Down Now we are going start to analyze the list to look at competition and find keywords that you can […]

  3. […] third post showed you how to use the FREE section in Market Samurai to take the massive list of  Keywords for Your Blog and Pare it Down    The fourth post looked at how you can analyze the competition for you keywords to see which […]

Speak Your Mind


CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.