[Eril-l] Making sense of usage for data resources?

Thu Dec 17 12:17:17 PST 2020

Thanks for the tips, I'll check out OpenRefine as well!

-Randy

From: Kate Reagor <kreagor at tsl.texas.gov>
Sent: Thursday, December 17, 2020 2:55 PM
To: Lancaster, Randy <RLANCAS1 at hfhs.org>; eril-l at lists.eril-l.org
Subject: RE: Making sense of usage for data resources?

*** External E-Mail - Use Caution ***

I prefer working in SQL when I can, but I run this dashboard off a Microsoft Access database because that's what my agency's IT folks allow.

I do have to massage the reports a bit before uploading them, even when they're already Counter 5. Particularly for this project, since the reports are at the consortium level and I need to crosswalk all the individual members' vendor IDs and names to our own internal ones. But otherwise the C5 reports don't need a lot of work if they're already normalized like the Database Master Report is (one column for the metric type, one for reporting period total).

I also created workflows in OpenRefine that let me automate most of the cleanup and transformation process for each vendor's monthly reports, which really speeds up the process.

After the reports are cleaned up and put into the proper layout, I upload them into the Access database and update the dashboard in Tableau!

____________________________________
Kate Reagor, MSIS
Library Technical Services Specialist
Texas State Library and Archives Commission
texshare at tsl.texas.gov<mailto:texshare at tsl.texas.gov> | kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>

From: Lancaster, Randy <RLANCAS1 at hfhs.org<mailto:RLANCAS1 at hfhs.org>>
Sent: Thursday, December 17, 2020 1:39 PM
To: Kate Reagor <kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>>; eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: RE: Making sense of usage for data resources?

Hi Kate, the Tableau file looks great!

Just curious about your analysis process, are you linking this with an SQL database and uploading COUNTER Reports direct?

I've been using Microsoft Access for the data and PowerBI for the analysis portion, but am considering using the whole COUNTER report instead of just total requests....

Thanks,

Randy Lancaster, ITIL
Applications Specialist
Sladen Library<https://urldefense.com/v3/__https:/nam10.safelinks.protection.outlook.com/?url=http*3A*2F*2Fhenryford.libguides.com*2Fsladen&data=04*7C01*7Ckreagor*40tsl.texas.gov*7Cce212305183047f4b72108d8a2c360d9*7Ca4597bff9f384145a0334a2168399a5e*7C0*7C0*7C637438307946216906*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C1000&sdata=RFGIixLeEd3KO8Y72LakamqLIrbcrOHFT23WjKYzaAs*3D&reserved=0__;JSUlJSUlJSUlJSUlJSUlJSU!!PFzsKvxRBh-H!JIhXjEpmFDEPaGOYNhDwuLbN0fi8uNT1g7PEdIA4fvlKIHTHS2n8EB5hu9OQAw$>
Henry Ford Hospital
rlancas1 at hfhs.org<mailto:rlancas1 at hfhs.org>
Office: 313-916-2550

From: Eril-l <eril-l-bounces at lists.eril-l.org<mailto:eril-l-bounces at lists.eril-l.org>> On Behalf Of Kate Reagor
Sent: Thursday, December 17, 2020 2:15 PM
To: Linden, Nancy <linden at uh.edu<mailto:linden at uh.edu>>; eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: Re: [Eril-l] Making sense of usage for data resources?

*** External E-Mail - Use Caution ***

Hi Nancy!

My MSIS capstone project involved standardizing TexShare usage data by converting non-COUNTER 5 reports into an approximated C5 equivalent. I took a lot of inspiration from GALILEO, which documents how they standardize/approximate their usage data at https://about.galileo.usg.edu/docs/materials_docs/Vendor_Stats_Type_Definitions.pdf<https://urldefense.com/v3/__https:/nam10.safelinks.protection.outlook.com/?url=https*3A*2F*2Furldefense.com*2Fv3*2F__https*3A*2Fabout.galileo.usg.edu*2Fdocs*2Fmaterials_docs*2FVendor_Stats_Type_Definitions.pdf__*3B!!PFzsKvxRBh-H!O9IMcIeZchrVzz15Nz-NoPXpaUt83wR0CpwEjQ8X_bfCko2wOKqJFb_wdc0-ow*24&data=04*7C01*7Ckreagor*40tsl.texas.gov*7Cce212305183047f4b72108d8a2c360d9*7Ca4597bff9f384145a0334a2168399a5e*7C0*7C0*7C637438307946226868*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C1000&sdata=JXvE7cnJeSsHmQkSSEzzz3F9j2cmSRS8oGj9DuQlUx8*3D&reserved=0__;JSUlJSUlJSUlJSUlJSUlJSUlJSUlJSUlJQ!!PFzsKvxRBh-H!JIhXjEpmFDEPaGOYNhDwuLbN0fi8uNT1g7PEdIA4fvlKIHTHS2n8EB7ZsyX_uA$>

