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?
    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.
    Student Usage
    Field Description Additional Information
    Active Students The number of students that interacted with the citation in some method: selected, liked, commented, 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
    Number of Reading List Views The total number of reading list views  
    Number of Citations Views The total number of citation views  
    Number of Full Text Views The total number of times the full text of any citation was accessed (multiple accesses by the same student count multiple times)  
    Number of Files Downloaded The total number of times files were downloaded (multiple downloads by the same student count multiple times)  
    Number of Discussions The total number of discussions on all citations  
    Number of Likes The total number of likes on all citations  
    Number of Read It The total number of citations marked "read it" 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  
    Students that Viewed Reading List The number of unique students that viewed the reading list  
    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  
    Students that Downloaded Files The number of unique students that downloaded files  
    Students that Commented The number of unique students that commented  
    Students that Clicked Like The number of unique students that selected Like  
    Students that Read It The number of unique students that read the full text  
    Total Events The total number of events (likes, selects, comments, and so forth) that a user performed who accessed Leganto from both a CMS and by permalinks.  
    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.  
    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 Citations The active citations of the reading list  
    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
    Operating System The operating system of the student's device  
    Browser Type The browser type of the student's device  
    Browser Version The browser version of the student's device  
    LTI Profile Code The LTI profile code  
    Citation Library Internal Tags The library internal tags of the citation  
    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

    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 the format 2/29/2012  
    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 Create Date The date that the course was created  
    Course Creator The creator of the course  
    Course End Date The end date of the course  
    Course Hours The hours of the course  
    Course ID The ID of the course  
    Course Instructor The name of the course instructor  
    Course Instructor and ID The course instructor with the course instructor's identifier This field  is useful when a course has more than one instructor. This field allows 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-3 Searchable ID 1-3 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 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 Create 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 Owner The owner of the reading list  
    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  
    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  

    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 Create 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 teh section  
    Section Library Internal Tags The internal library tags of the section  
    New for November
    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 Attribute (1-5) The citation attribute.  
    Citation Copyright Status The citation copyright status.  
    Citation Create Date The creation date of the citation  
    Citation Creator The creator of the citation  
    Citation Due Date The due date of the citation  
    New for November
    Citation File Size (KB)
    The size of the citation file  
    Citation Has Public Note Indicates if the citation has a public note  
    Citation ID The ID 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 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 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 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  
    New for November
    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 Repository Citation Indicates if the citation is linked to the repository Possible values are:
    • Yes
    • No
    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 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
    Article End Page The end page of 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.
    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: male, female, none, other 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 university 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. Choosing 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 in "identifier 1" 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.  
    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.