Archive for November, 2011

PostHeaderIcon 6 Cool Ways to Supplement Your Open Site Explorer Data

Posted by richardbaxterseo

And so it ends. By the time this post goes live, Yahoo Site Explorer will be gone. Let’s take a moment to silently reflect on the passing of a once great SEO tool.

Thankfully, there are a heap of Yahoo Site Explorer alternatives, with arguably more powerful features available than Y!SE ever had. Today, we’re going to take some fresh link data from your favourite link information mining tool of choice and supplement the hell out of it with even more data. Yey – let’s build a better Yahoo Site Explorer replacement.

A Special Thank You

This (long overdue) post wouldn’t be possible without the assistance of one of the SEO industry’s most unsung heroes – Niels Bosma. He’s the genius behind SEO Tools for Excel, which has opened up another level of SEO data analysis for Excel geeks all over the globe.

I’ve written about Niel’s amazing work over at SEOgadget before, so check out these links for a primer on the basics or an introduction on how to find lost links and get SEOmoz API data into Excel. When you’re done, we’re good to take it to the next level.

Here's the finished product, click the image for a massive, full screen image of this awe-inspiring spreadheet.

the finished article

#1 – How Many Likes, Google+’s and Tweets Were Received to My Linking URL?

Let’s start nice and easy with a count of the number of Likes, Google+’s and Tweets received by a URL. What’s not to love about a page that received a lot of social love? These two queries will churn happily through your link data until you’ve got more social than you can shake a stick at.

Retrieve the Google+ count for a URL:


Get the number of Tweets to a URL:


Get the number of Facebook Likes to a URL:


#2 – Are My Links Live and Accessible to Search Engines?

When you’re looking at link data, you’re looking at an internet that has been and gone. At least, you’re looking into the past – and we all know that link decay is an everyday part of the evolution of the internet. To take a super accurate snapshot of your link data, you really need to know if your link is still live.

On that note, check out this clever little formula:

=IF(XPathOnUrl(C2,"//a[contains(@href,'')]")="","NOT FOUND","FOUND")

Translated, it means, “If you found a href link on this page with in all or part of the href, say ‘FOUND’. If the response to that query was a blank cell, say ‘NOT FOUND’.” So you know, the SEO tools XPathOnUrl function returns nothing when no result is found.

#3 – Did Google Even Cache that Link?

In his post on automating SEO, Russ pointed out that not all of your backlinks may have been indexed by Google, and that you should identify them and link to them to get them discovered. That’s a very nice idea Russ! Russ’s solution was excellent, but required some fancy scripting work.

Assuming you’re not tracking new referrers with snazzy custom filters in Google Analytics, here’s an easy way to do it with Linkstant and the =HttpStatus function.


First, grab all of the new referring URLs. I do that with Scraper for Chrome. Export the URLs and then in a new Excel tab, put this URL in to cell A1:


A cache: request will respond with a 404 if the URL is not cached. So, a simple concatenate, followed by a "=HTTPstatus" will give you a list of URLs that Google has cached.

This is probably not the best way, but it works just the way you'd expect it to, most of the time:


Where $A$1 is our cache request URL.

Next, use this function to get the http status of the URL:


Grabbing the HTTP status of your URL list will give you a list of results like this:

a list of URL links that may or may not be indexed at Google

#4 – Get Search Volume Data for Your Inbound Anchor Text

An interesting way to identify links that might be a little above the radar, penalty-potential wise is to look at the search volume for the inbound anchor text used in the link. I mean, if you’ve got a lot of massively overcooked, highly competitive anchors from PageRank 0 sites, you’ve got a problem.

If you’ve got an Adwords API key, then it’s a piece of cake to use the Adwords API Extension for Excel – simply take a copy of all anchor text in the data, copy it to a separate table, de-duplicate it and run this array formula:


Then, do a VLOOKUP back in your main table and you’ll have search volumes for every anchor text used in your inbound links.

#5 – Extract the Domain From the Linked to URL

In my link data I really like to know if there are any potential problems with the domain I’m getting links from. PageRank 0 links, with extremely competitive anchor text could spell trouble, or at least some less than savvy link purchases. We're spending a lot of our time lately cleaning up this sort of thing, and this method makes it a whole lot easier.

