Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Info |
---|
(S)FTP-based data synchronization is not available by defaultas an out-of-box feature (additional chargecosts may apply), contact your account manager to get a quote. To have a data synchronization set up, you need to have an active MailUp account (not a free trial). |
sales representative for an estimation. Data synchronizations are not available to MailUp trial accounts. |
The (S)FTP Export allow you Data Sync allows to export recipients and related , demographic data or statistical data about and statistical figures related to Email or SMS channel traffic originated from your MailUp Account by simply generating a .csv file onto an SFTP server.
Using this service you can decide when running the file exchange to export from MailUp to your applicationsa 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 exports can be preferable a better solution when compared to API calls when using the statistics API counterpart, especially if the volume of the information to be exported 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 a Datasync an (S)FTP Export Export data sync (hereinafter referred as to as an Instance) will be configured to export data from one or more MailUp Lists and about one MailUp channel (email, SMS).
Based on the kind of data export chose you can specify to add to the report a specific subset of recipient fieldsreferring 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:
- 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 define:
- What data is to be included in the report
Environments and export timeframe (indicate which MailUp lists you want to extract data from and the extraction period)
Anchor | ||||
---|---|---|---|---|
|
These information change based on the kind of export you have bought, for this reason they are detailed 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
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)
Anchor | ||||
---|---|---|---|---|
|
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.
Expand | ||
---|---|---|
| ||
|
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
Anchor | ||||
---|---|---|---|---|
|
You can define:
- when the data export will be executed: for example every day at 10:00 rather than every week on tuesday at 10:00 and so on.
- where the file CSV generated should be delivered: you can get the file from the MailUp SFTP server (this is the default behavior), rather than configure the Instance to deliver the file on 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.
- 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.
Info | ||
---|---|---|
| ||
In case of incremental export we suggest you to add the Date / time in the file name. In this way date and time of the extraction will be added to the name of the generated file, avoiding to override file generated by previous export. |
Table of Contents |
---|