Published — v. 16

Data Sync FTP exports from MailUp

Owned by MailUp Agency (Deactivated)
Last updated: Jul 17, 2023 by Camilla Toracchio
3 min read

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.

The automated (S)FTP-based exports can be a better approach than using the statistics API counterpart, especially if the data expected in return is allegedly significant.

The (S)FTP export will deliver all data in one single csv file, as opposed to using the API which might possibly require an array of callbacks to retrieve the same amount of data for the same time frame. 

An (S)FTP Export data sync (hereinafter referred as to an Instance) is configured to export data from one or more MailUp Lists and referring to either one bewteen email or SMS generated traffic.

It is possible to enable one or more instances (tipically one for each kind) of the following (S)FTP data export types:

With every instances, it can be defined:

What data is to be included in the report

The data the export file includes depends on the kind of export purchased, for this reason they are detailed each in their related help page below:

Properties of the exported file

You can define how the report CSV will ultimately look like. You can also set properties that define the CSV structure and properties of the physical file the report will be contained into:

  • Separator, the character used to separate the column of the CSV report: you can choose between semicolon ( ; ), or comma ( , ), or pipe ( | )

  • Delimiter, the character used to enclose data when needed: you can choose between double quotes ( " ), or single quote ( ' )

  • Datatime Format for any date/time field type

  • File encoding, the encoding type of the physical CSV file delivered: one between UTF-8 (includes both Latin and other alphabets characters) or ANSI (include only Latin characters) can be selected. 

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 the report refers to. Usually you can configure an instance to deliver a report containing all of the data generated from the last 24 hours or from the date/time the same export ran successfully last time. 

  • if you have an Instance configured to run every week on Monday at 10:00 and to generate a report containing all of the data from the last export executed, the report generated every monday will contains the data generated from the past monday (a week time of data).

  • if you have an Instance configured to be executed every day at 10:00 and to generate a report containing all the data generated from the last export executed, the report generated every day will contains the data generated from yesterday (a day of data).

  • if you have an Instance configured to be executed every day at 10:00 and to generate a report containing all the data generated in the last 24 hours, the report generated every hours will contains the data generated in the last 24 hours (a day of data).


These settings can change based on the kind of (S)FTP export. You can find further details in each specific help page:

Schedulation and delivery of the export

It can be defined:

  • when the data export will be executed: for example every day at 10:00 or every Tuesday at 10:00.

  • where the file CSV should be delivered: you can retrieve the file from the MailUp SFTP server (which is the default behavior), as opposed to having the Instance configured to deliver the csv file over an external (S)FTP server

  • properties of the generated CSV file: mainly the name of the file

These settings can change based on the kind of (S)FTP export. Further details can be found at the related help page for each type of export:

  • Export of email subscribers

  • Export of email unsubscribers

  • Export of email statistics (delivered, opens, clicks, bounces)

  • Export of SMS statistics

You can also define the name of the CSV file that will be generated.

Important Note

In case of incremental export we suggest to use the Date / time (timestamp) as part of the csv file name. Doing so, the date and time of the extraction will be added to the name of the delivered file, preventing the system from overwriting csv files coming from previous export sessions/periods