---
title: "Get School Stats"
method: GET
path: "/admin/school-stats"
tags: ["Admin - School Stats"]
---

# Get School Stats

`GET /admin/school-stats`

Get comprehensive school statistics.
- school_id: specific school, or omit for global view across all schools
- school_year: format "YYYY-YYYY" (default: current school year)
- period: "all", "t1", "t2", "t3", or month abbreviation (sep, oct, nov, dec, jan, feb, mar, apr, may, jun)

## Query parameters

- `school_id` string, nullable — School ID, omit for global view
- `school_year` string — School year (e.g., 2024-2025)
- `period` string — Period: all, t1, t2, t3, or month (sep, oct, etc.)

## Response `200`

Successful Response

- SchoolStatsResponse
  - `school_id` string, nullable, required
  - `school_name` string, nullable, required
  - `school_info` SchoolInfo — School information displayed when a specific school is selected.
    - `contract_type` string, nullable
    - `contract_start_date` string, date-time, nullable
    - `contract_end_date` string, date-time, nullable
    - `first_teacher_created_at` string, date-time, nullable
  - `period_start` string, date-time, required
  - `period_end` string, date-time, required
  - `teacher_stats` TeacherStats, required
    - `active` integer, required
    - `registered` integer, required
    - `total` integer, required
    - `total_available` boolean, required
    - `active_percentage` number, required
  - `student_stats` StudentStats, required
    - `active` integer, required
    - `registered` integer, required
    - `total` integer, required
    - `total_available` boolean, required
    - `active_percentage` number, required
  - `establishment_stats` EstablishmentStats, required
    - `paid` integer, required
    - `registered` integer, required
    - `paid_percentage` number, required
  - `teacher_activity_by_month` MonthlyTeacherActivity[], required
    - `month` string, required
    - `month_label` string, required
    - `assignments_created` integer, required
    - `exercises_created` integer, required
    - `exams_created` integer, required
    - `courses_created` integer, required
  - `student_activity_by_month` MonthlyStudentActivity[], required
    - `month` string, required
    - `month_label` string, required
    - `courses_created` integer, required
    - `exercise_sessions_practice` integer, required
    - `exercise_sessions_assignment` integer, required
    - `ai_tutor_hours` number, required
  - `teachers_table` TeacherTableRow[], required
    - `teacher_id` string, required
    - `teacher_name` string, required
    - `subject` string, nullable
    - `class_count` integer, required
    - `is_active_7d` boolean, required
    - `student_active_percentage` number, required
    - `assignments_created` integer, required
    - `exercises_created` integer, required
    - `exams_created` integer, required
    - `courses_created` integer, required
    - `school_name` string, nullable
  - `classes_table` ClassTableRow[], required
    - `class_id` string, required
    - `class_name` string, required
    - `teacher_name` string, required
    - `student_count` integer, required
    - `courses_created` integer, required
    - `exercise_sessions_practice` integer, required
    - `exercise_sessions_assignment` integer, required
    - `ai_tutor_hours` number, required
    - `school_name` string, nullable

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/excellence-ai/apis/excellence-learning.md) · [All operations](https://skmtc.dev/excellence-ai/apis/excellence-learning/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/excellence-ai/excellence-learning/revisions/c407f3b5a05b/schema)