Measurements Playbook - Counter 5 Usage Stats for Librarians: Quarterly Usage Stats
Quarters
Months | Calendar Year | Fiscal Year |
Jan - Mar | Q1 | FYQ3 |
Apr - June | Q2 | FYQ4 |
July - Sept | Q3 | FYQ1 |
Oct - Dec | Q4 | FYQ2 |
Counter 5: Definitions of New Metrics
Total Item Requests
- Total number of times an article was requested (i.e. fulltext was downloaded or viewed).
- Double-click filters are applied to these transactions.
- This NEW Counter 5 metric is the equivalent of the old FT Views or FT Requests.
Unique Item Requests
- Number of unique articles requested in a user-session.
- This is the new and better way to count for cost-per-use because it eliminates the duplication built into Total Item Requests when someone pulls up the html, and then pulls a pdf of the same article in the same session.
- These numbers will likely be lower than Total Item Requests.
Total Item Investigations
- Total number of times content or info related to a content item was accessed.
- Includes the following:
- Viewing an abstract
- Linking to a link resolver
- Viewing cited references
- Linking to an ILL form
- Viewing html fulltext
- Viewing the PDF
- Watching a video
- Viewing an article preview
- Total Item Investigations is a good metric for citation databases not known for fulltext, such as Cinahl, since users may interact with it more looking at abstracts, or clicking out to a link resolver to get fulltext elsewhere, or ordering via a built-in ILL form.
- Counts the total clicks on the site.
Key Points
- Accessing an item as FT counts as both a request AND an investigation (an expression of interest).
- Intro to the Playbook
- Overview of Measurements
- Crash Course in Counter 5 (Intro & Definitions)
- What C5 Metrics will we be tracking in 2021?
- Tools & Worksheets
- Questions
- Submit Stats
- Reports
- The Measurements Team
- Measurements Extra Credit
Quarterly Usage Stats - Introduction to The Measurements Playbook
These pages include admin links for various publishers and database vendors to facilitate pulling usage stats for Access Medicine, Clinical Key, Cochrane, Ebsco (Cinahl), Ovid and individual journals like NEJM, JAMA, and Pediatrics.
Where possible, we've added suggestions on the appropriate reports to pull along with notes on how to read / interpret reports, esp. in reference to the new Counter 5 metrics.
We may not be able to list everything people are using here, but it will give you a place to start.
- Contact Michele Matucheski if you need additional help or guidance.
Ascension Library Services
Overview of Measurements
Goals:
- Measurement of Operations
- Assess target users (needs, interests, etc.)
- Account for resources
- Explain how resources are being used
- Enhance visibility
- Describe impact
- Ensure efficiency
- Support planning
- Support decision making
Uses
- Compare to self annually
- National annual report
- Contract optimization
-
Measurement Team Update Covering Phases 1 - 2 - 3February 25, 2021 Update
-
Measurement Team Update covering Phases 1-2-3December 2020 Update
-
Utilizing National Quarterly Stats at the Local Level (pdf)by Michele Matucheski - Ascension Wisconsin
Crash Course in Counter 5 (Intro & Definitions)
Do you need a crash course in the new Counter 5 Metrics? We knew it was coming. Many of our vendors / publishers have already stopped producing usage stats in the old familiar Counter 4 format, and only offer Counter 5 stats now.
There's a lot to know, including:
- New definitions of the Counter 5 Metrics
- Total vs. Item vs. Unique Investigations
- Total Vs. Item Unique Requests
- What's the difference between investigations and requests?
- How and what do they count (or do NOT count)
- How do they translate to the old Counter 4 usage stats?
- Just what stats should I be tracking now?
- What reports will give me those stats?
Here are some additional learning resources to get you started:
The Counter Project Foundation Classes video series on YouTube.
- Metric Types * (Definitions)
- Reports *
- Metrics & Reports: Putting it all Together *
- Attributes, Elements & Other Slightly Techy Things
- Book Reports
- Database Reports
- Journal Reports
- Understanding the Use of Open Access Content
- Working with Counter 5 Reports in Microsoft Excel
- Platform Reports
- Usage in the Time of the Pandemic
-
Friendly Guide to Release 5 for Librarians (pdf)This guide seems to track along with the Counter 5 Foundation training videos 1-2-3.
-
Understanding Counter 5See ALL the Friendly Guides to the Release 5 Code of Practice and Manual for Librarians. *Journal Stats * Book Stats.
A Practical Guide to COUNTER Release 5 from ASERL on Vimeo
(November 2020; about 1 hour)
Some helpful notes:
Counter 5 Metric Types - Definitions:
What's the difference between Item Investigations and Item Requests in Counter 5?
- Total Item Requests (TIR) appears to be equivalent to the old Fulltext Views or FT Requests in C4.
- Because the TIR metric most closely correlates to the old C4 metric for FT Views, it can help translate / interpret how the new C5 metrics are tracking.
- Total Item Investigations (TII) appears to count the total clicks on the site. This is most useful for citation databases, not known for fulltext.
- Total Item Investigations is a good metric for citation databases like Cinahl, since users may interact with it more looking at abstracts, or clicking out to a link resolver to get fulltext elsewhere, or ordering via a built-in ILL form.
- Unique Item Requests (C5) is the new and better way to count for cost-per-use, because it excludes duplication in Total Item Requests (html + pdf of the same article / session). These numbers will likely be lower than what you're used to seeing with FT Views.
User Action:
- Accessing an item as FT counts as both a request AND an investigation (an expression of interest).
- The new Counter 5 metrics eliminate the double counts when someone pulls up the html, and then pulls a pdf of the same article in the same session.
What metrics do I need to be tracking for national Ascension Library Services?
We've distilled it down to just a handful (NOT all) of the new C5 metrics:
Don't worry: This Playbook will lead you through all the steps of running the recommended reports and pulling the requested metrics with screenshots.
What C5 metrics do I need to be tracking for national Ascension Library Services?
We've distilled it down to just a handful (NOT all) of the new C5 metrics:
Don't worry. The Measurements Playbook will lead you through all the steps to pulling the recommended reports and metrics.
Tools & Worksheets
-
How to Convert Excel to Google SheetsMany vendor usage reports come as Excel files. Since Ascension uses G-Suite, you'll need to convert some files.
Here are two optional methods for collecting your quarterly stats:
-
Library Quarterly Statistics Data Entry Submission Form (RedCap) PDF - (READ ONLY)Recommended Use: Print this off to collect and record your stats in preparation for data entry.
-
Quarterly Statistics Worksheet 2021 (on Google Drive)Recommended Use: Save a copy to your own files and adapt for your own purposes. Leave this copy "clean" for everyone to use.
-
Quarterly Stats Worksheet (Excel)Template to track quarterly stats.
Questions
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Submit Stats
You will receive an invitation through RedCap to submit your stats following the end of each quarter.
> If you do NOT receive an invitation, contact Ross McKinney.
Reports
The Measurements Team
Questions, Comments, of Feedback about Library Statistics? Feel free to contact anyone on The Measurements Team:
- Christy Tyson
- Jean Jenkins
- Michele Matucheski
- Ross McKinney
- Eleanor Truex
- Bonnie Arnold
Library Measurements Extra Credit
So you love keeping stats and tracking your own local data!
Here are some templates from your fellow Ascension Librarians that you are welcome to use and adapt for your own purposes:
-
Blank DIY QuickDoc 2021 and BeyondSimple spreadsheet template to track in-house document delivery, ILL Borrow, and ILL Lend transactions. Goes beyond Docline reports.Most of this data is not required for national Ascension reporting, but does allow you to create a nice profile of your library services around ILL and document delivery.
Working with Library Statistics (NNLM) (pdf)
This is a pdf version of an old but very useful website.
Cost-per-Use
The Formula:
COST divided by USE = cost/use
Example for a Library website:
$4000 for LibGuides software divided by 30,000 hits = 13 cents / use
This is an excellent value!
Tip: When using Counter 5 Reports, use the Unique Item Request metric to calculate cost-per-use for Journals.
-
How Not to Waste Money: Use the Cost-per-Use FormulaArticle by Forbes.
Pulling Stats
- Pulling Stats - Table of Contents
- SUSHI Process in TDNet
- Pulling Stats - AccessMedicine
- Pulling Stats - Annals of Internal Medicine
- Pulling Stats - Cochrane via Ovid
- Pulling Stats - Cochrane via Wiley
- Pulling Stats - Clinical Key
- Pulling Stats - Clinical Key C5 NEW!
- Pulling Stats - Docline
- Pulling Stats - DynaMed
- Pulling Stats - EbscoHost Databases - CINAHL
- Pulling Stats - EbscoHost Databases - DynaMed
- Pulling Stats - EbscoHost - eJournals
- Pulling Stats - JAMA
- Pulling Stats - NEJM
- Pulling Stats - Ovid eJournals
- Pulling Stats - Pediatrics
- Pulling Stats - ScienceDirect eJournals
- Pulling Stats - TDNet
Pulling Stats - Table of Contents
This tabbed box contains step-by-step instructions for pulling quarterly stats for the following resources:
Click the three dots to see additional tabs off to the right.
- SUSHI Process in TDNet - Simplify harvesting stats! [New as of May 2024]
- AccessMedicine
- Annals of Internal Medicine
- Cochrane via Ovid
- Cochrane via Wiley
- Clinical Key
- Docline
- EbscoHost Databases - CINAHL
- EbscoHost Databases - DynaMed
- EbscoHost - eJournals
- JAMA
- NEJM
- Ovid eJournals
- Pediatrics
- ScienceDirect eJournals
SUSHI Process in TDNet - Smita Joshipura explains the setup in these Google Slides (as of May 2024)
Once you set up SUSHI through TDNet, it should make pulling stats much easier!
> Please be aware that a few vendors (ex. R2) are NOT SUSHI compliant, so this method of harvesting stats won't work with all vendors.
Thanks to Smita for figuring out how to do it!
> SUSHI Counter5 Reports on TDNet - Step-by-step tutorial with screenshots by TDNet on set up and how to run reports.
__________________________________________________________________________________
Elsevier SUSHI Set-UP Support (bypass the default Elsevier Help Desk)
Here's the website: https://dev.elsevier.com/sushicop5.html
and here is the dedicated support email: datasupportRD@elsevier.com
Pulling Stats - AccessMedicine
NOTE: Vendors using the SilverChair Platform tend to post their C5 stats after 10 business days into the new month. Be aware of this and do not be alarmed if the last month shows ZERO Stats. Just wait a few more days, and try running the report after the 15th of the month.
Due to some issues encountered with the first round of pulling Counter 5 stats for AccessMedicine, The Measurements Team revised the metrics and reports we'll be tracking for AccessMedicine. Follow the instructions below:
Part 1)
Log into Access Medicine > Click on the Other Reports Tab > Select AccessMedicine, if you subscribe to multiple sites. (You can leave it at All Sites, if you only have the main AccessMedicine collection.)
> Select a time interval
> Recommended Report: Institutional Product Activity Report
Look for Content Accesses [Highlighted in gold.]
- Be sure you are reporting the desired time interval / quarter.
- We will continue to track this metric from AccessMedicine's proprietary reports for the time being.
- This metric does not appear to map to anything directly in Counter 4 or Counter 5.
- Libraries who purchase additional specialty collections (ie Access Surgery) are not able to separate the basic AM content from other specialty collections in the C5 Stats. SilverChair does not offer a C5 Database Report that might make this possible. This old report allows them to look at each collection separately.
Part 2)
Sign in with your admin credentials. Click on the Counter 5 Tab.
Select a date range:
From the list of available Counter 5 Reports, choose the PR Platform Master Report. Download CSV.
- Alternative Report (for AMITA): Consortium Platform Master Report (CR_PR).
Look for
- Total Item Investigations
In this example,
- Total Item Investigations = 46 (Highlighted in apple green)
Here's another example:
In this sample report, Total Item Investigations is broken out between 3 platforms. In this case, you'd want to add up the reporting totals for all 3.
- Total Item Investigations = 21 + 8 + 1 = 30
Why are we making this change?
We think this C5 metric may do a better job of showing overall usage in AccessMedicine, since AccessMedicine is more than just a fulltext database for eBooks. People also use the other components of AccessMedicine including drug info, Diagnosaurus, procedure videos and multimedia, study tools and review questions, among other things.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Annals of Internal Medicine (direct from the Publisher)
Choose “Institutional Admin Login”
Login. Click on your name in the upper right corner:
Choose Usage Reports:
Go to Atypon Insights for Counter 5 reports:
Recommended Report: : Journal Requests (Excluding OA_Gold) (TR_J1)
> Choose TSV (Tab Separated Values) format. Save the file. Open with Google Sheets or Excel.
Look for:
- Total Item Requests = 41 [Highlighted in orange]
- Unique Item Requests = 37 [Highlighted in apple green]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Cochrane via Ovid
Cochrane via Ovid
Note: Your institution may have Cochrane access through another vendor like Ebsco or Wiley. In that case, follow the general directions for pulling stats under those vendors instead.
>> Log in with your Admin credentials.
Choose Database Master report:
Look for the following metrics:
- Searches (Regular or Platform) = 4 [Highlighted in orange]
- Choose Regular or Platform Searches for this metric.
- Federated Searches is a separate thing that we are NOT tracking at this time. So you can ignore that line.
- Total Item Investigations = 1 [Highlighted in apple green]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
- What if the required metric does not appear on the report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Next rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
- Double check to make sure that:
Pulling Stats - Cochrane via Wiley
Note: Your institution may have Cochrane access through another vendor like Ebsco or Ovid. In that case, follow the general directions for pulling stats under those vendors instead.
>> Log in with your Wiley admin username and password.
> Click your name to see a dropdown menu, then click on Institutional Admin.
On the Usage Reports Page, scroll down to the bottom of the page where you should see this:
Be sure the Counter 5 tab is selected, then click on Go to Atyphon Insights.
Set up the report to look like this (using the relevant time interval).
> Recommended Report: Database Master Report (DR)
> Then hit generate or email report.
Note: TSV format is similar to CSV and will open in a spreadsheet. You will probably need to save the file, and drag it into a Google Drive to open with Google Sheets in order to view the file.
Look for:
- Searches = 7 [Highlighted in orange]
- Total Item Investigations = 38 [apple green]
From the report, record the required metrics for the respective time interval / quarter. In this case it would be:
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Clinical Key
- The best option for Clinical Key stats is to contact your account rep. and sign up to receive the monthly usage reports delivered by email. There is no admin login to pull our own usage stats.
- As of April 7, 2021, CK has not been able to provide Counter 5 Reports, so we will continue on with the old Counter 4 Reports, until CK makes the upgrade.
- Above is a snippet from a sample CK monthly Counter 4 report.
- Look for the overall Content Views. This will be at the top of the report.
- Because this report is issued monthly, you will have to add up the numbers for the respective quarter you need to report for Ascension Quarterly Stats.
- In this case, you'd want to add up the content accesses for January + Feb + March = 634 + 439 + 338 = 1,411 total.
- For the first quarter, the total at the right is summed up for you.
- In future quarters, you will need to add the 3 months for each respective quarter manually.
Reporting individual journal usage from CK:
Those who have access to Clinical Key may also be reporting usage stats on select ejournals such as:
- American Journal of Obstetrics & Gynecology
- Journal of the American College of Cardiology (JACC)
- Lancet
Using the same monthly CK report, scroll down until you see a section for FullText Journal and Clinics Views by Title. [In this sample report it was Page 9.]
- Because this report is issued monthly, you will have to add up the numbers for the respective quarter you need to report for Ascension Quarterly Stats.
- This report shows the most used journals at the top. They are NOT alphabetical.
- If you have a hard time finding these 4 ejournals in the list, try the "Find in Page" [Ctrl +F] command to locate them.
- In this case, all 4 focus titles appear in the same snippet.
- Again, you'd want to add up the content accesses for January + Feb + March.
- For the first quarter, the total at the right is summed up for you.
- In future quarters, you will need to add the 3 months for each respective quarter manually.
- This report shows the most used journals at the top. They are NOT alphabetical.
Note on submitting data for journals in Clinical Key:
- On the Redcap Quarterly Stats Submission form, enter the respective C4 numbers for Fulltext Views in the C5 box for Total Item Requests. These metrics are roughly equivalent between C4 and C5.
- Leave the box for Unique Item Requests blank, since there is no equivalent metric on the Counter 4 Report.
NEW - Updated July 2023
Now Available: COUNTER5 Usage Reports for ClinicalKey
> Sign up for the CK Counter 5 Reports (You only need to do this once.)
Elsevier Product Insights for Customers (E-Pic Portal)
> General instructions on best practices for accessing and generating reports [from Elsevier]
> Specific instructions for Ascension 1/4ly stats reporting:
Sign in with your username and password or via your institution.
Part 1)
Recommended Report: PR_P1 - Platform Usage
Select the time interval.
Save as CSV, and open with Google Sheets.
Look for Total Item Requests [Highlighted in gold/orange.]
and Unique Item Requests [Highlighted in apple green.]
> Note: At this point we do NOT have a slot on the RedCap form to record Unique Item Requests, although we may in future. You may want to get used to tracking it in the meantime.
- Be sure you are reporting the desired time interval / quarter.
- Total Item Requests (C5) should be roughly equivalent to Content Accesses / Total Content Views (C4)
- Unique Item Requests (C5) is a NEW metric with no equivalents in the old Counter 4 reports.
- This gives us an overall picture of usage on this resource.
Part 2) Reporting individual C5 journal usage from Clinical Key:
Those who have access to Clinical Key may also be reporting usage stats on select ejournals such as:
- American Journal of Obstetrics & Gynecology
- Chest
- Journal of the American College of Cardiology (JACC)
- Lancet
Recommended Report: TR_J1
Select the time interval.
Save as CSV, and open with Google Sheets.
Pick out the individual journals you need to report on.
Look for:
- Total Item Requests [Highlighted in orange]
- Unique Item Requests [Highlighted in apple green] This is a NEW metric for CK. There should already be a place on the RedCap form to report this metric.
-
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Food for thought: You may want to check the TRJ1 Report for ScienceDirect as well. In WI, we found that there was significant usage for some of the Elsevier journals we're tracking. Similar to Ovid and LWW offering access to the same journals on different platforms aimed at institutional and individual subscribers, you may want to add Total Item Requests (TIRs) together and report the totals per journal. Same for Unique Item Requests (UIRs). Then report the totals on the RedCap form so we can capture that usage.
For example:
TIR on Clinical Key | TIR on ScienceDirect | Total TIR at Elsevier | |
Lancet | 36 | 29 | 65 |
UIR on Clinical Key | UIR on ScienceDirect | Total UIR at Elsevier | |
Lancet | 25 | 25 | 50 |
Question: What if my stats are lower than expected?
- Double check to make sure you selected the intended interval (3 months, not 1 month).
- Double check to make sure that stats for the last month have actually posted. It can take several weeks for the publishers to process and post C5 stats, and the last month may not appear as soon as you'd think. You may see all zeros in the column for the last month, or that month may not even be a choice to select for the time interval.
- Is something going on with your access? Did your IPs change? Did the publisher block your access due to a delay in renewals, or some other technical issue?
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Docline
-
How to Pull Docline Reportsand how they can be used in your local Ministry.
Pulling Stats - DynaMed
Log into DynaMed through the Person icon (circled in red above) at the upper right side of the page.
Once you are signed in, you should see your initials in place of the Person icon (circled above in red).
Click on your initials, and you'll see a drop down menuu:
Click on Switch Location.
Choose Ascension Health and click on Switch Location.
Now when you click on your initials at the upper right corner, you'll see a different menu.
Click on Analytics.
This will bring up the DynaMed Insights Dashboard for Ascension Health nationwide.
Deselect All, and choose your local market site(s). Then click on Show Selected Sites.
This will allow you to see DynaMed Stats for your local market.
The Dashboard should recalibrate to show stats from the selected markets.
Things to consider when eyeballing your data:
* Is your usage going up, down, or holding steady?
* Is anything dramatic is happening with your stats. For instance, a sudden drop in usage might mean there's an access problem-- a broken link, a broken website, or IPs changed.
* Are there any big user groups, or topics being covered, etc.
Your manager will be discussing stats with you during regular 1:1 meetings.
Pulling Stats - EbscoHost Databases - CINAHL
Click on Create Report for Download.
- Then go to the Download Reports Tab to pull the report you just ran.
- Download as an Excel file; Pull into Google Drive and open with Google Sheets.
Look for:
- Searches
- Total Item Investigations
In this example, Searches = 534 [highlighted in orange]
and Total Item Investigations = 627 [highlighted in apple green]
These are the only 2 metrics to report on the national quarterly statistics.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - EbscoHost Databases - DynaMed
Report Type: Database Master
Reporting Period: Jan - Dec 2021.
Look for:
- Searches
- Total Item Investigations
- Total Item Requests
- Unique Item Investigations
- Unique Item Requests
Take a snippet of all 5 DynaMed metrics for the Reporting Period Total, as shown above. Include the report header showing the report name, institution, and reporting period for clarity.
Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
- Since it is a national contract, you may not have access to local DynaMed stats. It may depend on how it's configured, and what you are allowed to see with your admin access.
Pulling Stats - eJournals on EbscoHost Databases
> Log in > Reports & Statistics > Counter 5 Reports
Recommended Report: Journal Requests (Excluding OA_Gold) (TR_J1)
- Alternative Report: Title Master Report (This will give you more data, including the 2 metrics we're looking for.)
- Set the TR_J1 report to run for the desired quarterly interval. The example above runs Jan - Mar 2021.
- Run the report. It will come as an excel spreadsheet. You can have it emailed to you, or download it from the Reports section.
- Open the report in Excel and pull your data, or
- Pull the file into Google Drive, and open with Google Sheets.
- You may have to clean up the report a bit to view the stats for selected ejournals.
- Open the report in Excel and pull your data, or
Look for:
- Total Item Requests
- Unique Item Requests
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- You may need to add numbers if multiple editions of the journal are listed, as shown in this example.
- Some columns and additional data have been omitted for clarity.
- If the journal you seek does not appear on the list, it may mean it was not used during the given time period. Zero hits do not register on Counter 5 Reports.
Keep working through the list until you have collected stats for all Ebsco eJournals that you report on your quarterly stats.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - JAMA
NOTE: Vendors using the SilverChair Platform tend to post their C5 stats after 10 business days into the new month. Be aware of this and do not be alarmed if the last month shows ZERO Stats. Just wait a few more days, and try running the report after the 15th of the month.
>>>> Log in with your admin credentials.
Select the Counter 5 Tab and choose a reporting interval / dates:
Tip: Set the report to run the desired time interval. We recommend the 3-month interval you need to report out. That way, the report does the math for you!
Recommended Report: TR_J1 Journal Requests (Excluding OA_Gold) - lists just the 2 metrics we need. TR_J1 is shown below.
Alternative Report: The Platform Master would show all 6 C5 Metrics, including the 2 we need.
Download as CSV. Save to your Google Drive and Open with Google Sheets.
Interpretation: You may see other journals listed on the JAMA platform. Since we are only looking for stats on JAMA the ejournal, not every journal on the entire JAMA platform, scroll down to the JAMA line.
Look for:
- Total Item Requests = 565 for the quarter [Highlighted in orange.]
- Unique Item Requests = 511 [Highlighted in green.]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - NEJM
Note: Consider also pulling stats for NEJM via Ovid, as well as direct from NEJM. See the Pulling Stats - Ovid tab for more info. That said, direct from NEJM should be the primary source for NEJM stats.
Log into the NEJM Admin Account for Institutions.
> Choose Usage Reports > Be sure the Counter 5 Tab is active. > Click on the Counter 5 Reports button at the lower right.
Here you can choose the setting for the report you want to run.
- It should pull in your identity.
- Choose TSV format.
- Custom Dates: Choose the quarter (or other interval).
- Report: Journal Requests (Excluding OA_Gold) (TR_J1)
- Alternative Report: Title Master Report (TR) - This report will give you more data, including the 2 metrics we're asking for.
- At the bottom of the screen, you can generate the report or email it to yourself
Once you download the report, drag into G-Drive. Then open with Google Sheets. You should see something like this:
Look for:
- Total Item Requests = 2067 [Highlighted in orange]
- Unique Item Requests = 1645 [Highlighted in apple green]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Ovid eJournals
>> Log in with your admin credentials.
Recommended Report: TR_J1 Journal Requests (Excluding OA_Gold)
- Alternative Report: Title Master Report (This will give you more data, including the 2 metrics we're looking for.)
- Set the report to run for the desired quarterly interval. The example above runs Jan - Mar 2021.
- Run as and Excel Spreadsheet or CSV. This will be emailed to you as a zipped file. You can also download it from the Reports section.
- Unzip/ extract the file. Pull it into Google Drive, and open with Google Sheets.
- You may have to clean up the report a bit to view the stats for selected ejournals.
Look for:
- Total Item Requests = 71 + 34 = 105
- Unique Item Requests = 66 + 31 = 97
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- You may need to add numbers if multiple platforms are listed, as shown in this example.
- Some columns and additional data have been omitted for clarity.
Keep working through the list until you have collected stats for all Ovid Journals that you report on your quarterly stats.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - Pediatrics
(AFTER November 8, 2021 on their new platform)
Usage Reports - AAP Journals & AAP eBooks
- AAP Institutional Login (New on Silverchair - Use this after Nov. 8, 2021)
- Handout from APP on how to retrieve usage stats on the new platform
NOTE: Vendors using the SilverChair Platform tend to post their C5 stats after 10 business days into the new month. Be aware of this and do not be alarmed if the last month shows ZERO Stats. Just wait a few more days, and try running the report after the 15th of the month.
1) Go to https://sitemaster.publications.aap.org/admin/login.aspx
2) Log into the AAP admin portal with your credentials For assistance with your AAP login, you may submit an inquiry.
3) Once you are logged in, you can click on the corresponding tab on the top of the page to access the counter report options:
4) Set the date range for the time period for which you want to run stats.
- Recommended Report: TR_J1 Journal Requests (Excluding OA_Gold)
- Alternative Report: Title Master Report (This will give you more data, including the 2 metrics we're looking for.)
- Set the report to run for the desired quarterly interval. The example above runs October - December 2021.
- Run as CSV. Pull it into Google Drive, and open with Google Sheets.
- You may have to clean up the report a bit to view the stats for Pediatrics.
Look for:
- Total Item Requests = 156 [Highlighted in orange]
- Unique Item Requests = 112 [Highlighted in apple green]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
_____________________________________________________________________________
For Pediatrics Stats BEFORE November 8, 2021
To pull stats for the October - December quarter of 2021, you'll need to pull the October stats on the old platform, as they won't be included on the new platform. Add the Oct stats from Highwire together with the new stats from Silverchair to get complete C5 stats for October - December 2021.
Instructions on how to access the journal from AAP - Pediatrics to get usage statistics.
Refer to the following steps to view Usage Report Counter Statistics for AAP publications at your Institution:
1. Go to http://dashboard.
2. Click on the link for View Counter Usage Reports > Counter 5 Usage Reports
3. Sign in with your administrator login credentials
4. Specify the parameters for the statistics you would like to view and click the Run Report button.
- Recommended Report: TR_J1 Journal Requests (Excluding OA_Gold)
- Alternative Report: Title Master Report (This will give you more data, including the 2 metrics we're looking for.)
- Set the report to run for the desired quarterly interval. The example below runs Jan - Mar 2021.
- Run as CSV. Pull it into Google Drive, and open with Google Sheets.
- You may have to clean up the report a bit to view the stats for Pediatrics.
Look for:
- Total Item Requests = 739 [Highlighted in orange]
- Unique Item Requests = 593 [Highlighted in apple green]
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- Some columns and additional data have been omitted for clarity.
Pulling Stats - ScienceDirect eJournals
Recommended Report: Journal Requests (Excluding OA_Gold) (TR_J1)
- Alternative Report: Title Master Report (This will give you more data, including the 2 metrics we're looking for.)
- Set the TR_J1 report to run for the desired quarterly interval. The example above runs Jan - Mar 2021.
- Run the report. It will come as an Excel spreadsheet. You can have it emailed to you, or download it from the Reports section.
- Open the report in Excel and pull your data, or
- Pull the file into Google Drive, and open with Google Sheets.
- You may have to clean up the report a bit to view the stats for selected ejournals.
- Open the report in Excel and pull your data, or
Look for:
Total Item Requests
Unique Item Requests
- Note: This assumes the report interval was limited to the quarter you are focused on. If you set the time interval for more than 3 months, you may have to do some math manually to pull the stats for the respective quarter.
- You may need to add numbers if multiple editions of the journal are listed, as shown in this example. \
- Some columns and additional data have been omitted for clarity.
- If the journal you seek does not appear on the list, it may mean it was not used during the given time period. Zero hits do not register on Counter 5 Reports.
Keep working through the list until you have collected stats for all eJournals from this vendor that you report on your quarterly stats.
Question: What if the required metric does not appear on my report?
- Double check to make sure that:
- You've pulled the recommended report for the correct time period, as not all metrics show on every report.
- Then rerun the report with a longer time period. Instead of 3 months, try a year. Does the metric appear now?]
- In Counter 5, if the count is zero, that item will NOT appear on the reports.
Pulling Stats - TDNet
Under Construction
Literature Search Evaluations: Assessing Our Impact and Proving Our Worth to Quality Care.
Ascension Librarians use a RedCap Survey that asks users how their librarian-mediated searches impacted patient care, changed practices, and decision-making at their organization. The survey results are then populated into visual graphs and charts that make the data easy to understand and interpret for Librarians and Leaders. The visual reports are used to educate organizational administrators as well as stakeholders about the value of Library Services.
* Lit Search Evaluations: Assessing Our Impact and Proving our Worth to Quality Care [Google Slides]