Want to download a list of Klout scores for a list of Twitter users? There is an app for that

Posted on January 21, 2013

Update : The tool is not working. I suspect it has something to do with the new methods introduced by Klout where a call first needs to be made to get the KloutID from the Twitter name, then lookup on the Klout ID. Will keep you posted on any progress.

With the TopTwits listings I have been doing I thought it would be good to be able to get the Klout scores in there and see how that changes the rankings for the top users. I also would like to see if I take the #afcon2013 player list how their Klout scores come out. There is a lot of debate around the merits of Klout, I don’t really want to get into that, rather just interested in the correlations.

I had a look at the Klout API and was considering trying to write some excel code to get me the Klout scores so I can just pop it into my Access database. I googled around about to avoid duplicating effort when I found a Windows App which does exactly what I wanted.

http://blog.wiggert.nl/?p=20

You will need to go onto Klout and register for a developer key to get the app to work, but it is simple and does the job.  It was a pain to find the app as googling for it produces and awful lot of junk above the app. Somehow I (luckily) managed to stumble across it, this post is simply to share that fortune and possibly assist others in finding this useful tool.

Thanks Wiggert of ISIZ Labs for sharing.

Oh, and if you download the tool and find it useful, just leave a not of thanks on Wiggert’s blog, I am sure he would appreciate it.

 

Players in #Afcon2013 with the most followers (Top 20)

Posted on January 20, 2013

Below is a list as at 3pm on 20/1/2013 of the Afcon#2013 players with the most followers. It is interesting to note that as per my previous post, South Africa has the highest percentage of players with Twitter accounts, yet, this list shows that none of those South African players makes the Top 10. The top 10 list is dominated by Ivory Coast (4), Nigera (2), Ghana (2) and one each from Mali and Togo. The first South African is Bernard Parker in 11th place.

Only 8 of the top 20 have had their accounts verified by Twitter.

# Twitter User (Screen name) Country verified Followers Follows Posts
1 Victor Moses (@VictorMoses) Nigeria Yes 147499 57 177
2 King Emmanuel Eboue (@TheRealEboue) CÔTE D’IVOIRE No 143332 162 3196
3 ASAMOAH GYAN (@ASAMOAH_GYAN) Ghana No 141759 37 2579
4 Salomon Kalou (@Skalhuno) CÔTE D’IVOIRE Yes 104935 87 1676
5 Kwadwo Asamoah (@Asabob20) Ghana Yes 85391 22 995
6 Momo Sissoko (@sissokomomo) Mali Yes 76320 30 490
7 Drogba Foundation (@FondationDrogba) CÔTE D’IVOIRE Yes 67997 35 213
8 Emmaunel Adebayor (@E_Adebayor) Togo Yes 62351 0 2
9 Joseph Yobo (@JosephYobo3) Nigeria No 43369 39 188
10 Didier Zokora (@maestrozokora) CÔTE D’IVOIRE No 37111 7 208
11 Bernard Parker (@BernardParker) South Africa No 30793 144 445
12 Adlene GUEDIOURA (@AdleneGUEDIOURA) Algeria Yes 26750 284 2323
13 Derek Boateng (@BoatengDerek) Ghana No 22269 34 326
14 thulani serero (@sererothulani) South Africa Yes 19237 30 149
15 Kagisho Dikgacoi (@KGDikgacoi) South Africa No 15656 390 1633
16 Ikechukwu Uche (@ikeuche9) Nigeria No 14621 45 422
17 Itumeleng khune (@TherealItu) South Africa No 13056 27 262
18 Katlego Mphela (@KillerMphela) South Africa No 11066 3 51
19 Afcon2013 (@AFCON2013za) South Africa No 9671 247 600
20 Agyemang-Badu (@Badu_Agyemang) Ghana No 7299 26 527

Excel Tool to download Twitter Statistics

Posted on January 20, 2013

I have been interested in analysing various Twitter stats and producing lists of top twitter users (j-j.co.za/toptwits) for some time now and been using various tools to do so. This has been challenging and the results I have been producing have been limited as a result. The tool I have used most is NodeXL,which is more for mapping social networks but has the side effect of being able to download “extended statistics” for each of the Nodes (people) on the network. This however does not give me all of the information I wanted and also works on screen names rather than the Twitter ID’s, so if someone changes their name they fall off my list.

Searching on-line I found that Google Docs spreadsheet provides a function ImportXML which a number of people have been using to bring XML results into a spreadsheet. It appears to have some limits (50 calls per document) which at the time seemed problematic since I was wanting to work with much larger lists. I know better understand some of the Twitter API calls so that limit is less extreme than I first though. Nonetheless I wanted to work in Excel as I am more comfortable with it.

