Table of Contents
So, SEO is DEAD.
Yeah freaking right!
But, there are a lot of solid considerations that force those of us who self-identify as SEO’s to take a closer look at what we’re really doing…
One thing is for damn sure, now is not the time to give up on search rankings, and for one big reason – search rankings still equal money.
But now, thanks to SEMRush, there is a much, much easier path quickly find out where you should be focusing your SEO dollars.
Find High Search Volume Keywords You Already Ranking For
Then optimize from there. Sounds simple right?
Well to be honest, the analysis is really simple, but increasing sustainable organic rankings, ehh not so much.
But let’s take a look at how SEMRush gives us all the data we need to at least identify and prioritize these keywords.
Go fire up your SEMRush account, don’t worry if you don’t have one – it’s free to create and use (up until a point).
Once you get there (and have created and account, and logged in), enter your domain in the search box:
For the purposes of demonstration I’m going to look at my friends website; www.FreeToursByFoot.com
Click Search, then scroll down to the “organic keywords” section, and hit the “Export” button:
Once clicked, you will get 3 format options > Choose XLS (Excel):
Now it is going to download the data, and once this has finished – open up your new file in Excel.
Initially it is going to look like this:
Not the sexiest of files, but with a couple formatting tweaks we’ll be in good shape:
- View > Freeze Panes > Freeze Top Row
- Highlight Row 1 > Bold + Underline + Data > Filter
- Delete column C (Previous Rank) Since this is important for this exercise
- Sort new column C (Now Search Volume) ‘Largest to Smallest’
- While column C is highlighted > Conditional Formatting > Color Scales > Green – Yellow – Red
- Highlight column B > Conditional Formatting > Color Scales > Red – Yellow – Green
Your file should now look like this:
Notice anything in Column B?
Those are your biggest opportunities, from top to bottom, color coded by current ranking; the darker the green, the higher you currently rank.
So looking at the screenshot above, we can very quickly see that my friend’s biggest keyword opportunity is to increase her ranking for the keyword washington dc tours, where she currently ranks 7th in Google, for a keyword with over 12,000 searches each month.
How Freaking Easy is That?
Stupid easy right?
So if you haven’t yet – go create an SEMRush account right now and run through this process.
Once you have identified which keywords are both qualified and deserving of your time, i.e. they have sufficient average monthly search volume (I like to use 1,000 searches/month as my baseline), next you need to figure out the SERP level competition, develop your keyword-level content strategy, and begin the process of acquiring high value (*cough* contextually relevant *cough*) links.
Leave us a comment if you have any more questions, tips, or hacks on how to improve this 5 minute analysis.