In our last article we published our keyword research spreadsheet.

This article provides information on reading the keyword research worksheet.

Makeup of the Keyword Research Spreadsheet.

Our keyword spreadsheet is divided into 4 parts for each set of keywords.

Part 1 - the keyword and popularity (number of searches in the past month).

Part 2 - The exact match (as entered using quotes).

Part 3 - The general match, this is the most popular search type, the user types the search terms in to the search engine without any operators.

Part 4 - The in title match. How many pages include the search terms within the page title.

Using the Search Types to Select Keywords.

We use the Exact match and the in title matches to determine the number of sites that have some optimisation for the selected keywords.

The exact match tells us how many pages and the strength of the top 10 results for the search terms within the body copy.

The in title match at Google tells us how many pages have been optimised for the keywords using the important title tag.

This is useful when considering the keywords for our search engine optimisation campaign.

The general match is the way that most searchers use search engines. That is just entering the keywords into the search box without any operators (quotes, etc.).

Selecting Keywords from the Spreadsheet.

Selecting keywords from the list to target for the search engine optimisation of the page is now straight forward.

We are looking for a keywords with a high popularity and high KEIin the general match and a Google PageRank equal or less than the page to be optimised in the Exact and In Title matches.

In future articles we will be putting the keyword research into practice to optimise our web pages.

Barry Tedstone - ABT Permanent Link |