I’m a big fan of creating your own SEO tools with Google docs, so when I found out about the Klout API, I immediately began finding ways to put that into a practical tool for SEOs. I’ve come up with one potential use which I will show you here, but really, the possibilities are vast for this sort of thing. In this post, I’ll show you how to pull useful data into a spreadsheet and apply the Klout API to get some actionable numbers for your social activities. Specifically, I’ll show you how to pull a list of tweets mentioning your business/organization/name/whatever and grab Klout scores for each Twitter handle automatically with the Klout API. Sound awesome? It sure is! Here we go with the tutorial.
Remember the basic scraping methodology we used in the Google docs rank checker post? We’re going to be using the same function (=importxml) but on a different search engine: Blekko! Blekko is the little SEO secret that’s vastly underutilized. And, since Google killed off Realtime Search recently (and most of us are still mourning its passing, even though it may soon return), we’ve been in dire need of a way to search Twitter without resorting to Twitter’s proprietary search. Enter the /Twitter Blekko slashtag!
Searching Blekko for anything with the /Twitter slashtag amended will yield a list of tweets using the term. This could be applied to brands, subjects, people, phrases, anything! You can even look for usage of specific hashtags if you put the hashtag in quotes (IE: “#seo”). So, we need to get our spreadsheet to form a Blekko search URL. If we run a quick search through Blekko with a basic query and the /Twitter slashtag, we can see that their search URL structure looks like this: