Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Info |
---|
(S)FTP-based data synchronization is synchronizations are not available as an out-of-box feature by default (additional costs may charges will apply), contact your sales representative for an estimation. Data synchronizations are not available to MailUp trial accounts. |
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 solution when compared to approach than using the statistics API counterpart, especially if the volume of the information returned 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 a series an array 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 more MailUp Lists and 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:
When an Instance is active you can defineWith every instances, it can be defined:
- indicate
i.e. which MailUp lists you want to extract data from and the extraction period)
Anchor | ||||
---|---|---|---|---|
|
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:
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
encoleenclose data when needed: you can choose between double
quotequotes ( " ), or single quote ( ' )
Datatime Format for any date/time field type
File encoding, the encoding type of the physical CSV file delivered:
you can chooseone between UTF-8 (includes both Latin and other alphabets characters)
,or ANSI (include only Latin characters) can be selected.
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 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 date/time the last export executedsame export ran successfully last time.
Expand | ||
---|---|---|
| ||
|
These settings can change based on the kind of (S)FTP export. You can find further details in the proper each specific help page.:
Anchor | ||||
---|---|---|---|---|
|
You It can definebe defined:
when the data export will be executed: for example every day at 10:00
rather than every week on tuesdayor every Tuesday at 10:00
and so on.
where the file CSV
generatedshould be delivered: you can
getretrieve the file from the MailUp SFTP server (
thiswhich is the default behavior),
rather than configureas opposed to having the Instance configured to deliver the csv file
onover an external (S)FTP server
characteristics of the generated properties 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.
Info |
---|
Important NoteIn case of incremental export we suggest you to add use the Date / time in the (timestamp) as part of the csv file name. In this way Doing so, the date and time of the extraction will be added to the name of the generated file, avoiding to override file generated by previous export.delivered file, preventing the system from overwriting csv files coming from previous export sessions/periods |
Table of Contents |
---|