Example Twitter Search Report: #ili2012

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

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

It's easy to add in Google Chart component sortable tables (click on column header to sort by column):

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 AlisonMcNab 71 4 17 112
2 karenblakeman 45 4 6 37
3 daveyp 32 1 22
4 carolgauld 29 3 55
5 tadawes 29 2 20 36
6 RossiAtanassova 29 1 14
7 archelina 24 1 2 48
8 CullenMarieG 21 1 41
9 mstephens7 19 1 18 30
10 dean_frey 16 5 34
Top ten users by ‘RT by’‘ count
Name rtbyCount rtofCount toCount fromCount
1 infointuitive 181 1 185
2 tadawes 20 29 2 36
3 mstephens7 18 19 1 30
4 AlisonMcNab 17 71 4 112
5 NinnaWiberg 16 2 32
6 annostman 12 1 1 13
7 biall_uk 10 2 10
8 vampmuseeternal 9 9
9 BaileyEnquire 8 8 1 27
10 ed_jewell 8 3 21
Top ten users by 'from’‘ count
Name fromCount rtbyCount rtofCount toCount
1 infointuitive 185 181 1
2 AlisonMcNab 112 17 71 4
3 carolgauld 55 3 29
4 archelina 48 2 24 1
5 CullenMarieG 41 1 21
6 karenblakeman 37 6 45 4
7 tadawes 36 20 29 2
8 dean_frey 34 5 16
9 NinnaWiberg 32 16 2
10 mstephens7 30 18 19 1

Now let's 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

plot of chunk unnamed-chunk-11

Or only show RTs:

plot of chunk unnamed-chunk-12 

## Error: invalid input 'ili2012 interesting presentation from Cranfield
## University Library A CRMCMS system to see your interactions with employees
## 😄' in 'utf8towcs'

## Error: invalid input 'ili2012 interesting presentation from Cranfield
## University Library A CRMCMS system to see your interactions with employees
## 😄' in 'utf8towcs'

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

plot of chunk unnamed-chunk-15

Top ten tags
tag tagCount
1 #ili2012 1367
2 #ILI2012 127
3 #B203 46
4 #lidp 23
5 #LIDP 17
6 #B204 15
7 #C201 15
8 #CILIP 12
9 #GrahamCoult 11
10 #SoTrue 8