WordPress Stats in R: Generating postview sparklines using SparkTable

After posting Analysing WordPress post velocity and momentum stats with Google Sheets (Spreadsheet) Tony quickly came back with WordPress Stats in R, which includes a handy custom function for querying the WordPress Stats API. Something I wanted to do in my original post was to generate sparklines for post activity. I wasn’t able to find […]

Analysing WordPress post velocity and momentum stats with Google Sheets (Spreadsheet)

Like other wordpress.com and self-hosted wordpress blogs using Jetpack I got my annual report. This left some questions about the posts made later in the year that hadn’t had time to collect views so I’ve created a Google Spreadsheet template which reveals some more answers.

Twitter provides proof of real-time engagement with the public: How to record it as evidence

Increasing staff are required to provide evidence of the impact of their research. Twitter can be a useful channel to track reaction, but do you have a strategy for recording this evidence. I provide some suggestions

Guest Post for Big Data Week #bdw13: Getting Creative with Big Data and Google Apps

I was recently asked to write a guest post for Big Data Week on using Google Apps as an interface for Big Data. For the post I decided to revisit an old recipe which uses Google Sheets (Spreadsheets) and Google Apps Script to interface the Twitter and Google Analytics API

CFHE12 Analysis: Summary of Twitter activity

In this post I want to pull together a couple of ideas around some of the measurable user activity generated as part of CFHE12. This will mainly focus around Twitter with some data from blog posts. I conclude that there are some simple opportunities to incorporate data from twitter into other channels, for example, summary of questions and retweets.

Summary of social monitoring tools and recipes I use at JISC CETIS

Tools and recipes I use for monitoring and reporting impact. All of the tools use Google Spreadsheets/Apps Script which is free for anyone to use with a Google account, and all the recipes use free tools (the exception being owning a copy of Excel).

Visualizing cMOOC data: Extracting and analysing data from FeedWordPress part 1 #ds106 #NodeXL

Aggregation of content is at the heart of cMOOC design and the RSS resyndication tool FeedWordPress is at the heart of a number of courses including ds106. In this most I explore how data collected by FeedWordPress can be refined and visualised in NodeXL to give an overview of content and using betweenness centrailty identify influencial posts

Notes from the Twitter backchannel at eAssessment Scotland 2012 #eas12

On Friday (31st August) I was at eAssessment Scotland 2012. In a continuation of my analysis of threaded discussion in a event backchannel I have a quick look at eas12 and reveal a different pattern of communication which shows that the audience was in broadcast mode.

How JISC CETIS dashboard social activity around blog posts using a splash of data science

Behind the scences look at how we (JISC CETIS) can quickly develop dashboards to monitor activty around blog posts (using Google Spreadsheets of course 😉

Google Spreadsheet Template for getting social activity around RSS feeds

Here’s a Google Spreadsheet template I’ve developed from some leftovers which pulls data together from comment feeds, Twitter and Delicious (with social counts for these plus Facebook, LinkedIn and Google+)

« Previous PageNext Page »
css.php