I found online that Excel can import an XML document, and that you can enter a URL there, which includes the ability to enter the Twitter API calls directly. Using the macro recorder I then figured out the calls and put some basic scripting around it to take a column of screen names, break it up into batches of 25 and then execute the XMLImport function for each batch and insert the results into the sheet.

Read the rest of this entry »

Following the #Afcon2013 players on Twitter (#CAN2013)

Posted on January 19, 2013

I spent some time today capturing the Afcon 2013 player list (23 players from each of the 16 teams) and then trying to locate their Twitter accounts. A somewhat arduous task and one that is less than accurate. None the less, it is complete and available for you to follow the players quite easily.

In all 85 players were added to the list : https://twitter.com/jjza/afcon2013 the majority of which are players, with some support accounts added. I have not added the official accounts of each of the team, although have collected some. Will consider adding when see what is coming up on the Tweet feed.  (This number will increase as I find more players, and I may not update the post, so don’t be surprised to find these don’t tally over time).

The position is summarised by country below. The top three by Rank are :

  1. South Africa
  2. Ivory Coast
  3. Algeria & Nigeria (tied)

Full list provided below.

Please click-through to the link. Mail me on afcon (at) j-j.co.za if you find additional players I have missed, or recommend any amendments  I have tried to ignore spoof accounts and fake accounts, but cannot be sure I have got it all right.

Enjoy the #Afcon2013. And best of luck to Bafana. May things improve after tonight’s rather dismal game.

Read the rest of this entry »

Website Changed : Activated cloudflare

Posted on January 19, 2013

I have read about Cloudflare for a while and it seems to provide considerable benefits. I have noticed that this site is sometimes a bit slow to load and Google certainly thinks so.  A potential problem is in Ad revenue as many online complain that Cloudflare has destroyed their ad-sense revenue (drop of 80% plus).  I don’t really run this site to make ad revenue and have notice a huge fall off of revenue (despite visits not changing significantly) – so am curious as to what difference this now makes. Previously I wasn’t inclined to go through the hassles of changing the DNS entries etc to make this work, however my ISP has enabled a very easy method of enabling it so I have now turned it on.

If you notice any changes (positive and negative), please share your thoughts in the comments.

Thanks

 

Afcon 2013 online resources

Posted on January 19, 2013

The African Cup of Nations (English #Afcon2013 French #CAN2013)

The tournament is being contested between 16 countries : Mozambique, Zimbabwe, DR Congo, Ethiopia, Togo, Malawi, Uganda, Cameroon, Nigeria, Sierra Leone, Liberia, Cape Verde, Algeria, Egypt or Central African Republic . Profiles of each of the teams can be found on LoriiPapa.com.

The tournament kicks off on 19 January 2013 and runs until the final on the 10th February.

The tournament is well represented online :

Various unofficial CAF 2013 twitter accounts abound include : @AFCON_SA

Read the rest of this entry »

Nokia music : when things go wrong #fail (updated : Resolved)

Posted on January 01, 2013

For a long time in SA we didn’t have any real choice if we wanted to buy music online. iTunes didn’t support us, the other stores wanted to sell DRM’ed music, the methods to download the music were painful and it really wasn’t much cheaper than getting the physical CD’s instore. Then I found Nokia Music (OVI store). They supported South African musicians, have a decent selection of artists and albums, are reasonably priced and provide further discounts for buying credit up front. Albums average between R60 and R100 each (and often it is the newer ones at R60). Songs between R6 and R10 each. Buy R500 of credit and get R600. So you could get between 6 and 10 albums for R500. Thats good value.

To download your music though you have to use the clunky Nokia Music Player. Worse than iTunes and I never use it for anything other than downloading my music. The problem with it is that it queues your songs for download but they regularly fail. Then it is a manual process of logging onto the website and getting the missing tracks individually. With the Lumia 800 things improved a little (or so I thought). You could now download the albums directly to the phone over wi-fi, no PC needed.

In the meantime iTunes started selling music in SA. I bought a Freshly Ground album for R60 but the rest of their music seemed expensive, sometimes as much as twice the price of Nokia Music (Rihanna Unapologetic Delux R60 vs over R120). I thought I would stay with Nokia music and put up with the hassles. iTunes really worked better, faster, simpler. But we all have our price.

Then it all went wrong.  (Although @NokiaRSA did fix it in the end : See update at end)

Read the rest of this entry »

%d bloggers like this: