Digital Usage
Using the Digital Usage subject area, you can create reports and dashboards relating to digital usage and answer the following types of business questions:
- How many times was the digital representation viewed?
- How many times was the digital representation shared?
- How many times was the digital representation access denied?
- How many and which of the digital files were downloaded?
- How many and which of the digital files were viewed?

Star Diagram – Digital Usage
Field Descriptions
The following fields are available in Licenses.

Digital Usage – Field Descriptions
Digital Usage Measures
The Digital Usage Measures table is a fact table that stores all measures relating to digital usage, such as number of digital representation views and number of digital file views.
The number of digital representation views may be greater than the number of digital file views if the representation has an access rights policy that requires the patron to acknowledge a copyright statement. If the patron does not accept the copyright statement, it counts as a representation view but not as a file view.
Field | Description | Additional Information |
---|---|---|
Num of digital representation views | The number of digital representation views | |
Num of digital representation shares | The number of digital representation shares | |
Num of digital representation access denied | The number of digital representation access denied | The number of times access to the digital representation has been denied due to the access rights policy blocking the user. |
Num of digital file views | The number of digital file views | In the Universal viewer and the Internet Archive Book Reader Viewer, there is no support for counting the number of files viewed (no event is triggered when moving between files), as there is for the Digital Viewer. |
Num of digital file downloads | The number of digital file downloads |
Digital Usage Details
The Digital Usage Details table is a dimension table that stores additional details about digital usage.
Field | Description | Additional Information |
---|---|---|
Request ID | The request ID | |
Delivery Type | The delivery type of the representation | Possible Values:
|
Representation ID | The representation ID | |
File ID | The file ID | |
Usage level | The usage level | |
Creator | The creator |
Representation Details
The Representation Details table is a dimension table that stores information about digital representations. The Rep Entity fields refer to fields that appear in the Digital Representation Resource Editor when selecting an Entity Type.
Field | Description | Additional Information |
---|---|---|
Rep Creation Date | The date that the representation was created | |
Rep Creator | The creator of the representation | |
Rep Delivery URL | The delivery URL of the representation | |
Rep Deposit ID | The deposit ID of the representation | |
Rep Digitization ID | The digitization ID of the representation | |
Rep Entity Author | The Author value of the representation entity type | |
Rep Entity Creator | The Creator value of the representation entity type | |
Rep Entity Date | The Date value of the representation entity type | |
Rep Entity Day in Month | The Day in Month value of the representation entity type | |
Rep Entity End Page | The End Page value of the representation entity type | |
Rep Entity End Time | The End Time value of the representation entity type | |
Rep Entity Issue | The Issue value of the representation entity type | |
Rep Entity Number | The Number value of the representation entity type | |
Rep Entity Season Month | The Season/Month value of the representation entity type | |
Rep Entity Start Page | The Start Page value of the representation entity type | |
Rep Entity Start Time | The Start Time value of the representation entity type | |
Rep Entity Title | The Title value of the representation entity type | |
Rep Entity Track | The Track value of the representation entity type | |
Rep Entity Type | The entity type of the representation | |
Rep Entity Volume | The Volume value of the representation entity type | |
Rep Entity Year | The Year value of the representation entity type | |
Rep Label | The label of the representation | |
Rep Last View Date | The last date that the representation was viewed | |
Rep Lifecycle | The lifecycle of the representation | |
Rep Link Param 1-5 | The representation link parameters 1-5 | |
Rep Modification Date | The modification date of the representation | |
Rep Modified By | The user who modified the representation | |
Rep Originating System ID | The origination system ID of the representation | |
Rep Public Note | The public note of the representation | |
Rep Remote Code | The remote code of the representation | |
Rep Type Code | The code of the type of the representation | |
Rep Usage Type | The usage type of the representation | |
Is Deposit | Indicates if the representation entered the repository as a deposit | |
Is Digitization | Indicates if the representation entered the repository from a digitization request |
File Details
The File Details table is a dimension table that stores information about the digital file details.
Field | Description | Additional Information |
---|---|---|
File Creation Date | The creation date of the file | |
File Creator | The creator of the file | |
File Deleted Type | The type of the deleted file | |
File Extension | The extension of the file | |
File Internal Path | The internal path of the file | |
File Label | The label of the file | |
File Last View Date | The last date the file was viewed | |
File Lifecycle | The lifecycle of the file | |
File Mime Type | The Mime type of the file | |
File Modification Date | The modification date of the file | |
File Modified By | The user who modified the file | |
File Name | The name of the file | |
File Original ID | The original ID of the file | |
File Original Name | The original name of the file | |
File Original Path | The original path of the file | |
File Size in Bytes | The size of the file in bytes |
Request Date
The Request Date table is a dimension table that stores information about the digital request date. For the purposes of this table, a request is the same as usage.
Field | Description | Additional Information |
---|---|---|
Request Date | Stores the request date in a date format such as 2/29/2014. | |
Request Start of Week | The date of the first business day of the week | |
Request Week Number | The number of the week of the year | |
Request Month Key | Stores the month of the date in number format such as 2 for February | |
Request Month | Stores the month of the date in month description format such as February | |
Request Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Request Quarter | Stores the quarter of the date in a display format such as Q1 | |
Request Year | Stores the year of the date in number format such as 2012 | |
Request Fiscal year | Stores the fiscal year of the date in a string format such as 2012. | |
Request Date Filter (Under Construction) | Used to filter the request date.
The functionality of this field may change in the future, so this field should not be used for saved reports.
|
|
New for August! Request Year-Month |
The year and the month in a format such as 2023-1 |
Bibliographic Details
The Bibliographic Details table is a dimension table that stores the bibliographic details of the digital usage. The primary key of the table is MMS_ID.
The field descriptions can be found in the Bibliographic Details shared dimension.
Dewey Classifications
Books can be classified with Dewey Classifications.
In Dewey Classifications, topics are ordered in a hierarchy that is indicated by a three digit number. The highest level of the hierarchy is indicated by a number with one significant digit followed by two zeros, such as 600. The second level in the hierarchy is indicated by a number with two significant digits followed by one zero, such as 630. The third level in the hierarchy is indicated by a number with three significant digits such as 636.
Note that the Dewey number is taken from the 852 subfield h of the holdings record and not from the 082 of the bibliographic record.
The field descriptions can be found in the Dewey Classifications shared dimension.
LC Classification
Using this dimension, the user can drill down from Group1 to Group4. In each level, the user may see measures accumulated to the relevant group and see the number of items grouped by classification.
The field descriptions can be found in the LC Classifications shared dimension.