Check out this formula as a very simple way to extract the characters up to, but not including the first trailing slash in a URL (assumes there's a "http://" at the beginning of the URL):


If some of your links are from homepages (which often they are), simply add this extension to display the full URL, should there be no trailing slash in the URL:


#6 – Get PageRank for the Linking URL and Domain

Yes, you heard that right. The old school link auditor in me can’t shy away from the fact that while PageRank is pretty useless as an overall proxy to rankings, it will come in handy if you’re trying to get a sense of the overall quality of the backlinks of a website. Like I mentioned above, a lot of PageRank 0 links from cruddy sites, with highly competitive inbound anchor text might be something you should make yourself aware of.

Here’s how:


What Could You Build?

There are a few more tricks left that you should go and explore in SEO Tools. I also happen to know there’s an SEO Tools v3.0 coming very soon, and it will kick ass! Though I’m really grateful for Yahoo Site Explorer, I’m not going to miss it. It’s sort of like an Overture Keyword Tool situation. When that disappeared, there was outrage, now, silence.

Have fun rolling your own tools and, as always I'd love to hear how you're getting on! – follow SEOgadget on Google+

Do you like this post? Yes No

Similar Posts:

Article Source: The Only Yard For The Internet Junkie
If you like all this stuff here then you can buy me a pack of cigarettes.

PostHeaderIcon Apple To Surpass HP As Top PC Vendor In 2012? Depends On How You Look At Things

HP’s behavior in 2011 has been, well, erratic , to say the least. The absolute least. The PR missteps by the world’s top PC supplier has opened a crack just wide enough for other to sneak in and steal HP’s title of king of the PC hill. So which competitor has the gumption to take the top spot? Lenovo recently unseated Dell from the number two position, so it appears to hold the prime position for usurpation. Wrong! says one analyst – who expects Apple to become the global PC leader in in 2012.

What? Sure, Mac sales surged in the US this year, but Gartner’s third quarter numbers don’t even have Apple in the top five global PC vendors (who are HP, Lenovo, Dell, Acer and Asus, in that order). Something seems fishy here.

You see, Canalys analyst (try saying that three times fast!) Tim Coulling lumped in iPads with normal PCs when he crunched the data and said that Apple was poised to trump HP in 2012. That seems a bit off to us, especially when Apple’s iPad started the whole trumped-up “Post PC” claims. If iPads are post-PC, how can they be counted as PCs? Additionally, there is no word in Canalys’ press release whether or not laptops are included in their tally, or even how Coulling came by his numbers.

Just for fun, let’s look at some third quarter numbers from non-Canalys sources (Apple calls them fourth fiscal quarter numbers, by the way): according to Gartner, HP shipped 16.2 million PCs, far more than the 4.89 million Macs Apple managed to move. In addition, that 16.2 million PCs shipped number for HP is more than all tablets combined managed to ship — only 13.6 million slates shipped in the third quarter, with 11.12 million being iPads, according to Apple. 11.12 million plus 4.89 million equals 16.01 million — only a couple hundred thousand less than HP’s shipped units. So we can understand Coulling’s logic, if you agree that Mac and iPad sales will continue to increase next year and are fine with lumping in tablet sales as PC sales.

What do you think, Maximum PC readers? Should tablets be included when counting total PC sales, or are they an entirely different beast all together, as some industry insiders claim?

Similar Posts:

Article Source: The Only Yard For The Internet Junkie
If you like all this stuff here then you can buy me a pack of cigarettes.

PostHeaderIcon Exclusive Sneak Peak: Mad Catz’ Most Over-The-Top Mouse Yet


It’s been a little more than a year since we first reviewed the R.A.T. gaming mouse from Mad Catz, and called it the best mouse we’ve ever played with. Since then, there’s been a couple of incremental upgrades to the line (the cordless R.A.T. 9, the white “Albino” R.A.T. the 6400 DPI Contagion Edition), but nothing that fundamentally altered the design. They’re about to do just that, though, and we got to take a sneak peak at the result.

The Cyborg M.M.O. is (for all the terribly bad guessers out there) a version of the R.A.T. designed for MMO gaming. Where the original R.A.T. had 6 programmable buttons, the M.M.O. has 13, plus a shift button and a three-mode toggle, allowing for a maximum of 78 custom bindings per profile.

Also like the original, the M.M.O. has a feature we’ve never seen on a mouse before. Special buttons on either side of the scroll wheel allow you enter “Action Lock” mode, where any right- or left-mouse-button click toggles between the button being in the “up” position and the button being held down. The idea is that you use this feature for MMOs where holding right click causes your character to run forward, or enter mouselook mode. Tri-color indicator LEDs in each mouse button keep you from losing track of whether Action Lock is on or off.

And of course the mouse comes equipped with the latest 6400 DPI sensor—a feature that might be more useful to RTS or FPS gamers. We’ll be looking forward to testing out the M.M.O. for a full review, but so far we like what we see. Check out our gallery of the M.M.O.’s snazzy new paint job below, and less us know what you think of Mad Catz’ latest.


Similar Posts:

Article Source: The Only Yard For The Internet Junkie
If you like all this stuff here then you can buy me a pack of cigarettes.

Free premium templates and themes
Add to Technorati Favorites
Free PageRank Display
Our Partners


Related Links
Resources Link Directory Professional Web Design Template