Goal​

The Message Statistics for a message can be exported as a report in Excel or CSV format.

Background Information​

The export generated as an Excel file processes the data visually and separates the data on different worksheets based on the information content. The message statistics exported as an Excel file contain all of the information displayed in the ​Message Statistics window. In addition, all data for the ​Delivery Performance,​ Recipient Activity, and ​Conversions ​sections and their sub-tabs are integrated into the export for the message. Charts and tables are also included in the export. For more information on the data for each section and their sub-tabs, please refer to the respective chapters Delivery Performance, Recipient Activity, and Conversions (see Delivery Performance (window), Recipient Activity (window), and Conversions (window)​).

The export generated as a CSV file lists all the data without presenting it visually or displaying it separately on different worksheets. The message statistics exported as CSV files contain all of the information displayed in the ​Message Statistics window. In addition, all data for the ​Delivery Performance,​ Recipient Activity, and ​Conversions sections and their sub-tabs are integrated into the export for the message. The underlying data for charts and tables are also included in the export. For more information on the data for each section and their sub-tabs, please refer to the respective chapters Delivery Performance, Recipient Activity, and Conversions (see Delivery Performance (window), Recipient Activity (window), and Conversions (window)​).

Procedure

  1. In the main navigation menu, click ​Statistics​ > Group Messages > Email/AMP Email/SMS/PushNotifications/In-App Messages.

  2. Next to the desired message, click  ​View Statistics.

  3. Click the ​Export Excel Report button, if you want to export the message statistics as an Excel file.

    - or -

    Select the drop-down list item  ​Export CSV​, if you want to export the message statistics as a CSV file.

  4. Select a language for your export, and click Export CSV or Export Excel. A status message informs you that the export file has been created. After the data is successfully exported, you will receive a notification that it is available for download if you are still logged into the same session. The system also sends you an email with a link to the exported file. This email is sent to the email address with which you are registered in the system. The link is valid for 7 days.

  5. Go to the notification center or open the link in the email sent to you by the system. If you are not logged into the same session, the system log-in page opens.

  6. The ​Export View window opens.

  7. Click ​Export to open or save the file.