Example Twitter Search Report: #sotondiglit

A graphical report on a search for up to 1500 recent tweets tagged #sotondiglit.

If you want to run the script used to generate this report yourself using the latest version of RSTudio, you can find it here: https://github.com/psychemedia/Twitter-Backchannel-Analysis/blob/master/twitterSearchDemoX.Rmd

(It requires a few R libraries you may need to install…)

First, who is being RTd, and how often were they RTd in the sample?

[Disable output with r opts_chunk$set(echo=FALSE, message=FALSE) in single backtick quotes]

Let's start by seeing who's been tweeting most amongst the sampled tweets…

plot of chunk unnamed-chunk-1

And who's been RTd most:

plot of chunk unnamed-chunk-2

Start off with some simple summary tables of who's been tweeting, RTd, etc.

Top ten users by ‘RT of’ and ‘from’ count
Name rtofCount toCount rtbyCount fromCount
1 timbuckteeth 41 14 19 66
2 cristinacost 32 8 5 59
3 dajbconf 23 7 8 69
4 C01Clem 16 6 1 31
5 suukii 13 2 30 60
6 suebecks 13 7 15 49
7 lisaharris 13 3 13 28
8 rikkiprince 11 7 7 29
9 GraemeEarl 11 2 3 21
10 IvanMelendezCh 11 1 3 19
Top ten users by ‘RT by’‘ count
Name rtbyCount rtofCount toCount fromCount
1 fionajharvey 33 10 3 63
2 suukii 30 13 2 60
3 madelinep 22 10 9 59
4 timbuckteeth 19 41 14 66
5 Emmadw 18 9 9 48
6 suebecks 15 13 7 49
7 lisaharris 13 13 3 28
8 CITEsoton 12 6 2 24
9 dajbconf 8 23 7 69
10 Tim10101 8 4 3 28
Top ten users by 'from’‘ count
Name fromCount rtbyCount rtofCount toCount
1 dajbconf 69 8 23 7
2 timbuckteeth 66 19 41 14
3 fionajharvey 63 33 10 3
4 suukii 60 30 13 2
5 cristinacost 59 5 32 8
6 madelinep 59 22 10 9
7 suebecks 49 15 13 7
8 Emmadw 48 18 9 9
9 C01Clem 31 1 16 6
10 mushychelle 30 5 5 8

It's easy to add in Google Chart component sortable tables:

Now lets try an accession plot (based on an oriiginal idea by @mediaczar)

plot of chunk unnamed-chunk-8

The accession plot shows the accession of folk using the search term in the tweet sample, and each of their sampled tweets thereafter.

We can add value to the chart by colouring tweets to see which were original tweets and which were RTs.

plot of chunk unnamed-chunk-9

We can also limit the chart to only show original tweets:

plot of chunk unnamed-chunk-10

Or only show RTs:

plot of chunk unnamed-chunk-11

## Warning: font width unknown for character 0x1d
## Warning: font width unknown for character 0x1d
## Warning: font metrics unknown for character 0x1d
## NULL

plot of chunk unnamed-chunk-12

## NULL

plot of chunk unnamed-chunk-13

Let's look to see what tags were used in the sample four times or more:

plot of chunk unnamed-chunk-14

Top ten tags
tag tagCount
1 #sotondiglit 1245
2 #diglit 15
3 #fb 10
4 #career 6
5 #openbadges 6
6 #H800 5
7 #digitalwisdom 5
8 #solstice2012 5
9 #if2012 4
10 #rminhe 4