Example Twitter Search Report: #iwmw12

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

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 iwmwlive 20 5 5 92
2 PlanetClaire 13 10 2 59
3 iwmw 10 2 22
4 millaraj 9 1 3 25
5 sheilmcn 7 3 3 34
6 mhawksey 7 3 1 10
7 briankelly 5 14 3 30
8 Webdunk 5 2 6 20
9 garethjms 5 4 11
10 mariekeguy 4 7 7 37
Top ten users by ‘RT by’‘ count
Name rtbyCount rtofCount toCount fromCount
1 jessica_hobbs 11 1 23
2 sharonsteeples 10 1 4 32
3 mariekeguy 7 4 7 37
4 suzshi 7 4 31
5 Webdunk 6 5 2 20
6 CMS_Elevator 6 10
7 iwmwlive 5 20 5 92
8 ScruffianPeej 4 1 15
9 sheilmcn 3 7 3 34
10 briankelly 3 5 14 30
Top ten users by 'from’‘ count
Name fromCount rtbyCount rtofCount toCount
1 iwmwlive 92 5 20 5
2 PlanetClaire 59 2 13 10
3 mariekeguy 37 7 4 7
4 sheilmcn 34 3 7 3
5 sharonsteeples 32 10 1 4
6 suzshi 31 7 4
7 briankelly 30 3 5 14
8 millaraj 25 3 9 1
9 jessica_hobbs 23 11 1
10 iwmw 22 10 2

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 

## 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:

## Error: invalid multibyte string at '<a3>150 f<6f>r. Kettle, tea bags,
## en-suite, Freeview! But no concierge so got a bit lost #IWMW12'

## Error: object 'df.data.t' not found

## Error: object 'tag.count' not found

## Error: object 'tag.count' not found

plot of chunk unnamed-chunk-14 

## Error: object 'tag.count' not found

## Error: object 'tag.count' not found