Sets the Overview tab's KPI cards directly, and also sets the year used by CHED, ISO, AACCUP, Trends, Room Use, and Staff Transactions (from the period's end date).
📚Collection Health
📤Circulation Activity — Year 2026
📊Efficiency & Engagement Ratios
🔖Holds & Reservations
💰Fines & Revenue
👥Patron Engagement & Impact — Year 2026
📊Demographics & Distribution
Patrons by Gender
Top Patron Types
📅Peak Use — Days & Times (All-Time)
Which days and time periods see the most library use (checkouts + in-library visits). Use this to plan staffing and opening hours.
⏱Average Loan Duration by Patron Type
How long current checkouts have been out vs. the scheduled loan period — based on items currently checked out.
😴Lapsed Patrons
Patrons who borrowed last year but not this year — prime targets for re-engagement outreach.
💰Fine Revenue by Patron Type (This Year)
Which patron groups generate the most fines — useful for policy review and targeted reminders.
🪑In-Library (Room) Use
Items read inside the library without checkout. Recorded by staff via Circulation → Check In with "Record in-library use" checked before re-shelving.
👤Staff Transactions
Destiny Audit transactions performed by staff user IDs 572608, 963453, and 882550, totaled by month for 2026.
🏥Collection Health KPIs
📊Collection Composition
By Dewey Decimal Category
Subject distribution of the collection
By Sublocation / Section
Physical placement within the library
📈Collection Currency & Growth
💰Funding & Publisher Analysis
🕰Average Collection Age by Dewey Range
Which subject areas have the oldest collections — helps prioritize acquisition budgets for outdated sections.
📦Items Never Used
Titles/items with no checkout AND no in-library use — signals poor acquisitions or poor discoverability. Items with room-use-only activity are counted separately.
🌿Weeding Candidates (No Use in 3+ Years)
Items with no checkout and no in-library (room) use for 3+ years — safe candidates for withdrawal. Books with recent room use are automatically excluded even if never checked out.
📐Circulation & Use Indicators — ISO 2789 / 11620 / 16439
📚Collection & Resource Indicators — ISO 2789 / ALA ACRL
🎓Educational Support Indicators — ISO 21001:2018
💸Financial & Management Metrics — IFLA / ISO 11620
Require financial ledger data. ILS provides the denominator for Cost per User — enter budget figures in the manual section below.
| Metric | ILS Denominator |
|---|---|
| Cost per Active User | Enter in manual section ↓ |
| Cost per Loan | Enter in manual section ↓ |
| Cost per Resource Download | Enter in manual section ↓ |
| Library Budget as % of Institution Budget | Enter in manual section ↓ |
| Staff Costs as % of Operating Expenditures | Enter in manual section ↓ |
| % Electronic Expenditures | Enter in manual section ↓ |
📋Survey-based & Operational Metrics — IFLA / ISO 11620 / ALA
Require surveys, logs, or HR records. Enter actual values in the manual section below.
| Metric | Data Source |
|---|---|
| User Satisfaction Index | User satisfaction survey (annual) |
| Title / Subject Availability Rate | Shelf-availability / user sampling study |
| Facilities Satisfaction Rate | Facility satisfaction survey |
| Correct Answer Rate (Reference) | Reference audit / mystery shopping |
| Library Visits per Capita | Physical gate counter + census/enrollment data |
| Workstation / Wi-Fi Downtime Rate | IT syslog / helpdesk ticket system |
| Speed of Document Delivery / ILL | ILL logbook or delivery tracking |
| Median Acquisitions Processing Time | Acquisitions & cataloging logbook |
| Cataloging Accuracy Rate | Peer cataloging audit |
| Staff Training Hours per FTE | HR / training attendance records |
| % Staff with IT / Data Certifications | HR credentials database |
| ALA — Knowledge Acquisition Rate | Post-program ALA Project Outcome survey |
| ALA — Confidence Building Rate | Post-program ALA Project Outcome survey |
| ALA — Behavioral Change Intention Rate | Post-program ALA Project Outcome survey |
| ALA — Resource Awareness Rate | Post-program ALA Project Outcome survey |
Covers sections A (Administration) through G (Linkages). Enter values for each indicator using the fields below. Items marked ✓ Compliant / ✗ Non-compliant have defined thresholds per the AACCUP instrument. Unlock editing with the dashboard password.
Enter the dashboard password to record or edit AACCUP metrics.
📝 AACCUP Area VII — Manual Documentation Metrics
0/75 fields recorded📊Who Uses the Library Most?
Cross-tabulation of patron demographics vs. actual borrowing activity — not filtered by the selections above, shows the full population comparison.
📅Peak Checkout Days
All-time checkout volume by weekday — use to guide staffing and program scheduling.
⏱Current Loan Duration by Patron Type
Based on currently checked-out items. Shows how long patrons actually keep materials vs. the loan period allowed.
📦Collection Health at a Glance
Items that have never circulated and long-idle items are weeding candidates that free shelf space and improve accreditation scores.
👋Patron Engagement Deep Dive
Lapsed patrons and fine distribution by patron type — key for outreach targeting and fine policy review.
🌿 Green Library KPI Dashboard
Track environmental sustainability metrics. LIB-CIRC-001 is auto-computed from your ILS. Enter current values for the rest by clicking Update — saved to Supabase and available on any device.
Total annual energy (electricity + gas) ÷ library sq footage.
Source: Utility Bills & Building Floor Plan
% of waste diverted from landfills via recycling, composting, or book donation.
Source: Waste Management Invoices / Waste Audits
Total water consumed (indoor + landscaping) per square foot.
Source: Water Utility Bills
Average annual checkouts per physical item (Turnover Rate).
Source: ILS — auto-computed
% of receipts, notices, and registrations that are digital-only.
Source: ILS Notification Logs & Printer Logs
% of supplies sourced with eco-labels (EcoLogo, Green Seal, FSC).
Source: Financial Procurement & Invoice Audits
% of decommissioned IT hardware sent to certified e-waste recyclers.
Source: IT Asset Management / Disposal Receipts
% of terminals with automated sleep/power-down outside operating hours.
Source: IT Management Console (MDM)
% of library programs dedicated to sustainability and climate literacy.
Source: Events Calendar & Room Booking System
Total annual attendance at environmental/sustainability programs.
Source: Program Gate/Head Counts
🔄Sync Destiny → Supabase
Push a fresh snapshot from your Destiny ILS into Supabase so historical trend charts update. Run the daily sync once per day and the monthly sync after each month closes (or use a cron job to automate).
Full Catalog syncs call number/title/author/publisher/year/sublocation/barcode for every non-withdrawn item into the library_catalog Supabase table, for other apps to read without connecting to Destiny directly. Not on a schedule (Hobby plan cron slots are full) — run manually here whenever the catalog changes.
📱Facebook Page Engagement
Other Campuses
Campuses running their own SLiMS or Koha instead of Destiny. SLiMS campuses sync automatically; Koha campuses are local-only and upload a CSV export on whatever schedule their site can manage.
Sync SLiMS Campuses
Runs nightly alongside the Destiny snapshot sync too. Koha campuses aren't reachable from here — see /api/sync/koha-uploadfor the CSV upload each Koha site's staff run instead.