How To Implement a Keyword Strategy

How To Implement a Keyword Strategy
This guide was originally offered for purchase in 2015, but now as some of the examples have gotten dated I’m publishing it here, for free. The goal is to provide a framework for how to approach actually implementing a keyword strategy.

Before you begin, in order to get the most out of this information – the following assumptions must be met:

You’ve completed thorough keyword research for your website and market, analyzing the data I recommend for carving out keyword targets; namely you’ve dissected page one rankings on Google and have identified at least 100 low hanging fruit (LHF) keywords.
Page 1 Position – This is a number ranging from 1 to 10 showing the current
Ranking URL for each position on the first page of Google. For each keyword in your list there should be up to 10 rows in your spreadsheet.
Keyword – the keyword you’re targeting
Monthly Search Volume – pretty self-explanatory, but the average monthly search volume for the keyword in column B.
Word Count – the number of words on the page for the URL currently in this row’s ranking position.
Keyword In – One column for each of the following binary keyword inclusion points;
Domain – Is the keyword in the domain?
URL – Is the keyword in the URL?
Title – Is the keyword used in the page title?
Headers – Is the keyword used in any of the header tags on the page?
Domain Links – The number of total links to the domain.
Page Links – The number of total links to the ranking URL.You have a spreadsheet with the following data;
You have a basic working knowledge of Excel and are familiar with (or are at least willing to figure out) how to use super basic functions like sum and average, as well as being able to turn on Data > Filter and performing some basic sorting within your data columns.
All good on the assumptions?
If not, get started on your keyword research right now:

If so – awesome! Here we go.

Prioritizing Your Keyword List
While going after the giant volume head terms is the shiny object that usually lures people into SEO, more times than not these terms end up being prohibitively difficult and end up setting you p for disappointment.