Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Leganto Student Usage

    Analytics
    Using the Leganto Student Usage subject area, you can create reports/dashboards relating to Leganto Student Usage and answer the following types of business questions:
    • Are my reading lists effective?
    • How involved are students with the reading list?
    leganto_student_usage_star_diagram.png
    Star Diagram – Leganto Student Usage

    Field Descriptions

    The following fields are available in Leganto Student Usage.
    leganto_student_usage_description3.png
    Leganto Student Usage – Field Descriptions
    Date fields can consist of a partial date, such as just the year or a month and year. Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.

    Student Usage

    The Student Usage table is a fact table that stores all measures relating to student usage, such as the number of active students, the number of reading list views, number of portfolios, and the number of students that viewed a reading list.
    • Counts for unique users are those that contain the word Students. Those that start with Number count total selects.
    • A student is someone without the instructor role.
    • This subject area includes only student and guests views and not library staff usage.
    Student Usage
    Field Description Additional Information
    Active Citations The active citations of the reading list  
    Active Courses The number of courses related to reading lists with any student usage  
    Active Reading Lists The number of reading lists with any student usage  
    Active Sections The active sections of the reading list  
    Active Students The number of students that interacted with the citation in any way, for example, selected, liked, commented, or viewed the material  
    Activity Score The average number of citations interacted with by each student This is calculated according to the following formula:
    [Sum (Active_Students per Active_citation) / (Total_Num_participants X Total citations)] X 100
    For example: A Reading list with 10 citations and 10 total participants
    • Example 1: 5 students did any kind of activity on all the 10 citations -> activity score =50%
      [(5+5+5+5+5+5+5+5+5+5) / (10 X 10) ] X 100
    • Example 2:
      10 students did any kind of activity on 5 citations -> activity score will be = 50%
      [(10+10+10+10+10) / (10 X 10)] X 100
    • Example 3:
      10 students did any kind of activity on 10 citations -> activity score = 100%
      [(10+10+10+10+10+10+10+10+10+10) / (10 X 10)] X 100
    Browser Type The browser type of the student's device  
    Browser Version The browser version of the student's device  
    Citation Library Internal Tags The library internal tags of the citation  
    Citation Origin Where the citation originated. Possible values are:
    • Brief (appears for citations with only metadata details without a link and attachments)
    • CiteIt!
    • Digital (Repository)
    • Digital/Electronic (Repository)
    • Digital/Physical/Electronic (Repository)
    • Electronic (Repository)
    • External URL
    • File
    • Manually Added
    • Mendeley
    • Physical (Repository)
    • Physical/Digital (Repository)
    • Primo Central
    • Refworks
    • Zotero
    • None
    Leganto Annotations The number of annotations  
    LTI Profile Code The LTI profile code  
    LTI Version The version of LTI  
    Number of Citations Views The total number of times users have accessed the full view of a citation  
    Number of Discussions The total number of discussions on all citations  
    Number of Files Downloaded The total number of times files were downloaded (multiple downloads by the same student count multiple times)  
    Number of Full Text Views The total number of times any full text link of any citation was clicked (either from the brief view of the full view of the citation). This includes related records. Multiple accesses by the same student count multiple times.
    Number of Likes The total number of likes on all citations  
    Number of Marked as Done The total number of citations marked "Done" by each student, added together  
    Number of Mobile Activities The total number of activities from mobile devices  
    Number of Non-Mobile Activities The total number of activities from non-mobile devices  
    Number of Reading List Views The total number of reading list views  
    Operating System The operating system of the student's device  
    Student Discussions  The number of unique students that commented  
    Student Type The student type Possible values are:
    • Guest – a user not logged in to Leganto
    • Not Registered – a user not registered for the course
    • Registered
    New for August!
    Students that Added Private Annotations
    The number of students that added private annotations to a reading list  
    New for August!
    Students that Added Public Annotations
    The number of students that added public annotations to a reading list  
    Students that Clicked Like The number of unique students that selected Like  
    Students that Downloaded Files The number of unique students that downloaded files  
    Students that Marked as Done The number of unique students that marked the full text as Done  
    Students that Viewed Citation The number of unique students that viewed the citation This includes guest users.
    Students that Viewed Full Text The number of unique students that viewed the full text This includes related records. 
    Students that Viewed Reading List The number of unique students that viewed the reading list  
    Total Events The total number of events that a user performed who accessed Leganto from both a CMS and by permalinks. The events counted are the following:
    • Number of Citation views
    • Number of Reading List views
    • Number of Full text views
    • Number of file downloaded
    • Number of Discussions
    • Number of Likes
    • Number of Marked as Done
     
    Total Events using LTI The total number of events (likes, selects, comments, and so forth) that a user performed who accessed Leganto from a CMS using a Learning Tools Interoperability (LTI) system.  
    User Role The user role Use this field to filter reports to display just student usage without guest usage, for example.

    Possible values are:

    • Guest – a user not logged in to Leganto
    • Student a user logged in to Leganto

    Event Date

    The Event Date dimension is a dimension table that stores details about the date of events.
    Event Date
    Field Description Additional Information
    Date Stores the date in number format, for example: 2/29/2012  
    Date and Time Stores the date and time in number format, for example: 2/29/2012 12:35 PM  
    Time Stores the time in the format configured by your institution, for example:12:35 PM  
    Week Number The number of the week of the year  
    Start of Week The date of the first business day of the week  
    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
    Month Desc Stores the month of the date in month description format such as February  
    Full Month Desc Stores the month and the year of the date in a display format such as Feb 12  
    Quarter Stores the quarter of the date in a display format such as Q1  
    Year Stores the year of the date in string format such as 2012  
    Fiscal Month Key Stores the fiscal month of the date in number format such as 2 for February  
    Fiscal Year Stores the fiscal year of the date in string format such as 2012.  
    Date Filter Used to filter report results by date  

    Courses

    The Courses table is a dimension table that stores details about the course, including the course name, the course year, and the course creator. The primary key of the table is COURSE_ID.
    When a reading list is associated with multiple courses, all courses associated with the reading list appear in Analytics.
    Courses
    Field Description Additional Information
    Academic Department The academic department of the course  
    Academic Department Description The description of the academic department  
    Campus Name and Participants The campus name and the participants in the course  
    Course Code The code of the course  
    Course Creation Date The date that the course was created  
    Course Creator The creator of the course  
    Course Submit List By The date by which all reading lists for the course should be submitted  
    Course End Date The end date of the course  
    Course ID The ID of the course  
    Course Instructor The name of the course instructor  
    Course Instructor Preferred Email  The preferred email address of the course instructor  
    Course Instructor With Primary Identifier The course instructor with the course instructor's primary identifier This field is useful when a course has more than one instructor. This field enables you to display the instructors together with their identifiers.
    Course Instructor Identifier The primary identifier of the course instructor  
    Course Modification Date The date that the course was modified  
    Course Modified By The person who modified the course  
    Course Name The name of the course  
    Course Section The section of the course  
    Course Start Date The start date of the course  
    Course Status The status of the course  
    Course Term The term of the course  
    Course Year The year of the course  
    Number of Citations The total number of citations  
    Number of Participants The total number of participants in the course  
    Processing Department The processing department of the course  
    Rolled Over from Code The code of the course from which the details of this course are copied  
    Searchable ID 1-10 Searchable ID 1-3 of the course  
    Weekly Hours The weekly hours of the course  

    Reading Lists

    The Reading Lists table is a dimension table that stores details relating to a reading list, including the reading list name, the reading list status, and the reading list creation date. The primary key of the table is READING_LIST_ID.
    Reading Lists
    Field Description Additional Information
    Date Sent For Library Review The date the reading list was sent for library review.  
    Instructors and Collaborators IDs The IDs of the instructors and collaborators.  
    Number of Active Students on the List The number of unique students who engaged with this list in any way (including simply viewing the list and exiting).  
    Number of Citations The total number of citations.  
    Number of Student Suggestions The number of student suggestions for the reading list.  
    Publication List Visibility To whom the reading list is visible. Possible values are:
    • Authenticated Students
    • Enrolled course’s students
    • Open to Everyone
    • Material Open to All Authenticate Students
    Publication Status The publication status of the reading list. Possible values are:
    • Draft
    • Published
    Reading List Associated to a Course Indicates if the reading list is associated to a course (yes/no).  
    Reading List Code The code of the reading list.  
    Reading List Creation Date The date that the reading list was created.  
    Reading List Creator The creator of the reading list.  
    Reading List Deleted Indicates if the reading list was deleted.  
    Reading List Description The description of the reading list.  
    Reading List Due Back Date The due back date of the reading list.  
    Reading List ID The ID of the reading list.  
    Reading List Locked Indicates if the reading list is locked (yes/no).  
    Reading List Modification Date The date that the reading list was modified.  
    Reading List Modified By The person who modified the reading list.  
    Reading List Name The name of the reading list.  
    Reading List Number of Participants The number of participants on the reading list.  
    Reading List Owner The owner of the reading list.  
    Reading List Owner Preferred Email The preferred email of the reading list owner.  
    Reading List Reset Date The date the reading list was reset.  
    Reading List Status The status of the reading list.  
    Reading List Score The score of the reading list.  
    Leganto First Sent for Library Review Date The date that the reading list was first sent for review.  
    Leganto Last Sent for Library Review Date The date that the reading list was last sent for review.  
    Reading List Visible Start Date The start date that the reading list is visible to students.  
    Reading List Visible End Date The end date that the reading list is visible to students.  
    Reading List Sticker Price The total price of the citations with sticker price.  
    Reading List Sticker Price (Covered by Library) The total sticker price of the citations that are covered by the library.  
    Review Requester Name The name of the review requester. Last name, first name format
    Review Requester Name and ID The name of the review requester with the requester's ID. ID, last name, first name format
    Review Requester Preferred Email The preferred email of the review requester.  

    Reading List Section

    The Leganto Reading List Section table is a dimension table that stores details relating to a reading list, including Section Name, Section Order, and Section Creation Date.
    Leganto Reading List Section
    Field Description Additional Information
    Section Creation Date The creation date of the section  
    Section Creator The creator of the section  
    Section Description The description of the section  
    Section End Date The end date of the section  
    Section ID The ID of the section  
    Section Library Internal Tags The internal library tags of the section  
    Section Locked Indicates if the section is locked  
    Section Modification Date The modification date of the section  
    Section Modified By Who modified the section last  
    Section Name The name of the section  
    Section Number of Citations The number of citations for the section  
    Section Order A number indicating the place of the citation in order  
    Section Start Date The start date of the section  

    Citations

    The Reading List Citation table is a fact table that stores the measure relating to number of citations. This table also holds details about the citation, including citation creator, citation status, and citation type. The primary key of the table is CITATION ID.
    Citations
    Field Description Additional Information
    Citation Alma Digital Downloads The the number of digital citation downloads during an active course  
    Citation Alma Digital Views The number of digital citation views during an active course  
    Citation Attribute (1-5) The citation attribute.  
    Citation Copyright Status The citation copyright status.  
    Citation Covered by Library Indicates if the citation has availability in the library

    Value is Yes if the citation has an MMS ID (which means it is a repository citation) or if Link & Availability has a URL (using the Alma link resolver).

    Citation Creation Date The creation date of the citation  
    Citation Creator The creator of the citation  
    Citation Due Date The due date of the citation  
    Citation File Size (KB) The size of the citation file  
    Citation Has Assignment Indicates if the citation has an assigment  
    Citation Has Public Note Indicates if the citation has a public note  
    Citation ID The ID of the citation  
    Citation Library External Tags The library external tags of the citation  
    Citation Library Internal Tags The library internal tags of the citation  
    Citation Library Tags Indicates if the citation has library tags   
    Citation License Type The license type of the citation  
    Citation Locate Status The locate status of the citation  
    Citation Material Type The material type of the citation  
    Citation Material Type Code The material type code of the citation  
    Citation Material Visibility End Date The visibility end date of the citation material  
    Citation Material Visibility Start Date The visibility start date of the citation material  
    Citation Modification Date The modification date of the citation  
    Citation Modified By The user who modified the citation  
    Citation Number of Loans The number of times the citation was loaned during the course dates  
    Citation Order A number indicating the place of the citation in order  
    Citation Public Note The public note of the citation  
    Citation Public Tags The public tags of the citation  
    Citation Resolving Disabled Indicates if the resolving feature is disabled  
    Citation Source The source URL of the citation  
    Citation Status The status of the citation  
    Citation Sticker Price The total price of the citations with sticker price  
    Citation Thumbnail File Size (KB) The size of the citation thumbnail file  
    Citation Type The citation type Possible values are:
    • Physical book
    • Physical article
    • Electronic book
    • Electronic article
    Citation Uploaded File Indicates if the citation has an uploaded file  
    Citation Visibility End Date The visibility end date of the citation  
    Citation Visibility Start Date The visibility start date of the citation  
    Course End Date The end date of the course  
    Course Start Date The start date of the course  
    Is Digital Citation Indicates if the citation is a digital resource  
    Is Repository Citation Indicates if the citation is linked to the repository Possible values are:
    • Yes
    • No
    Num of Assignments The number of assignments that are linked to a citation  
    Num of Private Annotations the number of private annotations of the citation  
    Num of Public Annotations the number of public annotations of the citation  

    Citation Metadata Details

    The Citation Metadata Details table is a dimension table that stores the citation metadata details of the course reserves.
    Citation Metadata Details
    Field Description Additional Information
    Additional Person Name The additional person name  
    Article End Page The end page of the article  
    Article Number of Pages The number of pages in the article  
    Article Start Page The start page of the article  
    Author The author of the article  
    Book Call Number The call number of the book  
    Book Chapter Author The author of the book chapter  
    Book Chapter Editor The editor of the book chapter  
    Book Chapter Number The chapter number of the book  
    Book Chapter Title The title of the book chapter  
    Book Edition The edition of the book  
    Barcode The barcode of the book  
    DOI The digital object identifier  
    ISBN The ISBN of the book  
    ISSN The ISSN of the journal  
    Issue The issue of the journal  
    Journal Title The title of the journal  
    Note The note on the citation  
    OCLC Number The OCLC number  
    Pages The pages of the citation  
    Part The part of the book  
    Publication Date The date of publication  
    Publication Place The place of publication  
    Publisher The publisher of the book  
    Title The title of the citation  
    Volume The volume of the citation  

    Student Details

    The Student Details table is a dimension table that stores information concerning student details. It contains information only when the relevant parameter in Leganto is set to true to enable exposing student information.

    Field Description Additional information
    User ID Stores the unique ID of the user  
    Primary identifier Stores the primary identifier that the user uses in order to log on to Alma See the field location in Alma in the image below.
    User Title The title of the user  
    User Type Stores the values Internal and External.
    • Internal - An internal user is one whose core user details are managed within the system such as user name, password, contact information, and so forth.
    • External - An external user is one whose core user details are managed by a student information system.
    See the field location in Alma in the image below.
    User Group Stores the group with which the user is associated such as Faculty, Graduate, or Student See the field location in Alma in the image below.
    User Record Type Indicates if the user is a Public User or a Staff User See the field location in Alma in the image below.
    First Name Stores the user’s first name See the field location in Alma in the image below.
    Full Name The user's first and last name There is no option to include the middle name.
    Last Name Stores the user’s last name See the field location in Alma in the image below.
    Middle Name Stores the middle name of the user See the field location in Alma in the image below.
    Preferred First Name Stores the user’s preferred first name See the field location in Alma in the image below.
    Preferred Last Name Stores the user’s preferred last name See the field location in Alma in the image below.
    Preferred Middle Name Stores the user's preferred middle name See the field location in Alma in the image below.
    Job Description Stores free-form text that describes the function of the user in the library See the field location in Alma in the image below.
    Job Title Stores the job category definition to which the user belongs based on the Job Categories code table See the field location in Alma in the image below.
    Gender Possible values are taken from the Genders code table (Configuration > User Management > User Details > Genders) See the field location in Alma in the image below.
    Birth Date Stores the birth date of the user See the field location in Alma in the image below.
    Campus Code Stores the campus code of the user See the field location in Alma in the image below.
    Status Date Stores the date on which the patron was registered in the institution See the field location in Alma in the image below.
    Status Indicates if the user is active See the field location in Alma in the image below.
    Creation Date Stores the date that the user was created in the system See the field location in Alma in the image below.
    Last Activity Date The last date that a patron made a request or borrowed or returned an item  
    Modified By Stores the name of the user that modified the user record See the field location in Alma in the image below.
    Modification Date Stores the date of the modification of the user record See the field location in Alma in the image below.
    Expiry Date Stores the date on which the user is to expire and no longer be able to get service from the system See the field location in Alma in the image below.
    Changing the user expiry date is one way to control item due dates that extend beyond the end of a semester and must be shortened to the end of the semester. For more information, see How to Make Items Have Due Dates at the End of the Semester.
    Locked Out Date Indicates the date on which the user is locked out. A user is locked out if he tries to access the Alma system several times with incorrect credentials.  
    Purge Date Stores the date on which the user record is to be deleted from Alma See the field location in Alma in the image below.
    Default Language Stores the default language of the user See the field location in Alma in the image below.
    Failed Authentication Stores the number of times that the user tried to access Alma with an incorrect password  
    Creator Stores the user name of the user that created the user in the system See the field location in Alma in the image below.
    External ID Stores the ID of the user in the originating system  
    Identifier 1 Stores identifier 1. The identifier field allows you to enrich the user details exported to Analytics with additional identifiers. Selecting a specific identifier to be included in the user details is done in Alma (in a table that is currently restricted to Ex Libris staff). For assistance in defining this field, contact Ex Libris Support.
    Only one value per identifier is supported.
    Identifier 2 Stores identifier 2. See details for the Identifier 1 field above.  
    IdP Service in Use Indicates if an identity provider service is in use  
    Statistical Categories 1-5 These fields allow you to map five statistical categories. This allows you to filter reports based on advanced user information typically stored in the statistical category fields. For more information, see Configuring Statistical Categories for Analytics.  
    Resource Sharing Library Code The code of the resource sharing library assigned to the user.  
    Resource Sharing Library The resource sharing library assigned to the user.  
    Cataloger Level The cataloger level of the user  
    Has Role Other Than Patron indicates if the patron has a role other than Patron  
    Has Role Other Than Patron and Instructor  Indicates if the patron has a role other than Patron and Instructor  
    Is Blocked Indicates if the patron is blocked  
    Patron Letters Opt In The letters for which the patron has opted in  
    Patron Letters Opt Out The letters for which the patron has opted out  
    User – Linked From Other Institution Indicates if the user is linked from another institution Possible values:
    • yes
    • no
    User – Linked From Institution Code The code of the institution from which the user is linked  
    User – Linked From Institution Name The name of the institution from which the user is linked  
    Linked To Other Institution Indicates if the user is linked to another institution  
    User Group Code The user group code  
    users_report1.png
    users_report2.png
    user_details_page_new.png

    Institution

    The shared Institution dimension allows the Network Zone to view reports according to institution. It is available in every subject area. It contains the following fields:
    Institution
    Field Description Additional information
    Institution Code The code of the institution.  
    Institution Name The name of the institution.  
    Institution Timezone The timezone of the institution  
    Data Available As Of When the data became available to analytics  
    Data Updated As Of When the data was taken from Alma  
    If an analytics report is run from the Network Zone 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.