Page tree

Versions Compared

Key

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

...

The eventual layout is partly configurable and can be enabled opon on demand.

Basic Csv Layout 

The following table describes the format of the records in the unsubscribers file. This file is usually an incremental file and is generated at an agreed frequency.

...

Field

Header Display Name

Description

Examples

Optional

E-mail address

email

e-mail address of the unsubscriber

john.smith@myprovider.com

N
Phone NumberPhone NumberThe subscriber phone phone number (with o without prefix)
Y

List ID

idList

List ID in MailUp

1

Y

Unsubscription date

OptOut_Date

Unsubscription date in ISO format

20110122T111244

Y

Message ID

optout_nl

ID MailUp uses to identify the email message that triggered the unsubscription request (spontaneous unsubscriptions)

161

Y

Type

optout_type

Unsubscription type (manual, automatic, bounce ecc.). See next column for accepted values

0 = User forced optout through the MailUp admin console
2 = recipient clicked on unsubscription link
4 = imported as unsubscribed
8 = hard bounce 
16= feedback loop (spam notification) 
32 = list unsubscribe http
,64 = list newsletter (unsubscribe mailtoheader)
128 = Inactive recipients
256 = unsubscribed due to blocked email1
512 = unsubscribed due to repeated transient bounce
1024 = unsubscribed due to right to oblivion



Y
Sub Typeoptout_subtypeUnsubscription sub_type (manual, automatic, bounce ecc.). Used together with Type, detail the cause of the unsubscription.
See next column for accepted values


TypeSub TypeDescription
0
User forced optout through the MailUp admin console
2
Recipient clicked on unsubscription link
4
Imported as unsubscribed
8
Hard bounce - wrong email
81Hard bounce wrong email, syntax of the email address is wrong.
82Hard bounce wrong email, domain of the email address is dismissed.
83Hard bounce wrong email, email address abandoned.
16
Feedback loop (spam notification) 
32, 64
Newsletter (unsubscribe header)
128
Inactive recipients
256
Unsubscribed due to blocked email
2561

Unsubscribed due to blocked email. Blocked by destination MTA.

2562Unsubscribed due to blocked email.SPAM content.
2563Unsubscribed due to blocked email. Configuration problem on destination MTA.
512
Unsubscribed due to repeated transient bounce
5121Unsubscribed due to repeated transient bounce. Recipient is temporary unsubscribed and could be subscribed again.
5122Unsubscribed due to repeated transient bounce. Recipient is permanently unsubscribed
1024
unsubscribed due to right to oblivion


Y

(1) Possible causes are:

...

  1. Included bounces filter : you can include only the bounce types you need.
  2. Excluded bounces filter : or you can prevent some types to show up in the csv file
  3. Display columns' header
  4. Encrypt Email column 

Samples

Sample 1 displays a standard unsubscription layout with "Email", "idList", "OptOut_Date","optout_nl" and "Optout_type"

...

No Format
email;idList;FirstName;LastName;Company;City
smith@email.com;2;John;Smith;company1;London
white@email.com;2;James;White;company1;Leeds
green@email.com;2;Paul;Green;company1;Norfolk


Sample 4 displays the same file layout as above but including md5 encrypted email columna different kind of layout with "Email", "idList", "OptOut_Date","optout_nl", "Optout_type" and "Optout_subtype"

No Format
email;idList;FirstName;LastName;Company;City
bcfe3aa6688b119b6e05e7917d7405e9;2;John;Smith;company1;London
2c7fd48eb4e0511b729e3448287ceacf;2;James;White;company1;Leeds
d8923f6f03e03ed628bd997ca3795ace;2;Paul;Green;company1;NorfolkOptOut_Date;optout_nl;optout_type;optout_subtype
casellaerrata@cdnosdmcokdsm.it;1;20140630T151918;2;8;
abuse@bouncemanager.it;1;20140630T151918;2;8;1
davinci@mailup.it;1;20140630T151918;2;2;
support@hotmail.com;1;20140630T151918;2;256;1


Should you need any further information or custom integrations please do not hesitate to contact your account manager.

...