Skip to main content
The app has two analytics surfaces:

​
In-app Analytics

Admin → Analytics shows enrollment, student searches, cabinet fill, print activity, and school breakdowns from MongoDB. Data Leads see school-scoped metrics; Admins see district-wide totals plus an account snapshot (MFA disabled, locked, forced password change). Search analytics count lookups from Dashboard, Intake, All Students, and the command palette. Raw search text is not stored — only query type (name, DOB, ID), source, and whether it returned matches. Events expire after 180 days. Use Refresh to reload the snapshot. Deeper tools (Enrollment, Activity Report, Print Reports, Cabinets) are linked from the same page.
Analytics page with Students, Enrolled today, Cabinet fill, Prints metrics and charts

In-app Analytics — metric cards, enrollment/print charts, and school breakdown

​
MotherDuck Analytics (Admin only)

Admin → MotherDuck queries a MotherDuck DuckDB warehouse over the Postgres endpoint.
MotherDuck Analytics page showing Connected status and enrollment charts

MotherDuck Analytics — connection status, Sync from MongoDB, and warehouse charts

​
Setup

  1. Create an account and access token at app.motherduck.com (Settings → Access tokens).
  2. Set environment variables on the server:
  1. Open Admin → MotherDuck and click Sync from MongoDB.
Sync creates the database (if needed), students and sync_meta tables, then loads a full student snapshot. Charts (14-day enrollments, status, schools) read from MotherDuck after sync.
Re-run Sync from MongoDB after large imports or end-of-day so warehouse charts stay current. In-app Analytics always reflects live MongoDB without sync.

​
APIs (Admin)