<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Any solution to gathering usage stats is going to be time-laborious or expensive or some balance of time and cost. There is a growing set of open source solutions, but they require some programming and data management skills. There are
also some prominent stats gathering services, but these are costly and still require a certain amount of skills to analyze and manage the data.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I think the most economical solution is investment in advanced Excel training and then use Excel for compiling data from the files that are downloaded. This requires access to Excel and training, but once this investment is made, the data
features enable data from multiple files to be “queried”. This is especially good if you don’t have a very large collection of ebooks, because there are limits to number of rows that Excel can handle.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The problems you’re having with LibInsights and SUSHI are more likely related to the platforms providing the data rather than LibInsights itself. Many of our platforms that claim to have SUSHI enabled do not work or have such severe limits
of time or data that we just end up downloading the data manually. What a waste.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The other problem unique to ebook usage is, of course, the metric-level problem…that is, book- vs. chapter-level. This is somewhat reconciled with COUNTER R5 reports (Section_Type field), but it does make trend analysis difficult to reconcile
with R4 metrics (BR1 vs. BR2). Hopefully, this problem will dissipate over time, but there are still issues (e.g. what is “section” – chapter? Sub-sections of a chapter?).
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Good luck<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Karen R. Harker, MLS, MPH<o:p></o:p></p>
<p class="MsoNormal">Collection Assessment Librarian<o:p></o:p></p>
<p class="MsoNormal">University of North Texas Libraries<o:p></o:p></p>
<p class="MsoNormal">1155 Union Blvd.<o:p></o:p></p>
<p class="MsoNormal">#305190<o:p></o:p></p>
<p class="MsoNormal">Denton, TX 76203-5017<o:p></o:p></p>
<p class="MsoNormal">940-565-2688<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org> <b>On Behalf Of
</b>Heidi Card<br>
<b>Sent:</b> Friday, June 4, 2021 1:05 PM<br>
<b>To:</b> Adrian Graham <adrian.graham@austincc.edu>; eril-l@lists.eril-l.org<br>
<b>Subject:</b> Re: [Eril-l] [External] Ebook Statistics: Software Solutions? Best practices?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Hello! <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Thank you for asking this question – I’ve wanted to get an idea of what other folks do, too, as I work without an ERM. My method has consisted separate spreadsheets that I add together, rather than one long
one. I have also been working with LibInsight (via Springshare), which allows us to set up SUSHI for *<b>some</b>* resources. But I’ve found many inconsistencies with it (and lots of error fetching via SUSHI), and end up going back to the vendors to verify
the numbers. I’ve always felt more comfortable going directly to the vendor. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">I look forward to hearing what other folks are doing!
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Best, <o:p></o:p></span></p>
<div style="border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Heidi <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><b><span style="font-size:14.0pt"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt">Heidi Card </span></b><span style="font-size:12.0pt">(she/her),<b> MA, MLIS</b><o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:12.0pt">Access & Discovery Librarian</span></i><span style="font-size:12.0pt">,
<b>Collections & Metadata Services<o:p></o:p></b></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#2F5496">Gumberg Library | Duquesne University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#2F5496;background:#FAFAFA">600 Forbes Avenue, Pittsburgh, PA 15282<br>
</span><span style="font-size:12.0pt"><a href="mailto:cardh@duq.edu"><span style="color:#0563C1">cardh@duq.edu</span></a> |
<span style="color:#2F5496">412.396.5233<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1F4E79"><a href="https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.duq.edu%2Flibrary&data=04%7C01%7Ckaren.harker%40unt.edu%7C186a275c7818475b6d7308d927834fad%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C637584267198405149%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=kc0vOHz4LnrSrJ8YilewGC7%2Bg28imxeqFfEi9JIAsNs%3D&reserved=0"><span lang="EN" style="color:#1F4E79">www.duq.edu/library</span></a></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt">I acknowledge and honor the
<a href="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.shawnee-tribe.org%2F&data=04%7C01%7Ckaren.harker%40unt.edu%7C186a275c7818475b6d7308d927834fad%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C637584267198405149%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Q1cdrg4vRoh9GHbZlo%2BRvQaR21l%2F%2F7bApT51zGXCJ1A%3D&reserved=0">
<span style="color:#0563C1">Shawnee</span></a> and <a href="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.osagenation-nsn.gov%2F&data=04%7C01%7Ckaren.harker%40unt.edu%7C186a275c7818475b6d7308d927834fad%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C637584267198415141%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=i6cgjhMszkMcz9eDJqYwNgaWiBYe851UQJRz8V4T1iA%3D&reserved=0">
<span style="color:#0563C1">Osage</span></a> peoples, past, present, and future, and all of the original Indigenous peoples of the land upon which Duquesne University, Pittsburgh, PA stands.<span style="color:#500050"> <a href="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fnative-land.ca%2F__%3B!!KGKeukY!hwVSpngdzjG6ntQbVc2XbH1KgZNaFcsVa_KOZGxfbG03aniAyA7g73mexh6YkpiS-Wll%24&data=04%7C01%7Ckaren.harker%40unt.edu%7C186a275c7818475b6d7308d927834fad%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C637584267198425136%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Jj2FqczffcDKrs4rpCUHP0S0aZNoOZn097eZ6m5Del0%3D&reserved=0" target="_blank"><span style="color:#1155CC">Whose
land are you on?<br>
</span></a></span></span></i><span style="font-size:8.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><b>From:</b> Eril-l <<a href="mailto:eril-l-bounces@lists.eril-l.org">eril-l-bounces@lists.eril-l.org</a>>
<b>On Behalf Of </b>Adrian Graham<br>
<b>Sent:</b> Friday, June 4, 2021 12:31 PM<br>
<b>To:</b> <a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a><br>
<b>Subject:</b> [External] [Eril-l] Ebook Statistics: Software Solutions? Best practices?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi, all!<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">How do you compile ebook title level usage statistics and provide access to your selectors for collection development and weeding?<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Like many of us, our ebook platforms have grown substantially over the past few years and we are searching for a better means of tracking title level usage statistics. Our current method of downloading myriad COUNTER 5 Book Requests reports
from vendor admin profiles and combining them into one giant spreadsheet is time consuming and the results are difficult to parse.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Is there a software solution? We have an ERM but it doesn't have the ability to import this type of COUNTER report. Any tips and tricks would be greatly appreciated!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Adrian<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Adrian Graham, MSIS<br>
e-Resources Librarian / Associate Professor<br>
Austin Community College - South Austin Campus<br>
1820 W Stassney LN, Austin, TX 78745<span style="color:#888888"><br>
512.223.9179</span></span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="color:#888888"><a href="https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fresearchguides.austincc.edu%2Fadriangraham&data=04%7C01%7Ckaren.harker%40unt.edu%7C186a275c7818475b6d7308d927834fad%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C637584267198425136%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=vC%2FbkZiVcxvFnKpeVkAC6bgi%2BQErzfG5wLRIXU0jmfc%3D&reserved=0" target="_blank"><span style="font-family:"Trebuchet MS",sans-serif;color:#1155CC">researchguides.austincc.edu/adriangraham</span></a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>