Most SEOs know that winning the battle for top search terms is in the links. They regularly check the back links of top rankings sites to get a clear picture of the “external relevance profile” of those sites. From this they learn:

  1. How many incoming links the site has

  2. The source of such links

  3. The anchor text of those incoming links

If you are familiar with Google Webmaster Central you know that you’ve got almost everything you need when you pull up the external links report, including all the incoming links and link text that Googlebot is aware of. The problem is that this data is available only for your own site, not for competitive analysis of your rivals. Also, most sites competing for top terms have thousands of links, yet competitive link analysis tools are currently limited to just a thousand results.

There are a couple of ways around these problems. I’m going to share one of my most closely guarded SEO tricks… Warning, this requires a little programming!

Option 1: Get access to your competitor’s Google Webmaster Central account by setting up a phishing site, breaking into his/her home, or bribing the technical support staff to place a Google file validating you as the owner.

Okay, obviously that option was a joke. :-) Now, let me explain the real deal. The idea is to use Yahoo’s Site Explorer and Yahoo’s powerful link command on the competitor. In order to pass the one thousand links mark, we need to add a keyword to the link search. For example link:http://sitename.com keyword1, link:http://sitename.com keyword2, etc. Save all the links, concatenate them together and filter the duplicates. You can use the keywords you have already generated in your keyword research analysis for this process.

For example, let’s see how we can extract SEOmoz’s two million links from Yahoo.

1. Extract a list of relevant keywords using Google’s tool

2. Use Yahoo Site Explorer to determine the total number of inbound links (You need to be logged in to Yahoo). Choose “Show Links Except from this domain to Entire Site”

3. Use Yahoo Search link command and add keywords to extract subsets of incoming links. One thousand at a time. Here I do a search adding “seo” and another adding “social media”

Although you can get the full list of links using this trick, the list includes links that are ‘nofollow’ that clearly do not pass any link juice. There are also sitewide links (blogroll links, and links included on every page of other sites), links coming from the same domain, IP block (class C), or owner (from the registrar information), as well as links that are not ‘nofollow,’ but which Google may be preventing from passing link juice. Any of these may increase your link count, but will not necessarily provide the same value as links coming from multiple, unaffiliated sites.

To take things to the next (useful) level, we need first to carefully organize the links by domain, IP block and ownership so that we can identify what I call unique link sources. Second, we need to filter out the links that are ‘nofollow.’ Finally, we need to visit the pages where the links are and see if they pass link juice, as I explained in the post about testing paid links.

Once the process is complete, we can collect all the anchor text coming from those links to get a complete external relevance profile. Now you can see how and why your competitor is listed and use it to form a solid link-building strategy. You have a highly-targeted list of link sources to pursue.

As you probably guessed by now, this is something that is far easier to do with a tool (stay tunned ;-) .)

I was a little bit hesitant to share this, so I would really appreciate if you let me know in the comment if you found this useful.

 

Did you enjoy reading this? Subscribe to this site! Choose from either daily email updates or our RSS feed and never miss a thing!

This entry was posted on Wednesday, October 17th, 2007 at 10:42 am and is filed under . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.



45 comments ↓


Jeremy on 10.17.07 at 12:21 pm

This is very useful. PLEASE…Tell me more.

Permalink

juerg on 10.17.07 at 2:31 pm

Very useful and interesting stuff–but: How long did it take you – assuming you were usin n o tool to perform this task and – you guessed it- how long does it take you w i t h tool…

Permalink

Hamlet Batista on 10.17.07 at 3:32 pm

juerg – I am too lazy to do this type of stuff manually. Using Yahoo’s API and a sizeable pool of web proxies (to overcome Yahoo’s API limit) you can do this in several hours.

I plan to share the tool, but I need to work more on it first.

Permalink

juerg on 10.17.07 at 4:22 pm

Great. I was hoping you were lazy enough to come up with some code for us to share …. many thanks in advance and looking forward

Permalink

» Today’s resources posts SEOisEZ.com: Blogging the Best of SEO on 10.18.07 at 1:00 am

[...] Sphinns – Revealing your Competitor’s FULL External Relevance Profile – One of my best kept secrets at Ham… -  Ever want to know step by step how to run a competitive analysis?  Now you do.  The only [...]

