Export Email Statistics
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.
This export type displays the statistical data about Email channel related to one or more Mailup lists in a certain time frame.
The eventual layout is partly configurable.
What data is to be included in the report
The CSV report can reports data about Sent, Opens, Clicks and Bounces for each email message sent from selected lists.
You can set the instance to choose which one are the events included in the report.
You can set the instance to generate reports that contains one or more of the following data except for the email address and the MailUp list id, which are required values that will always be enclosed in the report
Data | Header Display Name | Description | Examples |
|---|---|---|---|
recipient email address | |||
MailUp list id | idList | Unique identifier of the MailUp list from which the email message was sent and where the statistical data are registered | 1 |
Recipient Id | idoptin | Unique identifier of the MailUp subscriber who triggered a statistical event | 1 |
Email Message Id | idNl | Unique identifier of the of the MailUp newsletter that was sent | 12 |
| Sendout id | idInvio | Unique identifier of the of the MailUp sendout | 20 |
Message subject | subject | Subject of the MailUp newsletter | 🚘Your car policy is about to expire⌚ |
Event Type | statusType | The event the report row relates to.
|
|
| Event date | statusChange | Date of the operation saved in the record. It can indicate the date of an open, a click or a bounce | 20220121T141244 |
| Event Details | details | The detail could be the link clicked for a click event or the type of bounce for a bounce event. The detail isn't valued for sent and open event. |
|
| Email sent date | sentDate | The date when the email message was sent | 20220121T111244 |
| MailUp group id | groupids | Any unique identifier of the MailUp Groups to which the recipient is added at the time of export. In case of multiple values, expect a string value separated by comma | 3,5 |
| Tag | Tag | The Tag related to the MailUp newsletter that was sent In case of multiple values, expect a string value separated by comma | receipt,sea_hotel |
| SMTP + campaign code | campaignCode | Useful only in case of transactional or SMTP+ mailings. The string that is used for message aggregation used during transactional or SMTP+ mailings | campaigncode1 |
| MailUp environment names (List names) | listName | Name of the MailUp list from which the email message was sent and the data registered | Newsletter |
| MailUp group names | groupNames | Any name of the MailUp Groups to which the recipient is added at the time of export. In case of multiple values, expect a string value separated by comma | group1,group2 |
| Recipient fields | Data saved in the recipients personal data fields. You can select those of your interest to the report |
It is required to export email address, MailUp list id, Email Message Id, Sendout id, Message subject, Event Type, Event date, Event Details, Email sent date for each event
idList,idInvio,idNl,email,subject,statusType,details,statusChange,sentDate 1,21231,3574,mail1@mailup.com,Energy: this is your new offer,OPN,,2022-12-29 04:16:43,2022-12-20 16:47:04 1,21231,3574,mail2@mailup.com,Energy: this is your new offer,OPN,,2022-12-29 16:01:04,2022-12-20 16:47:04 1,21079,3555,mail1@mailup.com,"installment of 367,77€ of your mortgage",CLK,https://www.mysite.com,2022-12-29 08:09:24,2022-12-15 13:01:20 1,21420,417,mail3@mailup.com,Do you want change your car? Save money with long term rental,NCO,SBMF,2022-12-29 18:14:41,2022-12-29 18:09:30 1,21420,417,mail3@mailup.com,Do you want change your car? Save money with long term rental,SNT,,,2022-12-29 18:09:30 1,21420,417,mail2@mailup.com,Do you want change your car? Save money with long term rental,SNT,,,2022-12-29 18:09:52
It is required to export email address, MailUp list id, Message subject, Event Type, Event date, Event Details, Email sent date for each event and one recipient field (with id 28)
idList,idInvio,idNl,email,subject,statusType,details,statusChange,sentDate,Campo28 1,21231,3574,mail1@mailup.com,Energy: this is your new offer,OPN,,2022-12-29 04:16:43,2022-12-20 16:47:04,050340000000005530967 1,21231,3574,mail2@mailup.com,Energy: this is your new offer,OPN,,2022-12-29 16:01:04,2022-12-20 16:47:04,050570000000005530856 1,21079,3555,mail1@mailup.com,"installment of 367,77€ of your mortgage",CLK,https://www.mysite.com,2022-12-29 08:09:24,2022-12-15 13:01:20,050340000000005530967 1,21420,417,mail3@mailup.com,Do you want change your car? Save money with long term rental,NCO,SBMF,2022-12-29 18:14:41,2022-12-29 18:09:30,050340000000005530645 1,21420,417,mail3@mailup.com,Do you want change your car? Save money with long term rental,SNT,,,2022-12-29 18:09:30,050340000000005530645 1,21420,417,mail2@mailup.com,Do you want change your car? Save money with long term rental,SNT,,,2022-12-29 18:09:52,050570000000005530856
It is required to export email address, MailUp list id, Email Message Id, Sendout id, Event Type, Event date, Event Details, Email sent date, Tag and MailUp group id for each event
"idList";"idInvio";"idNl";"email";"statusType";"details";"statusChange";"sentDate";"Tags";"GroupIds" "1";"4817";"2158";"mail1@mailup.com";"SNT";"";"";"20230113T015837";"SomDocents";"51" "1";"4817";"2158";"mail1@mailup.com";"OPN";"";"20230113T173113";"20230113T015837";"SomDocents";"51" "1";"4817";"2158";"mail1@mailup.com";"CLK";"https://mailup.com";"20230113T173137";"20230113T015837";"SomDocents";"51" "1";"4817";"2158";"mail2@mailup.com";"SNT";"";"";"20230113T015837";"SomDocents";"51" "1";"4817";"2158";"mail2@mailup.com";"OPN";"";"20230113T015851";"20230113T015837";"SomDocents";"51" "1";"4832";"2161";"mail2@mailup.com";"OPN";"";"20230113T163532";"20230113T163525";"";"" "1";"4832";"2161";"mail2@mailup.com";"SNT";"";"";"20230113T163525";"";"" "1";"3596";"1862";"mail3@mailup.com";"CLK";"https://mailup.com";"20230113T163521";"20210104T070016";"SomDocents,oldnewsletter";"44,50,74" "1";"3656";"1871";"mail3@mailup.com";"CLK";"https://mailup.com";"20230113T103739";"20210204T073103";"SomDocents,oldnewsletter2";"44,50,74" "1";"4817";"2158";"mail4@mailup.com";"NCO";"SBMF";"20230113T104050";"20230113T000509";"SomDocents";"51"
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 to generate a report containing:
- all events registered in the last 24 hours for the MailUp lists you have indicated
- all events registered from the last export executed for the MailUp lists you have indicated
Bounce chart
Allowed codes for bounces are listed in the table below
Bounce Type | Bounce Description |
AR | Auto Reply |
BN | Bounce No Email Address |
CR | Challenge-Response |
GB | General Bounce |
HB | Hard Bounce |
MB | Mail Block - General |
MBAD | Mail Block - Attachment Detected |
MBKS | Mail Block - Known Spammer |
MBRD | Mail Block - Relay Denied |
MBSD | Mail Block - Spam Detected |
NB | Non Bounce |
SB | Soft Bounce - General |
SBDF | Soft Bounce - Dns Failure |
SBMF | Soft Bounce - Mailbox Full |
SBMS | Soft Bounce - Message Size Too Large |
SR | Subscribe Request |
TB | Transient Bounce |
UR | Unsubscribe Request |