I am currently trying to plan how to optimize my site based on keywords. I read and I understand site architecture and usability http://www.seomoz.org/blog/site-architecture-for-seo , but I am still somewhat confused about how to target each keyword per page or when
http://www.seomoz.org/img/upload/splitting-keyword-targeted-.gif
Let me give you an example. We build databases for SME's using 3 different technologies. One of them is MS Access.
Based on PPC campaigns and keyword research some of the possible keywords might be
ms access programmer
ms access consultants
access database experts
According to the link provided, should these be separate pages? I feel if they were, our site nativigation would be cluttered and clients would not be benefiting from them at all. It might even lead to some redundant data which I believe is bad right? My feeling is to make one page and target one keyword, but I'm not sure.
For example, see one of our top ranking competitors
http://www.justgetproductive.com/content/access-programmer/index.php
Please, look at the footer? Is that actually how I should structure my links? I hope the answer is NO! Then again, if I do just have one page targeting one keyword, what do I do about the others? Do I just try to use blog posts/articles addressing those keywords? Do I not target them at all?
Thanks for any advice, please keep in mind I am just getting started. My approach is to create a plan to outline everything before I put a lot of time into it.
