Simplified Data Export File

​Timestamp​

sentToMTA.Timestamp

Shows the time when the message was transferred the first time to the Mapp MTA in preparation for sendout to the MTA of the contact.

ISO 8601 timestamp

20 numbers and characters

​Timestamp​

skip.Timestamp

Shows the time when the address was skipped in the message sendout. Skipped messages are sorted out before sendout for a various reasons (for example, the address is deactivated system-wide). These messages never leave the Mapp infrastructure.

ISO 8601 timestamp

20 numbers and characters

​Category​

skip.Category

Shows the reason why the message was skipped.

The following values are possible:

• CHANNEL_NO_ADDRESS

• CHANNEL_READ_MODE_DENIED

• INVALID_ENCRYPTED_ADDRESS

• INVALID_ALTERNATE_ADDRESS

• SYS_OVER_BOOKED

• USR_OVER_BOOKED

• SYS_BLACKLIST_ROBINSON

• GRP_BLACKLISTED

• SYS_BOUNCED

• GRP_BOUNCED

• EXTERNAL_ATTRIBUTE_FILTER

• SKIP_RECIPIENT

• INTERCEPTOR_FAILED

• PERSONALIZATION_FAILED

• SEND_FAILED

• GLOBAL_ROBINSON

• INVALID_ADDRESS

• TEMP_COMMUNICATION_FAILURE

For more information, see ​Skip Categories in Exports​.

String / enum

26 characters

​Timestamp​

bounce.Timestamp

Shows the time when the message generated a bounce response. A bounce is a message that Engage sent, but the MTA of the recipient refused to accept. For example, a message that is sent to an address that does not exist at the domain. For more information, see Message Sendout Process​.

ISO 8601 timestamp

20 numbers and characters

​Category​

bounce.Category

Shows the category of the bounce. The bounce category provides detailed information about what prevented the delivery of the message to a contact. Or, information about what happened once the message arrived in the inbox of the recipient.

The following categories are possible:

• Transient: Indicates issues such as a full inbox or a lack of available disk space.

• Blocked: Indicates that either the receiving MTA or the recipient refuses to accept delivery of a message (for example, because the sending address appears on a blocklist).

• Rejected: Indicates that an address no longer exists or the email account is not active.

• Unknown: Indicates that the exact cause of the delivery failure cannot be determined.

String / enum

9 characters

Timestamp

feedback.Timestamp

Shows the time of the first spam complaint.

ISO 8601 timestamp

20 numbers and characters

​Timestamp​

open.Timestamp

Shows the time that the contact first opened the message. The time is based on which event Engage records first. The event is either the time when the tracking pixel downloads from the Engage server or the first time the contact clicks a link.

ISO 8601 timestamp

20 numbers and characters

​Timestamp​

click.Timestamp

Shows the timestamp of the first link click in the message.

ISO 8601 timestamp

20 numbers and characters

​Timestamp​

clickLink.Timestamp

Shows the time of the first link click.

ISO 8601 timestamp

20 characters

​Link Category Name​

click.Link.Category.Name

Shows the name of the link category that is assigned to the clicked link (if a link category was assigned). For more information, see ​Link Categories​.

String

200 characters

​Link Category ID​

click.Link.Category.Id

Shows the ID of the link category that is assigned to the clicked link. Engage automatically assigns the ID. The link category ID cannot be changed. For more information, see ​Link Categories​.

Number

10 digits

​URL​

click.Link.URL

Shows the URL of the clicked link including any resolved personalizations.

String

Unlimited number of characters

​Link ID​

click.Link.Id

Shows the link ID of the clicked link. Engage automatically assigns the link ID during sendout. Each link in the message is numbered consecutively. The numbering starts with 0 (null).

Number

10 digits

​Link Type​

click.Link.Type

Shows the type of link. The following types of links are possible:

• Normal: The link is not a system link and does not contain a personalisation.

• Individual: The link contains a personalisation.

• System: The link is a system link. The following types of system links are possible:

String / enum

10 characters

​Type of System Link​

click.Link.SystemLinkType

Shows the type of system link. The following types of system links are possible:

• read_message: This link opens the message in the web browser. This method bypasses display problems in the email client.

• profile_edit: This link opens a form in the web browser where the contact can edit their profile data.

• forward_message: This link opens a form to forward the message with the Engage forward functionality

• subscribe: This link opens a website where the contact can subscribe to the group.

• unsubscribe: This link opens a website where the contact can unsubscribe from the group.

String / enum

15 characters

​Timestamp​

forward.Timestamp

