Using SEOmoz’s Linkscape API with Google Docs

SEOmoz Linkscape API is an extremely powerful tool for SEOs, but SEOs often do not come from a development background, and might find the API inaccessible to them. Whilst I believe SEOs should learn to code somewhat, I know not everyone is from that school of thought. If you are unfamiliar with the API, then you can see the SEOmoz API wiki; we’re going to be looking at the URL Metrics API.

Luckily, a recent blog post from Ian Lurie details using Linkscape API with Google Spreadsheets. Ian’s post is great, and probably does exactly what you are looking for. What I post here is a modified version the code from his post, which I used to form the basis of a competitive analysis tool detailed in my recent SEOmoz post: Competitive Analysis in under 60 Seconds using Google Docs.

You can see the code in action in my example spreadsheet (you’ll need to copy if and add your SEOmoz API key), or take a peek here:

Continue reading

Google’s +1 vulnerable to clickjacking?

Google +1 logoThe internet and particularly the SEO community is abuzz from Google revealing there new +1 button yesterday. If you are unsure what this is all about then you could start by reading this introduction to +1 by Danny Sullivan over at Search Engine Land. If you are interested in reading more about the impact on SEO then you should start with Tom Critchlow’s excellent analysis on the rise of social SEO on the SEOmoz blog.

If you aren’t interested in any of that and just want to play with it already then log into your Google/Gmail account and head over to Google Experimental where you can turn the feature on if you’re not already seeing it. If you are in the UK you need to make sure you aren’t being redirect to which doesn’t serve the buttons currently, you can start via If you are using IE7, an iPad or probably numerous other devices then you are out of luck for the moment. Though if you are using IE7 you probably have other problems to worry about. 😉

There is some great coverage of the +1 button already all over the internet. My post today focuses on the fact that it appears that the +1 button is vulnerable to clickjacking…

Continue reading

Link Building and Hugs

You can't outsource giving a shit. -Tom CritchlowThere are a tonne of write ups (and some great photos) about the Distilled Link Building event that took place on Friday, so I’ll keep this short and sweet: it rocked. There was a great mixture of high level strategy tips, with low level techniques to use.

To illustrate: Reddit is currently piling up the sand bags ready for the onslaught that could come when people follow one strategy given up by the venerable Russ Jones.

Every single speaker had me scribbling down notes as fast as I could manage, and day dreaming about how I could deploy some of their ideas. All the attendees seemed to be in a trance, and it was quite exciting to be there for this groundbreaking link building event.

If you are stateside and you can make it to New Orleans this week I think there are still tickets available for the next iteration of the event. I cannot recommend it enough; I love the SEO community because there is such a great culture of sharing knowledge but I was still surprised by the depth of the amazing tips that some of the speakers were giving away.

Rand Fishkin and Tom AnthonyAfter the main event, those who could withstand the urge to go and start trying out their new link building ideas right away headed over to a nearby pub/bowling place for some network, bowling and a few beers.

I met some great people there, and exchanged some cool ideas.

Lastly, if you’ve been over at the new SEOmoz Q&A building up a few mozPoints (damn you Egobait!) and weren’t sure if they’re worth the effort then I have news. No sooner did I complain to Rand that the promised ‘hug from Roger’ (SEOmoz’s mozBot) failed to arrive when I reached the requisite 50 mozPoints than he set upon me himself to make up for it. I could feel the SEO knowledge emanating from him… I think that’s what it was.

See you next year!

Caching Google Maps Geocoder Results

After my post Geocoding UK Postcodes with Google Maps API I’ve had a few people contact me about caching geocoding results back to a server, for subsequent pages.

It’s a good question – Google’s geocoder permits you to make 50,000 queries a day, which sounds like a lot. However, that is only 35 a minute, which if you sustain for more than a few minutes, kicks in the limit (apparently…). So you might be interested in caching your results.

If you aren’t fussed about UK geocoding, you can access the regular Google geocoder using HTTP, as documented in the Google Maps Documentation.

However, if you want to temporarily cache results collected by the client (as per my UK geocoding example linked to above), you need to send them back over an AJAX connection, and that is what this article discusses. Although aimed at using the UK geocoding technique, a lot of this tutorial will be applicable to results via the normal Google Javascript geocoder.

So what this short tutorial is going to do is show you how once a postcode has been translated into longitude and latitude, the result can be sent back to your server to be temporarily stored in a database. Then we are going to look at how we can query our own database before we query Google’s, for each result.

Note: I’m told it used to be in Google’s Terms that you couldn’t store geocoding results, but it doesn’t appear to be that way now. However, we are only going to store them temporarily, so we don’t have to hit Google’s server repeatedly for the same query.

If you are eager just to see how this all will work, you can go straight to the demo page.

So, lets get going…

Continue reading

Geocoding UK Postcodes with Google Map API

Notice: As a few people have pointed out, this announcement from Google means Geocoding is now built in. Yet as more people have pointed out – it kinda sucks accuracy wise (think over a mile off on some postcodes!), whereas my method continues to be accurate.

Google Maps API provides a geocoding feature, for finding the latitude and longitude of places or addresses; but it does not work for UK postcodes. This is thanks to Royal Mail who have a copyright on the data, and are very restrictive with their (expensive) licenses for it.

There are various solutions out there for using 3rd party services and importing the data to be used with Google Maps, or for using community built databases for the info. However, I’ve had a few people ask me about doing it just though Google.

It is possible — Google AJAX Search API does provide geocoding for UK postcodes. We need to use the two APIs in harmony to achieve our result.

So here it is.

Continue reading

Grow up, Mashup!

Is 2006 the Year of the Mashup? I think not. Mashups are at the stage that DHTML was at before it matured into Web 2.0 – lots of bells and whistles, but little real meat. 2006 will see people acclimatise themselves to the principles and technology, and maybe the best thought out mashups will become established. But it will be 2007 that will truly be the Year of the Mashup. currently tracks 979 mashups, and 269 APIs, and shows a rate of 2.7 new mashups per day, so mashups are obviously very popular, so what’s the problem?

Continue reading