Permalink

Sam Daams on 10.18.07 at 8:06 am

This is VERY useful stuff Hamlet. It also shows that in order to build up a serious site in a seriously competitive field takes work, lots of it. Too many people forget that. If you’re going after a competitive field you should expect to be burning a lot of hours building up your site and it’s reputation before you see any results! An automatic tool to do a lot of this would be valuable to a lot of serious SEO – you could probably charge for it or maybe license via SEOMOZ (not sure if they do that stuff though)?

By the way, I just noticed today the ‘top posters’ area. Is there any reason my name links back to a post on this site or is that a bug?

Permalink

Jez on 10.18.07 at 8:37 am

Good post, as I read it I thought it was leading somewhere ;-)

Do you plan to integrate this with ranksense? (I do not remember this being a feature)

How scalable do you think a published solution would be, given the requirement for proxies?

Permalink

Web Design Newcastle on 10.18.07 at 10:18 am

Nice tip there. I never knew you could add keywords to the Link: search.

Permalink

Hamlet Batista on 10.18.07 at 10:28 am

Sam, Jez

This functionality will be part of the advanced edition of RankSense that is in the works.

I’m working on a free web tool off of the prototype so that you guys have something useful to play with. I plan to use it as a viral marketing piece to promote RankSense ;-)

BTW: Consider applying to RankSense’s private beta if you haven’t done so yet

Permalink

5ubliminal on 10.18.07 at 10:29 am

If I feel generous, which I usually don’t ;) , I might release a software quite soon to do what you talk about here including some detailed reports.

Maybe …

Permalink

Hamlet Batista on 10.18.07 at 11:00 am

Hey 5ubliminal! Do you want to make some extra bucks? Send me an email.

I am always looking for help and you seem to be a very talented programmer.

Permalink

Hamlet Batista on 10.18.07 at 11:48 am

By the way, I just noticed today the ‘top posters’ area. Is there any reason my name links back to a post on this site or is that a bug?

Sam – I forgot to answer this.

It seems it is a bug on the plugin. I’ll check if there is a new version and see if that fixes it.

Permalink

juerg on 10.18.07 at 6:20 pm

BTW: Consider applying to RankSense’s private beta if you haven’t done so yet.”
Hi Hamlet
did apply some time ago, but no reply yet..??
Can you please look for arranging this. I am on a new and urgent project and would be more than pleased to check this thing out…
Thank you

Permalink

David Hopkins on 10.18.07 at 6:57 pm

Moving over to Safari:

This is certainly a useful method. I have an extra tip to get a few more keywords. I recently found an excellent tool that logs millions of queries on Google.com to allow for some advanced keyword research. The tool (Seodigger.com) allows you to find out what keywords a domain is on the first two pages of Google. You could use this to get some more keywords to get more of the site’s incoming links.

What do you use to stop Yahoo temoprarily banning your IP When harvesting Yahoo data I always pick up the HTTP header code to make sure i’ve not been blocked. If i’ve been blocked I use sleep() to stop for a bit. I also sleep 10 seconds between each HTTP request. Do you have a better method

In ref. to Sam’s point that this shows how much work you need to do, if only SEO clients could be made to understand this P. I also think you would benefit much more by releasing the tool for free. Obviously you would only be able to make the script available. Something like this would take your site out P

What sort of programmers are you looking for If I can be of any use, I know (X)HTML, CSS, DTD, JavaScript, DOM, AJAX, JSON, XML, XSL, XSL-FO, XPath, XLink, XInclude, PHP 4&5, SQL, SVG (basic), XUL & FF extensions building (basic). Also do logo, interface design, icons and have made a number of scrapping tools and search engine widgets. Can also put you in touch with some people who know Perl, Python, C, Java. Some of these are in Poland, so lower payment demand but have no search engine knowledge.

Permalink

shor on 10.18.07 at 10:15 pm

Another gem of a post Hamlet.
Waiting for your post on the automation of this technique!

Permalink

Hamlet Batista on 10.19.07 at 12:12 am

juerg – I will make sure you get it so you can play with it this weekend

The tool allows you to Seodigger.com find out what keywords a domain is on the first two pages of Google . You could use this to get some more keywords to get more of the site’s incoming links.

