Exporting statistical data
For you to be able to export statistical data from newsletter mailings into your office software and combine them with data from other mailings (e.g. by post), the OpenEMM provides you with a function for exporting statistical data. You have the possibility of exporting click data from the OpenEMM’s statistics tool into your spreadsheet software (e.g. Microsoft Excel).
The data can be exported in CSV (Comma Separated Values) format. This is a simple text format that separates the individual entries by the use of commas. The CSV format is used for data exchange between various spreadsheets and databases. Almost every spreadsheet program can import and export CSV data. OpenEMM uses this to advantage.
The procedure is extremely simple to use: If you want to export the statistics for a mailing, click on the corresponding symbol for export in the Statistics side tab.
This form of data export is possible for general statistics as well as all other forms of statistics the OpenEMM provides (weekly, daily or hourly statistics, see previous chapter.). Clicking on the small disk symbol opens the web browser’s download dialog which guides you through the process. It may look slightly different on your screen according to your browser version and operating system.
Fig. 5.17: Download can start.
The download starts as soon as you click on the Save button. Choose a directory on your hard disk where you would like to save the CSV file. It is safer to have the computer store the file on your hard disk first, because not all EXCEL and browser versions support direct import using the Open button.
Please note: Depending on your browser settings, the download dialog may include a security check warning you of possible dangers when downloading files and asking you for confirmation you wish to proceed. This confirmation may be answered by clicking on the Yes button.
When the download is finished, you can open the CSV file in your spreadsheet software, for instance Excel like in our example. Statistical data is already entered into columns and cells. They can then be processed for documenting marketing activities or creating individual analysis reports.
Fig. 5.18: An exported CSV file, opened in Excel.