---
title: Course Completion by User
description: Features of the course completion by user page under the 'Analytics' tab
---
[Skip to content](https://support.edapp.com/course-completion-by-user#main-content)
English
Show submenu for translations
![EdApp - logo dark mode-1.png\]](https://support.edapp.com/hs-fs/hubfs/EdApp%20-%20logo%20dark%20mode-1.png?height=40&name=EdApp%20-%20logo%20dark%20mode-1.png)
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
Open main navigation
Close main navigation
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
- English
Show submenu for translations
- [edapp.com](https://www.edapp.com/)
[edapp.com](https://www.edapp.com/)
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://support.edapp.com/?hsLang=en)
2. [Admin portal](https://support.edapp.com/admin-portal?hsLang=en)
3. [Analytics](https://support.edapp.com/admin-portal?hsLang=en#analytics)
# Course Completion by User
## Features of the course completion by user page under the 'Analytics' tab
### Contents
[Filters](https://support.edapp.com/course-completion-by-user#filter)
[Export](https://support.edapp.com/course-completion-by-user#export)
[Column Definitions](https://support.edapp.com/course-completion-by-user#column-definition)
The Course Completion by User report summarises your user's progress per course. It is useful to drill down to see which users are falling behind on progress in order to increase engagement and features an export capability opening up opportunities for further data manipulation. 
A user will appear in this report once the course is assigned to them via universal access, user group collection, or direct assignment to a user group or paths.
### Filter
In the report, the admin can see a variety of filters available for data drill-down:
1. Course Title
2. Users
3. User Groups
4. Status
The additional filter tab can be used to filter the following:
-User Status
-User Name
-Name
-Email
-Training Mode
-Mandatory
-Status
-Language
-Due Date
-Course Completed
-Coursed Opened
-Course Published
-Score
-Progress
-Custom fields (This can be located by enabling the specific custom field in the "Hidden Fields" section beside the export button. Please note that you would need to have created and enabled custom fields in the App Settings first)
**Filter for Archived Users**
****
Course Completion By User (CCBU) Report now includes data from **Archived users**.
**Steps:**
1\. Click on the "More Filters" button
2\. Add into the "User Status" filter to "Enabled" and "**Archived**"
\* For Edapp,** Archive **means** Deleted.**
\* Using the new **User Status filter** you can include users with the status of Archive in the report and export.
*Note this filter feature is only for the Course Completion By User (CCBU) report, as the [Performance Dashboard](https://support.edapp.com/performance-dashboard?hsLang=en) does not include **Archived Users***
**Filter for Previously Assigned Courses to Learners**
The Course Completion By User (CCBU) report now contains learner progress data for courseware that the learner **no longer has access to**.
**Steps:**
1\. Click on the view more options (eye icon)
2\. Scroll down and select the "Assigned Status", then click "Apply"
2\. Click on the "More Filters" button
2\. Add into the "Assigned Status" filter to "Currently Assigned" and "**Previously Assigned**", then click "Apply"
*Note this filter feature is only for the Course Completion By User (CCBU) report, as the [Performance Dashboard](https://support.edapp.com/performance-dashboard?hsLang=en)does not include **Previously Assigned Courses to Learners***
### **Export Data**
Admin can click the "Export" button which will allow admin to have the flexibility to use the data as they please, such as uploading it into third-party platforms. The file will be exported into a CSV file. **(The downloaded file will depend on what is filtered and currently showing on the Course Completion By User page. If it's filtered to only 2 users from a user group, it will only download the data for those 2 users filtered)**
The Course Completion by User export has been formatted this way to allow admins to use the Excel functionalities on the report such as filtering and pivot tables.
In the table below you will see explanations of the columns that you find in the **report** (on the admin.edapp.com user interface) and the **export**.
### 
### **Column Definition in report and export**
| **Column** | **Definition** | **Report or Export** |
| --- | --- | --- |
| UserID | Unique ID to identify the users | Export |
| User Details | Username and Full name | Report and Export |
| Username | Username of the user that is used to log in EdApp | Export |
| User Groups | A full list of user groups of the learner | Report and Export |
| First name | First name of the user provided in the user profile | Export |
| Last Name | Last name of the user provided in the user profile | Export |
| Course ID | Unique ID to identify a course | Export |
| Course | Courses are assigned to the learner via one of the below ways: - Universal access - User Group Collection of the User Group or other user group that the user is assigned to - Direct user group - Paths The course must be published, not archived, and have at least one published and non-archived lesson. | Report and Export |
| Language | If a course has been translated and linked to multiple versions, then the data will be aggregated to show up as one row with the below rule: - If the course has not been attempted, there will be no data for language - If the course has been attempted but not completed, the data of the course that has the highest progress will be displayed - If the course has been attempted and completed, the data of the course that has the latest completion (if the course has been completed multiple times in multiple versions) will be displayed | Report and Export |
| Date Completed | The latest date the course was completed (if it has been completed). Displayed in UTC. | Report and Export |
| Required lessons Completed | The number of *required lessons* that have been completed by the user | Report and Export |
| Required lessons | The number of *required lessons* in the course. | Report and Export |
| Times Spent (minutes) | The amount of time a user spent in-lesson (on all sides of the lesson) for all lessons in the course. This data will show up for incomplete courses as well. | Export |
| Time Spent (dynamic format) | same as C13 | Report and Export |
| Average Score (Maximum: 100) | - The sum of the highest achieved score in all counted lessons in the course divided by the number of counted lessons - This calculation implies that non-mandatory lessons will be counted too. - This will show up only after a course is completed - The non-scoring lesson will be included in the calculation | Report and Export |
| Progress (0%-100%) | - Representing the percentage of the course the user has completed - The number of completed, required lessons divided by the number of required lessons | Report and Export |
| User Status | - Displays the status of the User as Enabled or Archived (Deleted) | Report and Export |
| Custom Fields | Additional data that you have configured **[here](https://support.edapp.com/custom-fields?hsLang=en)**. | Report and Export |
| **Clicking on a User brings you to a Lesson Level Detail view for that User/Course** | | |
| **Lessons Table Data** | | |
| Lesson | The title of the lesson | Both |
| Course | The course the lesson belongs to | Both |
| Status | The status of the lesson (Opened, Unopened, or Complete) | Both |
| Time Spent | The total time spent by the learner in the lesson | Both |
| Completions | The number of times the learner has successfully completed the lesson | Both |
| Date Completed | The date the lesson was first completed | Both |
| Best Score | Out of all lesson attempts, the best score achieved by the learner | Both |
| Attempts | The total number of successful and unsuccessful attempts at the lesson by the learner | Both |
| **Clicking on a User's Lesson record brings you to an Attempt detail table** | | |
| **Attempts Data** | | |
| Total Attempts | The total number of attempts the learner has made for the lesson | Both |
| Successful Attempts | The total number of times the learner has successfully completed the lesson | Both |
| Unsuccessful Attempts | The total number of times the learner has attempted but not successfully completed the lesson | Both |
| Date Attempted | The date of the lesson attempt | Both |
| Course | The name of the course the lesson belongs to | Both |
| Lesson | The lesson the attempt record applies to | Both |
| Training Mode | Individual or Group | Both |
| Score | The score the learner received in the attempt | Both |
| Result | The result of the attempt (successful or unsuccessful) | Both |
Users with the following roles enabled on their profile **will not be included**in this report:
- Reviewer
- Once it is unticked, the user will now be a normal learner and will appear on the CCBU along with other users who took the quiz.
- If the user took the quiz on a “reviewer” role and the admin unticks it after, it will take a few hours before the user appears on the CCBU. However, if an admin wants to see the progress of that specific user, they can proceed to the Data Drill Down section of the Performance Dashboard
- Excluded from analytics
Admins can check if the said user has the above permissions by following the [guide here](https://support.edapp.com/roles-permissions?hsLang=en#reviewers).
- [Getting started](https://support.edapp.com/getting-started?hsLang=en#main-content)
- [Get Started in 5 Minutes](https://support.edapp.com/getting-started?hsLang=en#get-started-in-5-minutes)
- [Lessons & Courses](https://support.edapp.com/getting-started?hsLang=en#lessons-courses)
- [Basic User Management](https://support.edapp.com/getting-started?hsLang=en#basic-user-management)
- [Course Library](https://support.edapp.com/getting-started?hsLang=en#course-library)
- [Definitions](https://support.edapp.com/getting-started?hsLang=en#definitions)
- [Admin portal](https://support.edapp.com/admin-portal?hsLang=en#main-content)
- [Advanced User Management](https://support.edapp.com/admin-portal?hsLang=en#advanced-user-management)
- [Lesson Management](https://support.edapp.com/admin-portal?hsLang=en#lesson-management)
- [Course Management](https://support.edapp.com/admin-portal?hsLang=en#course-management)
- [App Customisation](https://support.edapp.com/admin-portal?hsLang=en#app-customisation)
- [Peer Learning](https://support.edapp.com/admin-portal?hsLang=en#peer-learning)
- [Engagement](https://support.edapp.com/admin-portal?hsLang=en#engagement)
- [Analytics](https://support.edapp.com/admin-portal?hsLang=en#analytics)
- [Features](https://support.edapp.com/admin-portal?hsLang=en#features)
- [EducateAll](https://support.edapp.com/admin-portal?hsLang=en#educateall)
- [Sharing Content](https://support.edapp.com/admin-portal?hsLang=en#sharing-content)
- [Integrations](https://support.edapp.com/admin-portal?hsLang=en#integrations)
- [Learner's app](https://support.edapp.com/learners-app?hsLang=en#main-content)
- [Logging In](https://support.edapp.com/learners-app?hsLang=en#logging-in)
- [Taking Courses](https://support.edapp.com/learners-app?hsLang=en#taking-courses)
- [Features For Learners](https://support.edapp.com/learners-app?hsLang=en#features-for-learners)
- [Extras](https://support.edapp.com/learners-app?hsLang=en#extras)
- [Star Bar](https://support.edapp.com/learners-app?hsLang=en#star-bar)
- [Creator Tool](https://support.edapp.com/creator-tool?hsLang=en#main-content)
- [Branding](https://support.edapp.com/creator-tool?hsLang=en#branding)
- [Templates](https://support.edapp.com/creator-tool?hsLang=en#templates)
- [Course & Lesson Configurations](https://support.edapp.com/creator-tool?hsLang=en#course-lesson-configurations)
- [Copying Slides/Lessons/Courses](https://support.edapp.com/creator-tool?hsLang=en#copying-slides-lessons-courses)
- [Translations](https://support.edapp.com/creator-tool?hsLang=en#translations)
- [Content](https://support.edapp.com/creator-tool?hsLang=en#content)
- [Tips and tricks](https://support.edapp.com/tips-and-tricks?hsLang=en#main-content)
- [Learning Programme Management](https://support.edapp.com/tips-and-tricks?hsLang=en#learning-programme-management)
- [Authoring](https://support.edapp.com/tips-and-tricks?hsLang=en#authoring)
- [Best Practices](https://support.edapp.com/tips-and-tricks?hsLang=en#best-practices)
- [Programme Success](https://support.edapp.com/tips-and-tricks?hsLang=en#programme-success)
- [Engagement](https://support.edapp.com/tips-and-tricks?hsLang=en#engagement)
- [Launch Kit](https://support.edapp.com/tips-and-tricks?hsLang=en#launch-kit)
- [FAQ](https://support.edapp.com/faq?hsLang=en#main-content)
- [Lessons & Courseware](https://support.edapp.com/faq?hsLang=en#lessons-courseware)
- [Authoring](https://support.edapp.com/faq?hsLang=en#authoring)
- [User Registration & Management](https://support.edapp.com/faq?hsLang=en#user-registration-management)
- [Display](https://support.edapp.com/faq?hsLang=en#display)
- [Engagement](https://support.edapp.com/faq?hsLang=en#engagement)
- [Peer Learning](https://support.edapp.com/faq?hsLang=en#peer-learning)
- [Knowledge Performance](https://support.edapp.com/faq?hsLang=en#knowledge-performance)
- [Analytics](https://support.edapp.com/faq?hsLang=en#analytics)
- [System & Technical Support](https://support.edapp.com/faq?hsLang=en#system-technical-support)
- [Subscriptions & Pricing](https://support.edapp.com/faq?hsLang=en#subscriptions-pricing)
- [Educate All](https://support.edapp.com/faq?hsLang=en#educate-all)
- [Contact & Support](https://support.edapp.com/faq?hsLang=en#contact-support)
- [Webinars](https://support.edapp.com/webinars?hsLang=en)
- [Technical / API documentation](https://support.edapp.com/technical-api-documentation?hsLang=en#main-content)
- [Single Sign On for the Learner's Portal](https://support.edapp.com/technical-api-documentation?hsLang=en#single-sign-on-for-the-learners-portal)
- [Single Sign-on for Admin Portal](https://support.edapp.com/technical-api-documentation?hsLang=en#single-sign-on-for-admin-portal)
- [Integrations](https://support.edapp.com/technical-api-documentation?hsLang=en#integrations)
- [API](https://support.edapp.com/technical-api-documentation?hsLang=en#api)
- [Legal documentation](https://support.edapp.com/legal-documentation?hsLang=en#main-content)
- [Third Party Gateway](https://support.edapp.com/legal-documentation?hsLang=en#third-party-gateway)
- [Privacy & Terms](https://support.edapp.com/legal-documentation?hsLang=en#privacy-terms)
- [Troubleshooting](https://support.edapp.com/troubleshooting?hsLang=en)
- [EdApp to SC Migration](https://support.edapp.com/edapp-to-sc-migration?hsLang=en)
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
[](http://edapp.com)
EdApp Help Center
Copyright © 2026, EdApp Pty Ltd
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"contentUrl" : "https://5741180.fs1.hubspotusercontent-na1.net/hubfs/5741180/ccbu4.webm",
"dateModified" : "2024-05-09T19:25:16.406Z",
"duration" : "PT0S",
"height" : 748,
"name" : "ccbu4",
"thumbnailUrl" : "https://5741180.fs1.hubspotusercontent-na1.net/hubfs/5741180/ccbu4.webm/medium.jpg",
"uploadDate" : "2024-05-09T19:25:16.402Z",
"width" : 1920
}
```