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 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 require a series of callbacks to retrieve the same amount of data for the same timeframe.
An instance of an (S)FTP Export data sync (hereinafter referred as to an Instance) will be 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 of the following (S)FTP data export types:
When an Instance is active you can define:
What data is to be included in the report
These information change based on the kind of export you have bought, for this reason they are detailed in the proper help page:
Properties of the exported file
You can define how the report CSV is built.
You can choose some technical data about the CSV structure of the report:
- 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 data when needed: you can choose between double quote ( " ), or single quote ( ' )
- Datatime Format for any date/time field type
- File encoding, the encoding type of the physical CSV file: you can choose between UTF-8 (includes both Latin and other alphabets characters), or ANSI (include only Latin characters)
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 the data generated in the last 24 hours or from the last export executed.
Examples
- if you have an Instance configured to be executed every week on Monday at 10:00 and to generate a report containing all the data generated from the last export executed, the report generated every monday will contains the data generated from the past monday (a week 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 the proper help page.
Schedulation and delivery of the export
You can define:
These settings can change based on the kind of (S)FTP export. You can find further details in the proper help page.
- Export of email subscribers
- Export of email unsubscribers
- Export of email statistics (delivered, opens, clicks, bounces)
- Export of SMS statistics
You can define the name of the file CSV that will be generated.