Report templates and system reports
Choose the result you need, then find its datasets in the table below. Select and sync datasets before using a locked report.
System reports
Section titled “System reports”Every system report appears under Reports. An available report opens when you select its name. A locked row shows Needs followed by the missing dataset names and a Manage datasets link when that action is available. After a sync adds a system report’s last missing dataset, the report can show Preparing for a few minutes and cannot be opened yet. The Reports page checks for it automatically for up to five minutes. Reload the page if it still does not open. Open it when it becomes available. System reports are read only; use Copy to make an editable report. Evaluation includes up to 3 published reports you create; drafts and system reports do not count toward this limit.
LMS Accounts shows a list with one row per account.
The LMS Accounts report shows an As of date from its last sync. Billing’s dated count may have a different date.
Templates
Section titled “Templates”To start with a query you can change, open Reports > New report, select Start from a template, then choose a template. The query and its inputs appear in the builder. For Course visits by course, select Run to see the course rows.
Student Engagement Signals leaves Days inactive empty for a student who never visited; that student still triggers the inactivity signal.
Course enrollment by role includes only course offerings.
Students active recently includes only course offerings.
| Report or template | Datasets needed |
|---|---|
| LMS Accounts (system and template) | Course Access, Course Access Log, Users, Organizational Units |
| Enrollment Trends (system and template) | User Enrollments, Organizational Units |
| Course Activity (Last 30 Days) (system) | Course Access, Organizational Units |
| Final Grade Distribution (system) | Grade Results, Grade Objects, Organizational Units |
| Students with Low Engagement (system) | User Enrollments, Role Details, Organizational Units, Course Access, Content Objects, Content User Progress, Grade Objects, Grade Results, Gradebook Settings, Users |
| Course visits per day | Course Access, Course Access Log |
| Inactive accounts | Course Access, Course Access Log, Users |
| Course visits by course | Course Access, Course Access Log |
| Course visitors this week vs last | Course Access, Course Access Log |
| Last course visit per person | Course Access, Course Access Log |
| Class list course visits | User Enrollments, Course Access, Course Access Log |
| Course enrollment by role | User Enrollments, Course Access, Course Access Log, Organizational Units |
| Students active recently | User Enrollments, Course Access, Course Access Log, Organizational Units |
| Student Engagement Signals | User Enrollments, Role Details, Organizational Units, Course Access, Content Objects, Content User Progress, Grade Objects, Grade Results, Gradebook Settings, Users |
If a template shows Missing datasets:, use Manage datasets to select and sync them before loading it. The dataset guide covers selection.
If the editor already has a query, Replace the current SQL with this template? confirms that loading the template will replace its query and inputs.
Which reports work with insight widgets
Section titled “Which reports work with insight widgets”Published reports with an OrgUnitId course column can supply insight widgets. See Create an insight widget for the next task.