Beyond Counter

1
Beyond Counter? NFAIS Conference on Usage
Statistics New Developments and
Practical Applications
Joe Zucca Director for Planning and
Communication University of Pennsylvania
Libraries
2
Data Farm Strategy
3
Thinking About Practical Applications
Can we leverage our many raw data assets?
What policies, logic, conditions govern those
data sources?
Can the raw data be converted into useful
structures?
Can those structures improve the horse power of
our data?
4
Schematic View of Data Logging Processes SUSHI
Vendor site
Data Farm SUSHI Harvester API
ERM
Data Farm
5
Data Farm COUNTER Report Generator
6
(No Transcript)
7
Distribution of Electronic Resource Use, FY2008.
Based on Internal Tracking
8
E-Resource Use (Logins). Selected Undergraduate
Dorms Based on Penn IP
Real-time Oracle Log of Requested Resources
Stouffer
Harrison
Gregory (incl MLp)
Logins Per Capita
Logins Per Capita
Dubois (afr-Amr Std)
Kings
Hill
Percent Freshman
9
Schematic View of the Data Logging Process WEB
Interface
1. User initiates a session using pages spawned
by a database
10
(No Transcript)
11
E-Journal Use (Views) by Undergraduates Source
EZ-Proxy
Based on ezproxy log analysis, Je-Aug, 2007,
Feb-Mar 2008. 215,000 observations
12
E-journal Use by Penn Communities, Based on
EZ-Proxy Log Analysis
Based on ezproxy log analysis, Je-Aug, 2007,
Feb-Mar 2008. 215,000 observations
13
Use of Electronic Journals, Subject Correlations,
Based on EZ-Proxy
Based on ezproxy log analysis, Je-Aug, 2007,
Feb-Mar 2008. 215,000 observations
14
Penns Use of Electronic Journals by Subject
Multi-Dimensional Scaling Model
Based on ezproxy log analysis, Je-Aug, 2007,
Feb-Mar 2008. 215,000 observations
Multidimensional Scale of E-Resource Use by
Subject All Users
Dimension II Humanistic-Science
Dimension II Qualitative-Quantitative
15
Schematic View of the Data Logging Process PROXY
Service
1. User initiates a session using pages spawned
by a database
16
Thinking About Practical Applications
17
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx-zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
18
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
xxx.xx.xxx.xxx .edu on-campus Van Pelt
Library staff office July 26, 2007 341
p.m. Device Mac OSX Browser Safari
19
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx-zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
Referring URL library web page listing
resources on Psychology (community 59) Olson,
Coordinating Bibliographer
20
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
zucca Penn authentication key Provost cntr
LIBRARY staff
21
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
SessionID 10335905PsycInfo (resource identifier
7014)
22
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
sfx_session_idJournal of Experimental Child
Psychology, Relations Among Musical Skills,
Phonological Processing and Early Reading Ability
in Preschool Children.
23
Events a Structure for Library Decision Metrics
EVENT
24
Data Farm Tiered Framework
Service Environment
Repository processes
Analysis
oracle
DATA STORE query (sql) parse, resolve, anonymize,
secure!
XML
perl
XL
25
Data Farm Tiered Framework Details Metridoc
Setting
Tier III MIS Tools Services.
RSS
Oracle
XLS
XML
Admin Interface
Admin users create metridoc schema, specifying
structures for raw data sources
Tier I. Data Ingest
Process Data
Raw data ingest and handoff for resolving into
Metridoc
Schema Repository
Tier II. Repository
Soap Connection
SQL Generator spawns tables following
user-defined schema
Client
Resolver issues data as event-level metridoc xml
Resolver
SQL Generator
Soap Connection
Like a prism, the SQL Generator parses metridoc
info into relational structures within the Data
Repository
Logs other Data sources
Data Repository
Voyager People Data ERM
26
The Goal? Higher Resolution, Better Intelligence

• Simple Rates of Consumption COUNTER
• Count Views, Sessions by Resource

• Financial Analysis
• Cost Per Use Views/Expenditure

• Audience Metrics
• Per Capita Use Aggregated Views/Total
  Audience
• Per Capita Use Views/Community of Interest
  or Status
• Patterns of Use Cross-Disciplinary
  Interests, Other Population Affects

• User Behavior
• Web Interface Design
• Indexing

• Integrated Business Analysis print, digital,
  non-collection services

• The Intersection of Use, Quality, and Customer
  Satisfaction