in SEO Tips by Jeffrey_Smith

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

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)

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

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

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… 

Read More Related Posts
Glitch? New Algorithm? Amnesia? Who Knows...
What happened to the search results for SEO today around 1PM CST? I think at this point, only the Google engineers responsible for hitting the “scramble results for kicks button” ...
Traffic Sources, Vistors and Conversion
With all of the marketing jargon about sales funnels, sales cycles, message matching and utilizing enticing value propositions to encourage click throughs and conversions its easy to forget what proceeds ...
READ MORE ads Trend Data
If you are engaged in SEO and curious about which keywords are driving the most traffic to your website in Google, the SEO Quake team who brought you SEO Digger ...
Crucial Search Engine Optimization Tips
One of the primary objectives of SEO (search engine optimization) is to create structure and manage multiple layers and processes to create an optimal signal for search engines. One of ...
Google PageRank Update December 2009
Last night, Google has passed out a little page rank love with a recent update to kick off the new Google caffeine (bigger, faster, smarter) search engine initiative. For many of ...
There are two common dynamics that can play out when seizing the SEO window of opportunity in your market. You are either  (1) the most relevant / grandfathered search result ...
Do Your Landing Pages Have First Rank Priority?
You have heard of first link priority right? I prefer the take of Andy Beard on this one...which is test it first and then test it again and again, but ...
Don’t Let Broken Links and Errors Devalue SEO Efforts
When making viable shifts to your website or site architecture, here are a few things to take in consideration that can affect existing SEO. Like Murphy 's Law, anything that ...
There are 3 nodes of relevance to integrate holistically into an internet marketing campaign to ensure a healthy, robust online presence; those nodes or rather prerequisites are SEO, Syndication and ...
5 Things You Should Know About SEO
With SEO being all the rave right now, here are five things to keep in mind before engaging any SEO campaign. Search engine optimization is about setting realistic goals within respectable ...
Search Results for SEO Experience Technical Difficulties
Alternative Traffic Sources: Diversity and Conversion
SEO Tool SEM Rush Adds New Keyword Trend
Crucial Search Engine Optimization Tips
Happy New Year’s Page Rank Update
Seizing the SEO Window of Opportunity
Are Your Landing Pages Optimized with First Rank
Don’t Let Broken Links and Errors Devalue SEO
SEO, Syndication and Social Media
5 Things You Should Know About SEO

About Jeffrey_Smith

In 2006, Jeffrey Smith founded SEO Design Solutions (An SEO Provider who now develops SEO Software for WordPress).

Jeffrey has actively been involved in internet marketing since 1995 and brings a wealth of collective experiences and marketing strategies to increase rankings, revenue and reach.

8 thoughts on “SEO Tips to Spy On Competitors
  1. 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..


  2. 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..!!

  3. Thank you very much for the article I will now go off and practice the tips you have given

  4. Cheers for this very interesting

  5. aishalal says:

    You have explain steps very well.
    Like your SEO Rush.

Comments are closed.