Benchmark

Create analytics reports comparing the performance of your institution to similar institutions.

Using the Benchmark subject area, you can create analytics reports comparing the performance of your institution to similar institutions. These reports can can help you identify places in your workflow that can be improved.

In order for the benchmark analytics to be active in an institution, the following two conditions must be met:

The following are some example of business questions that can be investigated with this subject area:

  • What is the average time in my institution (compared to other institutions) from when the order is sent until the electronic resource is activated?
  • What is the average time in my institution (compared to other institutions) from when the order is sent until the physical item arrives?
  • What is the average time in my institution (compared to other institutions) for a physical item hold request to be processed?
  • What is the percentage of loans in my institution (compared to other institutions) that were returned late?

benchmark_star_diagram

Star Diagram – Benchmark

Field Descriptions

The following fields are available in Benchmark:

benchmark_field_descriptions.png

Benchmark - Field Descriptions
Benchmark information is updated in Analytics once a month.

KPI Measures

The Key Performance Indicator (KPI) table is a fact table that stores all measures relating to KPIs. It is divided into the following areas:

  • Inventory KPIs
  • Acquisition KPIs - POLs
  • Fulfillment KPIs - Requests
  • Fulfillment KPIs - Loans
  • Resource Sharing KPis - Borrowing Requests
  • Resource Sharing KPis - Lending Requests
  • Usage KPIs - COUNTER Reports

Inventory KPIs

Inventory KPIs
Field Description Additional Information
Total
Number of bibliographic records in repository (total) The total number of bibliographic records in the repository The value of this field is the monthly average by default.
Number of physical items in repository (total) The total number of physical items in the repository The value of this field is the monthly average by default.
Number of electronic portfolios in repository (total) The total number of electronic portfolios in the repository The value of this field is the monthly average by default.
Num of electronic portfolios in repository linked to CZ (total) The total number of electronic portfolios in the repository that are linked to the community zone  
Num of electronic portfolios in repository not linked to CZ (total) The total number of electronic portfolios in the repository that are not linked to the community zone  
Number of electronic collections in repository (total) The total number of electronic collections in the repository The value of this field is the monthly average by default.
Num of electronic collections in repository linked to CZ (total) The total number of electronic collections in the repository that are linked to the community zone  
Num of electronic collections in repository not linked to CZ (total) The total number of electronic collections in the repository that are not linked to the community zone  
Monthly
Number of bibliographic records in repository added (by month) The number of bibliographic records added to the repository per month  
Number of physical items in repository added (by month) The number of physical items added to the repository per month  
Number of electronic portfolios in repository added (by month) The number of electronic portfolios added to the repository per month  
Number of electronic collections in repository added (by month) The number of electronic collections added to the repository per month  

Acquisition KPIs - POLs

