Skip to Main Content

Alma Analytics Resource Guide

This guide covers how to use the Alma Analytics platform to produce robust reports. Included are instructions on accessing the Oracle-based service as well as how to use its menu driven service to build custom reports.

The Alma Fulfillment dashboard is designed to streamline and optimize the management of fulfillment operations. It provides librarians with an overview of circulation activities, including loans, returns, resource requests, and course reserves. The dashboard facilitates efficient tracking of items across various stages of the fulfillment process, ensuring that library patrons receive their requested materials promptly.

Login to Alma Analytics and go to /shared/Network 01FALSC_NETWORK/Dashboards/ and open Fulfillment.

Fulfillment Dashboard Description

Loans

Loans page has four subpages:

List of Loan Reports

This is a list of links of fulfillment reports created by the Analytics Working Group, an MCLS commissioned working group

Fulfillment by Items:
  • Circulation by Age of Item: Include Item publication date, item acquisition date, number of circulations each year, barcode, call number, title.
  • Circulation by Call Number: Include classification code, number of items, loans, renewals, loans from hold requests, returns, in house loans, lost, claimed returns. Prompts for library, loan dates.
  • Circulation by Item policy & Loans by Item Status: Includes library name, item policy, user group, loans (in house + not in house), prompts for loan date.
  • Circulation by Material Type and Location: Include library, material type, user group, loans, renewals, loans from holds, returns, in house loans, claimed returns, transactions total.
  • Circulation search by item barcode: Include library, material type, barcode, title, loans, renewals, loans from holds, returns, in house loans, claimed returns, transactions total.
  • Items not circulated in number of years: Include library, location, permanent call number, barcode, title, author, item policy, creation date, last loan date, process type.
Fulfillment by Borrower:
  • Cumulative Borrower ID Transactions by Material Type and Collection: Include library name, material type, loans, renewals, loans from hold requests, return, in house loans, claimed returns, total transactions. Prompts for loan date, library name. Prompts for loan date.
  • Circulation by Borrower Status: Include library name, user group, loans, renewals, loans from hold requests, returns, in house loans, claimed returns, total transactions. Prompts for loan date, library name.
  • Circulation by Material Type and Item Status: Includes library, item policy loans, renewals, loans from hold requests, returns, in house loans, claimed returns, total transactions. Prompts for loan date, library name
  • Cumulative Fulfilment Transactions by Collection and Materials Types: Includes library name, location name, number of loans, renewals, loans from hold requests, returns, in house loans, claimed returns, total transactions. Prompts for loan date.

 

 

Course Reserves

This report provides a feature to track and analyze the usage of course reserves, and answers key questions such as:

  • Which courses reserved a specific title?
  • Which courses have common titles on their reading lists?
  • What are the reading lists for each department?

Prompts:

Course Creation Date (Calendar): The date that the course was created. Choose between two dates. The default date first date is 07/01/2021.
Citation Material Type: The citation material type. The default values are Article;Book;Book Chapter;CD;DVD;Document;E-book;Electronic Article;Government Document;Journal;Music;Text Resource;Website
Course Name: The name of the course.
Reading List Name: The name of the reading list.
Citation Number of Loans: The number of times the citation was loaned during the course dates.

Report:

This page contains one report.

Course Reserves Usage Report:

The report shows the following columns

Course Reserves Usage Report
Reading List Name Course Name ISBN Barcode Title Author Combined and Normalized Citation Number of Loans Citation Material Types

 

Overdue Items

This report shows all overdue items.

  • List Patrons with Overdue Items.
  • Regularly run the report to monitor overdue items effectively.

Prompts:

Loan Date: Loan date in the date format MM/DD/YYYY    
Library Name (Active): The library name of active (not deleted) libraries. Location Name: The name of the location of the physical item.
Circ. Desk Name: The name of the circulation desk Loan Material Type: The material type of the loan.
Title Contain: The name or title of a printed or published resource. You may use % as a wild card to search for certain words. Example: %Education%%Florida%    

Report:

This page contains one report:

Overdue Items:

The report shows the following columns

Overdue Items
Library
Name
(Active)
Title Material
Type
Barcode Permanent
Call
Number
User
Primary
Identifier
Patron
Name
Preferred
Email
Loan
Date
Return
Date
Days
Overdue
Process
Status

Lost Items

Alma Analytics reports can track various item statuses when items are marked as "lost.":

  • Items are marked as "lost" in Alma either manually by library staff or automatically according to the library's configured lost item policies.
  • This report helps library staff manage and review lost items, especially for items loaned before a certain date, as these may require manual adjustment of fines.

Prompts:

Loan Date: Loan date in the date format MM/DD/YYYY  
Library Name (Active): The library name of active (not deleted) libraries. Location Name Stores the name of the location of the physical item.

Report:

This page contains one report:

Lost Item:

The report shows the following columns

Yesterday's User Cash Transactions
Library
Name
(Active)
Material
Type
Barcode User
Primary
Identifier
Patron
Name
Preferred
Email
Loan
Date
Due
Date
Return
Date
Days
Overdue
Title Process
Status

Cash Transactions

Cash Transactions page has two subpages:

×

Transactions

Alma Analytics fines and fees transactions report is crucial for libraries to manage financial transactions related to overdue fines and lost item fees. It allows libraries to:

  • Track and report on fines and fees assessed to patrons.
  • Provide detailed records of transactions, which are essential for financial accountability and transparency.
  • Analyze data to make informed decisions about fine policies and their impact on library services.

Prompts:

Owning Library Name (Active): The library name of active (not deleted) libraries Fine Fee Type: Displays the type of the fine or fee such as overdue loan fee or lost loan fee
Transaction Date: Dates of fine and fee transactions  
Fine Fee Creation Date: Displays the date that the fine and fee was created  
User Primary Identifier: Primary identifier that the user uses in order to log on to Alma  

