Published — v. 9

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

Email

email

recipient email address

john.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 ididInvioUnique identifier of the of the MailUp sendout20

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 datestatusChange

Date of the operation saved in the record. It can indicate the date of an open, a click or a bounce 

20220121T141244
Event DetailsdetailsThe 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 datesentDateThe date when the email message was sent20220121T111244
MailUp group idgroupids

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
TagTag

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 codecampaignCode

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)listNameName of the MailUp list from which the email message was sent and the data registeredNewsletter
MailUp group namesgroupNames

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 addressMailUp 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 addressMailUp list idMessage 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 addressMailUp 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