Using EZ Proxy and Google Analytics to Evaluate

Using EZ Proxy and Google Analytics to Evaluate Electronic Serials Usage 26 th North Carolina Serials Conference Chapel Hill, North Carolina March 31, 2017 H. Jamane Yeager Electronic Access Librarian Jerry Waller Systems Librarian

What are we trying to find ? • • • How our users use our electronic resources How our users access our journal articles When and where students access books in our Discovery System Are our users in the library or outside of the library How are our users accessing the library portal, mobile, desktop, google scholar, etc.

What data are we investigating? • EZ Proxy Logs August 1, 2016 – March 11, 2017 September 1, 2016 – December 31, 2016 Fall Semester January 1, 2017 – January 31, 2017 Winter Term February 1, 2017 – March 17, 2017 Spring Semester * EZ Proxy dropped data for March 11, 2017 to March 27, 2017

What data are we investigating? • Google Analytics data August 1, 2016 March 11, 2017* September 1, 2016 – December 31, 2016 Fall Semester January 1, 2017 – January 31, 2017 Winter Term February 1, 2017 – March 17, 2017 Spring Semester

Tools Used • • • Bash scripting Mac. Vim Reg. Ex EZPaarse Open. Refine Tableau

EZProxy Logs: A Voyage of Discovery We have a self-hosted ezproxy server.

