This export type encloses the statistics generated from an Email campaign. This means it will display as many rows as many were the actions taken by a recipient towards a certain campaign.

A row will be generated each time a recipient opens a message or clicks on any of the links nested into the email message. A row is also generated for those recipients who did not received the email message due to a bounce.

Full export is flexible to meet customers' highest expectations and can be mainly customized with the fields listed below.

Csv Layout

What data is tracked

Statistics file for email channel contains rows ("records") describing the latest action performed by the recipient. For example:

• if a recipient downloads the images and does not click any link in the message, the file will contain only a record that reports that opening ("OPN").
• if a recipient downloads the images and then clicks a link in the message, the file will contain only a record that reports that click ("CLK").
• if a recipient downloads the images and then clicks three different links in the message, the file will contain three records, one for each link ("CLK").
• if a recipient downloads the images, clicks a link and then opens again the message, the file will contain only a record that reports latest opening ("OPN").
• if a recipient opens a message (i.e. downloads the images) several time, the file will contain only a record that reports latest opening ("OPN").

File content is incremental, i.e. it only contains the actions recorded since the last export. So, actions performed by a user on a message in different days may be spread across different files.

Column options

The layout displayed above can't be modified in the fields' order, but you can decide to toggle some of them or add some to the default layout:

1. Any dynamic field belonging to recipients, also available if fields were renamed.
2. In the "Details" column it is possibile to display the click URL when the row is CLK type.
3. Column "SendId".
4. Email values encryption
   
   

Row options

The csv file may optionally display :

1. columns header, exported along with the data
2. last Action only: you can choose to read only the latest action a recipient took for a certain campaign. So if a recipient views a campaign and then he clicks on it, on the csv only the click row will be exported.
3. toggle click related rows
4. toggle open/views related rows
5. toggle bounce related rows
6. toggle sent email rows (SNT).  

Other options 

Each column can be also written with a text qualifier, usually a single or double quote.

Samples

Sample 1 displays "idList", "idNL", "Email", "subject", "statusType", "details", "statusChange" (date), "sentdate" (date), "note" and four dynamic fields.

idList;idNl;email;subject;statusType;details;statusChange;sentDate;note;FirstName;LastName;CustomerId;TargetId
5;1555;email@sample.au;Subject of your campaign;OPN;;20150513T232106;20150513T112026;Your message note;John;Smith;34234;085861532
5;1555;email@sample.au;Subject of your campaign;CLK;http://clickurl.com/;20150513T232206;20150513T112210;Your message note;John;Smith;34234;085861532
5;1550;email-23445@sample.com;Campaign subject;NCO;MBSD;20150513T013820;20150508T150226;;;;;0158634536
5;1555;email.sample@email.com;Campaign subject;NCO;HB;20150513T182035;20150513T112210;;;;;001478445;2125401707

Sample 2 displays "idList", "idInvio" (sendId),"idNL" (newsletter id), "Email", "Subject", "statusChange", "sentdate" and "FirstName"

idList;idInvio;idNl;email;subject;statusType;details;statusChange;sentDate;FirstName
1;173;175;john@email.com;;CLK;Unsubscribe;20150521T105739;20150521T105733;John
1;166;172;john@email.com;Test DynField;SNT;;;20150417T140808;John
1;166;172;john@email.com;Test DynField;OPN;;20150417T141100;20150417T140808;John

Sample 3 displays a csv layout inclusive of a single quote text qualifier. Text qualifier is very often used when one of the selected fields might display characters that could be misread as separator.

'idList';'idInvio';'idNl';'email';'subject';'statusType';'details';'statusChange';'sentDate'
'1';'14';'6';'demo@mailup.it';'Esempio di messaggio creato con un feed RSS';'OPN';'';'20140905T200936'

Sample 4 displays a the same csv layout as above, but inclusive of MD5 encrypted Email value

'idList';'idInvio';'idNl';'email';'subject';'statusType';'details';'statusChange';'sentDate'
'1';'14';'6';'febb975fe77448e72f0b54b2fab4cde8';'Esempio di messaggio creato con un feed RSS';'OPN';'';'20140905T200936'

Bounce chart

Allowed codes for bounces are listed in the table below

CSV Exported file shipping

The export process can put the target csv file to your console disk space you can usually connect through a Mailup Ftp account, or, if you feel more comfortable, we can ship it to yours.

When filling in the "submit form" at the bottom of this page, you'll find the proper blanks to let us know what FTP account the export process has to connect to. Leave them blank if you'd like the csv file to be left on your default Mailup account disk space.

When connected to your Mailup Ftp Account you'll find the exported csv files at this FTP relative path : "/ftp_export/"