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 | e-mail address of the unsubscriber | N | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Phone Number | Phone Number | The 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 | Y | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sub Type | optout_subtype | Unsubscription sub_type (manual, automatic, bounce ecc.). Used together with Type, detail the cause of the unsubscription. See next column for accepted values |
| 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 :
- Column "ListId", meant as the list where the subscription was originated from
- Column "Date", the date time the subscription took place
- Message Id, the email the recipients clicked on to the unsubscribe list. (not applicable to bounce unsubscriptions)
- "Optout type", meaning the event that triggered the unsubscription.
- Any dynamic field recipient
Other options
- Included bounces filter : you can include only the bounce types you need.
- Excluded bounces filter : or you can prevent some types to show up in the csv file
- Display columns' header
- 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. |