Shows the time when the message was forwarded. Only forwards made with the Engage forward function are tracked. For more information, see ​Mapp Engage Variables - Messages​.

ISO 8601 timestamp

20 characters

​Timestamp​

unsubscribe.Timestamp

Shows the time when the contact unsubscribed. The unsubscription must be made via the unsubscribe link in the message. Unsubscribes that cannot be attributed to a message that is contained in the export are not included in the export.

ISO 8601 timestamp

20 characters

​User​ ID

user.Id

Shows the ID of the contact in Engage. Engage The ID automatically assigns the ID when the contact is created. The ID is used for internal identification and is unique in the system.

Number

10 digits

​Email​

user.Email

Shows the email address of the contact in Engage. The email address is used for internal identification and is unique in the system. The email address is defined when the contact is created. This email address is editable. The email address can be edited between the time of the sendout and the export. In this case, the email address in the export no longer matches the address that performed the activity.

String

129 characters

​Mobile Number​

user.MobileNumber

Shows the mobile phone number of the contact.

String

18 characters

​App Alias​

user.AppAlias

Shows the mobile app ID that is saved in the profile of the contact in Engage. The application provider assigns this number to the contact that uses of the application.

String

Unlimited number of characters

​Identifier​

user.Identifier

Shows an additional identifier for the contact in the Engage system (for example, the ID of an external CRM system). The identifier must be manually defined. Otherwise, this column is empty.

String

Unlimited number of characters

​Alternate Email​

user.AlternateEmail

Based on the system configuration, this field shows the actual email address of the contact.

String

129 characters

​Alternate Mobile​

user.AlternateMobile

Based on the system configuration, this field shows the actual mobile phone number of the contact.

String

18 characters

​ID​

group.Id

Shows the ID of the group in which the message is sent. When the group is created, Engage automatically assigns a group ID. The ID is used for internal identification and is unique in the system.

Number

10 digits

​Name​

group.Name

Shows the name of the group in which the message is sent.

String

150 characters

​Email​

group.Email

Shows the email address of the group in which the message is sent. The group email address is unique in the system.

String

129 characters

​Category ID​

group.Category.Id

Shows the group category ID. Engage automatically assigns the ID, when the category is created. The category ID is used for internal identification and is unique in the system.

Number

10 digits

​Category Name​

group.Category.Name

Shows the name of the group category. The creator of the group category defines the name. The name can be changed in the ​Administration​ area.

String

200 characters

​ID​

message.Id

Shows the message ID. Engage automatically assigns the message ID when the message is created. The ID is used for internal identification and is unique in the system.

Number

10 digits

​Name​

message.Name

Shows the message name. The creator of the message defines the name of the message. The name is used for internal identification in the system.

String

250 characters

​Category ID​

message.Category.Id

Shows the message category ID. Engage automatically assigns the category ID when the category is created. The ID is unique in the system. Assignment of a message category is optional. Message categories are assigned during the message sendout process.

Number

10 digits

C​ategory Name​

message.Category.Name

Shows the message category name. The creator of the category name can edit the name in the ​Administration​ area of Engage.

String

200 characters

​Subject (Not Personalised)​

message.Subject.Unresolved

Shows the message subject including any personalisation placeholders. Personalizations appear as unresolved placeholders in this field (for example: Happy Birthday, <%${user['FirstName']}%>!).

String

Unlimited number of characters

​External Message ID​

message.ExternalId

Shows the external message ID of the message. The external message ID is extra reference number that can be manually added to a message during creation.

String

250 characters

​Type​

message.Type

Shows the type of message. The following types are possible:

• normal

• split_main

• split_test

• single

• super

• sub

• test

• pre_split_main

• system

For more information, see ​Analysis of Different Message Types​.

String / enum

15 characters

​Variation ID​

message.Variation.Id

If variations of a message are created, this field shows the variation ID. Engage automatically assigns the ID when the message variants are created. The variation ID is a comma-separated list of ID numbers or names. If no variations exist for a message, this field is empty. For more information, see ​Variation Analysis (tab)​.

String

Unlimited number of characters

​ID​

selection.Id

If a selection is applied, this field shows the selection ID. Engage The automatically assigns the ID when the selection is created. The ID is used for internal identification and is unique in the system.

Number

10 digits

​Name​

selection.Name

Shows the selection name. The system user who creates the selection defines the name of the selection. The name can be edited in the ​Selection​ area of Engage.

String

100 characters

​Event Timestamp​

record.Timestamp

Shows the time when the event took place. This field is a duplicate of the column that contains the specific timestamp (for example, the open timestamp or click timestamp).

