If you want to a top online businesses, plan first.
By this stage, you have already decided on your best concept and generated lots of keywords
We are going to use these keywords to plan the pages on our website. This will form your Website Blueprint. First please read Days 3 of the SBI Action Guide. Make sure you are familiar with the 3-tier structure before reading this page.
When I went through the SBI process for the first time I was overwhelmed with keeping track of all my keywords. Despite the theory, they did not always form a nice 3-tier structure the way they so easily did in the Action Guide. When you come to building your top online business you will find you need a system to keep track of everything.
Below are some of my ideas and how I put my Blueprint together. For every website I have done, I have taken a slightly different approach. I am getting better at it but have still to find the perfect solution.
I use an Excel Spreadsheet. I am assuming you are familiar with Excel. If not, use the Excel HELP or take the tutorials to do the basic things I suggest.
If you have an SBI subscription and use their invaluable BrainstormIt! software, export your Master Keyword List to Excel.
If you used Wordtracker directly, your only option is to export it to Excel.
When you have the definitive list of all the keywords you generated in one Excel spreadsheet, it is time to clean it up. I like to keep the data intact at each stage so I copy the entire worksheet and paste it into a new worksheet. Work on the new worksheet, keeping the original data intact. That way, you can always go back to it.
First, add a column to the far left. This is now Column A. Next, change the format of the columns containing numbers to display whole numbers, no decimal places. Then sort the data into alphabetical order.
Next, get rid of duplicates. It should be easy to run your eyes over the list quickly and spot them. When you see a duplicate, put a 'd'(or any letter or number) in Column A.
Next go to the top of the list and look at the keywords. Put a 'd' in Column A of any you want to delete. Delete ones which are completely off the subject, are nonsense or are too generic - top online businesses keep focussed.
When you are happy you have all the words you want to delete marked, sort the list by Column A. Highlight the rows that contain the 'd' and delete them.
Next, copy this data into a new worksheet. Sort it into Demand order.
I like to highlight the words which have a Demand between 300 and 3,000 AND have a much higher demand than supply. These are your 'best' keywords. Top online businesses will have a few keyowrds with demand in the low thousands and a lot in the hundreds.
Now you have your Keyword List, you can develop your Blueprint.
You now have a few options.
When you look at the list of keywords you start to pick out patterns and get a feel for a rough structure. In addition, you probably have an idea in your head about the different sections of your website. Between the keywords and your ideas, think of about 6 - 15 sections. Give each section a number.
Now go through each keyword and put it's 'section' number in column A.
Don't worry if you change your mind. It is common when really looking at the words to form different ideas to those you had when you started. More often than not, top online businesses start out as something else and evolve with planning.
When you have finished this exercise, you can sort the list by Column A. The keywords for each area appear together. Go through the list and put a couple of rows between each section. This is effectively your Blueprint. You just have to decide which one in each area will be used for the T2 page and which one is for the T3 pages.
You literally cut and paste! Change the row size to about 1 cm high. Set up your page to print the gridlines and print it out. Cut up each keyword so you have lots of strips of paper.
Now get some sheets of A4 or foolscap paper. Write each of the sections of your website at the top of a different sheet of paper. Lay the keywords out on the sheets of paper in the correct sections. When you are happy they are in the right place, tape or glue them on to the sheets.
You now need to decide which one will be the T2 page and which the T3 pages.
If you find that the keywords do not easily form a nice, neat blueprint and you already know what the sections of your site are, this method could work for you.
As you build your website, allocate the most appropriate keyword when you start each page.
This works well when you are re-developing an existing website and already have the content. You just need to allocate the best keyword and tweak the content for the Spiders.
If you can think of a better way, then do it. I have seen Excel grids which have the T2 keywords in the top row. The T3 pages are underneath.
It is easy to lose and forget what keywords you used and what the page was about when you build your top online business.
To help you, use more columns. I like to know if the keyword was a Tier 2 or Tier 3 page. I lik e to keep track of what the page was about of it is not obvious. I keep track of pages that I need to change. It looks something like this:
I can then clearly see all the information I need about the different areas of the site. This is particularly helpful when linking different pages together.
These are just my methods. Everyone has a different mind and wants to do things their own way. All I can say is that you need to organise and keep a track of things. So find a system that helps you to develop your top online business.