Enrollment Reports
Outline
Activity and User Enrollment reports let you review data related to your users' engagement with the content in your catalog. Activity Enrollment reports aggregate data by activity - letting you target specific content and associated user enrollments. User Enrollment reports aggregates data by user - letting you target specific users' engagement with content.
This article gives an overview of creating activity and user enrollment reports and outlines the default filters used to pull and organize data in each report.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448956/page_regular/space-281-29.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NTYvcGFnZV9yZWd1bGFyL3NwYWNlLTI4MS0yOS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=YRcd724RMW4-jOxWoaK0Uxk09xc5U4tsnAtIH3qPta53awxqfrWjTT7GwV6nPl0-yTm8W~brtBRilYHol-ok87rinnj6kEwCLTIYfezxzO7k1QQTixc-I1-5ze4SCKCcfdU30MceGStTzkZMWO2oBPwRDOhT6dNfHptMFn0A7N917TEEVdySZ~WuPImMemV-M5vV4zeHMtS8QDtpfxM4fFldNjbozdhmB~NlwYX7xwO3uxJ9JS8B4NpvpuAqE0JAP7A2OkQgK8rBEAubV1Uvl8Fy7RG7MLI7g~QHVW9OxLUPEj6Wxcf0csbku3v2xph5M622yk5njImJWurxjQI1RQ__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Create an enrollment report
Follow these steps to create a new Activity or User Enrollments Report:
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448959/page_regular/newreport.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NTkvcGFnZV9yZWd1bGFyL25ld3JlcG9ydC5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=DW9BZ2NdQklhEkgI936n2Kzal9iRZc5~jebFWfFKf40lTFXuZ9DCPN46HpmjS3F3FxOVw77Z6ara-gD68qTsIYD0bHDvkArl3D1drTQ8h3TFNencZwKRHnBpEj48QoEGbEYbtdpGG5vYxY65KBz7MfzJ6IsMvq3jnibf26SDW52T5hW-b~0e4s5UD9QrsKEVvWrJvOokMooCUE3KJHAp7xeUo7vce3UckEVKSshS19Ayhmq69T40puWFZcJJZLzsqGAhn8UosL5272C2kjIfZBxsfIeyttydyCPCGPh6GQ~P5CL9HxE4zGib~Jv2HYcHiseAOLV6pZ9fdt6l6bBuQQ__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
- Navigate to Reports in the admin navigation panel.
- Click the New Report button.
- Select User Enrollments or Activity Enrollments as the report Type.
- Click Create.
Heads Up!
Activity Enrollments reports will only include users with enrollments. A User Enrollments report can include users with no enrollments.
Each report type gives you access to query enrollment, activity, event, and user fields to build a report that pulls exactly the data you need.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448961/page_regular/space-281-29.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjEvcGFnZV9yZWd1bGFyL3NwYWNlLTI4MS0yOS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=XsNPJ8scOgEwvVZbo5zkphL-ykOL3iGdEQJaG2SvA3t8VxAg4ZeL0g48FdvBMBpSlEuyMcse5KuptSw-VE0zze5WKKP2uXyoBoyxwBN2WRPOa3JprmLX3SjWSAM~dGrzCF9oDDX8Ltm0YH3ZkjbGypK2~S5vOUinKHMP1mzDYsnLHZY0Gn1hJGEOH6~Dfyiq1Lfjk6Mn5O3ns2KvrgqLcO741oXqaAToMUiIgD-oWsOgBAgW-mwAsW4WwWY18RmvAoQVr6TaPv3GXVzcE3~K8hmuE8L~DeGgVX-HhlpO-qE33eel0lQ99EBJDxnUsH8jrh564YRj2zXM6X3w5WJPJA__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Activity enrollments report
Activity Enrollments reports let you query user enrollments by activity. Reports can be filtered using enrollment, activity, event, and user field data available in the platform.
The default Activity Enrollments Report Query pulls data on activity enrollments that have been completed in the last 90 days.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448962/page_regular/activity-columnpreview.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjIvcGFnZV9yZWd1bGFyL2FjdGl2aXR5LWNvbHVtbnByZXZpZXcucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1NzU5MDYyfX19XX0_&Signature=IRy3SGWr~QaNg3YDBu5D3ZetA4kDw0S8RoTm9EfL7qS~AYeqkOGJ~Nd0LKpd6msfkIp1YeHvRSNVzVp-5qjhD3g1GHAqixhro9InBW7rnuj3I80r6ZY16nGWPOl7RwdKunuRyJ6joQdr6-yK3WQR1bdttBjCUUUSWcGFStsWkvVkJ2u-kT7epx6RQTWSyBwF-0JAXWTPeF~9bZH5kZspgP91uLG5mLW96W~EP3rlpmOwMmx7U6U2Pc-bGD0auyFVCrhhgVolTV~OybapfP5GScvLhH7zqiwWtG2hXep30jWrEx9APs~QOxic1iVAKRtOKRYZEmRHi1Y-NAeCeLmABQ__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
The default columns used to organize Activity Enrollments reports include:
- User Full Name
- Pulled from First Name and Last Name fields in User profiles
- Activities Name
- Pulled from Activity properties
- Enrollment Enrolled On
- A time stamp of the learner's elected, or assigned, enrollment
- Enrollment Type
- Describes an enrollment as required, recommended, elected, etc.
- Enrollment Status
- Describes an enrollment as passed, dropped, in-progress, etc.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448964/page_regular/activity-columnpreviews.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjQvcGFnZV9yZWd1bGFyL2FjdGl2aXR5LWNvbHVtbnByZXZpZXdzLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcyNTc1OTA2Mn19fV19&Signature=WS8WrAZhwaNDISIvdQo4mrMhRg7vc~8dOi4iCz~ZCAL6R8I1cY3JvWji3HHvoislbc~qQw-FrfefAxGENHrxFgv1ytAwcBdiLYUDxVxyvGMdOkKBamAuRnVfvKKEybqmgonHodqRv8U~6O2C4v3jZy8pYwOOhGgGMEwdLQXCW6KOx41ZKkjvdjg2AndmmSL0fgae3EuP-Bw2kfzCPX9rSDPMXmm44bQ33Vn0JJ2Jq96CE7~nSX3sejC~95mapIUnQPp0OAlzYqJwUbRBA3bQoCgLwXHSwTwnDI-OBGAsmkjXjCWtp4fN5r2KbiGoZ3s6rW4I~ePcN298AlNMPUSXrg__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Click the Edit Query button to use Intellum's query builder to create a custom query that narrows or broadens the scope of the data included in your Activity Enrollments report.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448965/page_regular/space-281-29.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjUvcGFnZV9yZWd1bGFyL3NwYWNlLTI4MS0yOS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=R4s-sPkeiog2j2mMc1eUtzkYjDqZR35qYzbCvH6ocubc1hkz2WP2VHBypfBWgcsjUv6EQ9v9MdIYnzOuYRIDEi2kP4Av~oGeMQukFt5vuCDTETqYLfHUqzB1mMVvABnsLaU9E-mUIsCt35XHeknzxP0lxpwEsRQj6x16ZrDwEWsuTIwkFR0R0jIj7kiDcUdLW~J~xXNt4IczGn2sW2UfOOY7yJh6xJc0s98W9DWo3QKae-HdLQGqxz0RqGVqR5gjtzRkjyUruWPTQb9hoMDBUHTKkpSfg~WTNLMIyYqUkdIGBaLVgffOEIb9R5vFB7AidqY8RmN08rjfg6s~AmwOsg__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
User enrollments report
User Enrollments reports are like activity enrollments reports, but will include users even if they are not enrolled in an activity. Reports can be filtered using enrollment, activity, event, and user field data available in the platform.
The default User Enrollments Report Query pulls data on activity enrollments that have been completed in the last 90 days - and includes the default option to narrow the report by User ID.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448966/page_regular/user-columns.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjYvcGFnZV9yZWd1bGFyL3VzZXItY29sdW1ucy5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=FBDzUfRiXoBDJ8E4d-wJo6OXlvrMCq8nfgdQqShDGHWhoHoY08ndTEnUT4mZRvZn72yCe~h0mUKcVKIUKpa4ELwK3NGq7KDBclfaqBR7t2BHioblp0Zm6f1kWuf22yqUo9Q0En3GI2YAnl0ZwSLXXBbsRMF4Shl~s9eX5PzoT98mOS~1LHgCycDbQtEbpv29PO05PHBygnay9i3nrr3FsJ2J169yjq6Se~mAERJW7nkyu27Y6YxnrBXRTL7~HDqkxoa0hCI2KTKelBzJ5IE1gSDMRB05EKxIk-xT1CV6k0dN1p-HZmoLxY4QUlHViPSilGoe-5ZpgnwLuZuPQGKWOA__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
The default columns used to organize User Enrollments reports include:
- User Full Name
- Pulled from First Name and Last Name fields in User profiles
- Activities Name
- Pulled from Activity properties
- Enrollment Enrolled On
- A time stamp of the learner's elected, or assigned, enrollment
- Enrollment Type
- Describes an enrollment as required, recommended, elected, etc.
- Enrollment Status
- Describes an enrollment as passed, dropped, in-progress, etc.
![](https://cdn.exceedlms.com/uploads/resource_images/targets/1448967/page_regular/user-columspreview.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzE0NDg5NjcvcGFnZV9yZWd1bGFyL3VzZXItY29sdW1zcHJldmlldy5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3MjU3NTkwNjJ9fX1dfQ__&Signature=WWtqqC1t5d99BX9lyHyhU62~8YgSW~eO4NOh4jYE2~90SW6IJVGHcSaR65SNx-rOtzK88VAA2cpppx81vhHDlLyJ2BsKHeMQ4Q1Zy6P9wV2xQT1adjdKPd0CKvQwqqfw2QYhlNuDwmCunh2GzV4GIEzomW~TaLDQ0x~wTSkyLOf2zSZk58gLWW-CV2dkxccq~IGFq5xyExte8fzRlQSxoCSIYaMpZSXfTwFpy5LVsLcJ09eHo2g7AOCvtm8k~mu3Rwp3Bj679vQ9WktiVJSrBCyPvGChAzHKNMc40NK1jBB1OauNqlhsxZCR4QWo5xrW3QIirK5dm734JE0n9MaRBA__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Click the Edit Query button to use Intellum's query builder to create a custom query that narrows or broadens the scope of the data included in your User Enrollments report.
Learn more about Reports:
Reports | Admin Overview
![](https://cdn.exceedlms.com/uploads/resource_recommended_pictures/targets/1448991/activity_preview/cover-art-5.jpg?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX3JlY29tbWVuZGVkX3BpY3R1cmVzL3RhcmdldHMvMTQ0ODk5MS9hY3Rpdml0eV9wcmV2aWV3L2NvdmVyLWFydC01LmpwZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcyNTg0NTQwMn19fV19&Signature=ZUTaLa3VIrEmKMhSpk-sio5z1IZAWfl~bViaP7opPwgOSAotysbKlph-N-xCcHDEOoXFdwQDBbmd7IXG8U0U3jtqTHGZWpJ10cumc9is~FZi1n3pikkqjNnXKzkC-5uO0q3v6h1tWGL268BF30RZJn~decn~0u2uzVB-1uBhVGdIEb6-df-tF2AKUGWV5mTlgF~EfTucjgKvVEm0S93hyidLameU1yPX9QInSMDstmXf5wsihgammKlGlMwXyRb0b5lJ6kBE8xono-MIwMPkmCTdMmRwaJ1eNW5I-sLhgFtpVjxHqNX7J8EDbxlbzi4ZPrZMQ7QloEt6FNIHNlb9Ag__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
![](https://cdn.exceedlms.com/uploads/resource_images/targets/2461537/page_regular/2021-01-12-16-27-13.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4uZXhjZWVkbG1zLmNvbS91cGxvYWRzL3Jlc291cmNlX2ltYWdlcy90YXJnZXRzLzI0NjE1MzcvcGFnZV9yZWd1bGFyLzIwMjEtMDEtMTItMTYtMjctMTMucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzI1NzU5MDYyfX19XX0_&Signature=fIUnm2bipf8GNVEZTaNKR-klaotQZR1VuH~6wuCleHyGn4i8YCMHvZA1S~I03Yws3Fp9VZuMiLiv1l9WWlidXPnFz8vqp8arG-uPx7o6BqHFELFYzZukRX6tSPFEyw0BiteDxmkEFv-XzUKgldMxulJYcwbtz6yswgR3t79eYfqq2Mo9eNR8LUDEXVs2bcZkaqHVeMGTnIDl6CZQRePdBQvOGGGQDR7VQvBwiwD68ViYkXDQww5xoNErA8rAAguLlT3mtPVtQFBu9L3L0WNtVU~RHzGQFuRwz4CCeXRfGaw5fYC4rqPhRbTSHwHzvKkN630iAEbtzPFt2fWmEnTpmA__&Key-Pair-Id=APKAJINUZDMKZJI5I6DA)
Did this article help?
Let us know by leaving a star rating or review at the top of this article.