Export wizard: Content → Mailing statistics
If, when creating your export, you selected the 'Mailing statistics' type, you get a summarized statistic of send figures and performance for each mailing. It includes, among other things, the number of planned recipients, sendings, deliveries, retained addresses, bounces, opt-outs, opens, open rate, clicks, click rate, average email size and amount of traffic.
In this case, the 'Content' tab offers the options described below. For all other tabs, the general description of the settings applies.
'Content' tab
Define the content of the exported CSV file: Which data do you need, and in which column order?
- Step 1 - Data filter: Select the emails and the time period whose statistics you want to export. If you have booked a multi-account system with subaccounts, you can run a cross-account export from the admin account. In this case, the emails selected in the admin account are matched to the emails in the subaccounts by their substitutes in order to export their data.
- Step 2 - Column selection: Select the relevant statistics key figures and mailing details.
- Step 3 - Output format: In the last step, you see a summary of the export columns you selected. Sort the order of the columns by drag&drop and adjust further column properties.
Note on open and click rates in repeated exports with a time period filter
Open and click rates refer to the number of deliveries in the selected time period (Step 1 - Data filter). A typical use case is a daily export of the last calendar day. If there were no deliveries on that day, no open or click rate can be calculated. In this case, a dash "-" is output as the value. The value "0", on the other hand, means that there were deliveries on that day, but actually no opens or clicks.
The open and click key figures labeled "first time" count the first event per email and subscriber, regardless of the selected time period. Using the example above, i.e. a "daily export of the last calendar day": if the same subscriber opens the same email every day, each daily export will contain a unique open by this subscriber. The key figure "Opens first time", however, outputs a 1 only in the first daily export. On all following days, this key figure remains 0 for this subscriber. The same principle applies to "Clicks first time" and to the open and click rates "... first time" calculated from them.
