Skip to main content

Export and filter data for email campaign reports

Find and extract just the data you need.

Written by Laura Russell
Updated today

Exporting data from your email campaign reports helps you analyse performance, share insights with stakeholders, and work with your data outside of Dotdigital.

Before you start

Required permissions
​To use this feature, you must have the following user permissions:

  • Reporting drill down

  • Contact exporter

Export data from email reports

Export the Email reports table as a CSV file

  1. Go to Analytics > Reports.

  2. To filter reports by date, select DATE RANGE in the top right and choose a predefined date range, or enter a custom date range.​

  3. To filter by tags, apply a tag filter.

  4. Select APPLY.

  5. Select EXPORT CSV to export all displayed email reports.

  6. When your export is ready, select Download.

Export your email reports' drilldown reports

  1. Go to Analytics > Reports.

  2. Select the email report name to open campaign overview report.

  3. Select MORE REPORTS, then choose the report you want to export.”

  4. Select DISPLAY to choose the contact data fields to include in the export, or select the checkbox for Select all.

  5. Select APPLY.

  6. Expand the EXPORT drop-down menu and select Export.

You're taken to the Exports view, where the CSV file appears when it’s ready. This process may take time to complete. Once available, select Download.

View your previous exports

If you don’t download an export immediately, you can download it later. Previous exports are stored for up to 7 days.

To view your previous exports, expand the User menu, then go to Settings > General > Exports.

Create a new list with contacts from a report

  1. Go to Analytics > Reports.

  2. Select the campaign you want to view a report for.

  3. Expand the MORE REPORTS drop-down menu, then choose a report that gives a list of contacts as a result.

  4. Expand the EXPORT drop-down menu, then select Create list.

  5. Under Create list, enter a name for the list.

  6. Select Create.

We create your new list as a private list and it might take a few seconds to appear. To find your new list, go to Audience > Lists.

Map of openers report

In the Map of openers report, select a region, then choose Add these contacts to a list.


Filter contacts in email reports

To view data for specific contacts, select Filter: Showing all in the top-right corner of the page.

This filter gives you the following four options:

  • In the selected list

  • In the selected segment

  • Who received the selected split test variation

  • Who received the selected dynamic content variation

Filters on reports

If you apply a filter to the Email report overview, the following reports and metrics won't be available:

  • Delivery report

  • ISP complaints

  • Unsubscribes

You can't apply a filter to the following reports:

  • Soft bounces

  • Hard bounces

  • Emails skipped

Filter contacts by list

  1. Select the In the selected list radio button, and then SELECT LIST.

  2. Choose the list you want to filter by.

  3. Select APPLY.

This filters contacts by the lists they’re in now, not the lists they were in when the campaign was sent.

Filter contacts by segment

  1. Select the In the selected segment radio button.

  2. Either SELECT SEGMENT to choose an existing segment or NEW SEGMENT to create a new one.

  3. Select APPLY.

Filter contacts by split test variation

This option is available only for split test campaigns.

  1. Expand the Select split test drop-down menu.

  2. Choose a split test version.

  3. Select APPLY.

Filter contacts by dynamic content variation

You only have access to this option if your campaign contains dynamic content.

  1. Expand the Select dynamic content drop-down menu,

  2. Select a dynamic content block and its variation.

  3. Select APPLY.

Remove a filter

To remove a filter, select remove (X) icon next to the filter.


Choose visible columns

To change which columns are visible in a report grid view:

  1. On the report page, select DISPLAY.

  2. Select or clear the checkboxes to choose which columns you want to be visible.

  3. Select APPLY.

Where it’s possible to export a report, any changes you make to the visible columns also apply to the exported file.

Did this answer your question?