Acquisition KPIs - POLs
Field Description Additional Information
Num of PO Lines created (by month) The number of PO lines created per month  
Num of PO Lines created (last 365 days) The number of PO lines created in the last 365 days  
% of PO Lines originating from a purchase request The percentage of PO lines that originate from a purchase request  
% of PO Lines originating from an API The percentage of PO lines that originate from an API  
% of PO Lines originating from an import profile of type EOD The percentage of PO lines that originate from an import profile of type EOD  
% of PO Lines originating from manual entry The percentage of PO lines that originate from a manual entry  
Physical - Average days from POL sent to item arrival The average number of days that passed from the sending of the PO line for physical items until they arrived  
Physical - Average days from POL creation to sent The average number of days that passed from the creation of the PO line for physical items until they was sent  
Physical - Average days from POL creation to item arrival The average number of days that passed from the creation of the PO line for physical items until they arrived  
Physical - Med days from POL sent to item arrival The median number of days that passed from the sending of the PO line for physical items until they arrived  
Physical - Med from POL creation to sent The median number of days that passed from the creation of the PO line for physical items until they were sent  
Physical - Med from POL creation to item arrival The median number of days that passed from the creation of the PO line for physical items until they arrived  
Physical - 95% days from POL sent to item arrival The number of days after the PO line was sent by which 95% of the physical items arrived  
Physical - 95% days from POL creation to sent The number of days by which 95% of the items were sent after the PO line was created  
Physical - 95% days from POL creation to item arrival The number of days by which 95% of the items were received after the PO line was created  
Electronic Portfolio - Average days from POL sent to portfolio activation The average number of days that passed from the sending of the PO line for electronic portfolios until they were activated  
Electronic Portfolio - Average days from POL creation to sent The average number of days that passed from the creation of the PO line for electronic portfolios until they were sent  
Electronic Portfolio - Average days from POL creation to portfolio activation The average number of days that passed from the creation of the PO line for electronic portfolios until they were activated  
Electronic Portfolio - Med days from POL sent to portfolio activation The median number of days that passed from the sending of the PO line for electronic portfolios until they were activated  
Electronic Portfolio - Med days from POL creation to sent The median number of days that passed from the creation of the PO line for electronic portfolios until they were sent  
Electronic Portfolio - Med days from POL creation to portfolio activation The median number of days that passed from the creation of the PO line for electronic portfolios until they were activated  
Electronic Portfolio - 95% days from POL sent to portfolio activation The number of days by which 95% of the sent portfolios were activated  
Electronic Portfolio - 95% days from POL creation to sent The number of days by which 95% of the created PO lines were sent  
Electronic Portfolio - 95% days from POL creation to portfolio activation The number of days by which 95% of the created PO lines were activated  
Electronic Collection - Average days from POL sent to collection activation The average number of days that passed from the sending of the PO line for an electronic collection until it was activated  
Electronic Collection - Average days from POL creation to sent The average number of days that passed from the creation of the PO line for an electronic collection until it was sent  
Electronic Collection - Average days from POL creation to collection activation The average number of days that passed from the creation of the PO line for an electronic collection until it was activated  
Electronic Collection - Med days from POL sent to collection activation The median number of days that passed from the sending of the PO line for an electronic collection until it was activated  
Electronic Collection - Med days from POL creation to sent The median number of days that passed from the creation of the PO line for an electronic collection until it was sent  
Electronic Collection - Med days from POL creation to collection activation The median number of days that passed from the creation of the PO line for an electronic collection until it was activated  
Electronic Collection - 95% days from POL sent to collection activation The number of days by which 95% of the sent PO lines for electronic collections were activated  
Electronic Collection - 95% days from POL creation to sent The number of days by which 95% of the created PO lines for electronic collections were sent  
Electronic Collection - 95% days from POL creation to collection activation The number of days by which 95% of the created PO lines for electronic collections were activated  

Fulfillment KPIs - Requests

