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 taking no action on a campaign they were sent to.
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:
- if message is sent after latest export and recipient neither downloads the images nor clicks any link in the message, then file will contain a record marked as "NCO".
- 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.
- Exported statistics are aggregated by recipient, message and URL and provide information about actions occurred after latest export, so it can happen that
- if you open several times a newsletter only one record is exported for this kind of action and it refers to date and time of most recent opening. No opens count is provided
- if you click several times a link inside a newsletter only one record is exported for this kind of action and it refers to date and time of most recent click. No click count is provided
- if your clicks or opens are done either before and after an execution of export task, these actions will be tracked in two different export files
- Emails sent with MailUp always contain a single pixel image to track opens.
- If the recipient has not performed any action (image download, clicks) it is not possible to tell if an email was delivered in the inbox. Anyway, it is possible to know if it was blocked at an earlier stage by the email provider of the recipient.
- If a recipient reads the message without downloading any image or clicking any link, no action can be recorded.
- It is not possible to tell if the email client of the recipient tagged the message as "spam". Information about spam can be recorded only by the email provider, which returns an appropriate message.
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 no action (NCO) related rows
- toggle sent email rows (SNT).
What is the difference between NCO and SNT row types?
- NCO marked rows might represent a temporary action status. If the same NCO recipient should ever open or click an email, the NCO row would not be included in the exported csv.
- SNT instead reports the campaign sent to a certain recipient, and its status won't vary in the time even following to an open or a click action event. When SNT is enabled, usually NCO is not, and viceversa.
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" (another date) and four dynamic fields.
Sample 2 displays "idList", "idInvio" (sendId),"idNL" (newsletter id), "Email", "Subject", "statusChange", "sentdate" and "FirstName"
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.
Sample 4 displays a the same csv layout as above, but inclusive of MD5 encrypted Email value
Optional md5 / sha1 / sha256 / sha512 ecryption 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
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/"
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.
Please submit your request to Mailup support making sure you've filled the form below with your export preferences :
|Csv exported file name||Write here the name of the exported csv|
|Column Separator||Write here the character to use|
|Text Qualifier||Write here the character to use, else leave it blank|
|Show click Url||Yes / No|
|Show Send Id||Yes / No|
|Dynamic Fields||Write here field ids or names|
|File Header||Yes / No|
|Show only last action row||Yes / No|
|Show click rows||Yes / No|
|Show views rows||Yes / No|
|Show bounce rows||Yes / No|
|Show no actions rows||Yes / No|
|Show Sent rows||Yes / No|
|Frequency||Daily / Weekly|
|Recurs||Once / Every Day|
|Ftp Host : Port||Your Ftp Host Name|
|Ftp Username||Your Ftp Username|
|Ftp Password||Your Ftp account password|
|Ftp subfolder||The Ftp subfolder the file will be placed to|
|Email Encryption ?||Yes / No|
|Email Encryption Method||md5 / sha-1 / sha-256 / sha-512|