<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">The only way to do it for free is to collect and combine your COUNTER reports for yourself.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Melissa Belvadi</div><div>Collections Librarian</div><div>University of Prince Edward Island</div><div><a href="mailto:mbelvadi@upei.ca" target="_blank">mbelvadi@upei.ca</a> 9<span style="font-size:12.8px">02-566-0581</span></div><div>my <a href="http://www.google.com/calendar/embed?src=mbelvadi%40upei.ca&ctz=America/Halifax&mode=week" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(17,85,204)" target="_blank">public calendar</a></div><div><a href="https://mbelvadi.youcanbook.me/" target="_blank">Make an appointment</a> via YouCanBookMe</div><div><br></div><div><br><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Sep 6, 2019 at 4:12 PM Hertz, Ian S. <<a href="mailto:hertzis@wssu.edu">hertzis@wssu.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_1537685727483273951WordSection1">
<p class="MsoNormal"><span style="color:rgb(31,78,121)">Hello,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,78,121)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,78,121)">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
</span><span style="color:black">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
</span><span style="color:rgb(31,78,121)">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?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,78,121)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Thank you.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="color:rgb(31,73,125)">NOTE: (Please keep attachments in all correspondence)<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Ian Hertz, MLIS<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Electronic Resources Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Business Reference Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">O’Kelly Library Rm 114<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Winston Salem State University<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">336 750-2532<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Eril-l mailing list<br>
<a href="mailto:Eril-l@lists.eril-l.org" target="_blank">Eril-l@lists.eril-l.org</a><br>
<a href="http://lists.eril-l.org/listinfo.cgi/eril-l-eril-l.org" rel="noreferrer" target="_blank">http://lists.eril-l.org/listinfo.cgi/eril-l-eril-l.org</a><br>
</blockquote></div>