Fulfillment KPIs - Requests
Field Description Additional Information
Number of patron physical item requests created (by month) The number of patron physical item requests created per month  
Number of booking requests created (by month) The number of booking requests created per month  
Number of digitization requests created (by month) The number of digitization requests created per month  
Number of patron physical item requests rejected (by month) The number of patron physical item requests rejected per month  
Number of patron physical item requests rejected by library (by month) The number of patron physical item requests rejected by a library per month  
Number of patron physical item requests rejected by patron (by month) The number of patron physical item requests rejected by a patron library per month  
Number of physical item requests that involved transits (by month) The number of physical item requests that involved transits per month  
Average processing time physical item requests (date on hold shelf - date created) (last 365 days) The average processing time for physical item requests for the last 365 days. (Calculated by the number of days between the date the physical item request was created and the date the item was placed on the hold shelf.)  
Med processing time physical item requests (date on hold shelf - date created) (last 365 days) The median processing time for physical item requests for the last 365 days. (Calculated by the number of days between the date the physical item request was created and the date the item was placed on the hold shelf.)  
95% processing time physical item requests (date on hold shelf - date created) (last 365 days) The amount of processing time by which 95% of physical item requests were processed in the last 365 days. (Calculated by the number of days between the date the item request was created and the date the physical item was put on the hold shelf.  

Fulfillment KPIs - Loans

Fulfillment KPIs - Loans
Field Description Additional Information
Number of loans (In House+ Not In House) (by month) The number of loans including in house and not in house loans per month  
Number of loans (In House) (by month) The number of in house loans per month  
Number of loans (Not In House) (by month) The number of not in house loans per month  
Number of returns (In House+ Not In House) (by month) The number of returns including in house and not in house loans per month  
Number of returns (In House) (by month) The number of in house returns per month  
Number of returns (Not In House) (by month) The number of not in house returns per month  
Number of late returns (Not In House) (by month) The number of not in house late returns per month  
Number of on time returns (Not In House) (by month) The number of not in house on time returns per month  
% of late returns (by month) The percent of late returns per month  
% of on time returns (by month) The percent of on time returns per month  
Number of returns at non-owning library (Not In House) (by month) The number of not in house returns at a non-owning library per month  
Number of returns at owning library (Not In House) (by month) The number of not in house returns at an owning library per month  
% of returns at non-owning library (by month) The percent of returns at a non-owning library per month  
% of returns at owning library (by month) The percent of returns at an owning library per month  
Average expected loan period (due date - loan date) (last 365 days) The average expected loan period for the last 365 days. (Calculated by the number of days between the due date and the loan date.)  
Average actual loan period (return date - loan date) (last 365 days) The average actual loan period for the last 365 days. (Calculated by the number of days between the return date and the loan date.)  
Average loan days deviation from due date (average expected loan period - average actual loan period (last 365 days) The average loan days deviation from due date for the last 365 days. (Calculated by the number of days between the average expected loan period and the average actual loan period.)  
Med expected loan period (due date - loan date) (last 365 days) The median expected loan period for the last 365 days. (Calculated by the number of days between the due date and the loan date.)  
Med actual loan period (due date - loan date) (last 365 days) The median actual loan period for the last 365 days. (Calculated by the number of days between the due date and the loan date.)  
Med loan days deviation from due date (med expected loan period - med actual loan period (last 365 days) The median loan days deviation from due date for the last 365 days. (Calculated by the number of days between the median expected loan period and the median actual loan period.  
95% expected loan period (due date - loan date) (last 365 days) The expected loan period for 95% of the loans for the last 365 days. (Calculated by the number of days between the loan date and the due date.)  
95% actual loan period (due date - loan date) (last 365 days) The actual loan period for 95% of the loans for the last 365 days. (Calculated by the number of days between the loan date and the due date.)  
95% loan days deviation from due date (P95 expected loan period - P95 actual loan period (last 365 days) The number of loan days deviation from the due date for 95% of the loans for the last 365 days. (Calculated by the number of days between the actual loan period and the expected loan period.  

Resource Sharing KPIs - Borrowing Requests

Resource Sharing KPIs - Borrowing Requests
Field Description Additional Information
Number of borrowing requests created (by month) The number of borrowing requests created by month  
Number of borrowing requests fulfilled (by month) The number of borrowing requests fulfilled by month  
Number of borrowing requests rejected by all partners (by month) The number of borrowing requests rejected by all partners by month  
% of borrowing requests rejected by all partners (by month) The % of borrowing requests rejected by all partners by month  
Number of partner rejections of borrowing requests (by month) The number of partner rejections of borrowing requests by month  
Number of consulted partners (last 365 days) The number of consulted partners for the last 365 days  
Number of partners in rota (last 365 days) The number of partners in rota for the last 365 days  
Average supply time for borrowing requests (last 365 days) The average supply time for borrowing requests for the last 365 days  
Median supply time for borrowing requests (last 365 days) The median supply time for borrowing requests for the last 365 days  
95% supply time for borrowing requests (last 365 days) The 95% supply time for borrowing requests for the last 365 days  

Resource Sharing KPIs - Lending Requests

Resource Sharing KPIs - Lending Requests
Field Description Additional Information
Number of lending requests created (by month) The number of lending requests created by month  
Number of fulfilled lending requests (by month) The number of fulfilled lending requests by month  
Number of non-fulfilled lending requests (by month) The number of non-fulfilled lending requests by month  
% of lending requests created which were not fulfilled (by month) The % of lending requests created which were not fulfilled by month  
Average supply time for lending requests (last 365 days) The average supply time for lending requestsverage supply time for lending requests for the last 365 days  
Median supply time for lending requests (last 365 days) The median supply time for lending requests for the last 365 days  
95% supply time for lending requests (last 365 days) The 95% supply time for lending requests for the last 365 days  

Usage KPIs - COUNTER Reports

Usage KPIs - COUNTER Reports
Field Description Additional Information
JR1 Journal usage The journal usage of the previous calendar year Calculated from the Usage Data Details > JR1 - Journal Usage Counter measure of the Usage Data subject area.
JR1a Journal Archive usage    
BR1 Title Requests The number of book searches of the previous calendar year Calculated from the Usage Data Details > BR1 - Book Success Title Requests (total) measure of the Usage Data subject area.
BR2 Section Requests    
DB1 Database views The number of database views of the previous calendar year Calculated from the Usage Data Details > DB1 - DB Records Views measure of the Usage Data subject area.
DB1 Database searches The number of database searches of the previous calendar year Calculated from the Usage Data Details > DB1 - DB Searches measure of the Usage Data subject area.
PR1 Platform searches The number of platform searches of the previous calendar year Calculated from the Usage Data Details > PR1 - Platform Regular Searches measure of the Usage Data subject area.
Number of unique platforms loaded The number of unique platforms loaded of the previous calendar year Calculated from the formula: Count (distinct "Platform"." Platform") of the Usage Data subject area.
Number of unique COUNTER reports loaded The number of unique COUNTER reports loaded of the previous calendar year Calculated from the formula: Count (distinct "Usage Data Details"." Load File ID") of the Usage Data subject area.
Number of unique JR1 COUNTER reports loaded The number of unique JR1 COUNTER reports loaded  
Number of unique JR1a COUNTER reports loaded The number of unique JR1a COUNTER reports loaded  
Number of unique BR1 COUNTER reports loaded The number of unique BR1 COUNTER reports loaded  
Number of unique BR2 COUNTER reports loaded The number of unique BR2 COUNTER reports loaded  
Number of unique DB1 COUNTER reports loaded The number of unique DB1 COUNTER reports loaded  
Number of unique PR1 COUNTER reports loaded The number of unique PR1 COUNTER reports loaded  

Institution Profile

Institution Profile
Field Description Additional Information
Primary areas of study that the institution serves
Serves Humanities Indicates if the institution serves humanities  
Serves Social Sciences Indicates if the institution serves social sciences  
Serves Sciences Indicates if the institution serves sciences  
Serves Engineering Indicates if the institution serves engineering  
Serves Multidisciplinary Indicates if the institution serves multidisciplinary areas  
Serves Other Indicates if the institution serves other areas  
Professional graduate schools of the institution
Has Medical School Indicates if the institution has a medical school  
Has Dental School Indicates if the institution has a dental school  
Has Public Health School Indicates if the institution has a public health school  
Has Business School Indicates if the institution has a business school  
Has Law School Indicates if the institution has a law school  
Has Other School Indicates if the institution has other graduate schools  
Organizations to which the institution belongs
Belongs to American Library Association (ALA) Indicates if the institution belongs to the American Library Association (ALA)  
Belongs to American Association of Law Libraries (AALL) Indicates if the institution belongs to the American Association of Law Libraries (AALL)  
Belongs to Association of Research Libraries (ARL) Indicates if the institution belongs to the Association of Research Libraries (ARL)  
Belongs to Association of College and Research Libraries (ACRL) Indicates if the institution belongs to the Association of College and Research Libraries (ACRL)  
Belongs to Canadian Library Association Indicates if the institution belongs to the Canadian Library Association  
Belongs to Canadian Association of Law Libraries Indicates if the institution belongs to the Canadian Association of Law Libraries  
Belongs to Australian Library and Information Association Indicates if the institution belongs to the Australian Library and Information Association  
Belongs to Library and Information Association of New Zealand Indicates if the institution belongs to the Library and Information Association of New Zealand  
Belongs to Association of European Research Libraries Indicates if the institution belongs to the Association of European Research Libraries  
Belongs to German Library Association Indicates if the institution belongs to the German Library Association  
Belongs to Other Indicates if the institution belongs to other organizations  
Total annual amount spent
Total annual amount spent on all materials The total amount spent on all materials  
Total annual amount spent on electronic materials The total amount spent on electronic materials  
Total annual amount spent on physical materials The total amount spent on physical materials  
Student body size
Total undergraduate student body size The total undergraduate student body size  
Total graduate student body size The total graduate student body size  
Institution type The institution type  
Main source of library funding The main source of library funding  
Is my institution Indicates your institution  
Is network institution Indicates a network institution  
Is consortia member institution Indicates a consortia member institution  
Institution Your intuition  

KPI Date

KPI Date
Field Description Additional Information
KPI date Stores the KPI date in the date format 2/29/2012  
KPI month key Stores the month of the date in number format such as 2 for February  
KPI month Stores the month of the date in month description format such as February  
KPI full month Stores the month and the year of the date in a display format such as Feb 12  
KPI quarter Stores the quarter of the date in a display format such as Q1  
KPI year Stores the year of the date in string format such as 2012  
KPI Year-Month The year and the month in a format such as 2023-1  
KPI date Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy.