Matt Gallagher: This meeting is being recorded.
Cori Wilhelm: Alright. Hi, everyone! Thank you for joining us for the next spotlight on suny libraries. We're joined today by Matt Gallagher from Suny Binghamton. He's the director of Collection development and previously worked at University of Pennsylvania, Rutgers and University of the Sciences in Philadelphia.
Cori Wilhelm: His research interest focus on maximizing collections budgets and holistically developing collections on needs based approaches. And so I think we're gonna see a little bit of that today. So you can take it away. Matt.
Matt Gallagher: yeah, we we will see a little bit today. Thanks, Corey, and so just a full warning to everybody. It will be a live demo today. There are very, very few backup slide presentations. So I'm hoping that my computer can handle the bandwidth.
Matt Gallagher: So. So yeah, so I don't. So I'm pretty sure that Sunni trek migrated over to Almighty 2,019 I was operating Alma. I let a migration to Almo when I was at the University of the Sciences back in 2,016, and so those were the good old counter 4 days, and
Matt Gallagher: Alma had a really really good canned report for everything that I needed at the University of the Sciences. But for whatever reason they didn't choose to replicate it.
Matt Gallagher: Once counter 5 got introduced. And so I find that some of the can reports in Alma aren't really helpful
Matt Gallagher: to get to the data that I want to be able to assess a collection and also tell a story. So I'm gonna just go through
Matt Gallagher: that dashboard today.
Matt Gallagher: Sorry I'll kick it into presentation mode. So I'm just going to give you guys a quick overview of the dashboard itself. And then I wanted to talk about 6 specific examples. And so whenever I'm trying to present something to my colleagues for approval, I tend to think of them. As you know, I need to have a justification on why we need to buy this. You know, I wanna be able to assess a potential opportunity that presents itself to me through a vendor that reaches out to us.
Matt Gallagher: or I want to try something new, and I want to see what a new initiative would look like. So so I kind of tried to break them down into those categories. And so we'll be talking about some proquest. Historical newspapers
Matt Gallagher: will be talking about the Cambridge transformative deal that I know. A couple of other Sunnis looked at and agreed to. We started a Brill Eba at the beginning of 2,023
Matt Gallagher: last year we were lucky enough to be able to purchase the Wiley back file, and so we now have that
Matt Gallagher: as part of our kind of collections portfolio. We'll be talking about that, and I'll be kind of going into the individual details. So about you know how you can tailor the dashboard to suit your needs.
Matt Gallagher: And we'll also be talking about simplifying journal renewals. One of my colleagues, who, I think, is on the call Mary Tuttle. She has helped tailor the dashboard
Matt Gallagher: for individual subject librarian dashboards, and then, finally, you know, we can customize the
Matt Gallagher: template further to look at frontlist performances between. You know the sciences versus the social sciences. So I'm going to show an example of that with our Springer nature. Springer, naked Springer nature front file purchases.
Matt Gallagher: just a couple things about utility as I go through the demo. Is that you know, one of the things that's really nice about having this dashboard is that it has visualizations, and that it can provide a really quick bird's eye glance of the platform and publisher performance, and also give title level details.
Matt Gallagher: and so I find it really handy in meetings when I'm talking with maybe a dean or with a provost or with a chair to be able to show them exactly how we're trying to make decisions about how to spend collections, dollars
Matt Gallagher: and you can easily sort usage categories so that you know the highest items appear on any list, and I'll show you some examples about that. And so you know, some potential uses for this is to, you know. Look at ebook denials on a monthly basis for potential acquisitions. You can do relatively quick cost per use calculations. If you have
Matt Gallagher: Alma open alongside. You can. If you have. You know ill data that you request from your resource sharing folks, you can look at denials and compare them to ill's to see how much
Matt Gallagher: some you know how many users are being denied access to something on a platform, versus how many of them are doing the extra step and going to request it through Iol.
Matt Gallagher: and also depending on how lucky and your serendipitous things happen during your you know, playing around with this data you can id usage spikes related to curricula or course reserves. You know, for high high use items. So you know, you can id potential spikes or high use items.
Matt Gallagher: And like, I said, we use this as part of the annual resource review process.
Matt Gallagher: So I'm just gonna hop into it, and
Matt Gallagher: show you what it looks like. And so I think a couple people may have seen this before. I usually have a monthly call with a couple colleagues
Matt Gallagher: at Stony Brook, Albany, and Buffalo, and then I showed some of this to some of the team at Olis as well. So so if you, if you come across this great and I will let everyone know there is a shared copy of this on within Alma, so that everyone here can access this report. The only caveat is that you need to have your counter usage uploaded for it to process. And so.
Matt Gallagher: first and foremost
Matt Gallagher: managing sushi harvests, managing counter uploads takes a lot of work, and that's not I'm not responsible for that work here. And Stephanie. Hess's so some of you may have dealt with Stephanie before, and she manages that process here, and this would not be able to to occur without the work that she does on the back end. So I, obviously very appreciative of of her help here. So I'm just gonna show you the basics. So there are a number of different kind of tabs.
Matt Gallagher: or here and each one are relatively straightforward as far as what they are called. So. We have
Matt Gallagher: something that shows book usage, book denials, the E journal usage, the journal usage based on the publication date of the article
Matt Gallagher: journal, denials, article denials
Matt Gallagher: database, usage, and platform usage. And so I tried to keep things relatively straightforward. So II did try to keep the which counter report are we referring to? Are are calling as part of this process. So
Matt Gallagher: you can say, Oh, this is looking at the Tr underscore B, one data and also for each one. If you scroll down beyond the visual visualization, you'll actually see you know, platform title usage year requests. And so if I when I said. It's easy to sort you know, so I can say, Oh.
Matt Gallagher: on any given year what is the most used book?
Matt Gallagher: And so that sorts and I can say, Oh, wow! This title, blue is clearly being used as part of a course. unless one person at this university is just reading it in infiniteum. I'm pretty confident that if it's being used 13,000 times in a year, it's going to be for a course reserve. And so you can just kind of get a top level view of you know what
Matt Gallagher: titles your university is are using the most regularly you can when I say
Matt Gallagher: Platform, and that these values are sticky. So you can search. And if you want to save to yourself, I want to look at things that are else severe. You know, you type in science. You say, you know, there are a number number of different platforms that have science. I'm interested in
Matt Gallagher: just the science direct stuff.
Matt Gallagher: You can kind of copy that out and apply it.
Matt Gallagher: And you can say, Okay, so what titles are are users using the most with Elsevier. And so you know, this is an iterative process that you can use
Matt Gallagher: any time to look at any publisher platform as long as the data's there.
Matt Gallagher: and what is nice is that you'll see that the science direct is here in the prompt. It also sticks to this prompt. So this prompt is consistent across the entire dashboard. So if I wanna look at science direct journal usage now, I just kind of switch over into this tab, it's relatively consistent. So we're looking at total item requests and unique item requests from the Tr
Matt Gallagher: underscore, J. 3, report and again, similarly, here you have platform title usage year. And so, if I want to see what journal on Elsevier is the most popular on any given year, you know, I can see the signs of the total environment is something that gets a lot of usage. So that's kind of just broad sweeps.
Matt Gallagher: And just to give everyone an idea or a heads up that as you kind of have questions feel free to enter them into the chat, because we might be waiting for something to load at 1 point. And so I could potentially field those questions while we're waiting for a load.
Matt Gallagher: So I'm just going to go into some stories. So for anyone here who has purchased
Matt Gallagher: historical newspapers from proquest, they tend to be quite expensive.
Matt Gallagher: and so
Matt Gallagher: so whenever we want to, whenever I want to like. So I think everyone also is familiar with how onerous the licensing process is with New York State at the moment, and maybe previously
Matt Gallagher: all of the proquest historical newspapers are on ogs, and so it is. It's a very easy and painless way to spend money for us on content that gets a lot of use.
Matt Gallagher: and so
Matt Gallagher: hold on a second. reapply.
Matt Gallagher: driving and talking, sometimes multi testing So
Matt Gallagher: we had a little extra money at the end of last year. I thought that it made sense to purchase
Matt Gallagher: some proquest historical newspapers, because the usage is so good. And so if I'm in a meeting, and I've already looked at this data. It's very easy for me to kind of call up if I know the name format of
Matt Gallagher: what the item is. And now I can just kind of drag and drop all of this content into the normalized title. Apply it.
Matt Gallagher: and now I can very easily see you know
Matt Gallagher: how things have been used. And when I scroll down further and go to you know, total item investigations, I can say, wow! The New York Times is getting used, you know, 50,000 times in, you know, 2019, it drops down. There was a anomaly in 2,019. So sometimes I don't like to use that data. So again, if I wanna take it out, I just kind of
Matt Gallagher: click these years, apply it. 2019 is taken out of the data.
Matt Gallagher: And so I can say to everyone, Ok, we bought the Washington Post. It gets used 500 times a year. Does it get used as much as the New York Times. No, but
Matt Gallagher: if it's a single purchase, it's perpetual access, and we're paying a small ongoing.
Matt Gallagher: ongoing access fee
Matt Gallagher: it it's very easy to explain to people why we should buy historical newspapers, especially if they're New York, right? So we just went through a review process where we where I, sought approval to purchase the New York Herald Tribune. And so, you know, I mean, if you can look at
Matt Gallagher: the data from the New York collection from the New York Times Collection. You know, these are heavily used resources that make sense for our community, and they are used consistently. So last year. One of the titles that we purchased was The Times of India, because it was a request from a faculty, and we didn't have any foreign newspaper coverage. And so
Matt Gallagher: if I want. I can just
Matt Gallagher: kind of take all of these out again
Matt Gallagher: except the times of India. Alright. So
Matt Gallagher: just take them out relatively.
Matt Gallagher: simply. and apply it again.
Matt Gallagher: And so we purchased
Matt Gallagher: sometimes it takes a little while.
Matt Gallagher: sometimes you have to run the report again and reset it. You know it. It can be finicky.
Matt Gallagher: Let me reset it.
Okay, times of India.
Matt Gallagher: And so I can see relatively quickly. So we trialed this in March you can see that there was a big spike, but so I and then I didn't see any. You know. Access was turned on in June, and then I started to see regular usage. So I'm seeing, you know, a hundred uses a month right now. And so I say to myself, like, it's not the New York Times, but it's still receiving really, really good traction. And so I'm excited about
Matt Gallagher: this. If I'm you know, trying to justify a $30,000 expense for something, and I'm seeing very decent usage at the start. And hopefully, it's going to continue to go up, because this is only September, and
Matt Gallagher: we all know that, you know October and November tend to have higher statistics. Same thing with February and March. So I'm thinking that you know, once we start seeing this data more regularly. You know, it's gonna really prove that it was worth its purchase. And so this is a good way to demonstrate to an administrator or to your colleagues. You know about why this is a good way to spend money.
Matt Gallagher: and so that is my idea of a justification. We already owned access to some of the content. And I'm looking to purchase similarly minded content. And so I want to justify why, it's worth the value
Matt Gallagher: that we're paying for it.
Matt Gallagher: And the next use case is is Cambridge
Matt Gallagher: and so, if everyone remembers Cambridge came to us last year with a transformative agreement proposal. And they essentially said, You know, however, many journals you currently subscribe with to us, we're gonna open up the entire catalog of the Portfolio from 1997 to current, and we will also allow your publishers to publish OA
Matt Gallagher: in those titles. And so we took advantage of that. It was a nominal increase.
Matt Gallagher: But again, so if we want to justify our decisions, that one was a relatively straightforward decision for me, because the price increase wasn't that much? But I do want to just show how you can use this to justify that
Matt Gallagher: And so for me, I was saying, okay, let's look at the Niles in 2,021, you know. It wasn't too bad, but it was starting to spike at the end of the year.
Matt Gallagher: and then it started to get worse in 2022. What we're seeing twice the amount of denial. So yellow is 21 or inches 2022, and then it really started to get bad. We had almost 1,200 denials at the end of last year.
Matt Gallagher: And so we decided, you know. After looking at this, I said, you know it certainly makes sense to do this, and even though we have data now that access has been turned off. You can see that the nail the denials have dropped, at least in March and April, but in
Matt Gallagher: September they're still relatively flat. So so this is just gives you an idea of. You know how you can look at denials and say, are we satisfying users or not?
Matt Gallagher: The one thing that I'll say is that on the flip side, when we look at usage
Matt Gallagher: you can see that the usage has really skyrocketed. Now that we have access opened up to all of the titles rather than to just 80 of the titles. So we're talking about, you know, a doubling in February and March. Even though it's not quite doubled yet. So the this is a very encouraging sign to me, considering that we paid, you know, 3, $4,000 extra for the entire, the entirety of it. So
Matt Gallagher: this is a good example. Another way that you can drill into this. So you know, if you wanted to say, Why is this important? To an administrator or to your colleagues?
Matt Gallagher: You have to cherry-pick titles that make the most sense right? And so I'm going to just show you one title
Matt Gallagher: that I, Cherry picked after looking at about 5 titles. That shows exactly what I want to see and show an administrator. So I can say.
Matt Gallagher: Provost Paul Dean Falcon.
Matt Gallagher: You know.
Matt Gallagher: in
Matt Gallagher: 2021 and 2022, we didn't have access to this publication, and people were only able to get, you know, an article or 2 a month that were. That was probably an open access kind of gold OA article
Matt Gallagher: but you can see now that this is opened, you know, on some months we're seeing people request up to 13 you know, 8 articles a month and beforehand. I want to show them how many times users were being denied that data. So I can say, you know. Look, there was in
Matt Gallagher: September of last year 16 people hit pay walls trying to access this content on Cambridge platform. And so I think that you know this is a compelling swap, essentially like. We have seen spikes in denials last year. And now we're seeing low denials. Since we've made this change, we're seeing
Matt Gallagher: low usage in years past and seeing spikes in current years. And so when you say Cambridge has 200 titles that we didn't have access to. So this is probably happening across the majority of 200,
Matt Gallagher: a journal
Matt Gallagher: panel titles that becomes a very compelling picture to someone who might want to invest in that for the community, for the research community.
Matt Gallagher: Okay.
Matt Gallagher: I'm gonna switch it over to the Brill example now.
Matt Gallagher: And so I'm just gonna reset all of these things.
Matt Gallagher: We'll get a brill.
Matt Gallagher: Okay. So
Matt Gallagher: going back to book denials.
Matt Gallagher: I had a really nice relationship with Brill. When I was at University of Pennsylvania, we bought a lot of content with them. I find them to be a relatively fair
Matt Gallagher: publisher from a licensing standpoint and a cost standpoint
Matt Gallagher: And so I was looking at the denials that we had for Brill, and I wanted to know if it made sense to
Matt Gallagher: to start an Eva with them. And so
Matt Gallagher: I said, how many denials did we have in 2022, you know, I filtered this down.
Matt Gallagher: And I said, Okay, we had, you know, about almost 1,000 denials. And so you know, how much
Matt Gallagher: would it be worth to have an Eba? And so, you know, we settle on a price after talking about it and looking at this data.
Matt Gallagher: and just kind of read. return to what they previously were.
Matt Gallagher: And so you can see a brill, Eva. We have access to their entire catalog. So no users are being denied right now for any brill content any brill ebook content, that is.
Matt Gallagher: whereas, you know, we had highs of 141 users hitting pay walls last year and flip side. If I look at
Matt Gallagher: our usage, you know, you might say, hey, 300, you know, that's not that great. But you know, compared to prior years, it's really good.
Matt Gallagher: So one of the nice things about this dashboard, too, is that you can kind of add Isbn's to it. And so here is an example. Right? So
Matt Gallagher: we in 2021, 2022, we purchased books on Brill's ebook platform.
Matt Gallagher: Right now, outside of the Eva, we have 76 books that we purchased before the Eva started.
Matt Gallagher: and so you might say, you know, someone might ask me, well, Matt, how do you know that this usage here isn't related to the books that you purchased? And it is related to the Eba itself.
Matt Gallagher: And so I'm just gonna show you, the insanity of my computer.
Matt Gallagher: And so this is
Matt Gallagher: basically a Alma export for the 76 titles that we own. It's just a simple export from the community zone.
Matt Gallagher: So it has the 76. I can essentially copy these 3 fields of Isbn's. I return to my dashboard.
Matt Gallagher: I open up
Matt Gallagher: my values. I click on this
Matt Gallagher: pencil and I throw this in here. It normalizes everything. So now that all of this is kind of cleaned up.
Matt Gallagher: And now I'm just going to click, apply. Sometimes these data crunches do take a little bit longer, and so you can see that in 2,023
Matt Gallagher: we had 91 uses, right 91 uses of the things that we own perpetually compared to
Matt Gallagher: 1,900 total. And so that means that about 1,850 of the uses that we're seeing just through September are directly related to the Eba. And what's really nice is that moving forward? I can use the exact same feature to see how the books that we buy after year one are performing in subsequent years. So I can isolate information through Isbn's relatively, simply through this process.
Matt Gallagher: And you can also use this as a template and then save a copy of it and change the prompt a little bit, so that you have certain fields within the platform within the Isbn kind of customized and tailored. And so we use this as kind of the baseline, and then we build on top of it and create separate copies of it. So I'll show everyone what that looks like in the Directory as well.
Matt Gallagher: So that's Brill. As an example. I'm gonna go into Wiley next. But shut up. I'll just review the the chat just to see what people are talking about. If that's all right.
Cori Wilhelm: Yeah, we did have some questions in the chat about setting
Cori Wilhelm: setting up almond to run these, but I think they've kind of been answered. By Carrie shell
Cori Wilhelm: but we can certainly have some have some question time later on, too.
Matt Gallagher: Sure, yeah, we should have time.
Matt Gallagher: and so, anyway. So we'll go into to Wiley since we just bought that back file, and I'll show people what what that usage looks like.
Matt Gallagher: So once you have kind of all of these reports built out, it's really easy to, to, you know, manipulate them just a little bit for your own needs. Obviously you need to be a little bit more familiar with Alma, but
Matt Gallagher: but you can you can get a feel for things. So
Matt Gallagher: we purchased the. The. The Wiley purchase was finalized
Matt Gallagher: in May or June, so we didn't really start turning access on until over the summer, and so I wasn't expecting to see any crazy spike
Matt Gallagher: over the summer, but this is encouraging to me to see that that usage is about 2,000 items higher than it was in. So you know, right now, I only have one month of data, but as the counter data gets imported. It's just going to build onto this. And so, you know, I can see how good of a decision this was.
Matt Gallagher: But
Matt Gallagher: the backfile is really for 1,997. And before right? So one of the things that's nice about this is that I can look at the article
Matt Gallagher: date of publication.
Matt Gallagher: And so you know. So I can say that in 2022, you know, we had the most requests for articles that were published within the last year. Right? And it's very clear correlation year to year.
Matt Gallagher: But
Matt Gallagher: now that I know that this report is called Jr. 4, so I have the report name here, and I'm just gonna show you what it looks like from the catalog state like. So you know the catalog, or like where these items kind of reside. So a little bit of the back end of the dashboard.
Matt Gallagher: And so this is the main dashboard. If I go in to edit it.
Matt Gallagher: You know, just to show you exactly what it looks like. So I can say, okay, this report is named Jr. For total item requests. So I'm gonna go back to the catalog. I'm gonna find that that report.
Matt Gallagher: And so here you go. JR. 4 total item requests. And I'm going to go in and edit this because
Matt Gallagher: I'll show I'll return back to that screen because I'm interested. I'm not interested in the most current content with the wily backfile, because it is for the older content. And even though it's only been turned on for 3 months, I'm curious. And so I'm gonna just change the criteria of this graph.
Matt Gallagher: And so I'm going to say, is no greater than 1965 now.
Matt Gallagher: but no less than 90, 97.
Matt Gallagher: And like, I said, 29, you know.
Matt Gallagher: 2019 was a bit of anomaly. So I'm gonna take that year out. And then I'm gonna look at the results again.
Matt Gallagher: And so
Matt Gallagher: I can see here that Oh, I forgot something. I'm sorry.
Matt Gallagher: And then I'm gonna change the platform
Matt Gallagher: to be equal to Wiley. I forgot about
Matt Gallagher: grab about that one important.
Matt Gallagher: Okay?
Matt Gallagher: So now that we're looking at Wiley data specifically. So, remember, we only had we didn't have access to the majority of this content online if it was available, probably open access gold. OA has been since converted, you know. Maybe we own a couple of one backfiles or 2. Nothing crazy.
Matt Gallagher: and I can already see that
Matt Gallagher: 2023 is performing
Matt Gallagher: remarkably better than the prior years. And this is just with one or 2 months of data. So this is really encouraging to me. And also what's interesting about this graph is that there is definitely some correlation right here. And so I would not be surprised if there is a class that is using something.
Matt Gallagher: So if I wanted to dig down further, I think that this is a curricula curricular spike, and I think that people are accessing a specific article in a specific journal related to a course, about you know, 60 to 80 times a year, so I could drill down into that data if I wanted to get that. I didn't go that crazy for this today?
Matt Gallagher: and so let me just show another example of a
Matt Gallagher: something that you know a compelling title.
Matt Gallagher: And I'm going to change the title
Matt Gallagher: equal to ecology.
Matt Gallagher: And I'm gonna apply that.
Matt Gallagher: And so is this super compelling? No. But it's basically saying, within a month
Matt Gallagher: people have been using this. You know, from 19 accessing articles from 1,968 to 1996. You know, within 3 months they were accessing it, you know, 10 or 20 times. And so this is across again, 1,700 journal titles that were a part of this package. And so you can really start to build out.
Matt Gallagher: you know what it is that you're buying and justifying. Why it is you're buying it.
Matt Gallagher: I will say that
Matt Gallagher: the more examples that you have like this, the more convincing you sound to an administrator to say, Yeah, this is what we did last year, and this is how it turned out.
Matt Gallagher: And so
Matt Gallagher: so, yeah, so just another kind of nice way that you can use this. I didn't show the flip side of the Wiley example as far as
Matt Gallagher: as far as the denial data. And so I should have done that before I switched out
Matt Gallagher: and so now you can see denial data. So you know, 2019 anomaly. So we had 200, almost 300 denials last September. And now we're down to 56. And so, you know, this is this is just great for me. As far as you know, it was worth the purchase. It looks like it's
Matt Gallagher: functioning the way we want it to. So I am quite pleased so far. And each month I hope to be more pleased.
Matt Gallagher: So I'm gonna switch to example number 5, which is our usage dashboards for subject librarians which Mary helped build.
Matt Gallagher: And so
Matt Gallagher: I am just going to show one.
Matt Gallagher: So you can see here that we've basically created a different dashboard for different individuals. So each one is unique, and each one has a distinct prompt. And so I will show you exactly what that means. This could take a little while. I have
Matt Gallagher: some the the last example. It takes the list, the longest.
Matt Gallagher: okay? So
Matt Gallagher: here you can see that
Matt Gallagher: what we did was take. we use the plol data within a specific fund code to pull Issn's
Matt Gallagher: and then normalize them and then create a prompt that has all of these automatically selected so that only they are showing up
Matt Gallagher: and we kept everything else mostly the same, except for one change that I'll show you after this. You know.
Matt Gallagher: it's in a different area. So now an individual subject librarian can go into their portfolio at any given time
Matt Gallagher: and say, how are my journals performing? And again, let's say I, wanna I don't care about the platform here. I care about the title.
Matt Gallagher: so I can say, you know. Oh, adaptations been getting good. Use, agricultural history. Good use. It's available on a couple of different platforms. Maybe. You know, alcohol and alcoholism is getting very good use. But it has overlap with
Matt Gallagher: Ebsco host, so you can get a bunch of information in this area that says.
Matt Gallagher: like the American entomologist, it's not on another platform. So we're only getting it through Oxford academic, right? So there are a couple assumptions you can make
Matt Gallagher: through this data the subject librarian can interpret them, however, they'd like, and then, if you kind of but one of the. So one of the things that's interesting to me is overlap. And so I'm gonna look at this example right here alcohol and alcoholism.
Matt Gallagher: because you can see it's getting a lot of use each year, and most of that use is on Oxford
Matt Gallagher: Oxford's platform, not Ebsco's platform. And so
Matt Gallagher: I want to know what the overlap is, and
Matt Gallagher: what year
Matt Gallagher: of art, what year the articles are published that are being used right? So I want to know, overlap, and I want to know the year of publication of the article that are being used.
Matt Gallagher: So Mary has done really, really nice work as far as creating an inventory through.
Matt Gallagher: Well, I actually don't know how she did this, and so I just say, Thank you, and maybe one day I will talk to her about it.
Matt Gallagher: And so I'm looking for alcohol and alcoholism. So I have the title. I have Ebsco! I have the coverage year, and then I have the embargo period. So so you can see with Oxford University Press, we have 1,996 to 2,008 that isn't covered, and then also a one year embargo.
Matt Gallagher: And so now I want to look specifically at that title
Matt Gallagher: to see what years the articles are, you know. Is it overlap, or are we paying for the unique content? And so 2,008 to 2,022,
Matt Gallagher: you know.
Matt Gallagher: So it does look like 20 requests are within the last year, 18 requests, but then there are a number of
Matt Gallagher: requests that are happening before 20 2,008. So you know, a subject librarian can look at this data and decide for themselves like whether they think this is worth worth worthwhile, or if we should potentially cut this as a cost saving mechanism, so we could reinvest somewhere else. You know I have been in situations where I have had to come up with.
Matt Gallagher: you know, 50, $60,000 based on a budget cut and I always try to go to individual journal subscriptions and overlap first, because sometimes you just don't know what it is you're getting for what you're paying for.
Matt Gallagher: And finally, I wanted to look at 2 specific examples. And so
Matt Gallagher: we buy. We buy a couple disciplinary collections front lists with springer nature. One is a computer science package. So that operates, you know within the sciences, if you will. Engineering and the other are a number of their social science packages. And so if I were using the regular dashboard.
Matt Gallagher: I should have just stayed in it so I could show you. But let's go back.
Matt Gallagher: So if I pull up Springer nature here.
Matt Gallagher: I'm not going to be able to easily dissociate. What is computer science versus what is
Matt Gallagher: what our social sciences? You could look at the title level, but it is very tricky
Matt Gallagher: and so let me just pop up screen.
Matt Gallagher: Oh, I did that wrong, Springer Link.
Matt Gallagher: So if you kind of scroll through, it's it's really hard to to associate which one is from with which title is with which package, right?
Matt Gallagher: But what's really nice
Matt Gallagher: is that if you look in the community zone at
Matt Gallagher: you can essentially export
Matt Gallagher: a community zone collection
Matt Gallagher: to scrub out the Ispn data so that you can get a set of all 21,200 titles that are associated with the Springer computer science, 2,020 package. Right? So you can
Matt Gallagher: click into this, get an export and then you do a little data normalization
Matt Gallagher: to get Isbn list. And once you have that, then you can input it into this
Matt Gallagher: dashboard. And you can
Matt Gallagher: check that information whenever you'd like.
Matt Gallagher: And so once you have a static list. So if you bought the 2,020 collection, or the 2,021 collection. But you want to see how it performs over time. You can use this as a template, and then, you know, adjust the prompt, so that
Matt Gallagher: so that
Matt Gallagher: you get each month, you know, each month kind of data should accumulate and it might go down. It might go up depending on how relevant the titles are saying. And so, if you're interested in.
Matt Gallagher: how
Matt Gallagher: fast does usage drop off for science material compared to social science material. This is one way where you can kind of triangulate that data. If you're buying content across those sets that are somewhat consistent.
Matt Gallagher: This one takes a little while. So I'm gonna just take a look at the chat and see if there are any questions.
Cori Wilhelm: And we did have a question from colleen.
Cori Wilhelm: how do I get the dashboard that you just should the one for subject librarians
Cori Wilhelm: and these are customized that you may correct that.
Matt Gallagher: Yeah. So right now I will show everyone the the shared like the Directory.
Matt Gallagher: you know the the folder structure on where to get to this. But, colleen, we haven't, added the
Matt Gallagher: the template for the subject librarian dashboard just yet. And so that's something that we can look at doing and let everybody know afterwards.
Yeah, these 2 reports take a little while. So I'm happy to field some questions while we wait.
Matt Gallagher: Because I have yeah, one more. Oh, go ahead, Cory. Sorry I was gonna say, any other questions Yvonne had asked about
Cori Wilhelm: uploading the counterfeit data. From the vendors into Oma and Michelle said. You can set up sushi to pull in the reports automatically. Is that how you
Cori Wilhelm: did most of this map?
Matt Gallagher: So like I, said, Stephanie manages that process here, and so I believe that the whatever we can automate through a sushi harvest, we do.
Matt Gallagher: But you know, usually there's a report that only kicks out after the monthly summary is run, and then you know. So so there is like an error report. So sometimes, like a sushi vendor, will change platforms, and then you have to reconfigure it. Maybe your colleague change the password on you, and all of a sudden the connection breaks. So there's management stuff that has to go down each month on the collection itself.
Matt Gallagher: But but yeah, the sushi typically works well except when it doesn't. And then you have to figure out what went wrong. And so it's a constant battle of trying to stay ahead of it, and you usually lose with some humility involved in the process.
Cori Wilhelm: Yeah. FAQ, and one more question on here from Carrie. Helen, from the start of setting up this dashboard. Did it take you to get to the point of doing this kind of analysis.
Matt Gallagher: I don't know. I think II when I started so I started here last June, and I was very june is a nice time to start academic job, because you have the summer to kinda get acclimated. Typically and so I think I developed this dashboard over the summer, and you know we didn't do all of the customizations that you're seeing now. But the general the general dashboard probably took about, you know.
Matt Gallagher: I mean, I didn't work on it straight for 2 months. So it was. I didn't count how many hours it took, but I think I had. You know it probably got 2 months until it was in a nice shareable state, if you will.
Matt Gallagher: And I was probably putting. I don't know maybe 5 HA week into it, Max.
Matt Gallagher: all right. And then so colleen, I see your question. I'm gonna just
Matt Gallagher: finish my thought on this, because I want to show a different example afterwards. And and so, and that one might take a little while to load, too. So I will get to you in a second.
Matt Gallagher: Okay, so this is a specific list of isbns that are all computer science related. And so we've purchased in 2018 2019 2021, 22. So we have about 5 or 6 years worth of frontlist ebooks within this dashboard. So a number of Isbn's that are getting crunched against the counter data.
Matt Gallagher: And you can see that we've reached a relative peak
Matt Gallagher: the usage here. Maybe you know, 2,013 is a little higher than than 2,000 and
Matt Gallagher: last year, but then it dips a little lower. So it's gonna be interesting to see if if we get above these 2,020 2022 highs. But with science data, you you expect, you know, there's a lot of churn, and a lot of people are trying to look at the most current stuff. And so every once in a while you get a book that everyone's gonna use regularly. But most of the time it's gonna be a couple of uses. This is relatively niche content.
Matt Gallagher: And what's nice is that you can
Matt Gallagher: When you look at the title list below hopefully, my computer lets me look at it. Here we go.
Matt Gallagher: So what's nice is you can export
Matt Gallagher: the entire dashboard to excel. And if you do that. you can throw this data into a pivot table, and you can get some really really interesting statistics out of it.
Matt Gallagher: So one is
Matt Gallagher: how many titles that we bought were actually used. So from my example before
Matt Gallagher: there was 20 1,200 titles. In this we don't go and individually check 1,200 titles for a frontless package. We just assumed to have that. It happens automatically. So I can export this data into a and then, you know, create a pivot table and say, you know. And so about 10% of the content that we purchased 10, you know, 10 to 20% of the content that we purchased was actually used.
Matt Gallagher: on top of that you can see a little bit about. So
Matt Gallagher: this title, a Beginner's Guide to Python, 3. Programming. It was used in April of 2020, in May of 2020, in
Matt Gallagher: October of 2,020 and November of 2,020. And so you can kind of see how many times something has been used in a given month.
Matt Gallagher: and so that
Matt Gallagher: information can be really helpful to say, Hey, how are things in the sciences being used, and compare them to how things have been used in the, you know, in the social sciences. And so.
Matt Gallagher: if I run an analysis like this, I can tell you that the majority of these titles you can just kind of scroll through relatively quickly, and say, Okay, ones, twos. Here's a couple, you know, where it's been used more regularly, not surprisingly, something in artificial intelligence?
Matt Gallagher: and so you can kind of get a snapshot on how people are using the content across what? You know what platforms. And so
Matt Gallagher: just to give everyone a refresher. You know, one or 2 titles. It looks like usage is kind of, you know, like stayed relatively stable. Since we've been subscribing to these things longer. And I'm gonna just show the political science one afterwards to show how it differs and how you wouldn't be able to get this information in the regular the regular template. And so, while we wait for that, I will now look at your question, colleen.
Matt Gallagher: Do you ever use OA usage when evaluating individual journal subscriptions. So
Matt Gallagher: we have not had any like, our budget has been relatively healthy, and so I haven't had to ask anyone to do that yet, because we haven't had to. I haven't had to kind of
Matt Gallagher: tight rope walk cancellation process yet. So if we were to be looking at cancellations, then I would probably update this
Matt Gallagher: template to include that information which you can. But I kind of wanted to keep this relatively streamlined, and not add too much erroneous information, not erroneous. Just, you know, information that I wasn't necessarily interested in, and
Matt Gallagher: also kind of make it scalable, so that anyone else could copy a template and change it. However, they want some people don't like the numbers for months like this doesn't bother me. So there are definitely ways that you can modify this to your own individual institutions needs. I don't really care about Calendar Year versus fiscal year with journal subscriptions. It's mostly calendar year stuff. So I prefer calendar year over fiscal year. But if you're looking at a cost per use, you might want to
Matt Gallagher: on a calendar year. It really is up to you.
Matt Gallagher: yeah, happy to field other questions while we wait for this to load. And
Matt Gallagher: I figured that this would be the case. So
Matt Gallagher: what month numbers, Susan? Oh, oh, I gotcha, yeah, for the 4 for April.
Matt Gallagher: Yeah. Some people, some people some people like bothers. And so I fully understand that. And you all are more than welcome to tweak this as much as you want, and I'll I'll go into this if it if this takes a long time.
Matt Gallagher: Oh, looks like we got some movement.
Matt Gallagher: maybe.
in that.
Yvonne Kester: This is Yvonne Kester. Do you have time for a question at this moment.
Matt Gallagher: Yeah, of course. Yeah, go ahead, Yvonne.
Yvonne Kester: I just learned that there is a counter setting in where you edit the
Yvonne Kester: collections or the portfolios, and I was just wondering if you knew about that and
Yvonne Kester: whether it's really necessary to have that set to have these come out accurately.
Matt Gallagher: So for this. No.
Matt Gallagher: So if you just upload counter data into your Alma instance through sushi, this report is going to capture all of that.
Matt Gallagher: And and then. But if you want to try to get accurate cost per, use information. That's when you have to start entering in the counter platforms on the individual Po lines or the electronic collections. That's where Alma is trying to make the connection between the E inventory and the purchase order line and the counter data, and they're trying to combine it all together for you. This really is only looking at counter data.
Yvonne Kester: Excellent. Thank you so much.
Matt Gallagher: so
Matt Gallagher: so this is the ben is a social science librarian here. So this is
Matt Gallagher: And so you can see here that we're still. We're still in the process of peaking with this content, because we only started purchasing it in 2019. And so with the social sciences, I would expect the shelf life to be longer and so different to the computer science stuff, which kind of seems static. Since we've been buying it for 5 or 6 years, I would think that the political science is just gonna keep going up until maybe we hit 8 years or 10 years.
Matt Gallagher: And so that's going to be an interesting thing that we can monitor with this over time.
Matt Gallagher: And again, you know a similar thing. Where? You know, you would think that there's gonna be a lot more titles within here that just have different uses. So artificial intelligence.
Matt Gallagher: you know, things that are being used consistently across time rather than the computer science content that has just been used, you know, in one year. And then, all of a sudden, it's kind of old hat. And people move on. And so this is a good way to kind of just bifurcate that information and be able to monitor it consistently, because
Matt Gallagher: these
Matt Gallagher: these Isbn's, they're not gonna change. So you know, when Stephanie uploads this data in October, it's just gonna get updated. And all of this information is gonna be different. And I can run a different analysis. So so you know. So I think that it's a good you know, the examples I showed are just kind of good benchmarks, good kind of intro points on what this is capable of, and where you can where you can go with it.
Matt Gallagher: So where can you find it
Matt Gallagher: important. Question. So right now, if you go into the community and reports
Matt Gallagher: institutions. I didn't realize that there was a suny one. I should have thrown it in there. But I we created a Binghamton University folder. and so
Matt Gallagher: there are. There are a couple of things here for you to look at, and so it's in dashboard. So if you just go to dashboard and you expand.
Matt Gallagher: and what I did here is, so I locked all of this, so no one can change anything. What you have to do if you want to start tweaking, this is copy all of this into a folder within your institution zone, and then you can begin to play with it. However, your needs. You know, whatever your needs might be. So, Susan, if you wanna get the month in there rather than the number, you know. It's all that's all you
Matt Gallagher: and I'll follow up with, you know. I'll work with Cory and follow up with everyone on the list, so that if no one, if they don't remember this kind of
Matt Gallagher: tree you can, you know you can refer to it later. So
Matt Gallagher: so yeah. So I 5 min, I'll open it up for questions. I know that there was other questions. So are you concerned about turnaways when you have access to the full run.
Matt Gallagher: so, Susie, are, are you talking about Wiley? Susan?
Susan Davis (UB): Yeah, like, when you were showing, you know that you bought the whole archive, and and we've seen that with some things where we have the the entire package, there's still some turnaways, and you know, we just kinda like, well, users could maybe be not authenticated. And and it's obviously showing up in a in a report. But
Susan Davis (UB): otherwise it's like, Yeah, is, is that what level might we be concerned that something weird is going on?
Matt Gallagher: So I actually found an example that explains what's happening. So I can't remember what the title was. Let's just say it's called like advanced material science. It was something in the material sciences.
Matt Gallagher: Widely owned the content from
Matt Gallagher: 2,014 to 2,000
Matt Gallagher: 17 or 19. They owned it for like 5 years. And then it moved to Springer, and I don't know who it belonged to before that right? So they so every one of the platforms that owned it has all of the content on it. But Wiley only has the ability to sell the content that they owned then so they can't. They don't have the rights to sell the back file for it anymore, because it's no longer in their portfolio.
Susan Davis (UB): but there is still a pocket of it that is available via Wiley.
Susan Davis (UB): Yes. So we we only 2012. Yeah, we own 2012 to 2018 for that title. But they can't sell us. Yeah, but it's still
Susan Davis (UB): yeah. The Cdi is making. Maybe it look like you have more than you do, or people get there. And then they just click away.
Matt Gallagher: Right? Yeah, II think it's more that. It's not primo that is sending users there. It's just people who are searching Wiley, and then they stumble on that article, and then they hit the paywall. That's my assumption. Because I was looking at it. And it's like a relative. It was a very high use journal.
Susan Davis (UB): so yeah, I can't remember what it was. That's okay. But that's just yeah. I mean, it's like, it's gonna be sort of like a unique circumstance. Maybe for every title that this behavior is happening.
Matt Gallagher: Yeah, that that's that. I did. Look at that. So you can get the information and then look for that one or 2 specific oddity title and see why it's happening. So I mean, it is helpful for for those use cases too
Susan Davis (UB): great. This is very impressive, Matt. Thank you for sharing this with your Sunni colleagues.
Matt Gallagher: Of course, happily.
Matt Gallagher: Yeah, I hope that everyone can use it, and that it helps you all justify what
Matt Gallagher: we're doing
Cori Wilhelm: alright. Any last question before we include.
Cori Wilhelm: I'll go ahead and.