Canvas Default Account Reports
This document outlines the descriptions of the default Canvas reports, their configurations, and CSV export format and data.
Account and subaccount admins have access to Canvas reports that can be used to review account data or in conjunction with accessing Canvas via the API. Canvas includes a set of default reports available to all institutions. This document outlines the descriptions of all default reports, their configurations, and CSV export format and data. Configurations refer to the options and filters that can be enabled before the report is run.
Subaccount Reports
Users are associated with an account through a group or a course enrollment. Even though courses and groups can be created within subaccounts, user data is maintained at the account level. Subaccount reports that involve user data may not be as current as account-level reports. To maintain accuracy for subaccount reports, Canvas updates all user account associations weekly on Sundays (exact times may vary).
Course Grade Passback
The Course Grade Passback report gets the grade passback setting for courses in a selected term and only displays courses where a value has been set.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, grade passback setting |
Course Storage
The Course Storage report shows the current statistics for storage space used in every course in a selected term (shown in megabytes).
The report shows two columns about file storage. The storage used column shows unique files in the course; files included through a previous import or course copy are not counted against the storage limit. The sum of all files column shows the amount of space required to download all files associated with the course.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, course SIS ID, course short name, course name, account ID, account SIS ID, account name, storage used (in MB), sum of all files (in MB) |
Developer Keys Report
The Developer Keys Report includes Developer Keys available to the institution. The report includes keys inherited from parent or root account and keys installed directly in the account in which the report is run. For more information, see the Canvas API documentation.
|
CSV Format |
One row per key |
|
CSV Data |
Global ID, key name, inherited from parent account, contact info, key type, permitted API endpoints |
ePortfolio Report
The ePortfolio report includes all active ePortfolios for the current institution. The report can be customized to reduce the scope of the ePortfolio results to users without enrollments and/or ePortfolios that have been removed.
|
Configuration |
Enrollment status, removed ePortfolios |
|
CSV Format |
One row per ePortfolio |
|
CSV Data |
ePortfolio name, ePortfolio ID, author name, author ID, author SIS ID, author login ID, date created, date updated, is public, workflow state |
Grade Export
The Grade Export report shows the final grade results for all the students in a selected term.
The current score reflects the total while ignoring unsubmitted assignments and muted assignments, and the final score counts unsubmitted assignments and muted assignments as zero. If the Final Grade Override feature preview has been turned on in an account, the Grade Export report will include the override_score column.
For use with grading periods, use the MGP Grade Export report.
|
Configuration |
Term, deleted objects |
|
CSV Format |
One row per enrollment |
|
CSV Data |
Student name, student ID, student SIS ID, student integration ID*, course name, course ID, course SIS ID, section name, section ID, section SIS ID, term name, term ID, term SIS ID, current score, final score, enrollment state, unposted current score, unposted final score, override score, current grade, final grade, unposted current grade, unposted final grade, override grade |
* Contact your Customer Success Manager to include student integration IDs in the grade export report.
LTI Report
The LTI report provides an export of data that shows LTI (Learning Tool Interoperability) usage information.
|
Configuration |
Deleted objects |
|
CSV Format |
One row per LTI tool |
|
CSV Data |
Configuration location, associated account/course ID, associated account name, associated course name, tool ID, tool name, tool type, tool created at, tool privacy level, launch URL, custom fields |
Last Enrollment Activity
The Last Enrollment Activity report show the last activity on a user’s enrollments.
|
Configuration |
Term |
|
CSV Format |
One row per enrollment |
|
CSV Data |
User ID, user name, last activity date and time |
Last User Access
The Last User Access report shows the last login for active users. The endpoint used for the most recent access date and time is updated every 10 minutes. The date and time displayed in the report will reflect the time the endpoint was updated and may differ from the exact time the user accessed Canvas.
|
Configuration |
Term, deleted objects |
|
CSV Format |
One row per enrollment |
|
CSV Data |
User ID, user SIS ID (if applicable), user name, last access date and time, IP address |
Multiple Grading Periods Grade Export
The Multiple Grading Period (MGP) Grade Export report shows grading period grades (and overall course grades) for each student enrolled in a given term.
Each [grading period name] also includes columns that indicate the unposted current score and unposted final score. Depending on the term configuration, this report may include multiple grading periods. If the Final Grade Override feature preview has been turned on in an account, the MGP Grade Export report will include the override_score column.
|
Configuration |
Term |
|
CSV Format |
One row per enrollment |
|
CSV Data |
Student name, student ID, student SIS ID, course name, course ID, course SIS ID, section name, section ID, section SIS ID, term name, term ID, term SIS ID, grading period set name, grading period set ID, [grading period name] ID, [grading period name] current score, [grading period name] final score, [grading period name] unposted current score, [grading period name] unposted final score, current score, final score, enrollment state, unposted current score, unposted final score, override score, current grade, final grade, unposted current grade, unposted final grade, override grade |
Outcome Export
The Outcome Export report shows all learning outcomes in an account and includes details of all attributes associated with each outcome.
|
CSV Format |
One row per outcome |
|
CSV Data |
Canvas ID, vendor guide, object type, outcome title, outcome description, display name, calculation method, calculation integer, parent guides, workflow state, mastery points, ratings |
Outcome Results
The Outcome Results report shows the learning outcome results for all students in published courses.
Outcome results are tied to their level of outcome access. Account outcomes display on the account report, while the sub-account outcomes display on the sub-account report. Course outcomes only display within course reports. The only time outcomes would be displayed on both reports is if they are stored in both accounts, such as copying an account outcome to the sub-account level.
When generating this report from the account or subaccount level, all outcomes are included for the appropriate context or a parent sub-account level.
|
Configuration |
Term, deleted objects |
|
CSV Format |
One row per user-outcome-result pair |
|
CSV Data |
Student name, student ID, student SIS ID, assessment title, assessment ID, assessment type, submission date, submission score, learning outcome name, learning outcome ID, attempt number, outcome score, assessment question, assessment question ID, course name, course ID, course SIS ID, section name, section ID, section SIS ID, assignment URL, learning outcome friendly name, learning outcome points possible, learning outcome mastery score, learning outcome mastered, learning outcome rating, learning outcome rating points, account ID, account name, enrollment state |
Provisioning
The Provisioning report exports all the needed information that relates to provisioning Canvas in one or all of its respective categories: Users, Accounts, Terms, Courses, Sections, Enrollments, Groups, Group Memberships, Group Categories, Cross-listing, and User Observers.
Each report includes a created by SIS column. SIS data is displayed in the column regardless if the SIS creation checkbox is selected as part of the report configuration. Selecting the Created by SIS checkbox will display only data created by SIS.
Deleted courses without SIS IDs are only included in the Provisioning report if the course was deleted less than 120 days before the date the report is created. Courses with SIS IDs are not affected by this limit.
Groups and Group Memberships are only included in the Provisioning report if they were created through a Canvas SIS integration. To help manage and track manually created groups and group memberships, you may want to automatically allocate unique SIS IDs for manually created groups/memberships.
Start dates and end dates are only included in Provisioning reports for courses and sections that have selected the Students can only participate in the course between these dates checkbox in Course Settings.
|
Configuration |
Term, CSV File Type, created by SIS, deleted objects |
|
CSV Format |
One row per category |
|
CSV Data |
Users: Canvas user ID, integration ID, authentication provider ID, user ID, login ID, first name, last name, full name, sortable name, short name, email, status Accounts: Canvas account ID, account ID, Canvas parent ID, parent account ID, name, status Terms: Canvas term ID, term ID, name, status, start date, end date Courses: Canvas course ID, integration ID, course ID, short name, long name, Canvas account ID, account ID, Canvas term ID, term ID, status, start date, end date, Canvas Blueprint Course ID Sections: Canvas section ID, section ID, integration ID, Canvas course ID, course ID, name, status, start date, end date, Canvas account ID, account ID Enrollments: Canvas course ID, course ID, user ID, role, role ID, canvas section ID, section ID, status, Canvas associated user ID, base role type, limit section privileges, Canvas enrollment ID, Canvas temporary enrollment source ID, temporary enrollment source user ID Groups: Canvas group ID, group ID, Canvas group category ID, group category ID, Canvas account ID, account ID, Canvas course ID, course ID, name, status, context ID, context type, group category ID, max membership Group Memberships: Canvas group ID, group ID, Canvas user ID, user ID, status Group Categories: Canvas group category ID, group category ID, context ID, context type, group name, role, self signup, group limit, auto leader, status Cross-listing (X list): Canvas xlist course ID, xlist course ID, Canvas section ID, section ID, status, Canvas nonxlist course ID, nonxlist course ID User Observers: Canvas observer ID, observer ID, Canvas student ID, student ID, status Admin: Admin user name, Canvas user ID, user ID, Canvas account ID, account ID, role ID, role, status |
Public Courses
The Public Courses report shows all the public courses that are not deleted for a given term.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, course SIS ID, course short name, course name, course start date, course end date |
Recently Deleted Courses
The Recently Deleted Courses report shows all the courses for a given term that have been deleted in the last 30 days.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, course SIS ID, course short name, course name, course start date, course end date |
SIS Export
The SIS Export report exports the needed files for Users, Accounts, Terms, Courses, Sections, Enrollments, Groups, Group Memberships, Cross-listing, and User Observers managed by the SIS import. To view all file data not managed by SIS, please configure and export the Provisioning report.
Each report includes a created by SIS column. SIS data is only displayed in the column if the SIS creation checkbox is selected as part of the report configuration.
Start dates and end dates are only included in SIS Export reports for courses and sections that have selected the Students can only participate in the course between these dates checkbox in Course Settings.
|
Configuration |
Term, CSV File Type, created by SIS, deleted objects |
|
CSV Format |
One row per category |
|
CSV Data |
Accounts: Canvas account ID, account ID, Canvas parent ID, parent account ID, name, status Users: Canvas user ID, integration ID, authentication provider ID, user ID, login ID, first name, last name, full name, sortable name, short name, email, status Terms: Canvas term ID, term ID, name, status, start date, end date Courses: Canvas course ID, integration ID, course ID, short name, long name, Canvas account ID, account ID, Canvas term ID, term ID, status, start date, end date, course format, blueprint course id Sections: Canvas section ID, section ID, integration ID, Canvas course ID, course ID, name, status, start date, end date, Canvas account ID, account ID Enrollments: Canvas course ID, course ID, user ID, role, role ID, canvas section ID, section ID, status, Canvas associated user ID, limit section privileges Group Categories: Group category ID, account ID, course ID, category name, status Groups: Canvas group ID, group ID, group category ID, Canvas account ID, account ID, name, status Group Memberships: Canvas group ID, group ID, Canvas user ID, user ID, status Cross-listing (X list): Canvas xlist course ID, xlist course ID, Canvas section ID, section ID, status, Canvas nonxlist course ID, nonxlist course ID User Observers: observer ID, student ID, status Admin: User ID, account ID, role ID, role, status |
SIS Submission Reports
The SIS Submission report gets the submissions for courses. The SIS Submission Report may only display for institutions that have authenticated Canvas to post grades to their SIS.
|
Configuration |
Term |
|
CSV Format |
One row per category |
|
CSV Data |
Submission ID, attempt, score, grade, late, submission type, submitted at, graded at, workflow state, excused, assignment id, assignment name, assignment created at, assignment due at, assignment points possible, assignment description, assignment post to SIS, assignment group ID, assignment group name, assignment SIS source ID, course ID, course SIS ID, course name, section ID, section SIS ID, section name, account ID, account name, term ID, term SIS ID, term name, user ID, user name, user sortable name, user SIS user ID, user SIS login ID |
Student Competency
The Student Competency report shows the learning outcome results for all students.
This report displays the details of the outcome result including the associated assignment. However, this report only shows outcome results for assignments and does not include outcomes tied to question banks. For detailed reports, create outcomes at the account or sub-account level and add those outcomes to course activities.
When generating this report from the account or subaccount level, all outcomes are included for the appropriate context or a parent sub-account level. Additionally, reports include all child subaccount outcomes and all course level outcomes.
|
Configuration |
Term, deleted objects |
|
CSV Format |
One row per user-outcome-result pair |
|
CSV Data |
Student name, student ID, student SIS ID, assignment title, assignment ID, submission date, submission score, learning outcome name, learning outcome ID, attempt, outcome score, course name, course ID, course SIS ID, section name, section ID, section SIS ID, assignment URL, learning outcome friendly name, learning outcome points possible, learning outcome mastery score, learning outcome mastered, learning outcome rating, learning outcome rating points, account ID, account name, enrollment state |
Students with No Submissions
The Students with no submissions report shows all students enrolled in a course in a given term who have not submitted an assignment, graded discussion, or quiz between the given date range in a course.
|
Configuration |
Term, start date, end date, enrollment state |
|
CSV Format |
One row per student enrollment that meet the criteria |
|
CSV Data |
User ID, user SIS ID, user name, section ID, section SIS ID, section name, course ID, course SIS ID, course name |
Unpublished Courses
The Unpublished Courses report shows all the courses for a given term that are not published.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, course SIS ID, course short name, course name, course start date, course end date |
Unused Courses
The Unused Courses report shows courses that have none of the following items: assignments, announcements, discussions, files, modules, pages, or quizzes.
|
Configuration |
Term |
|
CSV Format |
One row per course |
|
CSV Data |
Course ID, course SIS ID, course short name, course long name, course status, course created date and time |
User Access Tokens
The User Access Tokens report shows users with access tokens.
|
Configuration |
Deleted objects |
|
CSV Format |
One row per token |
|
CSV Data |
User ID, user name, token hint, expiration, last used, dev key ID, dev key name |
User Course Access Log
The User Course Access Log report shows all the activity from users enrolled in all courses in a given term. The times viewed and times participated are counted from the beginning of time until the time the report was generated. A maximum of one month's data will be retrieved. By default, it will return data from the beginning of the previous week.
|
Configuration |
Term, start date, enrollment type |
|
CSV Format |
One row per student activity |
|
CSV Data |
Section ID, section SIS ID, section name, course ID, course SIS ID, course name, term ID, term SIS ID, term name, user ID, user SIS ID, user name, content type, content, times viewed, times participated, last viewed |
Zero Activity
The Zero Activity report shows all the students enrolled in any courses in a given term.
|
Configuration |
Term, start date |
|
CSV Format |
One row per user enrollment that have not visited the course since the date |
|
CSV Data |
User ID, user SIS ID, student name, section ID, section SIS ID, section name, course ID, course SIS ID, course name |
Last update: 2023-06-21
This resource can also be accessed from the following Canvas Guide:
