By 6 years ago in Link Building SEO

Link Analysis Tool : The ultimate open source SEO tool

Backlink analysis is a trick business and can be quite resource hungry. That’s why I’ve started developing an open source Link Analysis Tool.

The tool is currently in Beta and you can download it here. My idea is that by releasing this as an open source project other programmers and skilled people can help me improve the tool based on feature requests and bug reports from the community.

The script has an auto installer to set up the Mysql databases, you will need a Yahoo API – details are in the readme. Please leave feedback and feature requests in the comments below, if any PHP programmers want to contribute then drop me an email.

What it does

  • Uses Yahoo Site Explorer to find all pages on a site
  • Pulls in link data for every page on the site & orders results by pages with the most links
  • Allows you to drill down 2 levels deep into the link data for pages linking to the target site
  • Accepts Google sitemaps imports
  • Accepts single URL imports
  • Lets you check the rankings for any page on any search engine

Example: I enter my competitors url and the tool brings up a list of all their pages with the most linked pages at the top of the list. I can then drill down to find not only the exact sites linking to these pages but the sites that link to the linking pages as well. This allows me to very quickly evaluate the most valuable links to target for myself.






You can distribute the script as you wish in any form (for example with your own branding), all I ask is that you leave the “About this tool” link on the right hand side of each page and the designers link at the bottom. Selling the script is not permitted.

By Patrick Altoft. at 5:18AM on Friday, 28 Mar 2008

Patrick is the Director of Strategy at Branded3 and has spent the last 11 years working on the SEO strategies of some of the UK's largest brands. Patrick’s SEO knowledge and experience is highly regarded by many, and he’s regularly invited to speak at the world’s biggest search conferences and events. Follow Patrick Altoft on Twitter.


