Attributes of the table to export

These are the attributes of the main table that you selected to export. They are colored blue if it is a Profile export, or purple for a Custom Table export. You can select table components as well as technical data related to interactions (creation moment, update moment,...).

Event Attributes to add in the export

These fields represent all the relevant information recorded when there is a click in the selected e-mail campaign.

• interactionId : the id of the click interaction (individual per profile, not to be confused with the campaign id)

• urlName : the name of the link, as defined in the "Link checker" step of the campaign creation

• profileId : the technical id of the profile who clicked on the link. Additional profile attributes can be selected in the section "Profile Attributes to add in the export"

• creationTime : the creation time of the interaction, namely the moment when the link was clicked on

• clickedUrl : the URL address of the link that was clicked on

Data of the form to export

These fields represent all the relevant information recorded when a profile participates in the selected form :

• source : the answer to the technical question "source"

• language : the language version of the form

• Updated on : the moment when the form was last updated (mainly relevant in forms where updates are allowed)

• Participation moment : the moment when the participation was recorded

• Participation id : the individual id (per profile) of the participation

• Profile id : the technical id of the profile who participated to the form. Additional profile attributes can be selected in the section "Profile Attributes to add in the export"

• E-mail address : the e-mail address of the participating profile (only for private forms and when the default attribute emailAddress is used)

• Complete ? : whether the participation is complete or not

• All individual questions : the answer recorded for each individual question of the form can be exported. These fields are displayed as the page number of the question followed by its technical name.

Profile Attributes to add in the export

You can also export Profile attributes from the profile related to Custom Table entries (Interaction or Linked Data) or to communication events. You will recognize them easily by their blue color. You can select profile attributes as well as technical data (creation moment, update moment, recency fields, ...).

Please note that:

• It is possible to exclude columns by clicking on unwanted elements, or to click on the 'Unselect all" button and make your choice from scratch.

• In the interface, you will see the 'display name' given to the attributes. Their 'technical names' will appear by hovering your mouse over the attribute. However, your export will use the 'technical names' of the attributes in the column headers (unless the headers are modified at the next step).

• To modify the structure of the file obtained after the export, you can change the order of the blocks by dragging and dropping them.

Format of values

Configure the settings for the values of your file content.

Each of these options will only appear if your export contains attributes of the corresponding type. The relevant attributes are displayed under the format suggestions.

• Format of "booleans" type attributes : select the format for the attributes whose values are true or false (e.g.: subscriptions displayed as single-columns): 1/0, Y/N, or TRUE/FALSE

• Format of "date" type attributes: select the format of the attributes of date type (e.g.: birthdate).

• Format of "moment" type attributes: sele ct the format of attributes of time and date type (e.g.: technical attributes of creation time or of recency). Different levels of accuracy (with or without the time) and format are available.

• Multi-value separator: sel ect the separator of attributes that can take several values (e.g. single-column subscriptions, hobbies,...). This is not the global separator of the file (selected in the next section).

Format of file

At this step, you will be able to choose the settings of the file.

The File headers are, by default, the technical names of the fields (prefixed by "profile-" for profile attributes added to a Custom Table or communication interaction export).

They can however be redefined to fit the naming conventions used in your system.

The file is in CSV format, with UTF-8 encoding. You can choose what type of value separator you would like in the file:

• commas

• semicolons

• tabs

Export example

A sample of 10 profiles will allow you to preview the values and columns you will get in your export file.

In the 'Data' section, you will see all the data fields that will be included in the export.

In the 'Parameters' section, you will be able to verify that you selected the right data and file parameters.

Once you have checked the summary and you are sure that you have correctly defined your export, you can proceed to select the way in which you want to transfer the exported data.

You can do it either manually or automatically into the cloud location of your choice. In this second case, a number of additional parameters must be defined, namely the exact location, the file name, the name suffix and the type of file compression.

Downloading the export

For manual exports, go to the 'Finished' tab, then choose the relevant export. The line in question will turn blue.

Finally, click on the 'Download' button. The file will be automatically downloaded on your computer.

Exports dropped 'into the cloud' will be available on the remote location that you chose.