With the ​Event Type​, this information facilitates the processing and analysis of data.

ISO 8601 timestamp

20 characters

Event Type

record.Type

Shows the type of event.

The following types are possible:

• FirstSentToMTA

• FirstSkip

• FirstBounce

• FirstSpamComplaint

• FirstConfirmedOpen

• FirstClick

• FirstClickPerLink

• FirstForward

• FirstConversion

• FirstConversionPerId

• FirstUnsubscribe

For more information, see ​Message Sendout Process​, ​KPIs - Group Messages​, and ​KPIs - Single Messages​.

For more information, see ​Skip Categories in Exports​.

String / enum

24 characters

​Sendout Type​

sendout.Type

Shows the type of sendout.

The following types are possible:

• MAJOR: The message was sent as a group message.

• SINGLE: The message was sent as a single message.

• WELCOME: The message was sent as a welcome message.

• SYSTEM: The message was sent as a system message.

String / enum

7 characters

​Timestamp​

record.sentToMTA.Timestamp

Shows the sent to MTA timestamp of the message to which the event belongs.

Example: if the event is a link click in message A, this field shows the sent to MTA timestamp of message A

This information identifies single messages. The sent to MTA timestamp is available for all group and single messages.

ISO 8601 timestamp

20 numbers and characters

​Transactional Message ID​

record.ExternalTransactionID

Shows the transactional message ID (TMID) of the message to which the event belongs. If no TMID was used for sendout, this column is empty.

A transactional message includes a unique ID for every contact. This ID allows you to track every message individually and confirm that the contact receives and opens the message. You create a pattern for the TMID in the group settings. For more information, see ​Add a TMID to Messages​.

String

Unlimited number of characters

​Contact Information​

sendout.RecipientType

Shows how the recipient was contacted.

The following values are possible:

• TO: The recipient was sent a message.

• CC: The recipient was sent email in carbon copy.

• BCC: The recipient was sent email in blind carbon copy

String / enum

7 characters

Addressee Role

sendout.AddresseeRole

Shows the role of the addressee.

• NORMAL: The contact has a normal role in the system.

• CONTROL: The contact has a role other than the normal role in the system.

String / enum

7 characters

​Date of Birth​

user.DateOfBirth

Shows the date of birth of the contact.

Date

28 characters

​First Name​

user.FirstName

Shows the first name of the contact.

String

50 characters

​Last Name​

user.LastName

Shows the last name of the contact.

String

50 characters

Shows the gender of the contact:

• unset
• male
• female
• undisclosed

​Nickname​

user.NickName

Shows the preferred name of the contact.

String

50 characters

​Zip Code​

user.ZipCode

Shows the postal code of the contact.

String

10 characters

​Country Code​

user.ISOCountyCode

Shows the ISO 3166 country code that is saved in the profile of the contact. The country code is not based on an IP location.

For more information, see http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2.

String / enum

2 characters

​Language Code ​

user.ISOLanguageCode

Shows the ISO 639 language code that is saved in the profile of the contact.

For more information, see http://en.wikipedia.org/wiki/ISO_639.

String / enum

2 characters

​Time Zone​

user.TimeZone

Shows a number that represents the time zone that is saved in the profile of the contact.

Number

3 digits

​Title​

user.Title

Shows a number that represents the gender of the contact. When the gender is unknown, this field is empty.

The following values are possible:

• 0 = male

• 1 = female

String / enum

1 character

​Source ID​

user.PartnerId

Shows an ID which identifies the source of the address (for example, an agency or a company website).

Number

5 digits

Attribute Name

CSV-Export: user.CustomAttribute['attributename']

Example:

user.CustomAttribute['hobby']

Contains a custom attribute.

XML-Export: <field name="user.CustomAttribute['attributename']">value</field>

Example:

<field name="user.CustomAttribute['hobby']">soccer</field>

Contains a custom attribute.

Attribute Name

CSV-Export: user.MemberAttribute['attributename']

Example:

user.MemberAttribute['hobby']

Contains a member attribute.

XML-Export: <field name="user.MemberAttribute['attributename']">value</field>

Example:

<field name="user.MemberAttribute['hobby']">soccer</field>

Contains a member attribute.

Attribute Name

CSV-Export: group.CustomAttribute['attributename']

Example:

group.CustomAttribute['communicationID']

Contains a group attribute.

XML-Export: <field name="group.CustomAttribute['atributensme']">value</field>

Example:

<field name="group.CustomAttribute['communicationID']">12345</field>

Contains a group attribute.