This table represents the data available in Simulation data exports until January 11, 2027.
After said date, only the data format shown in Simulation data exports will be available. To help you adapt your processing of these data exports
Below the table you will also find an overview of possible breaking changes.
Legacy export data structure
| # | Column |
|---|---|
| 1 | Tenant |
| 2 | Campaign |
| 3 | Template ID |
| 4 | Template Name |
| 5 | Subject |
| 6 | Sender |
| 7 | |
| 8 | Firstname |
| 9 | Lastname |
| 10 | Language |
| 11 | User Group |
| 12 | Mail Status |
| 13 | Sent |
| 14 | Opened |
| 15 | Clicked |
| 16 | Interacted |
| 17 | Learned |
| 18 | Replied |
| 19 | Reported |
| 20 | Mobile |
| 21 | Landing Page |
| 22 | Extended Data |
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 header (Before) | Standardized header (After) | What changed |
|---|---|---|---|
| 1 | Tenant (customerName) | Customer Name | Renamed. blank values are returned as blank instead of '' |
| - | – | Customer ID (customerId) NEW | New. Placed directly after Customer Name. With custom column selection, only if requested |
| 2 | Campaign (campaignName) | Campaign Name | Renamed. Empty values are returned as blank instead of '' |
| - | – | Campaign ID (campaignId) NEW | New. Placed directly after Campaign Name. Same rules as Customer ID |
| 3 | Template ID | Template ID | Unchanged |
| 4 | Template Name | Template Name | Empty values are returned as blank instead of '' |
| 5 | Subject | Email Subject | Renamed. Empty values are returned as blank instead of '' |
| 6 | Sender | Email Sender | Renamed. Empty values are returned as blank instead of '' |
| 7 | User Email | Renamed. Can now be empty | |
| 8 | Firstname | User First Name | Renamed. Can now be empty |
| 9 | Lastname | User Last Name | Renamed. Can now be empty |
| 10 | Language | User Language | Renamed and returns ISO language codes. Empty values are returned as blank instead of '' |
| 11 | User Group | User Group | Empty values are returned as blank instead of '' |
| 12 | Mail Status | Mail Status | Empty values are returned as blank instead of '' |
| 13 | Sent | Sent | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 14 | Opened | Opened | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 15 | Clicked | Clicked | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 16 | Interacted | Interacted | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 17 | Learned | Learned | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 18 | Replied | Replied | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 19 | Reported | Reported | Type has changed to ISO date format. Empty values are blank in Excel instead of null. |
| 20 | Mobile | Mobile | Yes / No becomes true / false |
| 21 | Landing Page | Landing Page | Yes / No becomes true / false |
| 22 | Extended Data | Extended Data | Unchanged. Always at the end of the report |
Changes that might silently break old data processing automations
| Before (Legacy) | After (Standardization) | What changes |
|---|---|---|
Tenant, Campaign, Subject, Sender, Email, Firstname, Lastname, Language | Customer Name, Campaign Name, Email Subject, Email Sender, User Email, User First Name, User Last Name, User Language | Renamed column headers. Scripts/lookups matching the old names will stop matching. |
true / false (Mobile), localized Yes / No (Landing Page) | Native booleans in Excel, true / false in CSV | Boolean values for "Mobile" and "Landing Page" |
null for empty dates in Excel, '' for empty strings | Blank cell in Excel, empty field in CSV | Empty cells. Applies to template name, subject, sender, first and last name, language, user group, email, customer name and campaign name, and to the date columns in Excel |
| - | Customer ID, Campaign ID (optional, NEW) | Two new columns. When included, they are inserted after Customer Name and Campaign Name, so all later columns shift by one or two positions. Anything reading by position breaks |