Keyword Analysis using SEMrush, GA and GKP

SEMrush is a competitor analysis tool with main focus on keyword research. You can get a FREE 14 day trial of it’s PRO account using the link or code provided here.

We also talked about another article which suggests different ways in which bloggers can profit from SEMrush and make money.

While researching SEMrush on the Internet, I found excellent blog posts that suggested, good Adsense Income generation techniques using its capabilities. Though the techniques are not new, and can be found on many SEMrush reviews, it gave me new ideas on “how to increase my online income” using various keyword research tools.

So for my case-study, I’m going to use SEMrush, Google Keyword Planner and Google Analytics.  I’m going to find high performing keywords in minutes for my website “healthdummy.org”. You can do the same research to find keywords in your market niche.

SEMRush Keyword Analysis

Just enter the site URL in the search box provided with SEMrush. It will display various data on the same page. But what we are interested is in “main competitors”. For example, my site produced 237 results. Click on “View Full report” to get the maximum benefit for one’s site.

How to do Keyword Analysis using SEMrush

Once you type a website name, the related organic competitors are displayed

In this report, the following data will be listed.

  • Domain
  • Competition level
  • Common keywords
  • SE keywords
  • SE Traffic
  • SE Traffic price
  • Ads Keywords.

So our main aim should be to target competitor’s keywords. We can take data for common and SE keywords. But the common keywords data is also available in Google Analytics tool in the form of “Queries”. The same data will be posted here. So that’s not much of use to us right now, if we are targeting a new keyword.

Better click on the number with the hyperlink under SE keywords column. For example one of my competitor was “wlsurgery.com”. There were about 38 SE keywords. Clicking on it produced another report.

Doing Keyword analysis using SEMrush

Once you click on the number link in SETraffic, you can find your competitors keywords

In this report there are various parameters like

  • Keyword
  • Pos
  • Volume
  • CPC
  • URL
  • Traffic %
  • Costs %
  • Com
  • Results
  • Trend
  • SERP source
  • Last update

In order to save time and do further analysis, just click “Export” button at the top of the report. This will transfer all the data for the 38 keywords into an Excel sheet which in .xls or 97-2003 format.

But before you do that you need to first find profit-driving new keywords to target your site. For example, most of the keywords found for this example were mainly related to “forums”. Since my site was not having it, it’s not much of use. You can also open another Google Spreadsheet and write down the targetable keywords in a column.

The easiest way to find gold nugget keywords is to play a small intuitive game. I found the following keywords to my taste.

  • gastric sleeve before and after pictures
  • gastric sleeve before and after pics
  • gastric sleeve pics
  • gastric sleeve before and after 2013
  • before and after gastric sleeve
  • gastric sleeve pictures
  • sleeve surgery before and after
  • gastric sleeve surgery before and after pics
  • before and after gastric sleeve surgery pictures
  • before and after gastric sleeve photos
  • gastric sleeve success pictures
  • before after gastric sleeve

Since I already wrote an article about “gastric sleeve”, I found these keywords useful. My assumption is that, if articles are written on these related keywords, there is a bright chance of one of the posts become popular or reaching the top ranks in Google.

Otherwise, you can just update the existing post with these keywords by sprinkling them here and there. But make sure, they look natural and not artificially inflated in the post. You don’t want the over-optimization penalty to cut profits into your valuable article and time.

A better way to collect the keywords is to find them from different competitors. For this  I clicked another competitor’s number under SE keywords column. This produced about 257 keywords. Just simply export the data for further research.

Now if you want to target high CPC keywords, just sort that particular column in the ascending order. For example, “gastric bypass price” has a CPC of $28.44.  If you want to target keywords with high traffic then sort the “Volume” column in ascending order. Similarly you can play with other parameters like Competition, Traffic %, Trend, Results etc. For any help of any term, just hover over it.

Keyword Analysis for Google.com using SEMrush

Different data being displayed for a particular keyword for Google.com database

Reveal High Performing Keywords using Adwords Keyword Planner Tool

Since I wanted to target the above keyword for my new post, I’m taking this one and using the Google Keyword Planner (GKP) tool to find further more keywords based on this. When you enter that particular keyword and click on “Get Ideas” you get further suggestions to this one. Just click the “Download” button to export the list of keywords in Excel CSV format.

Keyword Analysis using GKP

When you type a keyword, you will get related keywords

Then you can hide the unnecessary data in the downloaded sheet. Just have these 4 columns.

  • Keyword
  • Avg. Monthly Searches (exact match only)
  • Competition
  • Suggested bid

Now each blogger’s aim is different. Some may target high CPC keywords, while some with high Volume, while some other with low competition. For the current example, I choose to target by volume. So in the Excel sheet (2013), click on Sort function and do the rest. But I found that many of the keywords were having competition from advertisers. So I resorted to sort by competition in the ascending order.

Keyword data downloaded from GKP

Using Excel sheet, you can sort your keyword data based on a parameter

Then I found 2 more keywords.

  • vertical banded gastroplasty
  • duodenal switch

Why I choose these Keywords?

Because the competition level for both of them was below 0.25 and the suggested bid was above $2. Normally for small bloggers and beginners, it’s best to target less competitive keywords and having average suggested big. Where to draw the red line is dependent on the niche, blogger’s perspective and one’s goals.

Generally I prefer to target keywords with volume between 500 and 2000 and having CPC more than $2.

Keyword Analysis using Google Analytics (GA)

Now the last weapon in the armory. You need to use the Google Analytics (GA) tool connected to Web Masters Tool (GWT). This is for the reason, organic keywords data is no longer provided for users logged into Google accounts or using encrypted search. But we can use the “Queries” data found under Acquisition > Search Engine Optimization.

Now I enter the search term “gastric bypass” and click on the search icon. Now I found 22 more keywords for which my website is already ranking in the search engines. I sorted based on Impressions. Then I found 2 other keywords.

  • gastric bypass before and after pics
  • gastric bypass pictures

Why I selected these keywords?

There were having more than the normalized impressions of 5. Also their average position in the SERPs were very large. So if I target them, one of the many posts I’m targeting for specific keywords will rank well.

Conclusion

I just have to implement this case-study and see if I can generate good traffic and revenue. Since this depends on many factors like off-site optimization, on-site optimization, on-page optimization, title, keyword research, backlinks etc. it’s hard to say whether my assumption will succeed or not. To know the results, stay tune to my blog and subscribe to my feed and you will get the updates.

About the Author

Palla Sridhar (a.k.a Palla Ramarao) is a Tech Blogger. Completed Masters in Civil Engineering from IIT Kanpur, INDIA. Presently working as Associate Professor. Worked with various Tech Blogs and very well versed with SEO benefits. I research the Internet for SEO articles and write posts for layman's understanding. Palla Sridhar on Google+

Leave a Reply 1 comment