126 Responses to “Link Analysis Tool : The ultimate open source SEO tool”

  1. Sweet! I can really use that. Not much more I can say.

  2. The only thing it is missing in a log analyzer so it can daily parse the logs for all referring URLs and then check those pages for links back to the page showing the entry.

    In this way it starts to auto discover the links since Yahoo only shows a small subset of links once you get to a certain number.

  3. PC Forums says:

    Now that’s hot! I’m gonna download this and give it a whirl.

    The feature I’m excited about is google sitemaps import. Daddy like!

  4. azzam says:

    Why thats mighty noble of you patrick.
    Will take a spin and see if any coding can be applied to improve.


  5. ourmonmouth says:

    Patrick – this is a seriously useful tool! Thanks for sharing.

    Best wishes,


  6. PPClab says:

    I really appreciate the great tool, I’ll try to contribute to it as much as possible.

  7. yoichi says:


    Thanks for this.
    But I’m getting this error message.

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /linkanalysis/index.php on line 45

    What could I have done wrong?

    Thanks for your help.

  8. Hi,

    Seems like a really useful tool, but I get zero (0) links for any url on any website I test with. Even though there are some results when I try Yahoo’s site. (?)

    Thanks for your help.

  9. Rebecca says:

    Thanks for the great tool Patrick. Can’t wait to get it installed and analysing!

  10. Gemme says:

    Seems like a great tool, thanks a lot. Am playing with it now.

    I don’t see yet the PR in my overview, am I missing something?

  11. martaay says:

    I also get this error message appearing in the error log after trying to add a site through addsite.php

  12. G says:

    You can’t downplay the completely invaluable nature of this tool for evaluating your OWN website, to figure out how relevant your linking neighborhood is, etc.

    I’m pretty stoked to get a real clear picture of where my site is at. (And maybe then I can get some insight on the kind of Twitter followers I’ve been attracting, too!)

  13. It’s up and running great. I have been looking for a way to see which pages of my sites are getting links. This really helps a lot.

    Thanks for sharing this. Excellent link analysis tool!

  14. How will your software compare to SEO SpyGlass?

  15. Del says:

    Looking good so far. I to am unable to see the PR column. It’s missing from the list of domains on the home page and also the link analysis of the website.

    FYI On the first pass it didn’t capture the number of links correctly – in fact it returned everything as 0 – the same as Carl-Johan above. I refreshed one entry manually and it then displayed link numbers so I refreshed the entire domain and the correct link numbers were displayed. :)

  16. SEO Blog says:

    Hi Patrick, thanks for this great tool. I came to your site from the SEO Book forums, great information there.

  17. AlainS says:

    Thanks very much for the tool! But the same information is already given in Google Webmaster Central or am I missing something?

    What I would love to find is a tool that also shows the anchortexts of the inbounds. Not a simple list of all anchortexts, but a statistical overview of all anchors:
    70% anchortext1
    8% anchortext2

    Is there something like that out there?

    Thanks again,

  18. PPClab says:

    I’m getting this message
    Spider results being spidered………
    Cannot connect to Yahoo, you might have used more than 5000 queries today?

    anything i should check…its a new api key

  19. Rebecca says:

    I’m having problems too. It says 0 links for all the sites I’ve added and also the PR column is missing. When I click the refresh link on the individual links within a site I get the following error:

    Fatal error: Call to undefined function: file_get_contents() in /home/virtual/site25/fst/var/www/html/linkanalysis/update.php on line 21

    Any clues??

  20. Del says:

    I’ve checked the code and the PR column is not included in the table so it’s not even trying to pull the image. It’s on a shared host running a version of PHP just prior to 5 if that helps.

  21. SEO Blog says:

    Patrick, sorry. I have a problem with the tool. I must be doing something wrong. When I go to:
    I get an error message:
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘mydatabasename’@’localhost’ (using password: YES) in /home/user/public_html/linkanalysis/ on line 5
    Unable to connect to database

    Can you please give me any lights on this, I will appreciate it.

  22. Bill says:

    Thanks, Patrick, for the head’s up. This will be a useful addition to the ‘bat belt’ of tools we use.

    Take care,

  23. [...] Link Analysis Tool: The Ultimate Open Source SEO Tool – from BlogStorm. [...]

  24. Pommy says:

    I keep getting this error message:

    Service Temporarily Unavailable
    The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

    Any Ideas

  25. Luke says:

    Looks like an awesome tool, thanks. Having some issues implementing though – getting a 503 error when trying to add a domain. Could this be a permission problem?

  26. Awesome Patrick. Can’t wait to put it to use and see all the future enhancements.

  27. Evan says:

    hey Patrick, still getting the error, I have not idea if the email i sent you via your contact form when thru or not the page timed out. Thanks

  28. [...] Link Analysis Tool : The ultimate open source SEO tool [...]

  29. Hi Patrick,

    It really is a valuable tool, and I look forward to updates to it.

    My domains loaded after I got a new API key from Yahoo – don’t know what was wrong the the first one I got. When I reloaded my domains I got the link count from Yahoo.

    However, the PageRank is missing from my version as well, same as other people have mentioned above.

    I look forward to any upgrades to your tool.

  30. Colin Gray says:

    Yep, really good tool, I’m gonna install and will head back with comments after a decent trial.



  31. SEO Blog says:

    Hi Patrick I have not been able to make it work. I have replaced username, password and database-name in the config.php file as you mentioned, but is not working still. Can you show me a sample of how it has to be done properly? Thanks in advance.

    This is whow I replaced it on the file:

    $mainconnection =MYSQL_CONNECT(“localhost”,”myuser”,”my password”) OR DIE(“Unable to connect to database”);

    @mysql_select_db(“mydatabasename”) or die(“Unable to select the database”);

    “and also:”


    I don’t know what’s wrong? I keep getting the same error:

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘mydatabasename’@’localhost’ (using password: YES) in /home/user/public_html/linkanalysis/ on line 5
    Unable to connect to database

  32. Nuno Andrade says:

    Hey Patrick,

    Thanks for the tool. Unfortunately, there seems to be no readme file in your zip file and I am getting the following error when I try to add a site:

    “Column count doesn’t match value count at row 1″

    Any help would be greatly appreciated.


  33. Michal says:

    I have the same problem as above. With the last release you must forget to include readme file.


  34. Judd Exley says:

    Ditto the two above. I’m actually working on fixing this if I can. Hopefully you beat me to it…


  35. That sounds an awesome tool. Many thanks for sharing

  36. Ash says:

    Good Piece of work, Definitely going got use it

  37. [...] Altoft of BlogStorm has created an open source link analysis tool that does some of the same functions as SEO Quake. Patrick’s tool is not a Firefox extension, [...]

  38. [...] Link Analysis Tool The tool is currently in Beta and you can download it here. My idea is that by releasing this as an open source project other programmers and skilled people can help me improve the tool based on feature requests and bug reports from the community. Read more here [...]

  39. arin2u says:

    I get to know about this tool from vandelaydesign and it’s seems to be a really handy tool to work on. downloading it. Thanks for making it free for distribution. i really appreciate it.

  40. [...] calculators to Flash quizzes. Patrick Altoft of BlogStorm launched his SEO blog based off of a link analysis tool that gained huge popularity. In fact, he was able to attain 10,000 links in just 3 [...]

  41. [...] Altoft of Blogstorm has recently written a Link Analysis Tool "the ultimate open source SEO Tool". It’s a server-based tool that runs on PHP & MySQL. Better still, he released it as [...]

  42. Vlad says:

    Hi man
    Really great tool, RESPECT.

    had a little problem, it doesn’t show pr on pages and some pages wasn’t crawled by bot, why ?

    i can show u what is this about if you are interested


  43. Babieintown says:

    Wait for your excellent tool, Love it. Need a new version
    for now seem like a little bug to me, Every link show 0 link to each result. How can i do ?

  44. Darlehen says:

    @ yoichi

    I had the same, login into phpmyadmin and check all rights. That was my bottleneck :)

    BTW. I love the tool now, as it is up and running ;-)

  45. [...] Yahoo Site explorer 2.    Domain Pop Backlink Checker 3.    Link analysis Tool (You have to download tool from here then install it on your server after that you can check [...]

  46. TzuVelli says:

    Hey Patrick,

    Great tool! Unfortunately, I do not have a ReadMe file so I am not exactly sure how to install it. Sure would love to gt that ReadMe file or a pointer to installation directions.


  47. [...] Yahoo Site explorer 2.    Domain Pop Backlink Checker 3.    Link analysis Tool (You have to download tool from here then install it on your server after that you can check [...]

  48. David says:

    I am having problems downloading and running it. Is their a phone number I could call? Or could I IM someone?

  49. omar says:

    Everything working well except the pagerank, not showing..any clues? great tool though, thanks Patrick!

  50. Leon says:

    Having a problem to run the program, I can download the file but there a problem installing the program. Can anybody help me.

  51. Still no readme file? Is this project dead? It looks really promising and I was hoping to add it as a backend tool to me site…

  52. umx says:

    Holla, i’ve got Spider results
    Incorrect integer value: ” for column ‘id’ at row 1 anyone can help with this?

  53. widarta says:

    thanks for this great tool… ;)

  54. izle says:

    woowwww…. That is a great tool. Thanks for sharing.

  55. ShriNagesh says:

    Great. Isn’t this handy. Link analysis through plugin. Thx for taking time to script it

  56. Urban says:

    Nice nice project just keep it and working on it ! :D

  57. visiblenet says:

    This tool seems really useful. Many of the features mentioned are highly sought out by webmasters and SEOs. Link data can be so important, many people aren’t even aware of how to use this type of data. We use a combination of in-house tools we developed, which are now offered on our company site for free. Thought maybe readers here may be interested in trying them out. We encourage feedback, so please let us know if you think improvements can be made.

  58. riya says:

    thanks ,this tools is working better than paid tools

  59. SEO Sydney says:

    Nice tool, working well

  60. Poly SEO says:

    Thanks for sharing, much appreciated!
    It does not look like visible is going to offer their source code, none the less they seem have some helpful tools.

  61. Sanip says:

    How to using tools online can increase my pagerank

  62. Thanks for this great piece of software. I have used it a couple of times and it has returned some interesting results encompassing Yahoo’s index. The bones of the software are here and following some further updates (which I understand you and others are working on) this is sure to be a leading backlinking analysis tool – keep up the great work please!

  63. novalja zrce says:

    yeah thats a nice tool. i like it

  64. Multimedia memory card files recovery software quickly restores favorite music mp3, audio, video clippings and other similar files from digital media storage drives.

  65. This is a great tool. Trying to figure where your back links have come from is extremely difficult and a lengthy process. This application allows you to see the page rank, how many links are present and what search engines it is featured in. In terms of seo, this is very useful and allows you to keep control over your outgoing links and also see your competitors links. Great post!

  66. SEO Rocks! says:

    Thanks for providing this great tool. We are in the middle of a major overhaul, and we would love to use this and link back to you for providing it. Thanks!

  67. This sounds like a great tool to have for any website. I like that I can check the page rank of any page on any search engine.

  68. Goran says:

    I am downloading the software now, will let you know what I think.

    I am hoping you could help me. I have spent the last few months looking for a really simple tool. I was hoping you would know of one that could help me.

    I have a list of urls that we have added a link to, we have the anchor text, and we have the links that the anchor text is pointing to.

    Every program that I have tried requires that we add a SINGLE DOMAIN and then it verifies that the link is pointing back.

    I would like to upload a list of different domains that different links are pointing to.

    Thus, I would add a csv containing the link where the url is, the anchor text and the url the link is pointing to and the software would verify that this is correct.


  69. mikej8seo says:

    interesting tool, gonna try this!

  70. Company offers keylogger utility to capture all typed email conversation, chat records and document lists

  71. Stefanos says:

    Great tool. I was looking for one like this, since I was not satisfied with all others. I will try to install it on my Joomla site. I hope that I will not have any problems.

  72. [...] Blogstorm Link Analysis Tool (Beta) – This downloadable tool is still in beta testing. But as of right now this tool will pull info from Yahoo! and grabs the Page Rank of a page. Then the tool finds not only the exact sites linking to these pages but the sites that link to the linking pages as well. [...]

  73. This is great can’t wait to test it out.

  74. [...] Blogstorm Link Analysis Tool (Beta) – Dette nedlastbare verktøyet er fremdeles i beta testing. Det benytter seg av Yahoo! for Ã¥ hente inn alle sider indeksert for et gitt nesttsted, og henter samtidig inn all tilgjengelig linkinformasjon forde aktuelle sidene. Det lar deg ogsÃ¥ kjøre “drill down” pÃ¥ inntill 2 nivÃ¥er – ser meget lovende ut, og skal definitivt testes. [...]

  75. Thanks I’ve found this really useful in my seo analysis

  76. Thanks a million for this tool, looks fantastic and I shall be installing it this afternoon.

    Thanks again.

  77. If anyone has tried either Market Samurai or Advanced Web Ranking I’d be very eager to know how you feel about their usefulness and value and also which you think is better.

  78. MLB jersey says:

    Nice news,thanks you for this good sharing.

  79. AtoutMarket says:

    Achetez en toute sécurité et au meilleur prix ! AtoutMarket, votre boutique spécialisée en matériel informatique, vous présente des produits pour améliorer les performances de votre PC.

  80. What will happen when Yahoo Site Explorer is closed by Microsoft Bing ?

  81. Chris.T says:

    nice tool .. anymore updates on the way ? Do you have a twitter account?

  82. Tereza says:

    WOW, thank you for this,it will help for sure!

  83. [...] Blogstorm Link Analysis Tool (Beta) – This downloadable tool is still in beta testing. But as of right now this tool will pull info from Yahoo! and grabs the Page Rank of a page. Then the tool finds not only the exact sites linking to these pages but the sites that link to the linking pages as well. [...]

  84. thanks, this looks great tool

  85. PROSEO says:

    Thanks for the tip! Looks interesting.

  86. Thanks for such a wonderful tool.. you are always rocking…

  87. says:

    very good tool,i want to use it in my site:

  88. Brandon says:

    This is awesome!! I was looking for a tool like this forever, so thank you for creating this! Love how it is open source, because I already know a few people that could help out with this!

  89. Thanks for the tool, it looks very interesting. I will probably have however to do some tweaking to make it compatible with my WordPress template, but that’s life…

    I specially appreciate it that you’ve made it open source. If I add things, I will certainly forward them to you, so that others can enjoy them too.

  90. NW SEO says:

    Hi all,

    I found this to be really useful and will likely be using it for my own SEO projects in the future.

    Thanks again!


  91. Doug says:

    According to this link, Site Explorer API shut down in Dec 2010…
    Will this tool still work?

  92. Seems likee a nice tool. We have something similair in our SEO Tool RankInspector.

  93. Anthurium says:

    Cool tool. Thanks for taking the time to build it.

  94. Stuart says:

    Just downloaded, gonna give it a go :-) Any tool that uses Yahoo! link data and can manipulate it for researching is in my good books before I even try it! Thx.

  95. This is a great tool. I also use this tool nowadays a lot. Gets me going :)


  96. thanks heaps! worth your weight in gold… awesome asset in the world of seo!

  97. Looks like a useful tool..

  98. Absolutely loving this tool!
    Just got this article sent to me from one of my mates who is using it and they are loving it!
    Thanks for posting

  99. Jay says:

    It looks great, but it seems that it isn’t working with some people. Well, I’m gonna try it anyway, see if it works.

  100. Great looking open source tool. I like market samurai and use SEO quake on the fly, that’s how I found this blog!

  101. Great Spy tool, i have been using varius tools, of course the classical one is checking sitelinks from yahoo, but is a bit annoying when your on page have make sitewide links :)

  102. samrat kafle says:

    Definitely great stuff to keep in memory really fact things are written here thanks for sharing cheers!!! :O

  103. [...] Blogstorm Link Analysis Tool (Beta) – This downloadable tool is still in beta testing. But as of right now this tool will pull info from Yahoo! and grabs the Page Rank of a page. Then the tool finds not only the exact sites linking to these pages but the sites that link to the linking pages as well. [...]

  104. Willemien says:

    Thanks for this handy tool! You can also use

  105. Billig Seo says:

    Wow, in days yahoo site explorer is gone this will definitely help us a lot. Thank You for this wonderful tool. I will use it from now on as my primary spy processor. Really god software. Big thanks from billig seo – a seo company in Oslo.

  106. Great tool, such a simple technology that can be used in a very effective way.

  107. Very well worth using, great tool for an ever increasing world of SEO realms.

  108. car gps says:

    can it be used now?

  109. Alan Johnson says:

    Thanks, this tool looks good, have you ever tried seopanel?

  110. SEOTEXT says:

    Thanks for a great article. We use this tool for over 1 year now and we are still happy about it. Does anybody know any new good alternatives?

  111. Seo Sailor says:

    thanks for sharing such kind of nice detail about tool

Leave a Reply