Page Comparison

The (S)FTP Export Data Sync allows to export recipients, demographic data and statistical figures related to Email or SMS traffic originated from a MailUp account. The outcome of the export will be delivered over to an (S)FTP server and it can be scheduled to run at the most convenient time for your business neeeds.

The automated (S)FTP-based exports can be a better solution when compared to using the statistics API counterpart, especially if the volume of the information returned 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 a series of callbacks to retrieve the same amount of data for the same timeframetime frame. 

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

Every kind of data export implies different columns, and therefore, different data, however a subset of recipient fields can be always added to csv layout, regardless of the export type:It is possible to enable one or more instances (tipically one for each kind) of the following (S)FTP data export types:

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

When an Instance is active you can defineWith every instances, it can be defined:

• What data is to be included in the report

• Environments and export timeframe (indicate i.e. which MailUp lists you want to extract data from and the extraction period)

• Schedulation and delivery of the export

Anchor
data data

What data is to be included in the report

These information change based The data the export file includes depends on the kind of export you have boughtpurchased, for this reason they are detailed each in the proper their related help page below:

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

Properties of the exported file

You can define how the report CSV is built.You can choose some technical data about 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 encole enclose data when needed: you can choose between double quote quotes ( " ), or single quote ( ' )
• Datatime Format for any date/time field type
• File encoding, the encoding type of the physical CSV file delivered: you can choose one between UTF-8 (includes both Latin and other alphabets characters) , or ANSI (include only Latin characters) can be selected. 

Anchor
env env

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

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

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

Anchor
sch sch

Schedulation and delivery of the export

You It can definebe defined:

• when the data export will be executed: for example every day at 10:00 rather than every week on tuesday or every Tuesday at 10:00 and so on.
• where the file CSV generated should be delivered: you can get retrieve the file from the MailUp SFTP server (this which is the default behavior), rather than configure as opposed to have configured the Instance to deliver the csv file on over an external (S)FTP server

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

These settings can change based on the kind of (S)FTP export. You can find further details in the proper help page.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 CSV that will be generated.