This article provides a detailed overview of the raw data export for Personalized Learning.
We have improved our Personalized Learning raw data exports, making them more consistent and useful for you. The following table represents the data you will receive after October 13, 2026. The corresponding table for legacy exports as well as an overview of possible breaking changes is provided in Legacy Personalized Learning data exports. Legacy exports will continue to be available until January 11, 2027.
Current raw data export structure
| # | Column | What it contains | Possible values |
|---|---|---|---|
| 1 | Extended Data | Adds one column per field your organisation has configured. | Depends on your organization's configuration |
| 2 | Customer Name | Official name of the customer in the SoSafe Manager. | Text |
| 3 | Customer ID | Internal SoSafe Customer ID | Positive integer |
| 4 | Campaign Name | Specific learning campaign to which the user is assigned to. | Text |
| 5 | Campaign ID | ID of the corresponding campaign | Positive integer |
| 6 | User ID | Internal SoSafe User ID. Used for internal tracking and analytics across learning modules. | Positive integer |
| 7 | User First Name | User’s given name, pulled from the identity provider or user import file. | Text · blank if not set |
| 8 | User Last Name | User’s family name, pulled from the identity provider or user import file. | Text · blank if not set |
| 9 | User Email | User's email address. This is their unique login credential and also the primary channel for email-based training delivery. | Text (email address) |
| 10 | User Language | Language in which the user receives their training content. | ISO 639-1 language code (e.g. en, de, fr) |
| 11 | User Group | Organizational group or groups to which the user belongs. The content depends on the customer’s feature configuration: If Profile-Based Personalization is enabled: • The column will display all user groups the individual user belongs to. • Groups are shown in alphabetical order, separated by a delimiter. • These groups are used to determine role-based content or risk-based personalization. If Profile-Based Personalization is not enabled: • The column will show the user's group, as imported from your connected identity provider (e.g. Microsoft Entra, Okta) or your manual user upload. • Each user will belong to exactly one group. |
Text · delimiter-separated list when Profile-Based Personalization is enabled |
| 12 | User Created | User SoSafe account creation date. This is when the user was first imported or synced, but not necessarily when training began. | ISO date |
| 13 | User Registered | User training registration date. This is when the user registered and logged into the E-Learning Platform the first time. | ISO date · blank if the user has never registered |
| 14 | User Active | Indicates whether the user is currently considered an active learning account in the system. |
true · false
|
| 15 | Level Achieved | Achieved level on the E-Learning Platform. | Positive integer |
| 16 | Completion Progress | Numerical value that reflects a user’s progression through their assigned learning path. |
0–100
|
| 17 | Completion Result |
0–100
|
|
| 18 | All Modules Passed |
Flag that indicates whether the user has completed all assigned modules. It includes both mandatory and optional ones based on the filter set in the Analytics dashboard at the time of download. This column is helpful for quickly filtering users who have fully completed their training. |
true · false
|
| 19 | Module completion details | Adds one column per module in the campaign as a column header, with date of completion, or blank if not completed yet. |
ISO date · blank if not completed |
Columns 20–40 are specific to Personalized Learning. | |||
| 20 | Learning Status | The user's stage in the e-learning funnel |
Invited · Registered · On Track · Overdue · Completed
|
| 21 | Mandatory Modules - Days Overdue | Days since the earliest overdue mandatory module's due date. When several are overdue it always uses the earliest. | Whole number. blank rather than 0 when nothing is overdue, so an average over this column counts only the people who are overdue. |
| 22 | Mandatory Modules - Overdue Count | Mandatory modules past their due date and not completed | Whole number — is 0 when there are no overdue modules. |
| 23 | Mandatory Modules - Overdue (Names) | Names of those modules, earliest due date first | List · blank if none |
| 24 | Mandatory Modules - Next Due Date | Due date of the earliest incomplete mandatory module. May be in the past if it is overdue. | ISO date · blank if all completed |
| 25 | Mandatory Modules - Assigned Count | Mandatory modules currently assigned. In drip-fed campaigns this increases over time as modules release. Equals Total in fixed campaigns. | Whole number |
| 26 | Mandatory Modules - Total Count | Total mandatory modules in the learning path. Set at campaign creation and does not change. | Whole number |
| 27 | Mandatory Modules - Completed Count | Assigned mandatory modules the user has completed | Whole number |
| 28 | Mandatory Modules - Available Count | Assigned but not yet completed, including overdue ones. Assigned minus Completed. | Whole number |
| 29 | Mandatory Modules - Available (Names) | Names of those modules, earliest due date first | List of module names separated by comma · blank if none |
| 30 | Optional Modules - Total Count | Total optional modules in the learning path, including completed | Whole number |
| 31 | Optional Modules - Completed Count | Optional modules completed to date | Whole number |
| 32 | All Modules - Total Count | Total number of Mandatory and Optional modules combined | Whole number |
| 33 | All Modules - Completed Count | Number of completed Mandatory and Optional modules combined | Whole number |
| 34 | Last Completed Module Name | Name of the most recently completed module, mandatory or optional |
Text · blank if none completed |
| 35 | Last Module Completion Date | When that module was finished | ISO date · blank if none completed |
| 36 | Days Since Last Completion | Days between that date and today | Whole number. blank rather than 0 when the user has completed nothing, so an average counts only the people who have completed something. |
| 37 | Is Responsible Person | Whether this user is responsible for one or more others — a manager or team lead |
true · false · blankBlank means the tenant hasn't configured it, or the person is a top-level manager |
| 38 | Responsible Person - First Name | First name of the person responsible for this user's progress |
Text · blank if none assigned |
| 39 | Responsible Person - Last Name | Last name of that person |
Text · blank if none assigned |
| 40 | Responsible Person - Email | Their email. Primary contact for follow-up |
Text · blank if none assigned |