This table represents the data available in Personalized Learning data exports until January 11, 2027.
After said date, only the data format shown in Personalized Learning data exports will be available. To help you adapt your processing of these data exports, we've also provided an overview of changes in the new format. Below said table you will also find an overview of possible breaking changes.
Export data structure
| # | Column |
|---|---|
| 1 | Extended Data — one column per field your organisation has configured |
| 2 | Mandant |
| 3 | Customer ID |
| 4 | Campaign |
| 5 | User ID |
| 6 | Firstname |
| 7 | Lastname |
| 8 | |
| 9 | Language |
| 10 | User Group |
| 11 | Created |
| 12 | Registered |
| 13 | Active |
| 14 | Level achieved |
| 15 | Progress |
| 16 | Result |
| 17 | All passed |
| 18 | Passed modules |
| 19 | Overdue mandatory modules |
| 20 | Passed mandatory modules |
| 21 | Passed optional modules |
| 22 | Recently finished module |
| 23 | Module completion details |
Columns 24–44 are specific to Personalized Learning and optional | |
| 24 | Learning Status |
| 25 | Mandatory Modules - Days Overdue |
| 26 | Mandatory Modules - Overdue Count |
| 27 | Mandatory Modules - Overdue (Names) |
| 28 | Mandatory Modules - Next Due Date |
| 29 | Mandatory Modules - Assigned Count |
| 30 | Mandatory Modules - Total Count |
| 31 | Mandatory Modules - Completed Count |
| 32 | Mandatory Modules - Available Count |
| 33 | Mandatory Modules - Available (Names) |
| 34 | Optional Modules - Total Count |
| 35 | Optional Modules - Completed Count |
| 36 | All Modules - Total Count |
| 37 | All Modules - Completed Count |
| 38 | Last Completed Module Name |
| 39 | Last Module Completion Date |
| 40 | Days Since Last Completion |
| 41 | Is Responsible Person |
| 42 | Responsible Person - First Name |
| 43 | Responsible Person - Last Name |
| 44 | Responsible Person - Email |
Changes in the new format
The new format (full details in Personalized Learning data exports) introduces some changes. The following table lists these changes to help you adapt your export data processing.
| Legacy # | Legacy name | New format name | Changes in the new format |
|---|---|---|---|
| 1 | Extended Data | Extended Data | Unchanged |
| 2 | Mandant | Customer Name | Renamed |
| 3 | Customer ID | Customer ID | Unchanged name. Emitted as a number rather than text. |
| 4 | Campaign | Campaign Name | Renamed |
| - | - | Campaign ID • NEW | New. Inserted at position 5 |
| 5 | User ID | User ID | Order changed to 6 |
| 6 | Firstname | User First Name | Renamed. Order changed to 7. |
| 7 | Lastname | User Last Name | Renamed. Order changed to 8. |
| 8 | User Email | Renamed. Order changed to 9. | |
| 9 | Language | User Language | Renamed. Order changed to 10. English becomes en(ISO 639-1). |
| 10 | User Group | User Group | Order changed to 11 |
| 11 | Created | User Created | Renamed. Order changed to 12. |
| 12 | Registered | User Registered | Renamed. Order changed to 13. |
| 13 | Active | User Active | Renamed. Order changed to 14. Yes becomes true, No becomes false. |
| 14 | Level achieved | Level Achieved | Capitalization. Order changed to 15. |
| 15 | Progress | Completion Progress | Renamed. Order changed to 16. |
| 16 | Result | Completion Result | Renamed. Order changed to 17. |
| 17 | All passed | All Modules Passed | Renamed. Order changed to 18. Yes becomes true, No becomes false. |
| 18 | Passed modules | Removed |
Removed from Standardized. Replaced by the new Personalized Learning columns: All Modules - Completed Count & All Modules - Total Count |
| 19 | Overdue mandatory modules | Removed |
Removed from Standardized. Replaced by the New Personalized Learning columns: Mandatory Modules - Overdue Count & Mandatory Modules - Total Count. In drip-fed campaigns use Mandatory Modules - Assigned Count as the denominator instead. |
| 20 | Passed mandatory modules | Removed |
Removed from Standardized. Replaced by the New Personalized Learning columns: Mandatory Modules - Completed Count & Mandatory Modules - Total Count |
| 21 | Passed optional modules | Removed |
Removed from Standardized. Replaced by the New Personalized Learning columns: Optional Modules - Completed Count & Optional Modules - Total Count |
| 22 | Recently finished module | Removed |
Removed from Standardized. Replaced by the New Personalized Learning columns: Last Module Completion Date |
| 23 | Module completion details | Module Completion Details | Capitalization. Order changed to 19. |
Changes that might silently break old data processing automations
| Before (Legacy) | After (Standardization) | What changes |
|---|---|---|
Yes |
true in Excel, "true" in CSV |
Yes / No becomes true / false — affects User Active, All Modules Passed
|
English |
en |
Language now returned as ISO 639-1 locale code. |
| Text | Numeric cells | Identifiers become numbers. A lookup matching an ID as text stops matching. |
| Fixed English | Translated into the export language | Headers have been localized |
'' |
blank in Excel, '' in CSV |
Empty cells |
| Column positions have changed | See mapping table above | Positional parsers may need index adjustments |