Nice find, David. I am glad you got the blank comments problem sorted out :-)


What do you use to stop Yahoo temoprarily banning your IP When harvesting Yahoo data I always pick up the HTTP header code to make sure i’ve not been blocked. If i’ve been blocked I use sleep() to stop for a bit. I also sleep 10 seconds between each HTTP request. Do you have a better method

I prefer to use the API instead of scrapping. The API gives you 5k queries per IP. You just need to use multiple proxies ;-)

What sort of programmers are you looking for

I can use you skills for client-side development. Please send me an email to discuss further. We prefer to code the server apps in Python/Django.

RankSense is a Windows application and is coded mostly in C++, but for that development I don’t use contractors only internal staff.

shor – thanks for stopping by and congrats on making the Digg homepage! Very clever post and title ;-)

The follow up post will make available the tool that does this. Stay tunned!

Permalink

Hugo Peppers on 10.19.07 at 12:40 am

I’m on the edge of my seat waiting for this tool.

Permalink

Matt Davies on 10.19.07 at 3:54 am

Genius. I’ll be keeping my eyes open for a tool, Hamlet. This is the sort of competitor research I’d love to do for my clients, but doing it manually would just be too time consuming.

Permalink

Hamlet Batista on 10.19.07 at 9:59 am

Matt, Hugo thanks. I am glad there is interest in such tool. We already started working on it. It will take about a week to complete and make available.

Permalink

5 Almost Popular Sphunn Articles That Didn’t Go Hot This Week | SEO News - All The SEO Scoop on 10.19.07 at 11:53 am

[...] Revealing your Competitor’s FULL External Relevance Profile [...]

Permalink

juerg on 10.19.07 at 4:22 pm

Hamlet, can you please arrange for me to get access to ranksense. Would be delighted to check it out starting this weekend
Thank you

Permalink

Hamlet Batista on 10.19.07 at 5:26 pm

juerg – sorry for the delay. I sent you an invitation code by email. Please allow for a few hours to get access to the latest build that is being published Today.

Thanks in advance for your quality feedback.

Permalink

My Ghillie » Revealing your Competitor’s FULL External Relevance Profile on 10.19.07 at 6:40 pm

[...] Check it out! While looking through the blogosphere we stumbled on an interesting post today.Here’s a quick excerpt…One of my best kept secrets at Hamlet Batista dot Com using Google suggest per site and Yahoo Site Explorer and some data crunching and sorting. [...]

Permalink

juerg on 10.20.07 at 2:43 am

Hamlet
thank you for your support. Tried to donwload/ access, but was declined, since account already created. Cannot provide another e-mail address…Can you please check and confirm. Hope I didnt miss anything…
Many thanks
Juerg

Permalink

juerg on 10.20.07 at 2:51 am

Hamlet
sorry, forgot to mention: Just for your info:Get mailer-daemon failure notice when e-mailing to nemedia for help (help@ranksense.com). Am using latest firefox. Obviously this is not my day. Will have a latte macchiato and wait for your reply…
Kind regards
juerg

Permalink

vingold on 10.20.07 at 11:06 am

Exceptional post!

I need to print it out and give it a try when I have a few free hours.

I look forward to more!

This was really good.

Permalink

Hamlet Batista on 10.20.07 at 11:12 am

Juerg – I deleted your existing accounts. Please try again with the invitation code I sent you. I apologize for the inconveniences. Thanks for alerting me about the email address issue. That address goes to several emails accounts (including mine). I guess one of them is incorrect.

Vingold – thanks. I am glad you liked it.

Permalink

john on 10.21.07 at 12:04 pm

I’d be interested in the tool as well. Sounds like an edge up on competition.

Permalink

SEONewbie on 10.22.07 at 10:51 am

This is really interesting. I’m looking for ways to stand out at my company and doing this may justify a much wanted raise.

I do wish there was a way I could tell if those websites that linked to a competitor were Affiliates. Any suggestions?

**hoping a free tool is available shortly**

Permalink

Amanda on 10.27.07 at 1:03 pm

I can’t wait to see what you come up with and test it out. Don’t make us wait too long!

Permalink

Hamlet Batista on 10.29.07 at 10:42 pm

