Export of email unsubscribers
FTP-based data synchronizations are not available by default (additional charges will apply), contact your account manager to receive a quotation.
In order to have a data synchronization set up, you need to have an active MailUp account (not a free trial).
In case you need any further information or custom integrations, please do not hesitate to contact your sales representative.
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.
What data is to be included in the report
The CSV report encloses the following data related to the unsubscribed recipients.
You can set the instance to generate reports that contains one or more of the following data except for the unsubscribed email address, which is a required value that will always be included and displayed in the first column of the report
Data | Header Display Name | Description | Examples |
|---|---|---|---|
unsubscribed email address | |||
| Mobile | Phone Number | The phone number related to the unsubscribed email address | |
MailUp list id | idList | Unique identifier of the MailUp list from which the email address has unsubscribed | 1 |
Unsubscribe date | OptOut_Date | Date and time when the email address has been unsubscribed from the MailUp list | 20210122T111244 |
| Registration Date | Subscription Date | Date and time when the email address completed the subscription to the MailUp list | 20210121T141244 |
Message id from which unsubscribe occurred | optout_nl | Unique identifier of the MailUp newsletter from which the recipient has clicked the unsubscription link. | 161 |
Reason for unsubscribing | optout_type | Unsubscription type (manual, automatic, bounce ecc.). Possible values are: 0 = User forced optout through the MailUp admin console | 8 |
| MailUp Group id | Groups | Any unique identifier of the MailUp Groups to which the recipient is assigned to at the time of export. In case of multiple values, expect a string value separated by comma | 3,5 |
| Recipient fields | Data saved in the recipients personal data fields. Any or all of these fields can be part of the report |
It is required to export MailUp list id, Unsubscribe date and Reason for unsubscribing for each unsubscribed recipient
email,idList,OptOut_Date,optout_type email1@mailup.com,1,20220219T073240,4 email2@mailup.com,1,20220420T145237,0
It is required to export MailUp list id, Unsubscribe date, Reason for unsubscribing and Message id from which unsubscribe occurred for each unsubscribed recipient
email,idList,OptOut_Date,optout_nl,optout_type email1@mailup.com,1,20220219T073240,3,2 email2@mailup.com,1,20220420T145237,,0 email3@mailup.com,1,20210109T081942,,4
It is required to export MailUp list id, Unsubscribe date, Reason for unsubscribing, Message id from which unsubscribe occurred and one recipient field for each unsubscribed recipient.
In this example in your business logic you have configured MailUp to use the field 28 to save the customer code defined by your CRM, and you need this data in the report generated by this Instance of the Datasync (S)FTP Export.
email;idList;OptOut_Date;optout_nl;optout_type;campo28 email1@mailup.com;11;20221225T141555;;8;050340000000005530967 email2@mailup.com;11;20221225T141554;;8;050340000000020175576
Environments and export timeframe
You can define which MailUp lists you want to extract data from and the extraction period.
Extraction period is the timeframe which the report refers.
Usually you can configure an Instance to generate report containing:
- all new unsubscribers from the last 24 hours for the desired MailUp lists
- all new unsubscribers that happened from the last export executed for the desired MailUp lists
- all unsubscribers in the MailUp for the desired MailUp lists