EZProxy Logs: A Voyage of Discovery . . . that we do not administer. : (

EZProxy Logs: A Voyage of Discovery Intermezzo

Intermezzo Access vs. Control

EZProxy Logs: A Voyage of Discovery

EZProxy Logs: A Voyage of Discovery Mad Max: Fury Road, 2015 Retrieved 27 Mar 2017 https: //imgur. com/gallery/hs. UZqgp

EZProxy Logs: A Voyage of Discovery

EZProxy Logs: A Voyage of Discovery Hello. What’s this, then?

Holy Crawfish! The EZProxy Logs are Gigagigantic!

Holy Crawfish! Gigagigantic (noun): a text file that is approximately 1 gigabyte in size.

Holy Crawfish! Why are they so big?

Why Are They so Ginormous? Can we make them smaller?

Why Are They so Ginormous? Issue Number 1 ""

Why Are They so Ginormous? This is better: "jwaller" "facstaff"

Why Are They so Ginormous? By default, it logs every resource summoned via ezproxy.

Systems Librarian, Know Thy Data! Every. css

Systems Librarian, Know Thy Data! Every. jpg

Systems Librarian, Know Thy Data! Every. woff

Why Are They so Ginormous?

Tools No filters. Lots of noise. What to do?

Tools Mac. Vim and Regular Expressions

Tools A Note on Regular Expressions

Tools g/[0 -9. ]* "" ""/normal dd

Tools

Tools EZPaarse https: //github. com/ezpaarse-project/

EZPaarse Caveats

Logins 31 cb e 9 35 0 e 8 b 3 5 5 11 0 e 2 a aa aa c 2 2 a 0 60 454 81 a 3 e d 2 98 d 1 b 4 480 22 1 d 4 f 07 78 46 1 c cb 8 e ee 9 a c 1 66 39 4 97 bf a 5 ff f 563 ab b 01 c 4 dc 0 bb c 3 d 5 b e 7 3 c 1 a 85 e 1 c 6 f 1 c 6 0 ef e 8 fe b 96 19 b 3 93 e 7 35 86 08 76 d 9 19 ab a 6 14 5 a 1 b 77 6 f e 8 fa fe a 6 4 cb c 4 8 56 70 602 e 6 e d 6 b 2 8 e a 7 a 2 0 30 af 72 42 f 6 33 7 b d 6 64 75 d 6 4 e 01 c 0 d 1 37 b 5 621 fc b 53 b 4 b 2 87 56 bd 92 7 a 41 2 e fa ab e 6 a 0 e b 1 85 675 2 a fa 0 e e 8 fb f 44 d 3 56 17 82 52 9 e 83 678 1 f 5 c 91 8 a 41 33 2 e 93 6 f 8 b 71 ed 683 6 f 36 51 bd 95 cd 4 5 b 4 e 5 d 0 e 0 b ab 08 d 0 52 83 0 c b 9 26 7 f 808 2 c 62 11 37 4 b 57 df 43 f 4 8 3 d 0 f 8 e c 2 7 d 4 04 ec 0 92 5 854 20 cc 9 b 0 87 fd d 1 b 34 13 02 13 c b 39 4 c 07 ef 5 a 53 1 d 8 f a 2 10 0 f 02 7 c f 6 d 3 5 b 02 922 9 e 50 58 5 b c 1 e 5 bc 64 98 9 c 5 e 01 0 f 27 4 b 0 c 8 a fb c 3 1014 b 3 d 83 3 a 23 de d 2 8 f 48 80 87 94 58 d 1 5 d f 7 1082 b 8 33 38 fb 4 e f 8 4 c f 4 3 2 f d 8 5 c 09 01 95 18 Count 1233 2 f d 1 17 9 b a 4 c 4 a 6 e 1 d b 2 ed f 0 3 d c 2 5 6 a 31 dd 9 e cc 5 1 a a 7 a 4 a 6 f 59 ea af ab fe 8 46 f 9 5 a e 9 10 0 b fe 94 e 0 ef c 8 e 1 3 c 21 a 8 98 10 40 0 a 0 d 0 d de d 8 cb 25 72 b 9 bb c 7 14 d 4 b 8 4 48 39 Student, Faculty, Staff Logins 3446 453 448

Journals 367 Count 177 119 108 89 73 57 [VALUE] 31 Nature (empty) The Journal of Comparative Organic Education Chemistry Review Public Relations Review The Journal of Personality and Journal of the Politics Individual Academy of Differences Marketing Science Journal Titles 27 (empty) Annual Review of Entomology

Analysis EZ Proxy Logs Journals ISSN Journal 0028 -0836 9780123742261 367 177 0010 -4086 Nature (empty) The Journal of Organic Chemistry Comparative Education Review 0363 -8111 Public Relations Review 89 0022 -3816 The Journal of Politics Personality and Individual Differences Journal of the Academy of Marketing Science 73 (empty) 27 0022 -3263 0191 -8869 0092 -0703 Count - ISSN 119 108 71 31

Platforms Count 66630 22933 8345 5920 Ebsco. Host JSTOR Hein. Online Web of Science 4183 3125 High. Wire Science Direct Platforms 1694 1624 1218 1141 Springer Taylor et Francis Wiley Gale Cengage

Analysis EZ Proxy Logs Platform Count Ebsco. Host 66630 JSTOR 22933 Hein. Online 8345 Web of Science 5920 High. Wire 4183 Science Direct 3125 Springer 1694 Taylor et Francis 1624 Wiley 1218 Gale Cengage 1141

Domain m co 434 e. om . c ub ur at . n w w w . c om 483 ag ep q. s u m ed u. sig ht in al d er jh e. us 638 gc . e m w w w co 1053 m r. ge om . c ge r 1141 rin sp oa d. nl w m co 1218 do rin sp k. p. co m 1624 lin y. ile ou gr al e . g go m co co m e. lin. w ra ry el ib ct. di re df on an . t w lin on w dg e. le m 6157 w ce ci en . s w w ow co t. 6379 w fk n os om . c st ho sc oh eb b. eb o . w ps ap eb. co ho 8345 w bs . a. e eb w g or m rg co e. lin on co bs . e nt te in he t. or. o os eb sc oh st . j m co t. Count 24435 co n b. s. ed w w w os oh eb sc a. s. ed Consultation by Domain 22933 22080 7611 5906 3035 398 375

Analysis EZ Proxy Logs Domain Count eds. a. ebscohost. com 24435 www. jstor. org 22933 eds. b. ebscohost. com 22080 heinonline. org 8345 content. ebscohost. com 7611 web. a. ebscohost. com 6379 web. b. ebscohost. com 6157 apps. webofknowledge. com 5906 www. sciencedirect. com 3035 www. tandfonline. com 1624

Segue Google Analytics

Google Analytics Definitions • Visits/Sessions – A visit is technically any web=accessible device that interacted with the website during a particular time frame. • Unique Visitors – Any visit from a specific IP address would increment the Unique Visitors count only once while going out of the website and going back in agai n would increment the Visits count on as many times as the user goes back and in on that day. • Page Views – An instance of a page being loaded (or reloaded) in a browser. Total number of pages viewed. • Page/Session (Average Page Dept) The average number of pages viewed during a session. • Bounce Rate – The number of bounces divided by the number of visits to a website. for 5 seconds or less.

Google Analytics Definitions Continued • Content - Areas of library websites will include instructional web pages. A common conceptual goal is to increase learning, which is demonstrated in Web analytics by visitors who stay on the page longer. • Pages Per Visit – page depth, averages the number of web pages visitors view before exiting the site. • Duration of visit – referred to as time on site, records the among of time a visitor is on a website or an individual web page

Google Analytics Key Performance Indicators • • Visits Page views Duration of visit Pages per visit

Analysis of Data Using Google Analytics • August 1, 2016 – March 11, 2017 Audience Overview • August 1, 2016 – March 11, 2017 Pages • Sept 1, 2016 –Dec. 31, 2016 Fall Semester Audience Overview • Sept 1, 2016 – Dec. 31, 2016 Fall Semester Sessions vs Pageviews • Sept 1, 2016 – Dec. 31, 2016 Fall Semester Session Duration • Oct. 9, 2016 – Oct. 14, 2016 Fall Break & • March 12, 2017 – March 17, 2017 Spring Break Page. View Comparison

What We Learned! • • No Tool will do everything! Web analytics tools or methods of tracking data change often Google Analytics is not tracking our WMS at this time Google Analytics is not tracking our Research guides

What We Need to Do Next! • Set internal benchmarks • Set up Event tracking • Set a regular time to monitor the data collected, monthly, quarterly, or yearly • Monitor our analytics against our vendor database statitics

Bibliography • Farney, Tabatha, and Nina Mc. Hale. Maximizing Google Analytics: Six High-Impact Practices. Chicago, IL: ALA Techsource 2013. • Farney, Tabatha, and Nina Mc. Hale. Library Technology Reports: Web Analytics for Information Professionals. New York: American Library Association 2014. • Fagan, Jody C. “The Suitability of Web Analytics Key Performance Indicators in the Academic Library Environment. ” The Journal of Academic Librarianship 40 (1)2014: 25– 34. doi: http: //dx. doi. org/10. 1016/j. acalib. 2013. 06. 005. • Coughlin, Daniel M, Mark C Campbell, and Bernard J Jansen. “A Web Analytics Approach for Appraising Electronic Resources in Academic Libraries. ” Journal of the Association for Information Science and Technology 67 (3)2016: 518– 34. doi: 10. 1002/asi. 23407.

Bibliography • Le. Maistre, Tiffany M. “Cost Per Use: Analyzing EZProy Logs for Assessment. ” Proceeding of the Charleston Library Conference. 2015. https: //doc. lib. purdue. edu/charleston. • Vecchione, Amy, Deana Brown, Elizabeth Allen, and Amanda Baschnagel. “Tracking User Behavior with Google Analytics Events on an Academic Library Web Site. ” Journal of Web Librarianship 10 (3)2016: 161– 75. • Yang, Le, and Joy M Perrin. “Tutorials on Google Analytics: How to Craft a Web Analytics Report for a Library Web Site. ” Journal of Web Librarianship 8 (4)2014: 404– 17. • Google Analytics Help – Google Support – https: //support. google. com/analytics

Questions