Campaign Data Export

The campaign data export allows you to fetch the detailed data for:

Event history - exports contain one record for each event that has occurred, meaning one contact may appear several times, depending on their activity.

Tip: this export type will also allow you to include additional information against each event, e.g. a click through feed can show each URL clicked.
Contact - exports contain one record per contact regardless of how many events they have triggered, i.e. there is no duplication of contacts within the export.
Device and location - exports contain one record for each open within the selected data source.

Note: there is no dedupe on this export, i.e. every open will be counted as an individual export.
List - schedule the export of a list’s contents to an SFTP (in CSV format).
Unsub list - schedule the export of an unsub list’s contents to an SFTP (in CSV format).

List and Unsub List are On Demand features. If you would like more information about these features, please contact your account manager.

Creating a campaign data export

From the export manager home screen:

Open the Create dropdown and select the Create export option.
On the create export form, enter a name for your export.
Enter a description to help identify the content/purpose of the export (optional).
Select the type of export: event history, contact, device and location, list, unsubscribe list.
Select a core table to use as your data source (not required for unsub lists).
Select an owner. This field defaults to you as the creator of the export.
Select a time zone for the exported data to be in. This defaults to your time zone.
Press the Save button.
On the Overview tab, press the add field button to open the field dialog box.

Note: for unsubscribe list exports, the add field button is replaced with the add unsubscribe field button.
Select the fields to include in the export.
Press the Okay button.

Once you have selected fields to export, the request download and schedule export tabs will be available.

Tip: you can edit basic details of the export (name, description and owner) using the Settings tab.

Additional export settings

In addition to adding core table fields on the overview tab, you may:

Add a system field.
Choose events to export.
Add a data source.

Add a system field

Press the add system field button.
Select system fields to add to your export.
Press the okay button.

Choose events to export

By default, your export includes all events. To select specific events:

Press the add event button.
Select from the list of available events by checking the boxes for events to include.
Press the okay button.

Add a data source

The data source defaults to the entire account. To select a specific source:

Press the add source button.
Select a source to add to your export.

Tip: if necessary, use the arrows to expand/collapse nested items in the account tree.
Press the okay button.

Note: if you select overlapping sources, e.g. an individual campaign and the whole workspace, the export will automatically dedupe the export, i.e. it will only contain one set of data.