Full export is flexible to meet customers' highest expectations and can be mainly customized with the fields listed below.
|Header Display Name|
List ID in MailUp
Send ID in MailUp
Message ID in MailUp
e-mail address of the recipient
Subject of the email message
Clicked URL (if Status=CLK) or bounce code (if Status=NCO)
Date of the operation saved in the record. It can indicate an open, a click or bounce detection
ISO format for dates
20110122T113000 stands for Jan 22th, 2011, 11:30 AM
Date the message was sent
ISO format for dates
What data is tracked
Statistics file for email channel contains rows ("records") describing the latest action performed by the recipient. For example:
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.
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:
- Any dynamic field belonging to recipients, also available if fields were renamed.
- In the "Details" column it is possibile to display the click URL when the row is CLK type.
- Column "SendId".
- Email values encryption
The csv file may optionally display :
- columns header, exported along with the data
- 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.
- toggle click related rows
- toggle open/views related rows
- toggle bounce related rows
- toggle sent email rows (SNT).
What is the difference between NCO and SNT row types?
Each column can be also written with a text qualifier, usually a single or double quote.
Sample 1 displays "idList", "idNL", "Email", "subject", "statusType", "details", "statusChange" (date), "sentdate" (date)
and four dynamic fields.
idList;idNl;email;subject;statusType;details;statusChange;sentDate;note;FirstName;LastName;CustomerId;TargetId 5;1555;firstname.lastname@example.org;Subject of your campaign;OPN;;20150513T232106;20150513T112026;Your message note;John;Smith;34234;085861532 5;1555;email@example.com;Subject of your campaign;CLK;http://clickurl.com/;20150513T232206;20150513T112210;Your message note;John;Smith;34234;085861532 5;1550;firstname.lastname@example.org;Campaign subject;NCO;MBSD;20150513T013820;20150508T150226;;;;;0158634536 5;1555;email@example.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;firstname.lastname@example.org;;CLK;Unsubscribe;20150521T105739;20150521T105733;John 1;166;172;email@example.com;Test DynField;SNT;;20150521T105242;20150417T140808;John 1;166;172;firstname.lastname@example.org;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.
Optional md5 / sha1 / sha256 / sha512 ecryption encryption applies to Email column only
Allowed codes for bounces are listed in the table below
Bounce No Email Address
Mail Block - General
Mail Block - Attachment Detected
Mail Block - Known Spammer
Mail Block - Relay Denied
Mail Block - Spam Detected
Soft Bounce - General
Soft Bounce - Dns Failure
Soft Bounce - Mailbox Full
Soft Bounce - Message Size Too Large
CSV Exported file shipping
When connected to your Mailup Ftp Account you'll find the exported csv files at this FTP relative path : "/ftp_export/"
FULL export type, accordingly to your usual campaign volumes, may generate a high amount of rows, remarkably increasing the target file size in some cases.
There's an optional feature that allows you to receive only the last action a subscriber took on a certain campaign. For instance, instead of writing both an Open and its subsequent click rows, the export process would only write the click row. This feature usually decreases a lot the average target file size.
You can submit your request filling in to "Show only last action row" as "Yes" in the form below.
Should you need any further information or custom integrations please do not hesitate to contact your account manager.