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

This export type displays the unsubscribed recipients in a certain time frame and belonging to one or more Mailup lists.

The eventual layout is partly configurable and can be enabled 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 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,64 = newsletter (unsubscribe header)
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:

  • Blocked by destination MTA
  • SPAM content 
  • Configuration problem on destination MTA 

Column options

You can add up columns to the basic layout above : 

  1. Column "ListId", meant as the list where the subscription was originated from
  2. Column "Date", the date time the subscription took place
  3. Message Id, the email the recipients clicked on to the unsubscribe list. (not applicable to bounce unsubscriptions)
  4. "Optout type", meaning the event that triggered the unsubscription.
  5. Any dynamic field recipient 

Other options

  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"

email;idList;OptOut_Date;optout_nl;optout_type
casellaerrata@cdnosdmcokdsm.it;1;20140630T151918;2;2
abuse@bouncemanager.it;1;20140630T151918;2;2
davinci@mailup.it;1;20140630T151918;2;2
support@hotmail.com;1;20140630T151918;2;2


Sample 2 displays another unsubscription layout with "Email", "idList", "OptOut_Date","optout_nl" and "Optout_type" and no file header

casellaerrata@cdnosdmcokdsm.it;1;20140630T151918;2;2
abuse@bouncemanager.it;1;20140630T151918;2;2
davinci@mailup.it;1;20140630T151918;2;2
support@hotmail.com;1;20140630T151918;2;2


Sample 3 displays  a different kind of layout with "Email", "idList", "FirstName", "LastName", "Company" and "City" with file header

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 a different kind of layout with "Email", "idList", "OptOut_Date","optout_nl", "Optout_type" and "Optout_subtype"

email;idList;OptOut_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.

  • No labels