Export wizard: Update changelog
You can find the general documentation of the export wizard here.
2022-09-05
Beta phase completed: the export wizard can now be booked
- Many thanks to our customers who actively supported us during the public beta phase with their suggestions, requests, questions and bug reports!
2022-03-07
Download link to the export file by email
- There is now a particularly easy way to download a successfully created export file: the download link to the file is included directly in the notification email if the 'Include download link to the export file' option is activated. This way, your editors receive the data they need, such as the opt-outs since the last export, without having to log in to the emma account or to an FTP server for the download.
2022-02-07
'Mailing statistics' export type: new key figures 'Clicks first time' and 'Click rate first time'
- With the 'Mailing statistics' export type, you can now export the number and rate of first-time clickers within a selected time period, similar to what is already possible for first-time openers. This key figure is particularly suitable for time-controlled, repeated exports of a rolling time period.
Example: You want to export the mailing statistics of the previous day every day. Suppose a subscriber clicks repeatedly in the same mailing over 3 days. This click is counted as 'Click unique' in each of the 3 daily exports, because the subscriber clicked at least once in relation to the time period (the respective day). Under the new key figure 'Clicks first time', however, this click is only contained in the first of the 3 daily exports. This way, when you add up all daily exports, you get the total that the general email statistics show as 'Clicks unique'.
2021-10-04
Cross-account export: additional detail 'Account properties' can be exported
- Account details extended: For the cross-account export within your multi-account system, you can now also export the account properties of the subaccounts. To do this, select the 'Properties' entry in the 'Content ⇒ Account details' step. If several properties are stored for an account, they are output separated by commas.
- Export overview: We fixed an error that prevented the set time interval of activated exports from being displayed.
2021-07-05
'Mailing statistics' export type: new key figure 'Opens first time'
- With the 'Mailing statistics' export type, you can now export the number of first-time openers within a selected time period. This key figure is particularly suitable for time-controlled, repeated exports of a rolling time period.
Example: You want to export the mailing statistics of the previous day every day. Suppose a subscriber opens the same mailing repeatedly over 3 days. This open is counted as 'Open unique' in each of the 3 daily exports, because the subscriber opened the mailing at least once in relation to the time period (the respective day). Under the new key figure 'Opens first time', however, this open is only contained in the first of the 3 daily exports. This way, when you add up all daily exports, you get the total that the general email statistics show as 'Opens unique'.
2020-09-07
New content filter for compact export files with maximum relevance
- Content filter for column contents: You can now filter the result of an export automatically, so that you only receive the content relevant to you, depending on the content of individual columns. A wide range of filters is available for this, such as "Number of opens >0", "Send date from 2020" or "Target group is 'New customers'". With one of the next updates, we will also add text filters such as "contains" or "begins with" here.
Further improvements
- Column overview simplified: We have revised the summary of the export columns. You can now edit the properties of a column by clicking the column name. You can set the column heading, the filters mentioned above and, depending on the type of column, further properties.
- User permission: To define the access permission to the export wizard per user, the user roles now contain the new permission 'Export wizard -> Use' in the 'Permissions modules' section.
- Mailing details extended: For all export types, you can now also export the description of the mailing in the mailing details.
2020-08-10
'Response data' export type -> 'Opt-out' event automatically uses the best data source
- When the 'Opt-out' event is exported, the best data source is now searched for automatically in order to obtain subscriber data that is as complete as possible. If current data no longer exists for a subscriber, the export falls back on the historical data of the opt-out. This option is limited to more recent opt-outs, because, depending on the settings of the opt-out setup, opt-out data is anonymized after 7 days at the latest.
Detailed improvements to operation
- 'Content' tab: The selectable export columns are now sorted better by content.
- 'Last exports' tab: The display of recently completed exports is now updated automatically and the download icon is shown.
2020-07-13
Repeated export in any calendar interval
- The time control has been extended to enable, for example, the regular export of the last quarter. The export can now start every x days/weeks/months in any interval, for example every 3 months.
- To match this, you can set any interval in the 'Past calendar days/weeks/months' date filter.
Bounce details extended
- In addition to the bounce code and bounce message, the 'Response data' export type can now also export the bounce email address. This address is important because it remains stored for each individual bounce, regardless of the current subscriber data.
- In addition to hard or soft bounces, you can now also export other bounces whose server response does not allow a clear classification as a hard or soft bounce.
Multi-account systems: cross-account export of shared mailings
- For multi-account systems, the matching of shared mailings has been improved. When exporting from the admin account, you can use the mailing filter to export one or more mailings across accounts, including all shared copies.
2020-06-15
'Response data' export type extended
- Click details: To evaluate the clicks on interest links in a targeted way, you can now output the linked link interest for each click. To do this, select the new columns 'Interest ID' and 'Interest name'. They supplement the existing details such as link ID, link URL, link tracking code and link comment.
- Bounce details: For the 'Hard bounces' and 'Soft bounces' events, you can output the bounce reason. To do this, select the new columns 'Bounce reason: code' and 'Bounce reason: text'.
- Opt-out details: For the 'Opt-out' event, you can now output the subscriber list from which the opt-out took place. To do this, select the new columns 'Opt-out list ID' and 'Opt-out list name'. If the opt-out covers several lists, they are output separated by commas.
- Events of deleted subscribers: The export now also contains the times of "subscriber-less" opens and clicks, so that the figures can be compared with those of the email statistics. This refers to events of deleted or completely unsubscribed subscribers for whom no subscriber field values are known anymore. In these cases, the exported subscriber field values are empty, similar to existing subscribers without profiling consent.
Time period filter and mailing details extended
- Time period filter: The 'Past calendar week/month' filter variant has been extended by the option 'Past calendar day'. This filter is suitable for time-controlled exports that run daily, weekly or monthly. It ensures a complete export without overlapping data.
- Mailing details: In addition to the mailing ID, subject, etc., you can output the subscriber lists and target groups set in the mailing as well as the send date.
Improved operation
- Every export has a copy function. Use existing exports as a template to transfer typical settings to new exports with one click. These include the order and naming of the export columns, the FTP connection data, notification addresses and formatted date placeholders in the file name and path.
- If necessary, you can cancel a running export, for example to correct the settings and start a new export immediately.
- You can delete export runs you no longer need to keep the list of recent exports clear.
- If the FTP upload of an export fails, the export is now always considered an error. The cause of the error is shown on the "Last exports" tab and the error notification email is sent. This applies even if the export itself was successful and the download link to the export file is available.
2020-05-04
New export type: mailing statistics
- When creating a new export, you can now choose from 3 different export modes. The new 'Mailing statistics' export type exports a summarized statistic of send figures and performance data for each mailing. For each mailing, you get the number of test sends, planned recipients, total sendings, deliveries, retained addresses, blacklistings, complaint list entries, bounces, opt-outs, opens and open rate (each unique and total), clicks and click rate (each unique and total), as well as the average email size and the traffic.
'Response data' export type extended
- In the mailing details, you can now also output the subscriber lists and target groups set in the mailing as well as the send date.
- If the 'Clicks' event is exported, you can now also output the link comment as a detail, in addition to the link URL, link ID and link tracking code. This also takes into account different comments on links that appear with an identical URL in different places of the mailing.
Miscellaneous
- On the 'Last exports' tab, ordered exports no longer appear only after completion; the progress of running exports is shown as well.
- On the 'FTP connection' tab, you can select the connection type 'SFTP encrypted with key'. It uses an SSH key instead of a password for particularly secure authentication.
2020-04-06
For multi-account systems: support for cross-account exports
- On the 'Test' tab, you can check with one click whether all subscriber fields involved in the export can be matched in the subaccounts. A substitute must be entered for each field involved in each account involved. Otherwise, the field cannot be matched and the exported field values remain empty.
New data filters
- The new time period filter 'Past calendar week/month' is suitable for automated exports that run weekly or monthly. It ensures a complete export without overlapping data.
- With the 'Emails' data filter, you limit the export to specific emails, which you either select directly or filter by mailing tags.
New output details
- If the 'Clicks' event is selected for the 'Response data' export type, you can also output the ID and the tracking code of the link in addition to the click URL.
- Stronger data protection: Optionally, you can output subscriber field values in pseudonymized form. You can select the hash mode you want.
- The generated CSV file is easier to import into Microsoft Excel®, because 'UTF-8 with BOM' is preset as the file format. Excel® recognizes this format automatically, so umlauts are imported correctly without manual steps.
- ZIP compression is preset. This significantly reduces the file size. In addition, when large exports are split into several CSV files, you receive only a single download file.
2020-03-09
Cross-account export for multi-account systems
- A cross-account export is now possible from the admin account. The export file contains the events of the subaccounts, including the account ID, company and customer number of each account. You can either select the accounts you want directly or filter them by account properties.
New export mode 'Mailing recipients'
- In the 'Mailing recipients' export mode, you get the number of opens and clicks for the emails sent to each subscriber.
2020-02-10
First release: 'Response data' export mode
- In the 'Response data' export mode, you get a history of each subscriber's reactions. This includes opt-ins, opt-outs, profile changes, sendings, deliveries, opens, clicks, hard bounces, soft bounces, blacklistings and retained sendings.
