[Eril-l] [External] Ebook Statistics: Software Solutions? Best practices?

Mon Jun 7 06:43:59 PDT 2021

Hi Karen,

Thanks for sharing! I was talking with some of my library colleagues about this – as I’m always on the lookout for a “better way” – and we talked about how quickly ER management has moved/changed in a few short years. I do greatly appreciate your comment about LibInsights – I voiced my concern about LibInsight, but indeed, it is the SUSHI mechanisms that cause the problems. Sometimes, struggling alone is a big part of the problem, so it makes me feel less frustrated (or incompetent!!!) to hear that others are having the same problems. 😉

We are starting to use Power BI, which had me backtrack to Excel’s query functions, and only last week took some initial tutorials. I agree that the query functions (in either Excel or Power PI) will be a game-changer. I found this tutorial incredibly helpful – https://youtu.be/i3CSD7bMMbg. It has exercises to follow along with and goes through the advanced Excel functions (pivot tables) and then show how they have been transformed into the more robust Power BI.

I’m going to let your final point on metrics rest until another thread, as I will first be working on getting my data in order, to better present it for those next discussions.

Thank you again!

Heidi

Heidi Card (she/her), MA, MLIS
Access & Discovery Librarian, Collections & Metadata Services
Gumberg Library | Duquesne University
600 Forbes Avenue, Pittsburgh, PA 15282
cardh at duq.edu<mailto:cardh at duq.edu> | 412.396.5233
www.duq.edu/library<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.duq.edu%2Flibrary&data=02%7C01%7C%7Ce13e7b8b1e714bd119ac08d61e4712cc%7C12c44311cf844e4195c38df690b1eb61%7C0%7C0%7C636729687933799303&sdata=ybuuCRW9rR7EdLRQHY%2FMZ1J%2F5COPPmkMUe6G5F7pD0M%3D&reserved=0>

I acknowledge and honor the Shawnee<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.shawnee-tribe.org%2F&data=04%7C01%7Ccardh%40duq.edu%7Cd63c48b5e5264624b06d08d898621b01%7C12c44311cf844e4195c38df690b1eb61%7C0%7C0%7C637426894434548849%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=vDdzk3eZwG%2FqsAKpKpDeYoxcK%2Bbcjk1svo9iy7MD%2BG0%3D&reserved=0> and Osage<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.osagenation-nsn.gov%2F&data=04%7C01%7Ccardh%40duq.edu%7Cd63c48b5e5264624b06d08d898621b01%7C12c44311cf844e4195c38df690b1eb61%7C0%7C0%7C637426894434548849%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=WOGb95Q5WasZ%2FxIxDVtTGV0rEalwK4c88jl2Ay2WPQY%3D&reserved=0> peoples, past, present, and future, and all of the original Indigenous peoples of the land upon which Duquesne University, Pittsburgh, PA stands. Whose land are you on?
<https://nam02.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%7Ccardh%40duq.edu%7Cd63c48b5e5264624b06d08d898621b01%7C12c44311cf844e4195c38df690b1eb61%7C0%7C0%7C637426894434558841%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=jkzE27yv%2BzTzwjG75FjVa6gB3yJ7QAkMenYmPdyH36M%3D&reserved=0>

From: Eril-l <eril-l-bounces at lists.eril-l.org> On Behalf Of Harker, Karen
Sent: Friday, June 4, 2021 2:19 PM
To: eril-l at lists.eril-l.org
Subject: Re: [Eril-l] [External] Ebook Statistics: Software Solutions? Best practices?

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.

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.

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.

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?).

Good luck

Karen R. Harker, MLS, MPH
Collection Assessment Librarian
University of North Texas Libraries
1155 Union Blvd.
#305190
Denton, TX 76203-5017
940-565-2688

From: Eril-l <eril-l-bounces at lists.eril-l.org<mailto:eril-l-bounces at lists.eril-l.org>> On Behalf Of Heidi Card
Sent: Friday, June 4, 2021 1:05 PM
To: Adrian Graham <adrian.graham at austincc.edu<mailto:adrian.graham at austincc.edu>>; eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: Re: [Eril-l] [External] Ebook Statistics: Software Solutions? Best practices?

Hello!

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 *some* 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.

I look forward to hearing what other folks are doing!

Best,

Heidi

Heidi Card (she/her), MA, MLIS
Access & Discovery Librarian, Collections & Metadata Services
Gumberg Library | Duquesne University
600 Forbes Avenue, Pittsburgh, PA 15282
cardh at duq.edu<mailto:cardh at duq.edu> | 412.396.5233
www.duq.edu/library<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.duq.edu%2Flibrary&data=04%7C01%7Ccardh%40duq.edu%7Cc643e1442dae45af885e08d9278535af%7C12c44311cf844e4195c38df690b1eb61%7C0%7C1%7C637584275365663452%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=VfUN7mvOlz2Don7ZQA2rJ7xNRO9IBd96iVYiVGtghas%3D&reserved=0>

I acknowledge and honor the Shawnee<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.shawnee-tribe.org%2F&data=04%7C01%7Ccardh%40duq.edu%7Cc643e1442dae45af885e08d9278535af%7C12c44311cf844e4195c38df690b1eb61%7C0%7C1%7C637584275365673444%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=cXr6QEtVxnlfsxYBj6UZiweUmkYqSw7OyMoSnghpPOk%3D&reserved=0> and Osage<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.osagenation-nsn.gov%2F&data=04%7C01%7Ccardh%40duq.edu%7Cc643e1442dae45af885e08d9278535af%7C12c44311cf844e4195c38df690b1eb61%7C0%7C1%7C637584275365673444%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=vUlFv%2BBVKpShRxmG9FY8ee8wJ8mBTYrm87MOJHmUWZo%3D&reserved=0> peoples, past, present, and future, and all of the original Indigenous peoples of the land upon which Duquesne University, Pittsburgh, PA stands. Whose land are you on?
<https://nam02.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%7Ccardh%40duq.edu%7Cc643e1442dae45af885e08d9278535af%7C12c44311cf844e4195c38df690b1eb61%7C0%7C1%7C637584275365683436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Or1pXdVPSL2dorHY%2BDOwjCA5TD5bFAIgsbYNBfzei7g%3D&reserved=0>

From: Eril-l <eril-l-bounces at lists.eril-l.org<mailto:eril-l-bounces at lists.eril-l.org>> On Behalf Of Adrian Graham
Sent: Friday, June 4, 2021 12:31 PM
To: eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: [External] [Eril-l] Ebook Statistics: Software Solutions? Best practices?

Hi, all!

How do you compile ebook title level usage statistics and provide access to your selectors for collection development and weeding?

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.

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!

Best,

Adrian

--
Adrian Graham, MSIS
e-Resources Librarian / Associate Professor
Austin Community College - South Austin Campus
1820 W Stassney LN, Austin, TX 78745
512.223.9179
researchguides.austincc.edu/adriangraham<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fresearchguides.austincc.edu%2Fadriangraham&data=04%7C01%7Ccardh%40duq.edu%7Cc643e1442dae45af885e08d9278535af%7C12c44311cf844e4195c38df690b1eb61%7C0%7C1%7C637584275365693435%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=bDzzw4yuA4s%2FiHdUKx7mPmB69368nOpt3ns%2Ff4yhvCo%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20210607/c6822ec7/attachment.html>