This article provides a detailed overview of the raw data export for Simulations.
We have improved our Simulation 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 Simulation data exports. Legacy exports will continue to be available until January 11, 2027.
Current raw data export structure
| # | Column name | What it contains | Possible values |
|---|---|---|---|
| 1 | Customer Name | Name of the customer | Text · blank if not set |
| 2 | Customer ID | ID of the customer | Number · blank if not set |
| 3 | Campaign Name | Name of the simulation campaign | Text · blank if not set |
| 4 | Campaign ID | ID of the simulation campaign | Number · blank if not set |
| 5 | Template ID | Unique identifier of the email template | Number · blank if not set |
| 6 | Template Name | Language-specific template name, localized | Text · blank if not set |
| 7 | Email Subject | Subject line of the simulation email, localized | Text · blank if not set |
| 8 | Email Sender | Sender's email address | Text · blank if not set |
| 9 | User Email | User's email address | Text · blank if not set |
| 10 | User First Name | User's first name | Text · blank if not set |
| 11 | User Last Name | User's last name | Text · blank if not set |
| 12 | User Language | User's preferred language | Text · blank if not set.ISO codes: en - Englishde - German… |
| 13 | User Group | User's organizational group. Multiple values are separated by semicolons for PBP groups. | Text · blank if not set |
| 14 | Mail Status | Current mail status of the email delivery | Text (e.g. Delivered)Codes: 2 - Successful 4 - Temporary error 5 - Failed (hard error) 6 - Error before send |
| 15 | Sent | Date the email was sent | ISO date-time · blank if not sent |
| 16 | Opened | Date the email was opened | ISO date-time · blank if not opened |
| 17 | Clicked | Date the user clicked a link | ISO date-time · blank if not clicked |
| 18 | Interacted | Date the user interacted with the landing page | ISO date-time · blank if none |
| 19 | Learned | Date the user visited the learning page | ISO date-time · blank if none |
| 20 | Replied | Date the user replied to the email | ISO date-time · blank if none |
| 21 | Reported | Date the user reported the email | ISO date-time · blank if none |
| 22 | Mobile | Whether the user clicked on a mobile device |
true · false
|
| 23 | Landing Page | Whether the template has a landing page |
true · false
|
| 24 | Extended Data | Adds one column per extended data field your organisation has configured. Always at the end of the report. | Values depend on customer field configuration |