Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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.

Full export is flexible to meet customers' expectations and is partly configurable upon demand.

Basic Layout

Field

Description

Format

Example

Optional

List ID

List ID in MailUp

Number

1

 

Send ID

Send ID in MailUp

Number

1

 

Message ID

Message ID in MailUp (newsletter/DEM)

Number

161

 

E-mail address

e-mail address of the recipient

String

john.smith@myprovider.com

 

Subject

Subject header of the email message

String

Test

 

Status

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

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
 

Details

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

String

 

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

 

Send date

Date the message was sent

ISO format for dates
yyyymmddThhmmss

20110122T111244

 

 

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 existing :

  1. Any dynamic field belonging to recipients.
  2. In the "Details" column it is possibile to display the click URL when the row is CLK type.
  3. Column "SendId".
  4. Column "IpAddress", where applicable. For instance, client ip address is caught in case of click or view
  5. Column "Geographical region", that reports approximately where a click or an open were made from.
  6. Column User agent : applicable to click and views rows
  7. Column "Tags" 

 

Row options

The csv file may optionally display :

  1. columns header, exported along with the data
  2. You can choose to read only the latest action a certain 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 views related rows
  5. toggle bounce related rows
  6. toggle no action ( NCO ) related rows

 

Other options 

Each columns can be also written with a text qualifier, usually a sinlge of double quote.

How to submit your export request?

Please submit your request to Mailup support today, and make sure you've filled the the form below : 

Property 
Csv exported file nameWrite here the name of the exported csv
Column SeparatorWrite here the carachter to use
Text QualifierWrite here the carachter to use
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

 

Below a csv sample that includes click, views, bounces, no actions , displays campaign tags and four dynamic fields ( campo18, campo19, campo33, campo34 )

idList;idNl;email;subject;statusType;details;statusChange;sentDate;tags;campo18;campo19;campo33;campo34
5;1555;email@sample.au;Subject of your campaign;OPN;http://clickurl.com/;20150513T232106;20150513T112026;John;Smith;34234;085861532;1
5;1555;email@sample.au;Subject of your campaign;CLK;http://clickurl.com/;20150513T232206;20150513T112210;John;Smith;34234;085861532;1
5;1550;email-23445@sample.com;Campaign subject;NCO;;20150513T013820;20150508T150226;;;;0158634536;0
5;1555;email.sample@email.com;Campaign subject;NCO;HB   ;20150513T182035;20150513T112210;;;;001478445;2125401707

 

Bounce chart

Allowed codes for bounces are listed in the table below

 

Bounce Type

Bounce Description

AR

Auto Reply

BN

Bounce No Email Address

CR

Challenge-Response

GB

General Bounce

HB

Hard Bounce

MB

Mail Block - General

MBAD

Mail Block - Attachment Detected

MBKS

Mail Block - Known Spammer

MBRD

Mail Block - Relay Denied

MBSD

Mail Block - Spam Detected

NB

Non Bounce

SB

Soft Bounce - General

SBDF

Soft Bounce - Dns Failure

SBMF

Soft Bounce - Mailbox Full

SBMS

Soft Bounce - Message Size Too Large

SR

Subscribe Request

TB

Transient Bounce

UR

Unsubscribe Request

  • No labels