Contents x
      Export Options in Mapp Engage
      • 6 Minutes to read
      • Print
      • Dark
        Light
      Contents

      Export Options in Mapp Engage

      • 6 Minutes to read
      • Print
      • Dark
        Light
      Article summary

      Engage stores very large amounts of data related to your email marketing campaigns. This includes profile data (addresses, personal data and preferences), recipient activity (clicks, opens and conversions), contact context information, and information about messages, groups and your system. Storage of such large amounts of data is made possible by our flexible and strong cloud architecture.

      Engage provides many types of exports to meet your needs and accommodate the requirements of different external data analysis tools.

      This topic helps you decide which exports are right for you.

      Raw Data​

      Raw data is unprocessed, stored information about individual activities. This means that the data is not pre-calculated or interpreted.

      The following exports of raw data are available in Engage:

      • Raw Data Export: A Raw Data Export contains all the unfiltered data that is available in Engage (for example, all bounces, all clicks, or all conversions). This highly detailed information can be linked to data from other channels and analyzed in an external tool such as a data warehouse or business intelligence tool to optimize the success of future campaigns. For more information, see ​Raw Data Exports.

      • Simplified Data Export: A Simplified Data Export is similar to a Raw Data Export. Both export raw data about individual activities for further processing. However, Simplified Data Exports only export the first instance of each event you select (for example, the first click). To analyze the exported data, you need an external tool such as a CRM (customer relationship management) system. The raw data alone does not follow a sorting strategy or provide usable insights. For more information, see ​Simplified Data Export​.

      Tab.:Differences between Simplified Data Exports and Raw Data Exports

      Simplified Data Export

      Raw Data Export

      Helps you analyze WHO interacts with your messages

      Helps you analyze HOW contacts interact with your messages

      Exports only the FIRST tracking event

      Exports ALL tracking events

      Contains basic information for each event (for example, timestamp, bounce category, link URL)

      Contains all available information for each event (for example, device data, geolocation data)

      Output files are usually smaller than a raw data export

      Output files can be very large

      Typically used for import into a CRM system

      Requires import into a Data Warehouse or similar system, for further analysis with a BI tool

      Raw Data Exports and Statistics

      Raw Data Exports and Simplified Data Exports deal with raw data. Message Statistics deal with processed events - (CC & BCC addresses, Control Users, Counting Clickers as Openers, among others). Therefore, do not compare Raw Data and Simplified Data Exports to Message Statistics. Raw Data and Simplified Data Exports do not basically have the KPI requirements that Message Statistics has, and therefore the numbers are logically different.

      If you do want to export your campaign performance, use the "Export Group Message Statistics" automation or use the Address Data Export.

      Bear in mind that Raw and Simplified Data Exports have a 1-hour delay as compared to Message Statistics. Mapp therefore recommends to execute your Raw and Simplified Data Export automation daily, in the night preferably covering the last 24 h of all messages and events.

      Processed Data​

      In Engage, data that is pre-calculated and filtered is called ​Processed Data​.

      A processed data export contains selected data to which a calculation logic is applied (for example, export of all recipients, openers, or clickers). After export from Engage, the data is available for analysis in an external tool to optimize the success of future campaigns.

      The following exports of processed data are available in Engage:

      • Address Data Export: Statistics export of address data for selected performance indicators of group or single messages. For more information, see ​Address Data Export (window)​.

      • Export Data to Server: Time-based automation that exports data from your system. This job offers a number of configurable exports. For more information, see ​Export Data to Server​.

      • Recipient Activity: Cloud export of information about recipient activity (opens, clicks, bounces, conversions). This is a system-wide export and can be generated for every type of message (single messages, group messages, test messages, split sendouts, super messages, system messages, control messages). For more information, see ​Cloud Export File​.

      • Aggregated Recipient Activity: Cloud export of aggregated information about recipient activity This export only includes information about group messages. For more information, see ​Cloud Export File​.

      • Aggregated Link Clicks: Cloud export of information about the clicks produced by a message. This export always refers to one message. For more information, see ​Cloud Export File​.

      Cloud Exports are an extra feature that must be enabled for your Engage system.

      Currently, the Cloud Export area is only accessible to Mapp team members. This means that a Mapp employee must set up and generate the export for you. For more information, contact your customer service representative.

      Reports​

      In Engage, exports that contain calculated KPIs are called reports. Reports deliver data that is more strongly aggregated than raw data or processed data exports. You can generate a reports for a single message or multiple messages. Depending on the report type, the report contains information about message, user or group data. Reports provide information about calculated KPIs such as the number of recipients, openers, opens, clicks, unsubscribes and bounces as well as calculated metrics such as the opening, click and conversion rates.

      • In the ​Statistics​ area of Engage, message statistics for group and single messages can be exported as a report in Excel or CSV format. For more information, see ​Export Message Statistics as a Report​.

      • In the​ Administration​  I ​Reports​ area of Engage there are seven types of reports. Each report contains different data. For more information, see ​Reports​.

      Export Options​

      Name

      Purpose

      Data Type

      Contents

      Format

      Cloud Exports

      Further analysis in an external tool (for example, a CRM, data warehouse or business intelligence tool).

      Processed or raw data

      Predefined export file type that selects certain data from the cloud for export.

      The following export types are available:

      • Recipient Activity

      • Aggregated Recipient Activity

      • Tracking Data for Landing Pages

      • Sendout Details for Coupons

      • Link Clicks

      • Aggregated Link Clicks

      • Related Data

      • Recipient Context

      For more information, see Cloud Exports​.

      XML, CSV or XSLT file uploaded to a server.

      Raw Data Exports

      Further analysis in an external tool (for example, a CRM, data warehouse or business intelligence tool).

      Raw data

      Unprocessed, stored information about the selected activities that is available in Engage.

      For more information, see ​Raw Data Exports.

      XML, CSV or XSLT file uploaded to a server.

      Simplified Data Exports

      Further analysis in an external tool (for example, a CRM, data warehouse or business intelligence tool).

      Raw data

      The first instance of each selected event

      For more information, see ​Simplified Data Export File​.

      XML, CSV or XSLT file uploaded to a server.

      Reports

      View and track information about your system.

      Report

      Raw data and calculated values (for example, the click or open rate).

      For more information, see ​Reports​.

      Excel file.

      A link to download the file is sent to your email address.

      Available Automations​

      Engage offers many convenient automations to help you automatically generate reports and exports.

      Job Name

      Purpose

      Data Type

      Contents

      Format

      Export Data to Server

      How you use this data depends on the export type.

      Mixed

      This automation offers several export types:

      • Member data (group-based)

      • Member data (message-based)

      • Tracking data exports

      • Blacklisted members

      • Domain stats

      • Conversion tracking

      For more information, see ​Export Data to Server​.

      XML, CSV or XSLT file uploaded to a server.

      Generate XML Group Report

      The report generated by this job is commonly used to synchronize contact lists in an external application.

      Report

      The group name, country and language code and optional response, subscription and unsubscribe details.

      For more information, see ​Generate XML Group Report​.

      XML file sent to an email account or uploaded to a server.

      Generate XML Message Report

      The status report generated by this job is commonly used to upload and analyze message statistics in an external application.

      Report

      The job settings determine the amount of detail included in the report.

      For more information, see ​Generate XML Message Report​.

      XML file sent to an email account or uploaded to a server.

      Generate Export

      This job generates Raw Data, Simplified Data or Cloud Exports.

      Processed or raw data

      All the settings for the export are entered in the ​Exports​ area. This job only automates file generation and upload.

      For more information, see ​Generate Export​.

      XML, CSV or XSLT file uploaded to a server.

      Generate Report for Download

      This job generates current data for an existing report.

      Mixed

      The report generated by this job must already be defined in the system.

      For more information, see ​Generate Report for Download​.

      A link to download the file is sent to your email address.

      Generate Coupon Report

      This job generates a coupon report. The report is exported to a server.


      The reports provides you with an overview of the coupons available in the system.

      For more information, see ​Generate Coupon Report​.

      TXT or CSV file uploaded to a server.

      Was this article helpful?
      What's Next