Child pages
  • [Email] Csv Export type "UNSUB"
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 opon 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 = list unsubscribe http
64 = list unsubscribe mailto
128 = Inactive recipients
256 = unsubscribed due to blocked email1
512 = unsubscribed due to repeated transient bounce
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 the same file layout as above but including md5 encrypted email column

email;idList;FirstName;LastName;Company;City
bcfe3aa6688b119b6e05e7917d7405e9;2;John;Smith;company1;London
2c7fd48eb4e0511b729e3448287ceacf;2;James;White;company1;Leeds
d8923f6f03e03ed628bd997ca3795ace;2;Paul;Green;company1;Norfolk

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

  • No labels