Today I decided that I’d spend some time looking around to see what some other bloggers are doing to determine what they might write about. That’s when I ran across some concepts aimed at improving SEO Google’s “Special” way using couple tools that are freely offered by Google: Google Trends and Google Keyword Planner. This blog is more of a historical record, or a testing of my hypothesis. My hypothesis is that I can use the two tools to generate topics for writing about–topics that perhaps will elicit more traffic. The test subject will be this article.
1 – Divergent Ideation Using Google Keyword Planner
My search returned something like 700 records. I could tell immediately from looking over the interface that Google has provided me that I’m not going to have the control I need to transform the data to something that will help me in my decision to select keywords that will improve traffic to this article. Therefore, I downloaded the data in comma separated (CSV) format so that I can pull it into Google Sheets and begin transforming it.
Transforming the data
4 columns make up the most useful data for my decision for this article…
- Keyword column isn’t that helpful right now. We’ll be looking at this later.
- Average Monthly Searches is just what it says. The data that comes over in the CSV file is a bit difficult to work with, but is still valuable.
- Suggested Bid is going to tell me how much value marketers are putting on the keyword combination.
- Competition is showing how many other bloggers are using the keyword.
2 NEW columns will help me get a better feel for the data…
- Word Count shows the number of words in the keyword combination that appears in the keyword column above. I’d like to keep concise, and if I can find a combo that is low in word count, but meets my other criteria… that will be much better.
- Monthly Search Level was created because the data in the Average Monthly Searches column isn’t very easily to work with due to the naming that Google used. I’ve assigned a number 1 through 5. 5 being the most searches down to 1 being the least. This column will allow me to sort by most down to least.
The data transformation ended up looking like this screenshot. You can see that I start by listing the keywords that received the most searches at the top of the list, then I listed the word count so that the least words are at the top and the most at the bottom. Next, I listed the suggested bid from highest down to lowest with the assumption that the marketers setting the values know what they are doing. Finally, I wanted the least competition at the top down to the most.
Narrow the list to my top 10
To get to my top 10 list, I first started by eliminating some from the top: “SEO” is too vague, “search engines” seemed off topic, “seomoz” doesn’t seem to have anything to do with what I’m doing, and so on. I worked my way down. At the end of my subjective hunting and pecking, I ended up with this list…