Skip to content

Visualising a monetised Twitter network

This is just a little experiment with nodeXL, inspired by this example of using it to visualise a Twitter network. NodeXL is a very nice social network analysis (SNA) and visualisation tool. It works from Microsoft Excel, and is very light and easy to use. The NodeXL Tutorial provides instructions on how to use it.

One thing that's particularly nice, for an SNA neophyte like myself, is that nodeXL can both search the net and do the visualisation (you can do this on VOSON too, though). And you can search Twitter too.

Many people on the Malaysian twitterverse will have noticed #xpaxblackberry coming up fairly often recently, and it seems clear that Xpax had purchased the help, perhaps via ChurpChurp, of various key bloggers/tweeters to get the word out. In addition, Xpax was organising an event last Saturday (which I was able to go to, after entering a competition with Nuffnang) to launch their new prepaid Blackberry service.

So - I decided to see what would happen if I put the search term - "xpaxblackberry" into NodeXL.

This is what I got on the 8th October - two days before the launch party
social network analysis visualisation nodexl twitter monetisation

This represents the tweeters who mentioned 'xpaxblackberry' in their tweet, and the lines represent who follows whom, within that group.

The size of the picture is relative to the "Betweenness centrality" of the tweeter: i.e. some people are more connected to other people, either directly or via other people, so they are 'in between' more people. For example: if I know Joe, Peter, and Jane, but none of them know each other, then I have a greater 'betweenness' value.

So, in the above graph, we can see that the four tweeters with the greatest centrality are @kennysia (BC value = 1), @benjern (BC value = 0.876), @julesisapen (BC value = 0.703), @joycethefairy (BC value = 0.671).

I also ran a 'Cluster' calculation, which calculates "the number of edges connecting a vertex's neighbors divided by the total number of possible edges between the vertex's neighbors." (Hansen, Shneiderman & Smith, p16). Basically, it tries to spot the clusters of nodes that are more interconnected amongst each other than to other people. They are represented by represented by the different colours, which can be seen easier here - four major clusters are visible.
social network analysis visualisation nodexl twitter monetisation

The next time I ran it was on the 10th October, in the afternoon before the event.
social network analysis visualisation nodexl twitter monetisation

The top four this time are: @benjern (BC value = 1), @julesisapen (BC value = 0.834), @kennysia (BC value = 0.685), @spinzer (BC value = 0.357).

The third time was on the 15th October, the Thursday following the event.
social network analysis visualisation nodexl twitter monetisation

The top four this time are: benjern (BC value = 1), @julesisapen (BC value = 0.625), @xpaxsays (BC value = 0.432), and @joycethefairy and @MyXpaX are equal in fourth place (BC value = 0.398).

• There are clearly more people, but not many more clusters here.
• Two new tweeters are prominent, @xpaxsays and @MyXpaX - they are 'corporate tweeters'.
• One interesting point is that although @joycethefairy has 1,521 followers, and @MyXpaX has only 19 followers, they have the same degree of centrality in this particular snapshot of the twitterverse. This shows how much the sample can influence the result of the 'social network' being analysed: within this sample thirteen followers of @joycethefairy and @MyXpaX tweeted 'xpaxblackberry', meaning they have the same weight in this sample. What has happened is that @MyXpaX keeps retweeting/mentioning and following tweeters who mention 'xpaxblackberry'.
• @kennysia, who was initially the most prominent and central person, has disappeared right off the graph. This must be because the archives are only kept for so long, and he has not tweeted recently enough; or that the tweets have gone beyond the 10-page limit (discussed here, I'm not sure what the exact story is). Or nodeXL only limits itself to a certain amount of days.

• To do an experiment like this better one would have to analyse more carefully over time (e.g. doing a search every hour or something - for a more sophisticated example see Tim Highfield's foray).
• What's interesting is to note the shifting of the centre of this particular 'conversation'.
• To get an idea of the relative importance of the tweeters, or at least assumed importance, it would be necessary to include some computation of the number of followers each one has.
• The reciprocity of follower/following is important too. The more followers there are compared to following, the more significant that tweeter is likely to be.
• The connections between tweeters are generally quite dense - that is to say, although there is clustering of smaller groups, there are lots of ties between the groups too.
• Overall, the leading tweeters are also leading bloggers. For the moment, I would say that there's no clear differentiation between the Malaysian blogosphere and twitterverse.


No Trackbacks


Display comments as Linear | Threaded

Polprav on :

Hello from Russia!
Can I quote a post in your blog with the link to you?

Addy on :

This open-source project is interesting. I see some dynamic filtering based on time period is allowed too. Might be useful in blog data projections, what do you think? But my fear is that it's still in beta stage...which makes is susceptible to bugs

julian on :

Hiya, I think that it's a pretty solid piece of software.

Not so sure what you mean about blog data projections tho...

mark on :

this is so very cool! not only helpful but actually loos great too! well done.. :-O

Niki Cheong on :

Wowza! How interesting. Thanks for sharing this Julian :-)

Notice how I'm not anywhere in there. i.e. Didn't get paid for the Xpax campaign. Maybe because I tweet about how I love my iPhone too often. Hehe :-D

julian on :

mark - thanks :-) The fancy visual stuff is done by the program though...

Niki - you're welcome. The Xpax was all over the place for a while, I reckon it's quite cheap for a company to get people to tweet about it.

Niki Cheong on :

Don't think it was cheap. But I suspect it's a long-term deal. So a lot was spent, probably expecting the campaign to go on for several months as well. :-D

julian on :

I suppose when I say cheap, I mean that paying bloggers/tweeters is relatively cheaper than other forms of advertisements such as celebrity endorsements, TV, newspapers, etc.

Overall, it was a large campaign - I thought it had past for the moment, but maybe more will happen in the coming months?

Niki Cheong on :

Ah yes, sorry about that. Misread your comment.

Not sure how long it will go for. Quite annoying at times, but I am very conscious of the fact that some people find my Tweets annoying too :-)

julian on :

No not really, I wasn't very clear.

Everybody can choose to follow whoever, and people who follow you will normally not find yours annoying.

With paid tweets, it's the possibility of
1) Tweets that don't go with the 'character' of the tweeter (e.g. I start to tweet about great make up)
2) Too many tweets on the same subject arriving from all directions (as with the Xpax)

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
:'( :-) :-| :-O :-( 8-) :-D :-P ;-) 
BBCode format allowed
Form options