Here is a nifty little SEO Tip for mapping out keyword clusters and their corresponding landing pages (within your own site or your competitors) using a combination of the link graph mining tool SEM Rush and Microsoft Excel.
Data Mining SEO Tips Using SEM Rush
Many of you may be familiar with this SEO tool from its originating debut years ago under the name of its predecessor SEO Digger (because it mines a website’s on page and off page link profile), but even since the evolution, the new and improved SEM Rush still has one familiar feature…
That distinguishing feature is that you can enter individual URL’s into the search bar and see how many keywords are driving traffic to a page based on its relative position in the top 20 results of Google. This means that you can put any page you like under the SEO microscope to unravel site architecture and link relationships in a matter of minutes (using the technique below).
If you truly understand the invaluable insight this tactic can provide for your own optimization efforts in addition to a method to reverse-engineer your competitor’s keywords and respective landing page relationships.
This is one instance of the link graph leaving an indelible mark can work for you or against you. Essentially, acquiring any keyword caught in the cross-hairs is only a matter of (a) enough topical content (b) enough trusted links (c) a great unique selling proposition and (d) enough time to build trust and momentum, before a top 10 position becomes a comforting reality.
For those unfamiliar with the context of SEO, keywords and their respective rankings for websites are by the page, so, this type of tactical intelligence can provide immense leverage in tackling multiple keywords in a commerce-driven volley for supremacy.
Instead of a rubber match with competitors, having the ability to peer behind the veil at which pages are targeting what can help you find unthought-of of lucrative keyword combinations.
The SEM Rush Deep Link / Data Mining Technique
This technique is like letting your competitors do all of the hard work for tracking actual effective keywords, and all you have to do is add their URL into a query in SEM Rush and hit search. *Please note that a premium account is required to unlock all of the data.
Enter the domain (or page in SEM Rush)
Next, download the excel spreadsheet so you can inspect the individual page / relationships in greater detail.
Export the Keywords Using Excel Icon
Then, sort Column H from A-Z and Delete Column D-G so you can focus on keywords and stemmed phrases all going to the same page, then look for which keywords correspond to each respective landing page.
Then you can sort and color coodinate landing pages and keywords
This allows you to determine (a) how many keywords that page ranks for and (b) a rough estimate on the percentage of traffic that page receives from that keyword. Between downloading the excel spreadsheet, sorting the URL column from A-Z. , you can discover keyword stemming and / or keyword clusters associated with each page.
The REAL VALUE is being able to add individual URL’s to the tool to extract only WHAT THAT PAGE ranks for (not just the standard blanket URL default)… The idea is to use it as a gauge to determine how far you have to go to reach a top 10 spot. Used in tandem with NicheWatchor SPYFU you can essentially zero in on a keyword and find how your pages stack up against other known or unknown competitors.
You can also determine how their site architecture may be aiding or impeding their SEO based on the volume of keywords and the spread of anchor text referring to their pages from off page augmentation.
This also allows you to track the inbound link profile of a page and determine where they are getting their most powerful off page push as well. This video on how to discover your competitors keywords provides more detail on how to implement that SEO technique.
Although this is not rocket science, it is a useful tactic that you can add to your SEO toolkit for competitive research and analysis. We hope you enjoyed this post, if you like what you read, then share it with others and pass it on…
This is a great tool. But the ideas you present are even greater and effective. Thanks for such a relevant post. It comes at a good time for me..
Danny
Thank you very much. This really gonna help us building great pages for competing keywords. Thanks for sharing. I like the article than the tool you have explained..!!
Thank you very much for the article I will now go off and practice the tips you have given
Cheers for this very interesting
Hey,
You have explain steps very well.
Like your SEO Rush.
Thanks