This presentation outlines the results of an environmental scan about usage statistic solutions available to libraries, and provides the experience of implementing both vendor-based and home-grown tools

Cassady, Samuel

Collard, Debbie

Seelye, Melissa

Visser, Alie

English

Scholarship@Western

Western UniversityScholarship@WesternWestern Libraries Presentations Western LibrariesWinter 2-1-2018Making Usage Stats Usable: Evaluating Usage StatTools and Maximizing Excel/Pivot TablesAlie VisserWestern University, avisser9@uwo.caMelissa SeelyeSamuel CassadyWestern University, scassady@uwo.caDebbie CollardWestern University, dcollard@uwo.caFollow this and additional works at: https://ir.lib.uwo.ca/wlpresPart of the Collection Development and Management CommonsCitation of this paper:Visser, Alie; Seelye, Melissa; Cassady, Samuel; and Collard, Debbie, "Making Usage Stats Usable: Evaluating Usage Stat Tools andMaximizing Excel/Pivot Tables" (2018). Western Libraries Presentations. 61.https://ir.lib.uwo.ca/wlpres/61Making Usage Stats Usable:Evaluating Usage Stat Tools and Maximizing Excel/Pivot TablesSamuel Cassady, Deb Collard, Melissa Seelye, Alie VisserWestern UniversityUniversity of MichiganUsage Statistics Overview● Broad definition:○ A means of “tracking, managing, analysing and reporting information resource usage” (Zhao, 1995)● Why are they important?○ Evidence-based collections decision making● Publishers in the past have provided various types and formats of usage○ Librarians need to be able to compare ‘apples to apples and not oranges’ for fair analysis COUNTER - What is it?● COUNTER is a non-profit organization supported by a global community of library, publisher and vendor members (Project Counter, 2018)○ Launched in 2002● Project COUNTER Code of Practice: ○ Facilitate the recording, exchange and interpretation of online usage data ● COUNTER usage reports examples:○ JR1 ○ DB1○ BR2Our Development Journey at Western● Phase 1 - Needs Assessment (July – November 2016)● Phase 2 - Environmental Scan (December 2016 – February 2017)● Phase 3 - Data Collection & Implementation (March – August 2017)Phase 1: Needs AssessmentPast experience:● Intota Assessment● SUSHI (Standardized Usage Statistics Harvesting Initiative)Required capabilities of tool selected:● Consistency & accuracy● Interoperability with existing tools● Capacity to store usage statistics for all e-resources● Cost effectivenessPhase 2: Environmental Scan● Surveying the usage statistics tools available from vendors ● Surveyed what usage statistics tools other institutions were using● We evaluated 4 vendor products, 3 open source products, and 3 homegrown tools from other institutionsWhy these tools did not meet our needs:● Lacking in currency flexibility● No customized fields● No bulk uploading of usage reports● Inability to work with our knowledgebase● Extensive IT support● CostThe Evolution of Our Homegrown ToolUsage Stats Archive● Reports saved in network drive● Organized by publisher● ~240 sub-foldersUsage by Individual TitleUsage by SubjectFuzzy Demonstrationhttps://www.microsoft.com/en-ca/download/details.aspx?id=15011Next Steps● How the tool is being used today● CRKN Journal Usage Project & subject codes = JIM● Annual updating, task time tracking● Great leap forward?:  LSP that includes a customizable, flexible usage toolTips & Tricks Google Doc: https://docs.google.com/document/d/1gzR-bl3eZzJvfAHhrs8zf41g-4HzLgQVJTAduzz2c6w/edit?usp=sharingReferencesDavis, P. M., & Price, J. S. (2006). EJournal interface can influence usage statistics: implications for libraries, publishers, and Project COUNTER. Journal of the Association for Information Science and Technology, 57(9), 1243-1248. doi:10.1002/asi.20405 Miller, A. (2014). Introduction to Using Excel®Pivot Tables and Pivot Charts to Increase Efficiency in Library Data Analysis and Illustration. Journal of Library Administration, 54(2), 94-106. doi:10.1080/01930826.2014.903365Project Counter. (n.d.). About. Retrieved January 21, 2018, from https://www.projectcounter.org/about/Sasyk, Z. (2017, March 16). Beyond Vendor Solutions: Homegrown COUNTER Usage Statistics Reports and Analysis. Retrieved January 29, 2018, from https://2017libtechconference.sched.com/event/954S/beyond-vendor-solutions-homegrown-counter-usage-statistics-reports-and-analysisZhao, D. (1995). Usage statistics collection and management in the ELINOR electronic library. Journal of Information Science, 21(1), 1-9. doi:10.1177/016555159502100101 Questions?Tips & Tricks Google Doc: https://docs.google.com/document/d/1gzR-bl3eZzJvfAHhrs8zf41g-4HzLgQVJTAduzz2c6w/edit?usp=sharing

Making Usage Stats Usable: Evaluating Usage Stat Tools and Maximizing Excel/Pivot Tables

https://ir.lib.uwo.ca/cgi/viewcontent.cgi?article=1064&amp;context=wlpres

Making Usage Stats Usable: Evaluating Usage Stat Tools and Maximizing Excel/Pivot Tables

Abstract

Similar works

Full text

Available Versions

Scholarship@Western