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
Email	email	recipient email address	j ohn.smith@myprovider.com
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. Possible values are: OPN (open) CLK (click) NCO (not delivered - bounce) SNT (sent)	OPN if the system records the action of downloading the images in the message CLK if the system records a click NCO in case of bounce SNT when a campaign was sent to a certain recipient
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.	http://www.clickedlink.com/home.html HB (hard bounce) Blank field if status=OPN or status=SNT
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

Examples

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

Report CSV

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)

Report CSV

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

Report CSV

"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

Browser not supported