Skip to main content
The app has two analytics surfaces:

​
In-app Analytics

Admin → Analytics shows enrollment, cabinet fill, print activity, and school breakdowns from MongoDB. Data Leads see school-scoped metrics; Admins see district-wide totals. 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)

​
ThoughtSpot (optional legacy)

The ThoughtSpot Liveboard embed may still be available at /admin/thoughtspot-analytics if THOUGHTSPOT_* env vars are set. MotherDuck is the primary warehouse path in navigation.