How I Create A Site Blueprint From The Keyword List (MKL)
Just wanted to share my system of creating a site blueprint in the most time efficient way (that I have found so far) from the keyword list.
I’ll do this example from the SBI’s MKL (Master Keyword List) and how I work in Excel (or Open Office Calc) to organize keywords.
I’ll just show you an example based on one seed word – tennis, but the system is identical if you combine multiple vertical brainstorms from multiple seed words.
So here we go…
Step 1: Do a vertical Brainstorm of main keyword and Export All
Step 2: Import into Excel (Calc) and Save As .xls or .ods
Step 3: Sort by Demand (which is column B). Note – I don’t look at Profitability at all so I delete that column too. Feel free to use it though if it means something to you.
Step 4: Then I insert 3 columns on the left:
Step 5: I go through the list and pick out keywords for T2. I choose those with demand over 1000 and supply less than 1000 – and of course these keywords need to fit my site concept.
Since my tennis site focuses on instruction and mental game, I don’t choose “history of tennis” and similar keywords – but I could of course if I wanted – they are of course all related to tennis since they came from the tennis seed word.
I then Cut / Paste T2 keywords with demand and supply on the left side. See example how I moved “How to play tennis” and “Tennis Video” to the left.
Step 6: I delete the keywords that I surely won’t use and keep looking for suitable T2 keywords to move to the left.
If I see very similar keywords or those with both singular and plural versions I put them together – since the article will be optimized for both and I need to remind myself to include both versions in the title and the text – if possible.
I also try to move suitable T3 keywords to logical “parent” T2 keywords as I go down the list. This is the main work that needs to be done but this system allows you to cut / paste the keyword only once and when you’re done the blueprint will almost be done without any more work.
I’ve done just a few keywords in the above example to show you how the system works but of course you should complete all your T2 and T3 keywords.
One more tip: I usually build all my T2 pages first so that they show the basic site outline to the first visitors and they all serve me as a foundation on which I put more T3 pages.
I also build 3 to 5 T3 pages for EACH T2 before submitting my site to major directories. It gives it better chance of being accepted.
After that just keep adding T3 pages and links – and of course you may later come up with another T2 (or a few of them) and expand your site – which is no problem at all.