Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 towho 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.

...

Field

Header Display Name

Description

Format

Example

Optional

List ID

idList

List ID in MailUp

Number

1

N

Send ID

idInvio

Send ID in MailUp

Number

1

Y

Message ID

idNl

Message ID in MailUp

Number

161

Y

E-mail address

email

e-mail address of the recipient

String

john.smith@myprovider.com

N

Subject

subject

Subject of the email message

String

Test

N

Status

statusType

Possible values:

  • OPN (open)
  • CLK (click)
  • NCO (not delivered - bounce)
  • SNT (sent)

String

  • OPN if the system records the action of downloading the images in the message
  • CLK if the system records a click
  • NCO in case of bounce, or when a message was sent but no clicks or opens were detected for it
  • SNT when a campaign was sent to a certain recipient
Y

Details

details

Clicked URL (if Status=CLK) or bounce code* (if Status=NCO)

String

Y

Date

statusChange

Date of the operation saved in the record. It can indicate an open, a click or bounce detection

ISO format for dates
yyyymmddThhmmss. Italian time zone applies

20110122T113000 stands for Jan 22th, 2011, 11:30 AM

N

Send date

sentDate

Date the message was sent

ISO format for dates
yyyymmddThhmmss. Italian time zone applies

20110122T111244

Y
NotenoteNote of the messageStringSome notes 

...

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").

...

  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 rowstoggle no action (NCO) related rows
  6. toggle sent email rows (SNT).    

 

Info

What is the difference between NCO and SNT row types?

  1. 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 csvThe email has not been delivered due to a bounce, but it might be delivered later.
  2. 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.

 

 

Other options 

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

...

No Format
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

...