[Eril-l] How to track all usage of individual journal titles

[Melissa Belvadi]

First, I recommend that with COUNTER 5 you start paying more attention to
"unique title requests" rather than "total" because "unique" dedupes if the
patron accesses the same article in multiple formats in the same session on
the same platform, eg the PDF and HTML versions. That was always a problem
with COUNTER 4 which reported PDF, HTML and total ft views but it was
impossible to distinguish the overlap.

There are commercial services now that will collect your COUNTER reports
for you across multiple platforms and provide the summary totals you want,
but of course they cost money.
The only way to do it for free is to collect and combine your COUNTER
reports for yourself.
And of course if the platform doesn't support COUNTER, you'll have to do
something else entirely, eg work through proxy server logs or such.

Something I did with COUNTER R4 reports was to collect all of our calendar
year JR1s into a single folder then have a student assistant literally copy
and paste to combine them into one huge spreadsheet file for me. Then I
could sort and search that and see the data per journal and pick and choose
which platforms (eg aggregators) I wanted to exclude. Depending on how much
data you have you may be able to do this or you may hit spreadsheet size
limits and need to use something like MS Access instead.  In either Excel
or Access , it's easy enough to use pivot tables to sum things up for you
and exclude certain platforms.

I am working on developing open source software that will use SUSHI to
harvest all of our COUNTER reports and put them into a central database for
searching by title/issn to get such summaries, but ran into some scale
problems with my database design (too much data for Google Sheets, as well
as lots of problems with even major vendors this year not being properly
SUSHI compliant) so it's not ready for sharing yet. I am hoping to have
some CS students help me get these problems fixed over this academic year.

Melissa Belvadi
Collections Librarian
University of Prince Edward Island
mbelvadi at upei.ca  902-566-0581
my public calendar
<http://www.google.com/calendar/embed?src=mbelvadi%40upei.ca&ctz=America/Halifax&mode=week>
Make an appointment <https://mbelvadi.youcanbook.me/> via YouCanBookMe





On Fri, Sep 6, 2019 at 4:12 PM Hertz, Ian S. <hertzis at wssu.edu> wrote:

> Hello,
>
>
>
> I am trying to make sure I capture all usage on titles not in aggregate
> databases.  For example, we have EBSCO manage our subscription to Harvard
> Educational Review.  It’s discoverable in our Serials Solutions ejournal
> portal.  A user would click through to get to EJS.  At that time, they
> could either browse by publication date, find the article and click open in
> new window.  I know EJS tracks that but if a user clicked through to the
> publisher site (an option in EJS) and find full text there, I’d want to
> track that.  Ultimately, I want to track all full text accesses in all
> placed for titles not in aggregate databases.  I know in counter 5, I can
> use total item requests but is there an easier way than to have to track in
> multiple places and sum them up?
>
>
>
> Thank you.
>
>
>
> *NOTE: (Please keep attachments in all correspondence)*
>
>
>
> Ian Hertz, MLIS
>
> Electronic Resources Librarian
>
> Business Reference Librarian
>
> O’Kelly Library Rm 114
>
> Winston Salem State University
>
> 336 750-2532
>
>
> _______________________________________________
> Eril-l mailing list
> Eril-l at lists.eril-l.org
> http://lists.eril-l.org/listinfo.cgi/eril-l-eril-l.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20190907/c78c0767/attachment-0001.html>