Improving seo google's special way

Improving SEO Google’s “Special” way

Lucas Hall UX

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

I’m going to start broad. Divergent ideation, or more commonly brainstorming, is all about generating new ideas. The first things I’ll need are keywords that I can analyze and that have something to do with what I’m doing with this article. In the Google Keyword Planner, I search using the phrase “search engine optimization generating traffic blog article”. I realize that it isn’t exactly correct grammar. It was “search engine optimization for generating traffic to a blog article like mine“, but it was too many words, so I stripped out the extra fluff.

Screenshot of Keyword Planner

Screenshot of 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.

Transforming keyword data - seo google and google seo?

Transforming keyword data – seo google and google seo?

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…

Top 10 keywords to look at deeper - seo google?

Top 10 keywords to look at deeper – seo google?

2 – Converging with Google Trends: SEO Google?

Google Trends is relatively new to me, but I imagine that it will be really helpful. While I can learn a great deal from spreadsheet already, I’ll actually be able to compare them all the terms against each other. Upon looking deeper, I can see that “google seo” and “seo google” are the same from a trends perspective. I can also see that “seo tutorial” and “seo optimization” may be decreasing so I’ll want to exclude those from the list. Based on this data visualization, it’s really between “seo google”, “best seo”, and “wordpress seo”. I try to stay as honest as possible, so maybe I won’t use “best seo”… After all, I’m certain that this isn’t the best blog out there on SEO. “Google SEO” and “WordPress SEO” seem to be the group I want to target with this blog.

Google Trends for my top 10 list

Google Trends for my top 10 list

Share link via: