Raw 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

​Transactional Message ID​

sentToMTA.ExternalTransactionId

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

A transactional message includes a unique ID for every contact. This ID lets you 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

​Subject (Personalised)​

sendout.Subject.Resolved

Shows the subject line of the message, including the resolved personalisation for each recipient (for example, "Happy Birthday, Sam" instead of "Happy Birthday, <%user.firstname%>").

​Sendout Channel​

sentToMTA.SendoutChannel

Shows the channel that is used for sendout. The following channels are possible:

• Email

• Mobile

• Fax

Currently, fax indicates the mobile push channel.

String / enum

6 characters

​Timestamp​

skip.Timestamp

Shows the time when the recipient was skipped in the message sendout. Skipped messages are sorted out before sendout for various reasons. For example, an address that 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

​Transactional Message ID​

skip.ExternalTransactionId

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

A transactional message includes a unique ID for every contact. This ID lets you track every message individually and to 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

​Timestamp​

bounce.Timestamp

Shows the time when the message generated a bounce response. A bounce is a message that Engage sent to a contact address but the receiving Mail Transfer Agent (MTA) rejected. There are two types of bounces:

• ​Hard Bounce:​ Permanent delivery failures such as a misspelled email address.

• ​Soft Bounce:​ Transient delivery failures such as a full inbox.

Messages that go into the spam folder or that are answered through automatic replies such as out of office messages are not counted as bounces.

ISO 8601 timestamp

20 numbers and characters

​Category​

bounce.Category

Shows the category of the bounce. The category provides detailed information about exactly what prevented the delivery of the message to a contact or what happened once the message arrived.

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

​Text​

bounce.Text

Shows the automated notification-message which the receiving mail server sent to Engage about a delivery problem (if text is available). Engage shows the first 1,000 characters of the notification text.

String

1000 characters

​Timestamp​

feedback.Timestamp

Shows the timestamp of the feedback. This class describes messages that are delivered to the inbox of a recipient. However, delivery of the message causes a reaction which is sent back to Engage. For example, a spam complaint or an automated out-of-office reply. Both external internet service providers and contacts can generate ​feedback​ responses.

ISO 8601 timestamp

20 numbers and characters

​Category​

feedback.Category

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

• ​Complaint:​ Shows feedback from the recipient that the receiving MTA reports to Engage. For example, a spam complaint.

• ​Autoresponder:​ Shows feedback from the recipient that is sent automatically from the email client of the recipient to Engage. For example, an out of office message.
  
  

String / enum

13 characters

​Timestamp​

render.Timestamp

Shows the time that the recipient opened the message. Based on which event Engage records first, this time is either when the tracking pixel downloads from the Engage server or the first link click.

ISO 8601 timestamp

20 numbers and characters

​Country​

render.GeoLocation.ISOCountryCode

Shows the 2-letter ISO country code of the recipient. The country is based on the IP address to which the tracking pixel is downloaded from the Engage server.

For a list of all ISO country codes, see http://en.wikipedia.org/wiki/ISO_3166-1.

String / enum

2 characters

​Region​

render.GeoLocation.RegionCode

Shows the 2-letter geolocation region code of the recipient. The region is based on the IP address to which the tracking pixel is downloaded from the Engage server.

Region codes for the US and Canada are: ISO-3166-2 code. Region codes for all other countries are: FIPS 10-4. For more information, see http://en.wikipedia.org/wiki/ISO_3166-2.

String / enum

2 characters

​City​

render.GeoLocation.City

Shows the city of the recipient. The city is based on the IP address to which the tracking pixel is downloaded from the Engage server.

Region codes for the US and Canada are: ISO-3166-2 code. Region codes for all other countries are: FIPS 10-4. For more information, see http://en.wikipedia.org/wiki/ISO_3166-2.

String

Unlimited

​Latitude​

render.GeoLocation.Latitude

Shows the latitude of the recipient. The latitude is based on the IP address to which the tracking pixel is downloaded from the Engage server.

The latitude and longitude are resolved to the city level only, and cannot precisely pinpoint the location of the contact.

String

Unlimited

​Longitude​

render.GeoLocation.Longitude

Shows the longitude of the recipient. The longitude is based on the IP address to which the tracking pixel is downloaded from the Engage server.

The latitude and longitude are resolved to the city level only, and cannot precisely pinpoint the location of the contact.

String

Unlimited

​Platform​

render.UserAgent.Platform

Shows the type of device on which the tracking pixel is downloaded from the Engage server with the user agent string. The device type is recorded for all opens, renders, and clicks.

The following platforms are possible: mobile, desktop, or tablet.

String

Unlimited

​Operating System Name​

render.UserAgent.OperatingSystemName

Shows the name of the operating system on which the tracking pixel is downloaded from the Engage server with the user agent string.

For example, iOS and Windows.

String

Unlimited

​Operating System Version​

render.UserAgent.OperatingSystemVersion

Shows the version of the operating system (for example, 7) on which the tracking pixel is downloaded from the Engage server with the user agent string.

String

Unlimited

​Email Client Name​

render.UserAgent.ClientName

Shows the name of the email client on which the tracking pixel is downloaded from the Engage server with the user agent string.

For example, Microsoft Outlook.

String

Unlimited

​Email Client Version​

render.UserAgent.ClientVersion

Shows the email client version on which the tracking pixel is downloaded from the Engage server with the user agent string.

For example, 2007 or 2010.

String

Unlimited

​Timestamp​

click.Timestamp

Shows the time of the link click.

ISO 8601 timestamp

20 numbers and characters

​Link ID​

click.Link.Id

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

Number

10 digits

​Link Category Name​

click.Link.Category.Name

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

String

20 characters

​Link Category ID​

click.Link.Category.Id

Shows the ID of the link category that is assigned to the clicked link. 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 personalisations.

String

Unlimited

​Link Type​

click.Link.Type

Shows the type of link that was clicked.

• ​Normal​: The link is a normal link, that is, it is not a system link or a personalised link.

• ​Individual​: This link contains a personalisation.

• ​System​: The link is a system link.

String / enum

10 characters

​Type of System Link​

click.Link.SystemLinkType

Shows the type of system link that was clicked.

The following values are possible:

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

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

• forward_message: Opens a form to forward the message with the Engage forward feature.

• subscribe: Opens a website where the contact can subscribe to the group.

• unsubscribe: Opens a website where the contact can unsubscribe from the group.

String / enum

15 characters

​Country​

click.GeoLocation.ISOCountryCode

Shows the 2-letter ISO country code of the recipient. The country is based on the IP address to which the tracking pixel is downloaded from the Engage server.

For a list of all ISO country codes, see http://en.wikipedia.org/wiki/ISO_3166-1.

String / enum

2 characters

​Region​

click.GeoLocation.RegionCode

Shows the 2-letter geolocation region code of the recipient. The region is based on the IP address to which the tracking pixel is downloaded from the Engage server.

Region codes for the US and Canada are: ISO-3166-2 code. Region codes for all other countries are: FIPS 10-4. For more information, see http://en.wikipedia.org/wiki/ISO_3166-2.

String / enum

2 characters

​City​

click.GeoLocation.City

Shows the city of the recipient. The city is based on the IP address to which the tracking pixel is downloaded from the Engage server.

String

Unlimited

​Latitude​

click.GeoLocation.Latitude

Shows the latitude of the recipient. The latitude is based on the IP address from which the link is clicked.

The latitude and longitude are only resolved to the city level and cannot precisely pinpoint the location of the contact.

String

Unlimited

​Longitude​

click.GeoLocation.Longitude

The longitude of the recipient. The longitude is based on the IP address from which the link is clicked.

The latitude and longitude are only resolved to the city level and cannot precisely pinpoint the location of the contact.

String

Unlimited

​Platform​

click.UserAgent.Platform

Shows the device on which the link is clicked. The platform is based on the user agent string.

The following values are possible:

• Mobile

• Desktop

• Tablet

String

Unlimited

​Operating System Name​

click.UserAgent.OperatingSystemName

Shows the name of the operating system of the device on which the link is clicked. The operating system is based on the user agent string.

For example, Windows and IOS.

String

Unlimited

​Operating System Version​

click.UserAgent.OperatingSystemVersion

Shows the version of the operating system of the device on which the link is clicked. This is derived from the user agent string.

For example, 8 for iOS version number 8.

String

Unlimited

​Email Client Name​

click.UserAgent.ClientName

Shows the name of the computer program that the recipient used to view or open the email as derived from the user agent string. The email client is the Mail User Agent (MUA).

Access to email in a web-based email account is recorded with the ​Browser Name​ and ​Browser Version​.

For example, Outlook and Apple Mail.

String

Unlimited

​Email Client Version​

click.UserAgent.ClientVersion

Shows the version of the computer program that the recipient used to view or open the email. This is derived from the user agent string.

For example, 2010 and 11.0.

String

Unlimited

​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 numbers and 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​.

Each forward displays in a separate row in the import file.

ISO 8601 timestamp

20 numbers and characters

​Timestamp​

conversion.cp.Timestamp

Shows the time of the conversion.

ISO 8601 timestamp

20 numbers and characters

​ID​

conversion.cp.Id

Shows the ID of the conversion. For more information, see ​Conversion Tracking​.

Number

10 Digits

​Name​

conversion.cp.Name

Shows the name of the conversion. For more information, see ​ Conversion Tracking​.

String

200

​Order ID​

conversion.cp.OrderId

Shows the order ID. The shop system or website must communicate this information to Engage.

String

30

​Number​

conversion.cp.ItemCount

Shows the number of items that were ordered. The shop system or website must communicate this information to Engage.

Number

9

​Amount​

conversion.cp.Amount

Shows the value of the total sales. The shop system or website must communicate this information to Engage.

Number

12

​Additional Parameters​

conversion.cp.RequestParameters

Shows more parameters, if the shop system or website communicates this information to Engage.

String

Unlimited

​User ID​

user.Id

Shows the ID of the recipient. Engage assigns the ID automatically when the contact or system user 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 recipient. Engage uses the email address for internal identification of the contact or system user. The email address is unique in the system but can be edited. Therefore, the email address can vary from the address in the export file.

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 of the recipient. The application provider assigns this number to the user of the application. Engage stores the ID in the profile of the contact.

String

Unlimited

​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 is manually defined. Otherwise, this column is empty.

String

Unlimited

​Alternate Email​

user.AlternateEmail

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

String

129 characters

​Alternate Mobile​

user.AlternateMobile

Based on the system configuration, 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. The ID is internal identification number that Engage assigned automatically to the group when the group was created. The ID of the group is unique in the system.

Number

10 digits

​Name​

group.Name

Shows the name of the group in which the message is sent. The creator of the group defines the name.

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 ID of the category to which the group is assigned. Engage assigns the group category ID automatically when the category is created. The ID is used for internal identification and is unique in the system.

Number

10 digits

​Category Name​

group.Category.Name

Shows the group category name. Assignment of a group category is optional. The creator of the category defines the name.

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

String

250 characters

​ID​

message.Id

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

Number

10 digits

​Name​

message.Name

Shows the message name. The author of the message defines the name during the message creation process. The message name is used for internal identification in the system and does not need to be unique.

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

​Category Name​

message.Category.Name

Shows the message category name. Assignment of a message category is optional. The creator of the message can assign a category during the message sendout process.

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

For more information, see ​Message Category​.

String

250 characters

​Subject (Not Personalized)​

message.Subject.Unresolved

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

String

Unlimited

​External Message ID​

message.ExternalId

Shows the external message ID of the message. The external message ID is an 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

The variation ID of the message. Engage assigns a variation ID automatically when the 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

​ID​

selection.Id

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

Number

10 digits

​Name​

selection.Name

Shows the selection name. The creator of the selection defines the name. The name must be unique in the system but can be edited.

String

100 characters

​Event Timestamp​

record.Timestamp

Shows the timestamp of the event. This field is always a duplicate of the column that contains the specific timestamp. For example, the render timestamp or click timestamp.

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

ISO 8601 timestamp

20 numbers and characters

​Event Type​

record.Type

Shows the type of event.

The following types are possible:

• SentToMTA

• Skips

• Bounces

• Feedback

• Renders

• Clicks

• Forwards

• Conversions

• Unsubscribes

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.

For example, if the event is a link click in message A, this field shows the sent to MTA timestamp of message A.

This information uniquely 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 lets you 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

Addressee Role​

sendout.AddresseeRole

Shows the role of the addressee.

The following values are possible:

• NORMAL.

• CONTROL.

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

Gender

user.Gender

Shows the gender of the contact:

• unset

• male

• female

• undisclosed

Number

​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. This value 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

Name of the attribute

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.

Name of the attribute

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.

Name of the attribute

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.