Using the Usage Data area, the Design Analytics user may create reports/dashboards for the Usage Data area and is able to answer the following types of business questions:
- Most frequently used journals
- Annual journal usage trend.
- Total and monthly number of successful requests per each journal
- Database Usage - Annual Trend
- Most Frequently Used Databases
- Total number of searches and sessions per each database and the monthly/yearly search statistics
UStat data is included in your Alma Analytics reports only if UStat is used by your institution and you load relevant, institution-specific vendor data to UStat. For details on how to use UStat, see the UStat User's Guide.
Star Diagram – Usage Data
The following lists the fields available in Usage Data.
Usage Data – Field Descriptions
Usage Data Details
The Usage Data Details table is a fact table that stores all measures relating to specific Title/platform/publisher/subscriber. The primary key is ID.
The data contained in the Usage Data subject area originates from the COUNTER reports loaded by the Alma institution.
|Title Identifier Counter||The number of unique title identifiers|
|Usage Measures Total||The sum total of all of the other measures for the particular query.|
|BR1 - Book Success Title Requests (Total)||Displays the total number of successful title requests by month and title for the Book Report 1 (BR1) material type.|
New for May!BR1 – Book Success Title Requests (html)
|Displays the number of successful title requests in HTML format by month and title for the Book Report 1 (BR1) material type.|
New for May!BR1 – Book Success Title Requests (pdf)
|Displays the number of successful title requests in PDF format by month and title for the Book Report 1 (BR1) material type.|
|BR2 - Book Success Section Requests (Total)||Displays the total number of successful section requests by month and title for the Book Report 2 (BR2) material type.|
New for May!BR2 – Book Success Title Requests (html)
|Displays the number of successful title requests in HTML format by month and title for the Book Report 2 (BR2) material type.|
New for May!BR2 – Book Success Title Requests (pdf)
|Displays the number of successful title requests in PDF format by month and title for the Book Report 2 (BR2) material type.|
New for May!BR3 – Title Access Denied (license limit exceeded)
|Displays the number of title requests denied because the license limit exceeded for the Book Report 3 (BR3) material type.|
New for May!BR3 – Title Access Denied (item not licensed)
|Displays the number of title requests denied because the item was not licensed for the Book Report 3 (BR3) material type.|
|DB1 - DB Federated Searches||The number of DB federated searches.||Federated search is an information retrieval technology that allows the simultaneous search of multiple searchable resources. A user makes a single query request that is distributed to the search engines participating in the federation. The federated search then aggregates the results that are received from the search engines for presentation to the user.|
|DB1 - DB Federated Sessions||The number of DB Federated sessions|
|DB1 - DB Records Views||A successful request for a database record that has originated from a set of search results, from browsing the database, or from a click on another database record.|
|DB1 - DB Result Clicks||A click originating from a set of search results.|
|DB1 - DB Searches||The number of successful database searches|
|DB1 - DB Sessions||The number of DB sessions. DB session is the period of activity between a user logging in to database and logging out of a (multi-user) system.|
|JR1 - Journal Usage Counter||The Number of successful full text article requests by Month and Journal report.|
|JR1a - Journal Usage Counter Archive||Number of Successful Full-Text Article Requests from an Archive by Month and Journal|
New for May!JR1 GOA – Journal Usage Counter Gold Open Access (Total)
|Number of Successful Gold Open Access Full-Text Article Requests by Month and Journal|
New for May!JR1 GOA – Journal Usage Counter Gold Open Access (html)
|Number of Successful Gold Open Access Full-Text Article Requests by Month and Journal in HTML format|
New for May!JR1 GOA – Journal Usage Counter Gold Open Access (pdf)
|Number of Successful Gold Open Access Full-Text Article Requests by Month and Journal in PDF format|
|PR1 - Platform Federated Searches||The number of platform federated searches.|
|PR1 - Platform Regular Searches||The number of platform regular searches.|
|PR1 - Platform Records Views||Total Searches, Result Clicks, and Record Views by Month and Platform|
|PR1 - Platform Result Clicks||The number of platform result clicks|
|Load File ID||Unique ID of the file loaded into USTAT|
|Material Type Indicator||Indicate if the usage is DB usage, Journal usage, Book Report 1 usage, or Book Report 2 usage|
The Usage Date table is a dimension table that stores details about the Title usage date. Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:
- Calendar Fields – These are date fields as they display in the calendar.
- Fiscal Date Fields – These are date fields that match the institution's fiscal period. In the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.
Using this dimension, the user can drill down from year to month. The usage is accumulated to the relevant level in the hierarchy.
The fields are the same as Loan Date:
|Loan Date||Stores the loan date in the date format 2/29/2012|
|Loan Month Key||Stores the month of the date in number format such as 2 for February||This field is useful when you want to sort by month|
|Loan Month||Stores the month of the date in month description format such as February|
|Loan Full Month||Stores the month and the year of the date in a display format such as Feb 12|
|Loan Quarter||Stores the quarter of the date in a display format such as Q1|
|Loan Year||Stores the year of the date in string format such as 2012|
|Loan Fiscal Year||Stores the fiscal year of the date in string format such as 2012.|
|Loan Time||Stores the time in the hours:minutes:seconds format for the loan date|
|Loan 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.|
The Title Identifier table is a dimension table that stores the details about the title identifier. The primary key of the table is TITLE_IDENTIFIER.
|Title Identifier||The unique identifier of the title|
|Origin Title||The original title of the Journal/Database|
|Display Title||The title in display format|
|Display Title 20 Chars||Holds 20 characters from the title|
|Normalized Title||The normalized title - small letters with underline between the words|
|Origin EISSN||The Original EISSN (with dash)|
|Normalized EISSN||The normalized EISSN without dash|
|Origin ISSN||The original ISSN (with dash)|
|Normalized ISSN||The normalized ISSN without dash|
|Origin ISBN||The original ISBN (with dash)|
|Normalized ISBN||The normalized ISBN without dash|
The Platform table is a dimension table that stores details about the platform. The primary key of the table is PLATFORM.
|Platform||The vendor or content provider. An interface from an aggregator, host, publisher, or service that delivers the content to the user and that counts and provides the COUNTER usage reports.|
|Normalized Platform||The normalized platform name|
The Publisher table is a dimension table that stores details about the publisher. The primary key of the table is PUBLISHER.
|Publisher||An organization, whose function is to commission, creates, collect, validate, host, distribute and trade information online and/or in printed form.|
|Normalized Publisher||The normalized publisher name|
The Subscriber table is a dimension table that stores details about the subscriber. The primary key of the table is SUBSCRIBER_ID.
|Subscriber ID||The unique ID of the subscriber|
|Subscriber||The library or instance. An individual or organization that pays a vendor for access to a specified range of the vendors services and/or content and is subject to terms and conditions agreed to with the vendor.|
|Normalized Subscriber||The normalized subscriber name|
The shared Institution dimension allows the network institution to view reports according to institution. It is available in every subject area. It contains the following fields:
|Institution Code||The code of the institution.|
|Institution Name||The name of the institution.|
If an analytics report is run from a member institution in a collaborative network implementing a Network Zone, all member institutions are included in the report for Institution Code and Institution Name.
If an analytics report is run from an institution that is not part of a collaborative network implementing a Network Zone, only the single institution from which the report is run is included in the report for Institution Code and Institution Name.
Reports involving data across a collaborative network implementing a Network Zone may take longer to run than reports within one institution.
Shared Dimensions with Other Subject Areas