My starting point was typically to determine what would be that resource's full-text equivalent (full articles, media views, etc) and count that as Total Item Requests. Then if they had some way of approximating metadata/abstract/preview views, then I would add that to the full text to get Total Item Investigations. If that wasn't possible, I would usually just duplicate Requests for Investigations.

Most of the vendors also have something on their websites explaining how they count their metrics, which can be helpful in determining how to assess and convert their metrics. I've also had some success in asking them directly when that information wasn't available online.

Even if it is an approximation, creating those conversions at least makes it possible to compare data a little more easily across all platforms. And like GALILEO does, I made sure to keep documentation showing how I created those crosswalks in case there were questions about how things were counted later.

You can see my prototype dashboard at https://public.tableau.com/profile/kate.reagor#!/vizhome/UsageReports/TexShareUsageOverviewDashboard<https://urldefense.com/v3/__https:/nam10.safelinks.protection.outlook.com/?url=https*3A*2F*2Furldefense.com*2Fv3*2F__https*3A*2Fpublic.tableau.com*2Fprofile*2Fkate.reagor*!*2Fvizhome*2FUsageReports*2FTexShareUsageOverviewDashboard__*3BIw!!PFzsKvxRBh-H!O9IMcIeZchrVzz15Nz-NoPXpaUt83wR0CpwEjQ8X_bfCko2wOKqJFb9LXJUNQg*24&data=04*7C01*7Ckreagor*40tsl.texas.gov*7Cce212305183047f4b72108d8a2c360d9*7Ca4597bff9f384145a0334a2168399a5e*7C0*7C0*7C637438307946226868*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C1000&sdata=gMdZGRscAOuu8pUksXhPViVtDQSp1mAh3*2FKGB*2FfdwW0*3D&reserved=0__;JSUlJSUlJSUlKiUlJSUlJSUlJSUlJSUlJSUlJSUl!!PFzsKvxRBh-H!JIhXjEpmFDEPaGOYNhDwuLbN0fi8uNT1g7PEdIA4fvlKIHTHS2n8EB5iazczlQ$> (I'm still updating it as I'm able!), and there's a button linking to the metric and conversion documentation at the bottom.

Kate Reagor
Library Technical Services Specialist
Texas State Library and Archives Commission
texshare at tsl.texas.gov<mailto:texshare at tsl.texas.gov> | kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>

From: Eril-l <eril-l-bounces at lists.eril-l.org<mailto:eril-l-bounces at lists.eril-l.org>> On Behalf Of Linden, Nancy
Sent: Thursday, December 17, 2020 12:20 PM
To: eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>
Subject: [Eril-l] Making sense of usage for data resources?

Hi all,

Does anyone have any experiences or approaches they can share about how they evaluate usage for data resources?

Examples I am referring to are SimplyMap, Social Explorer, etc. that all have different metrics and are oh so different from COUNTER (understandably.)

Thanks in advance!  (Apologies if this topic has been addressed in the last year and I have missed it!)

Best,
Nancy

Nancy Linden, Collections Coordinator
University of Houston Libraries
University of Houston
A Carnegie-designated Tier One public research university
713-743-9760
linden at uh.edu<mailto:linden at uh.edu>

________________________________

CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies.

Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com<https://urldefense.com/v3/__http:/www.henryford.com__;!!PFzsKvxRBh-H!JIhXjEpmFDEPaGOYNhDwuLbN0fi8uNT1g7PEdIA4fvlKIHTHS2n8EB48ixfqoA$> for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20201217/ed743d8f/attachment.html>