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 institution must be live for at least one year.
- You must select Yes in Data Sharing Profile.
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?
Field Descriptions
The following fields are available in Benchmark:
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
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | |
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| Monthly | ||||
| Number of bibliographic records in repository added (by month). | The number of bibliographic records added to the repository per month. | DOUBLE | ||
| Number of physical items in repository added (by month). | The number of physical items added to the repository per month. | DOUBLE | ||
| Number of electronic portfolios in repository added (by month). | The number of electronic portfolios added to the repository per month. | DOUBLE | ||
| Number of electronic collections in repository added (by month). | The number of electronic collections added to the repository per month. | DOUBLE | ||
Acquisition KPIs - POLs
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Num of PO Lines created (by month). | The number of PO lines created per month. | DOUBLE | ||
| Num of PO Lines created (last 365 days). | The number of PO lines created in the last 365 days. | DOUBLE | ||
| % of PO Lines originating from a purchase request. | The percentage of PO lines that originate from a purchase request. | DOUBLE | ||
| % of PO Lines originating from an API. | The percentage of PO lines that originate from an API. | DOUBLE | ||
| % 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. | DOUBLE | ||
| % of PO Lines originating from manual entry. | The percentage of PO lines that originate from a manual entry. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| Electronic Portfolio - 95% days from POL sent to portfolio activation. | The number of days by which 95% of the sent portfolios were activated. | DOUBLE | ||
| Electronic Portfolio - 95% days from POL creation to sent. | The number of days by which 95% of the created PO lines were sent. | DOUBLE | ||
| Electronic Portfolio - 95% days from POL creation to portfolio activation. | The number of days by which 95% of the created PO lines were activated. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE | ||
| 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. | DOUBLE |
Fulfillment KPIs - Requests
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Number of patron physical item requests created (by month). | The number of patron physical item requests created per month. | DOUBLE | ||
| Number of booking requests created (by month). | The number of booking requests created per month. | DOUBLE | ||
| Number of digitization requests created (by month). | The number of digitization requests created per month. | DOUBLE | ||
| Number of patron physical item requests rejected (by month). | The number of patron physical item requests rejected per month. | DOUBLE | ||
| Number of patron physical item requests rejected by library (by month). | The number of patron physical item requests rejected by a library per month. | DOUBLE | ||
| 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. | DOUBLE | ||
| Number of physical item requests that involved transits (by month). | The number of physical item requests that involved transits per month. | DOUBLE | ||
| 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) | DOUBLE | ||
| 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) | DOUBLE | ||
| 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) | DOUBLE |
Fulfillment KPIs - Loans
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Number of loans (In House+ Not In House) (by month). | The number of loans including in house and not in house loans per month. | DOUBLE | ||
| Number of loans (In House) (by month). | The number of in house loans per month. | DOUBLE | ||
| Number of loans (Not In House) (by month). | The number of not in house loans per month. | DOUBLE | ||
| Number of returns (In House+ Not In House) (by month). | The number of returns including in house and not in house loans per month. | DOUBLE | ||
| Number of returns (In House) (by month). | The number of in house returns per month. | DOUBLE | ||
| Number of returns (Not In House) (by month). | The number of not in house returns per month. | DOUBLE | ||
| Number of late returns (Not In House) (by month). | The number of not in house late returns per month. | DOUBLE | ||
| Number of on time returns (Not In House) (by month). | The number of not in house on time returns per month. | DOUBLE | ||
| % of late returns (by month). | The percent of late returns per month. | DOUBLE | ||
| % of on time returns (by month). | The percent of on time returns per month. | DOUBLE | ||
| 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. | DOUBLE | ||
| Number of returns at owning library (Not In House) (by month). | The number of not in house returns at an owning library per month. | DOUBLE | ||
| % of returns at non-owning library (by month). | The percent of returns at a non-owning library per month. | DOUBLE | ||
| % of returns at owning library (by month). | The percent of returns at an owning library per month. | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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. | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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.) | DOUBLE | ||
| 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. | DOUBLE |
Resource Sharing KPIs - Borrowing Requests
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Number of borrowing requests created (by month) | The number of borrowing requests created by month | DOUBLE | ||
| Number of borrowing requests fulfilled (by month) | The number of borrowing requests fulfilled by month | DOUBLE | ||
| Number of borrowing requests rejected by all partners (by month) | The number of borrowing requests rejected by all partners by month | DOUBLE | ||
| % of borrowing requests rejected by all partners (by month) | The % of borrowing requests rejected by all partners by month | DOUBLE | ||
| Number of partner rejections of borrowing requests (by month) | The number of partner rejections of borrowing requests by month | DOUBLE | ||
| Number of consulted partners (last 365 days) | The number of consulted partners for the last 365 days | DOUBLE | ||
| Number of partners in rota (last 365 days) | The number of partners in rota for the last 365 days | DOUBLE | ||
| Average supply time for borrowing requests (last 365 days) | The average supply time for borrowing requests for the last 365 days | DOUBLE | ||
| Median supply time for borrowing requests (last 365 days) | The median supply time for borrowing requests for the last 365 days | DOUBLE | ||
| 95% supply time for borrowing requests (last 365 days) | The 95% supply time for borrowing requests for the last 365 days | DOUBLE |
Resource Sharing KPIs - Lending Requests
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Number of lending requests created (by month) | The number of lending requests created by month | DOUBLE | ||
| Number of fulfilled lending requests (by month) | The number of fulfilled lending requests by month | DOUBLE | ||
| Number of non-fulfilled lending requests (by month) | The number of non-fulfilled lending requests by month | DOUBLE | ||
| % of lending requests created which were not fulfilled (by month) | The % of lending requests created which were not fulfilled by month | DOUBLE | ||
| 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 | DOUBLE | ||
| Median supply time for lending requests (last 365 days) | The median supply time for lending requests for the last 365 days | DOUBLE | ||
| 95% supply time for lending requests (last 365 days) | The 95% supply time for lending requests for the last 365 days | DOUBLE |
Usage KPIs - COUNTER Reports
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| 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. | DOUBLE | |
| JR1a Journal Archive usage | DOUBLE | |||
| 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. | DOUBLE | |
| BR2 Section Requests | DOUBLE | |||
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| 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. | DOUBLE | |
| Number of unique JR1 COUNTER reports loaded | The number of unique JR1 COUNTER reports loaded | DOUBLE | ||
| Number of unique JR1a COUNTER reports loaded | The number of unique JR1a COUNTER reports loaded | DOUBLE | ||
| Number of unique BR1 COUNTER reports loaded | The number of unique BR1 COUNTER reports loaded | DOUBLE | ||
| Number of unique BR2 COUNTER reports loaded | The number of unique BR2 COUNTER reports loaded | DOUBLE | ||
| Number of unique DB1 COUNTER reports loaded | The number of unique DB1 COUNTER reports loaded | DOUBLE | ||
| Number of unique PR1 COUNTER reports loaded | The number of unique PR1 COUNTER reports loaded | DOUBLE |
Institution Profile
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Primary areas of study that the institution serves | ||||
| Serves Humanities | Indicates if the institution serves humanities | VARCHAR | 10 | |
| Serves Social Sciences | Indicates if the institution serves social sciences | VARCHAR | 10 | |
| Serves Sciences | Indicates if the institution serves sciences | VARCHAR | 10 | |
| Serves Engineering | Indicates if the institution serves engineering | VARCHAR | 10 | |
| Serves Multidisciplinary | Indicates if the institution serves multidisciplinary areas | VARCHAR | 10 | |
| Serves Other | Indicates if the institution serves other areas | VARCHAR | 1024 | |
| Professional graduate schools of the institution | ||||
| Has Medical School | Indicates if the institution has a medical school | VARCHAR | 10 | |
| Has Dental School | Indicates if the institution has a dental school | VARCHAR | 10 | |
| Has Public Health School | Indicates if the institution has a public health school | VARCHAR | 10 | |
| Has Business School | Indicates if the institution has a business school | VARCHAR | 10 | |
| Has Law School | Indicates if the institution has a law school | VARCHAR | 10 | |
| Has Other School | Indicates if the institution has other graduate schools | VARCHAR | 1024 | |
| Organizations to which the institution belongs | ||||
| Belongs to American Library Association (ALA) | Indicates if the institution belongs to the American Library Association (ALA) | VARCHAR | 10 | |
| Belongs to American Association of Law Libraries (AALL) | Indicates if the institution belongs to the American Association of Law Libraries (AALL) | VARCHAR | 10 | |
| Belongs to Association of Research Libraries (ARL) | Indicates if the institution belongs to the Association of Research Libraries (ARL) | VARCHAR | 10 | |
| Belongs to Association of College and Research Libraries (ACRL) | Indicates if the institution belongs to the Association of College and Research Libraries (ACRL) | VARCHAR | 10 | |
| Belongs to Canadian Library Association | Indicates if the institution belongs to the Canadian Library Association | VARCHAR | 10 | |
| Belongs to Canadian Association of Law Libraries | Indicates if the institution belongs to the Canadian Association of Law Libraries | VARCHAR | 10 | |
| Belongs to Australian Library and Information Association | Indicates if the institution belongs to the Australian Library and Information Association | VARCHAR | 10 | |
| Belongs to Library and Information Association of New Zealand | Indicates if the institution belongs to the Library and Information Association of New Zealand | VARCHAR | 10 | |
| Belongs to Association of European Research Libraries | Indicates if the institution belongs to the Association of European Research Libraries | VARCHAR | 10 | |
| Belongs to German Library Association | Indicates if the institution belongs to the German Library Association | VARCHAR | 10 | |
| Belongs to Other | Indicates if the institution belongs to other organizations | VARCHAR | 1024 | |
| Total annual amount spent | ||||
| Total annual amount spent on all materials | The total amount spent on all materials | VARCHAR | 4000 | |
| Total annual amount spent on electronic materials | The total amount spent on electronic materials | VARCHAR | 4000 | |
| Total annual amount spent on physical materials | The total amount spent on physical materials | VARCHAR | 4000 | |
| Display Order - All Materials | INT | |||
| Display Order - Electronic | INT | |||
| Display Order - Physical | INT | |||
| Student body size | ||||
| Total undergraduate student body size | The total undergraduate student body size | VARCHAR | 4000 | |
| Total graduate student body size | The total graduate student body size | VARCHAR | 4000 | |
| Display Order - Total undergraduate student body size | ||||
| Display Order - Total graduate student body size | ||||
| Institution type | The institution type | VARCHAR | 4000 | |
| Main source of library funding | The main source of library funding | VARCHAR | 4000 | |
| Is Network Institution | Indicates your institution | VARCHAR | 10 | |
| Is consortia member institution | Indicates a consortia member institution | VARCHAR | 10 | |
| Is my Institution | DOUBLE | |||
| Institution | Your intuition | DOUBLE | ||
KPI Date
| Field | Description | Additional Information | Data Size | Data Size |
|---|---|---|---|---|
| KPI Date | Stores the KPI date in the date format 2/29/2012 | DATE | ||
| KPI Month Key | Stores the month of the date in number format such as 2 for February | INT | ||
| KPI Month | Stores the month of the date in month description format such as February | VARCHAR | 20 | |
| KPI Full Month | Stores the month and the year of the date in a display format such as Feb 12 | VARCHAR | 20 | |
| KPI Quarter | Stores the quarter of the date in a display format such as Q1 | VARCHAR | 20 | |
| KPI Year | Stores the year of the date in string format such as 2012 | VARCHAR | 250 | |
| KPI Year - Month Key | DOUBLE | |||
| KPI Year-Month | The year and the month in a format such as 2023-1 | VARCHAR | 250 | |
| 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. |
Page tags: article:topicproduct:almacontent:Documentationlang:englishInventory KPIsAcquisition KPIs - POLsFulfillment KPIs - RequestsFulfillment KPIs - LoansInstitution ProfileKPI Date
