|
Search Engine Optimisation Training Course
Lesson No.3 -
Refining Your Keywords
by Bruce Gow Search Engine Guy Pty Ltd http://www.searchengine-guy.com.au
Its time to use the Keywords list that you built in the
last lesson and begin to sort our keywords into themes.
Sort Your Keywords by Search Volume
Copy your keyword list into another spreadsheet with just the “keywords” and
“Search Numbers” columns as the picture below:

The easiest and quickest way to sort your keywords is by using the filter
function of Excel.
Your keyword list should now be sorted from the keywords with the most search
volume to the ones with the least search volume.
We now are going to create a new spreadsheet with 4 columns based on their
search volume and copy our keywords in each of them accordingly:
• Over 50,000 – The main keywords for your site should be within this category.
• From 10,001 to 50,000 – The keywords that will define the different categories
for your site should be within this category.
• From 3,001 to 10,000 – This category should contain potential primary keywords
for your posts or pages on your site.
• Less than 3,000 – This category should contain potential secondary keywords
for your posts or pages on your site.
Theme Creation for Your Site
Look at the list of Keywords you have in your second category, and group them
thematically as follows:
Through this process, we just found out what are the main categories of our
site.
Now, if you look a bit closer to the list, you’ll see that it is possible to
refine it a bit more. I took away company mentions of American firms such as
Orkin Pest Control. Unrelated terms such as Pest Control software should
be removed unless you intend to sell software on your website.
As there seem to be a lot of searches for different
pests, these should go into a theme of their own such as just "Pests".
Termites should be a theme for Termite Control, Termite Treatment, Termite
Inspection etc. Ultrasonic and electronic Pest control would have there
own as well, even though I don't agree with certain types of equipment that have
exorbitant claims. This will be dealt with later, it is important to make
mentions of these items as they are very common and popular keywords.
This is not a complete list, but a it is a great start. We now have a gross
overview of what content should fit under each category for our site.
In the process of adding more keywords under the
categories, you may come across some keywords that don’t fit in any of your
primary categories, at this point; you may just have to create a new category
just for them or consider whether or not they really are relevant to your site.
Exercise
Today’s task will require brainstorming by yourself and company key staff or
friends and family. Sort through and delete any mismatches and create
themes on the most important keywords for your website.
If all is well, by the end of the day you should have
all your keywords sorted in such a way that you already have an idea of what
your site structure should be since you already know your main theme, your site
categories, and the primary content for each of those categories.
1. Learn How
to Sort Out the Competition
2. Do
Your Keyword Research Homework
3. Refining
Your Keywords
4.
Evaluating Ranking Difficulty 5.
Mapping Your Site Structure 6.
Understanding Links & PageRank
7. Sculpting Your Site Structure
8. Cascading Style Sheet
Design 9. Using Wordpress
for SEO 10.
Setting up Your Analytics 11.
Engineering the Title Tag 12.
Optimising The Content 13.
Optimising The Description Tag 14.
Building Internal Links 15.
SEO & Images 16.
OnPage Analysis Using IBP 17.
Link Building 101 18.
Beating Your Competition 19.
Building External Links 20.
Using Structured SEO
Bookmark this on Delicious
Can't find what you're looking for? Try the Google search bar!
|