Page tree

Versions Compared

Key

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

...

Field

Description

Format

Example

Optional

List ID

List ID in MailUp

Number

1

N

Send ID

Send ID in MailUp

Number

1

Y

Message ID

Message ID in MailUp (newsletter/DEM)

Number

161

Y

E-mail address

e-mail address of the recipient

String

john.smith@myprovider.com

N

Subject

Subject header of the email message

String

Test

N

Status

Possible values:
OPN (open)
CLK (click)
NCO (not delivered)

SNT

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

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

String

Y

Date

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

ISO format for dates
yyyymmddThhmmss

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

N

Send date

Date the message was sent

ISO format for dates
yyyymmddThhmmss

20110122T111244

Y
Ip AddressClient's Ip address, applies only in case of click or openString Y
Geo DataThe region or area the action is generated fromString Y
User AgentUsually the standard browser or Email client information coming along with a view or a click. Please mind to use a text qualifier if planning to include this column in your csv final layoutString Y
Campaign TagsIf any was used for a campaign, this column will display a comma separated tag sequence. This column does not allow to use any custom separator other than comma, so please consider to use a text qualifier, or else a semicolon / pipe csv column separator if planning to include this column in your final csv layoutStringTag1, Tag2, Tag3Y

...

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

 

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 from the csv.
  2. SNT instead report 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.

...

Property 
Csv exported file nameWrite here the name of the exported csv
Column SeparatorWrite here the character to use
Text QualifierWrite here the character to use, else leave it blank
Show click UrlYes / No
Show Send IdYes / No
Show click/open ip addressYes / No
Show Geographical InformationYes / No
Show User AgentYes / No
Show Campaign tagsYes / No
Dynamic FieldsWrite here field ids or names
File HeaderYes / No
Show only last action rowYes / No
Show click rowsYes / No
Show views rowsYes / No
Show bounce rowsYes / No
Show no actions rowsYes / No
Show Sent rowsYes / No
FrequencyDaily / Weekly
RecursOnce / Every Day
Ftp Host : PortYour Ftp Host Name
Ftp UsernameYour Ftp Username
Ftp PasswordYour Ftp account password
Ftp subfolderThe Ftp subfolder the file will be placed to

...