Create a Master Keyword List

Creating a master keyword list is a very important step in having a profitable online business, keywords help with SEO (search engine optimization), pagerank and building traffic to your website.

Creating this list will help you in researching, collecting and organizing your keywords. Your entire site, including its most profitable directions, lies in selecting and using the right keywords.

The best way to develop your master keyword list is to have a brainstorm session and start writing down everything that comes to your mind until you have a sufficient amount of keywords to work with. Here are some great tools to help with your keyword researching:

Once you have these tools you are ready to begin building your master keyword list. Try and get as many keywords as possible right now, we will refine and tune the list later. Think of every keyword that you can that is related to your site concept. Even try using misspellings when finding keywords. Misspellings actually get good numbers when it comes to searches.

I recommend that you create your Master Keyword List in either a simple text file or via a database or spreadsheet program. A database or a spreadsheet will speed things up and provide you with extra functionality.

If the idea of a database or spreadsheet scares you, simply stick with a text list. It’s a bit inefficient so it will take you a little longer, but it will do the job just fine. Whatever you decide, please, please, please...

Do use a Master Keyword List. It will evolve into the master blueprint for your entire site. If you follow these instructions, the site will almost build itself!

Google Keyword Research | Organizing Your Data

In this video you are shown how easy it is to export your data from Google Adwords keyword tool to an Excel progam.

Create a Form/Table for Your Keyword List Information

Create six columns and label them:

    KEYWORD - this is where you will enter the keyword itself

    DEMAND - this is how many times it is searched

    SUPPLY - this is your competition (how many sites also use this keyword)

    SUPPLY SITE INFO. - make brief notes in this column for the kinds of sites that each Keyword search delivers (in other words what kind of sites are your competition).

    POSSIBLE PARTNERS - as you are browsing other sites using the same keywords (competition) that you would like to use make note of any affiliates or products that they are promoting that you too could promote on your site.

    IDEAS FOR CONTENT - make brief notes on any ideas you may come across that you could write about for each keyword.

Here is an example of how your Master Keyword List should look...

handmade jewelry 90,500 2,320,000 See NOTE
  NOTE: “handmade jewelry” is too general. Don't bother researching this word for products/services. The real opportunities lie in the niches, in topic keywords that have more specificity..
wire jewelry 60,500 550,000 information about tools, wig jigs, beads, different styles Artbeads Affiliate
making wire jewelry 6,600 23,600 tips, techniques, projects, videos Clickbank ebooks
wire wrapping jewelry 9,900 18,900 instructional techniques, projects, tools
silver wire jewelry 2900 27,200 types of wire, guage, gemstones, patterns
Master Keyword List

Add as many notes as you like for SUPPLY SITE INFO, POSSIBLE PARTNERS AND IDEAS FOR CONTENT COLUMNS. I’ve kept it very brief here, since it is only an example.

Windows of Information

When brainstorming for a topic and finding great keywords to use in your master keyword list, there are three windows of information that you will be researching...

    1) DEMAND:

    The demand for keywords is the number of times a particular keyword is searched via the Search Engines. The more times it is searched the more popular it is. This will give you a good idea of what your potential visitors want. In other words, if a keyword is searched often then you know it is a subject that lots of people are searching to find information on.Don't be so quick to delete those keywords that have low demand and even lower competition for. Even if there are at least 50 - 150 people a month asking the question - you can become an authority of it. You don't have to write a book - just several quality paragraphs about this topic. Also, once they arrive at your site they will quickly see all the other GREAT info you have to offer them.

    You can easily find your DEMAND information from any of the FREE Keyword Search Tools.

    2) SUPPLY

    The supply for keywords is your competition. In other words, how many sites already provide content for each of your keywords.

    I will show you how to use this tool below under “Researching Your Competition”.


    The profitability of a keyword is measured by how many sites already provide content for a particular keyword verses how many people search for it. A low profitability keyword would be one that has a huge amount of supply compared to it’s demand.

    For example, “handmade jewelry has a demand (search) of 90,500 and there are over 2,200,000 websites and blogs providing information regarding that keyword (supply). Therefore, “handmade jewelry” is too general, you would have a hard time competing for it with the search engines. The real opportunities lie in the niches, in topic keywords that have more specificity.(i.e.: wire jewelry, polymer clay jewelry, bead jewelry, hemp jewelry, etc.)

