Example Twitter Search Report: #opened12

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

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	sleslie	30	8	4	27
2	creativecommons	30			2
3	grantpotter	20	4	13	49
4	giuliaforsythe	19	2		5
5	BCcampus	17		4	11
6	cristobalcobo	17			11
7	cogdog	15	10	1	33
8	KavuBob	15	2	14	30
9	CommOER	15		3	21
10	clintlalonde	15	4	5	19

Top ten users by ‘RT by’‘ count
	Name	rtbyCount	rtofCount	toCount	fromCount
1	CosmoCat	23	12	3	42
2	Bill_world	18	1	1	35
3	wfvanvalkenburg	16	5	2	46
4	KavuBob	14	15	2	30
5	grantpotter	13	20	4	49
6	philosopher1978	10	5	3	29
7	time_motion	8	1		12
8	PeteForsyth	7	5	2	15
9	davidkohler	7	1		14
10	tjbliss	6	8	5	26

Top ten users by 'from’‘ count
	Name	fromCount	rtbyCount	rtofCount	toCount
1	grantpotter	49	13	20	4
2	wfvanvalkenburg	46	16	5	2
3	CosmoCat	42	23	12	3
4	Bill_world	35	18	1	1
5	cogdog	33	1	15	10
6	KavuBob	30	14	15	2
7	philosopher1978	29	10	5	3
8	sleslie	27	4	30	8
9	tjbliss	26	6	8	5
10	DrGarcia	22	3	2	6

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 'It is cracked ������opened12 httptcor4QGwp7P' in
## 'utf8towcs'

## Error: invalid input 'It is cracked ������opened12 httptcor4QGwp7P' in
## 'utf8towcs'

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

plot of chunk unnamed-chunk-15