SEONewbie – one way to tell if the backlinks are from affiliates is to check for HTTP redirects and cookies. I’ll add this to the next update to the tool.

Amanda – we are giving the finishing touches to the tool :-) Thanks for your patience.

Permalink

Vishal on 11.03.07 at 12:22 pm

very very informaive post. i will be implementing your directions. perhaps even code a system so that this can be shared without the complications… so anyone can come to my site page and insert the data and see the result, instead of repeating the tedious procedure for each domain / keyword. thanks!

Permalink

Advanced SEO Tips From Hamlet Batista | John Chow dot Com on 11.19.07 at 2:40 am

[...] Revealing your Competitor’s FULL External Relevance Profile – One of my best kept secrets [...]

Permalink

Nikhil on 11.28.07 at 10:27 am

Hello Hamlet,

Can i get invitation code for ranksense as well . I have already submitted there my email.?

Thanks
Nikhil

Permalink

Hamlet Batista on 11.28.07 at 6:08 pm

Nikhil – We’re sending out the rest of the invites this week. Stay tuned. Thanks for your interest.

Permalink

Prime Angus Filets: Links this Week 1-4-2008 | bobangus.com on 01.04.08 at 10:13 am

[...] profile for them. Hamlet Batista unleashed something that you will not find in any ebook with Revealing your Competitor’s FULL External Relevance Profile. Also, Earner’s Blog continues his series on link building with a good reminder to think [...]

Permalink

Seo Design Solutions on 01.04.08 at 12:22 pm

Hey Hamlet:

I know what you mean about sharing the good stuff. I have been giving away my techniques for months now for competitive link building and the like, but this is great information for link hunting. Good stuff…By the way, I hope you win an award for the recent nomination for best SEO Research Blog. Thanks for the tips.

Permalink

Link Building - All 2008 Nominees » SEMMYS.org on 01.22.08 at 5:45 pm

[...] Revealing your Competitor’s FULL External Relevance Profile – One of my best kept secrets Hamlet Batista | 10/17/07 [...]

Permalink

Link Building - 2008 Finalists » SEMMYS.org on 01.24.08 at 1:51 pm

[...] Revealing your Competitor’s FULL External Relevance Profile – One of my best kept secrets Hamlet Batista | 10/17/07 [...]

Permalink

losangelesseo on 01.30.08 at 11:44 am

is it possible to query the site with multiple keywords at once? like link://www.site.com keyword1,keyword2…

Permalink

Link Building - 2008 Winner » SEMMYS.org on 02.01.08 at 1:11 pm

[...] Revealing your Competitor’s FULL External Relevance Profile – One of my best kept secrets Hamlet Batista | 10/17/07 [...]

Permalink

The SEMMYS - Hobo SEO UK on 02.06.08 at 9:39 pm

[...] Revealing your Competitor’s FULL External Relevance Profile – Hamlet Batista [...]

Permalink

Manual Directory Submission Service on 02.08.08 at 6:53 am

Hello Hamlet,

Can i get invitation code for ranksense as well.

I would certainly be interested in the RankSense. Can you join me in your email newsletter so that I will be able to know when you will launch future version of RankSense.

Thanks
Padhamanabha

Permalink

Beth on 02.18.08 at 8:36 am

Hi Hamlet,

Could I also receive an invitation to check out your beta Ranksense?

Thanks,

Beth

Permalink

Aaron Hall on 01.09.09 at 10:59 am

This is very useful. Although I knew about Yahoo’s tools, your article helps to effectively apply those tools using a practical step-by-step method.

Permalink



Leave a Comment


 
pic2
There are many blogs about SEO. Many of them have done, and continue to do, a great job with traditional ideas. Unfortunately, knowing and doing what everybody else does is not a competitive advantage.

This blog is different. It’s about learning the most advanced SEO techniques, led by one of the industry’s up and coming SEO thinkers. Here you will find advanced search engine marketing tips and techniques that give you an edge over your competitors. The ideas are totally original: a fusion of Hamlet Batista’s own experience, research and careful experimentation, along with his readers’ questions, ideas, and thought-provoking input. Come along for the ride and explore, participate and push the limits of today’s SEO.
  » Read More