Reports:

This page contains three reports: summary of Active Fines & Fees, a simplified Active Fines & Fees, and the User Cash Transactions.

Active Fines & Fees (simplified):

The report shows the following columns

Active Fines & Fees (simplified) summary
Owning Library Name Fees-lost Fines-overdue Other fines/fees Grand Total

Active Fines & Fees (simplified):

The report shows the following columns

Active Fines & Fees (simplified)
  Remaining fine/fee amount  
Full Name User Primary
Identifier

Fees-
lost

Fines-
overdue

Other
fines/fees
Remaining
fine/fee
amount Total

User Cash Transactions:

The report shows the following columns

User Cash Transactions
User Primary
Identifier
Patron
Name
Owning Library
Name (Active)
Fine
Fee
Status
Transaction
Date
Original
Amount
Transaction
Amount
Fine Fee
Creation
Date
Fine Fee
Type
Fine Fee
Transaction
Type
×

Yesterday's Cash

The cash report generated by Alma Analytics is crucial for tracking daily financial activities and ensuring accuracy in the library's financial records. It allows libraries to:

  • It helps in monitoring the cash flow, identifying discrepancies, and making informed decisions based on the collected financial data.
  • Utilizing the cash report from the previous day can aid in reconciling transactions and preparing for audits.

Prompts:

Owning Library Name (Active): The library name of active (not deleted) libraries Fine Fee Type: Displays the type of the fine or fee such as overdue loan fee or lost loan fee
Transaction Date: Dates of fine and fee transactions  
Fine Fee Creation Date: Displays the date that the fine and fee was created  
User Primary Identifier: Primary identifier that the user uses in order to log on to Alma  

Report:

This page contains one report: Yesterday's User Cash Transactions.

Yesterday's User Cash Transactions:

The report shows the following columns

Yesterday's User Cash Transactions
User Primary
Identifier
Patron
Name
Owning Library
Name (Active)
Fine
Fee
Status
Transaction
Date
Original
Amount
Transaction
Amount
Fine Fee
Creation
Date
Fine Fee
Type
Fine
Fee
Transaction
​​​​​​​Type

 

Analysis

Time Analysis: 

  • By analyzing work elements, time analysis helps improve efficiency. ​

  • ​They are particularly useful for repetitive tasks in library systems, where they can identify inefficiencies and optimize resource allocation.​

Analysis page has three subpages:

×

Monthly

Monthly time analysis: 

  • Providing information on the busiest day of week and hour in certain months. ​

Prompts: the reports use inline prompts not dashboard prompts  

Loans type: Choose between Loans (In house) and Loans (Not in House)
Loan year: Choose from a list of loan years

Reports:

This page contains copies of the same report breakdown by month, so you can compare numbers by changing the inline filters

Loans-time analysis-Annual-Monthly Totals:

This report uses 24-hour clock

Loans-time analysis-Annual-Monthly Totals
Day of week 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Grand
Total

×

Weekly

Weekly time analysis: 

  • Providing information on the busiest day of week and hour. ​

Prompts: the reports use inline prompts not dashboard prompts  

Loans type: Choose between Loans (In house) and Loans (Not in House)
Loan year: Choose from a list of loan years

Reports:

This page contains two copies of the same report, so you can compare numbers by changing the inline filters

Loans Time Analysis:

This report uses 24-hour clock

Loans Time Analysis
Loan Hour 1
Sunday
2
Saturday
3
Monday
4
Tuesday
5
Wednesday
6
Thursday
7
Friday
Grand
Total

 

×

Quarterly

Quarterly time analysis: 

  • Providing information on the busiest day of week and hour in certain quarters of a year. ​

Prompts: the reports use inline prompts not dashboard prompts  

Loans type: Choose between Loans (In house) and Loans (Not in House)
Loan year: Choose from a list of loan years

Reports:

This page one report breakdown by quarter of year, so you can compare numbers by changing the inline filters

Loans-time analysis-Quarter Totals:

This report uses 24-hour clock

Loans-time analysis-Quarter Totals
Loan
Quarter
Loan
Hour
1
Sunday
2
Saturday
3
Monday
4
Tuesday
5
Wednesday
6
Thursday
7
Friday
Grand
Total

 

Troubleshooting and Data Cleaning

Troubleshooting and data cleaning page has two subpages:

Material Types Mismatch

Utilize the Alma Analytics report to identify items in your collection that have been incorrectly categorized by material type:

  • For instance, you may discover equipment erroneously labeled as books, or a study room designated as equipment.
  • Adjust the in-line filters to isolate and correct these mismatches.

 

Prompts: the reports use inline prompts not dashboard prompts  

Physical Item Material Type: Describes the nature of the material represented by the item record.
Loan Material Type: The material type of the loan
Bibliographic Material Type: Fields that Identify the Bibliographic Material Type in MARC LDR or dc:type

Report:

This page contains one report.

Fulfilment material type mismatch - inline Prompts:

Fulfilment material type mismatch - inline Prompts
Institution Name Item Id MMS Id Title Author Combined and Normalized Loans (In House + Not In House)

 

Overdue Items Not Set to Lost

The Alma Analytics report identifies all items overdue for more than a year:

  • Items not marked as 'lost' are highlighted for review.
  • It is recommended to verify the status of these items.
  • If appropriate, update the item status to 'lost'.

Prompts: there are no prompts in this page

Report:

This page contains one report.

More than a year-old overdue item not set to lost:

More than a year-old overdue item not set to lost
Material
Type
Barcode User
Primary
Identifier
Patron
Name
Preferred
Email
Loan
Date
Due
Date
Return
Date
Days
Overdue
Title Process
Status

Library
Name
(Active)