Researching Your Competition

Type in your keyword (with quotes) into the search box. To see how much competition there are for the keyword “wire wrapped jewelry” (with quotes).

Make note of the "total number of results" just under the Google search box. This will give you an idea of how competitive the phrase is. Repeat this process for each keyword on your list and then compare the numbers among all your searches.

This specific search yields this information… About 67,000 results for “wire wrapped jewelry”. You will find this information just under the search box. This is the amount that you will enter under SUPPLY column.

Repeat the same process for each of your keywords that you listed in your DEMAND column. Yes, seriously, do a search for each keyword. It is a bit tedious, but the research will pay off in the end. Unless you pay for a keyword search tool such as Wordtracker ($59/month) or Brainstorm It! (Wordtracker is included with Site Build It! so you can get both for one price $29/month), there is no other way to find out how many sites use each your keywords.

This tool is also great for researching information for your SUPPLY SITE INFO, POSSIBLE PARTNERS, and IDEAS FOR CONTENT columns.

Review Your Competition (SUPPLY) Sites

In the search results (from above “Researching Your Competition) click on the sites and start exploring.

Review as many sites from these results as you like. I’d suggest at least the first 10-20 sites. But you may find merchants in need of traffic help (i.e., you!) deeper down.

As you get into this in-depth research, you’ll notice three types of sites...

  • irrelevant -- for whatever reason (off-topic, geographic, lousy site, etc.), they just don't fit. Skip these.
  • merchant -- in POSSIBLE PARTNERS, enter what kind of merchandise they sell. If they have an affiliate program that fits your concept, enter the URL of the “join page” for the affiliate program of that merchant. These are indeed potential merchant-partners for you.

    Even better, you’re automatically organizing the POSSIBLE PARTNERSaccording to each keyword. This means that you are already pre-planning each Keyword-Focused Content Page’s “in-context” text links and setting the groundwork for the “M” (Monetization) stage.

  • content -- these sites are your direct competitors. They make money through affiliate programs, too. And good news! They’ll speed up your learning curve by giving you a lot of information. Why? Because they've already done a ton ofwork for you!
  • Here’s what to do...

      i) As you review these content sites, you may get some great ideas for content on your own site. Enter these ideas into the IDEAS FOR CONTENT column.

      ii) Browse the site, drilling down into the content. Click on the banner ads and text links, following these links out to their destinations to see what kind of merchants they have chosen as affiliate-partners. Or perhaps it’s a straight advertising deal -- make a note of these merchants as potential advertisers, too. If a given merchant fits your concept and has an affiliate program, enter the kind of merchandise it sells, and the “join page” URL, as you did just above.

QUICK TIP: It can be a tedious pain to look for a link to a merchant’s affiliate program. Some home pages are quite crowded. Here’s how to find it quickly:

  1. See if you can find reference to it with a quick scan of the top, left and bottom navbars (graphic or text links). If not
  2. Do a quick find on the home page. Press on the control+f keys on your keyboard (command+f if you are using a Mac). Then enter “affil” (the first few letters is fine and reduces chances of a typo) into the box of the window that pops up. Try also for “assoc” (short for “associate”) and “refer” (short for “referral” or “referrer” program).
  3. Use their search tool or online support chat (if they have one) or 1-800 line, or send them an e-mail. If they don’t have an affiliate program, ask if they are interested in buying pay-per-click advertising (more on selling pay-per-click advertising a bit later in this discussion)If you still can’t find it after that, forget it. They probably don’t have an affiliate program.

QUICK TIP: You will tend to find merchant sites via the engine’s “directory listings” and content sites by reviewing the top 20+ search results.

Continue on for the remaining keywords, until you have completed all six columns for all of your high profitability “wire jewelry”-containing keywords. Expected results?

  • lots of good content ideas for the site

  • some good leads to merchants who could need pay-per-click advertising from you a bit later

  • a few merchants who have affiliate programs

Refining Your Keyword List

In this part we are going to discuss refining and tuning your keyword list and analyzing keyword profitability. By now you should have a huge list of keywords related to your site now lets chop it down to get really targeted.

