Child pages
  • 8 - Measure activity by user

Sakai Usage Data Work Group: Sample User Report

 

This sample report for a single user, parkcz , shows usage by user in a single report that combines data from different sources. It is presented in this format to be a readable example; however, the required format would be more like a spreadsheet in which each row represents a unique user, and columns are the variables listed here and the current values for each user.

 

Some definitions:

 

  • Views are the number of times the users viewed this content. This is generally a higher value than visits. For example, “parkcz viewed resources 20 times the last week”.

 

  • Visits are the number of sessions that included views of this content. For example, “parkcz logged in 5 times last week.”

 

  • Variables are the views, objects, or attributes we want to measure.

 

  • Values are the quantitative measurement. This typeface indicates that we want to “drill down” into that value to look at the specific views, objects, or attributes that are included.

 

The Source column lists one of several data sources that currently store usage data.
 

  • The Sakai database. This typeface refers to the table in the Sakai database that stores the data.
     
  • Event logs. Text files parsed by day that list code-specified events and associated users, sites, and times. These are generated from a database query and imported into third-party log analysis software (in the UM case, that’s NetTracker).
     
  • Web server access logs. Standard access logs specified and produced by the web server software (in the UM case, that’s Apache).

 

 

Sample User Report - parkcz

 

Variable

Value

Source

UserID

parkcz

ctools_user.sakai_site

Affiliation

Information MSI - Student

Rackham - Student

UM User Directory Affiliation

# of Memberships

13

List of site titles, site ids, creation date

ctools_user.sakai_site_user

# of Course Sites

7

List of site titles, site ids, creation date, # of members

ctools_user.sakai_site_user and ctools_user.sakai_site

# of Project Sites

6

List of site titles, site ids, creation date, # of members

ctools_user.sakai_site_user and ctools_user.sakai_site

# of Grad Tools Sites

0

 

ctools_user.sakai_site_user and ctools_user.sakai_site

# of Visits

3

List of visits with time, length, entry page, exit page, browser, platform, # of views

Event Logs (NetTracker Repeat Visitor Summary, filtered by userID, Visit Breakdown)

# of Views

10

List of views with time, page, browser, platform, event

Event Logs (NetTracker Repeat Visitor Summary, filtered by userID, View Breakdown)

Average # of Sites/Visit

1

 

Calculate from event logs (NetTracker Repeat Visitor Summary, filtered by userID, site.visit event)

Average # of Views/Visit

3

 

Calculate from event Logs (NetTracker Repeat Visitor Summary, drill down to Visit Breakdown)

Notification – Announcements

Block

 

ctools_user.sakai_preferences (XML)

Notification – Resources

Digest

 

ctools_user.sakai_preferences (XML)

Notification – Email

At once

 

ctools_user.sakai_preferences (XML)