Using the plug-in
To compare statistical data for multiple mailings and export this to a CSV file, you must first select a number of mailings. To do so, select the functions Statistics and Mailing (Comparison) in the OpenEMM navigation bar. The "Comparing mailings" chapter shows you how to use the comparison function included as standard in OpenEMM. The data that this function supplies gives you an overview of the most important key indicators. A thorough comparison can however be obtained via the Export plugin.
The plugin displays an additional Export tab. The function's window lets you determine in detail the scope of the data and how it is displayed:
• | Choose one or more of the four mailing types. |
• | Select the period across which the analysis is to be made. Clicking in the date field opens a selection calendar. |
• | Select the character that is to be used to separate the individual data fields in the CSV file. This character depends on the program that you use to view or edit the CSV field. For Microsoft Excel for example, this is the preset semicolon character. |
• | Select a character that is to be used to mark the individual data fields. In most cases, the preset None is the correct choice. |
• | Select the character set that is to be used. In most cases, the preset ISO 8859-1 is the correct choice. |
• | Select the data fields that you need for your analysis. |
Fig. 12.15: Determining the data to be exported and how it is displayed.
Now click on Export.
After a short wait time, a message is shown and the file is made available for download. Click on the Save icon. The normal browser download dialog, in which you can open or save the file, is now displayed. If you open the file in Excel, the representation is similar to the following example:
Fig. 12.16: Example data in Excel