Your DEMAND column search generated many “site-concept-containing”keywords, along with the DEMAND (popularity or # of searches) for each keyword.

Your SUPPLY column search revealed the number of sites (i.e., theSUPPLY of sites) that provide information about each keyword, as well as a lot of leads to possible merchant-partners and even some ideas for content.

Now it’s time to pick the keywords with the best profitability. These will be the keywords with high DEMAND (i.e., tons of searches) and low SUPPLY (i.e., not too many sites found).

Eliminate any words that appear too competitive (i.e., SUPPLY is too high in column #2 or bidding competition is too intense), especially if they are not searched upon very often (i.e., DEMAND is low in column #1). And especially if there do not seem to be many POSSIBLE PARTNERS for them!

Bottom line?...

Your best keywords should have HIGH DEMAND and LOW SUPPLY.

This is a rough protocol, so don’t become a slave to it. Follow these two general guidelines...

    1) Eliminate only the worst combinations of high SUPPLY and low DEMAND and low number of POSSIBLE PARTNERS.

    2) When you’re ready to write your site, start with the keywords that have the best combination of high DEMAND and low SUPPLY (especially the ones that you really enjoy and know!) and a good number of POSSIBLE PARTNERS. As you start to see patterns for the kind of sites that appear in your SUPPLY SITES and POSSIBLE PARTNERS and IDEAS FOR CONTENT notes, you’ll refine your Site Concept. Ultimately, you’ll create Keyword-Focused Content Pages that...

    • fit with your final Site Concept
    • And...

    • have a good SUPPLY/DEMAND ratio
    • And...

    • have a good number of POTENTIAL PARTNERS
    • AND that...

    • you enjoy writing about.

Always do your homework look at the numbers that come up with your keywords dont get to hung up on them, but you should take them into account. Solo Build It and Wordtracker are two great tools for finding keywords and analyzing them. You want to make your keyword list as targeted as possible with little competion and good demand. Look for quality keywords that can contribute to your site not quantity. Quantity keywords may bring in traffic but most wont convert to sales, quality keywords will.

Always remember keywords are a big part of a profitable online business, they are the reason for traffic finding you, so don't cut corners.

Don't Stress Over The Numbers

Be careful. Don't fall into the trap of stressing over the numbers that you have entered into your master keyword list. I've found that people want to interpret how successful their site will be solely based on these numbers. It's impossible.

Use these numbers as guides. Remember, there is no such thing as a perfect topic that has excellent demand (high # of searches) and little supply (sites targeting that topic).

Keep in mind that...

SUPPLY and DEMAND numbers are still merely gross guidelines that point out some interesting big pictures. Make your brain the ultimate judge.

No single keyword, no matter how profitable it may calculate out to be, makes or breaks a business. The overall quantity and quality of all your pages are, ultimately, what makes your business snowball and gain momentum. The money (i.e., your income) is in C T P M...

Develop a wide variety of different keywords, and then build Keyword-Focused Content Pages (KFCPs) that deliver high-value information. Those pages attract and PREsell targeted visitors, who then click through to your merchants andother sources of income.

Keywords Are Vital To e-Business Success

Important Note...

Always remember keywords are a big part of a profitable online business, they are the reason for traffic finding you, so don’t cut corners.

I can’t over-emphasize the importance of your Master Keyword List. Your entire site, including its most profitable directions, lies in this blueprint. please do this. If you find creating your own list (with a database or spreadsheet program) to be too daunting, and if a text list is too awkward, consider SBI!’s Brainstorm It! tool.

A powerful automator, work-organizer and time-saver, it makes the entire master keyword list child’s play.

How? It does the demand, supply and profitability for you automatically, turning hours of work into minutes, as it builds and researches an entire master keyword list for you. it even calculates the profitability of every keyword automatically. It’s Find and Sort functions turn it into a powerful, high-yield tool.

Click here for more detailed information on Brainstorm It! In this article I explain the power of Brainstorm It!, how to use it and show you the results that these brainstorming tools provide to help build a successful site full of great keyword-focused content pages.

Master Keyword List Master Keyword List Master Keyword List

Return to top of Create a Master Keyword List
Return to How To Build a Jewelry Website
Return to home Page

New! Comments

Have your say about what you just read! Leave me a comment in the box below.