Skip to main content

Voyado Engage

Message & delivery - export fields

Message

Field

Description

Data type

Example value

messageId

Unique id for Message.

GUID

BA270CBB-EAEA-4237-AA4A-A53100909FA2

messageName

Name of the Message.

string

2020-06 Summer season

subject

Subject line of the Message.

string

"Digitalize your memories before summer"

status

Sending status of the message.

string

scheduled, inprogress or completed

scheduledDateTime

When the message started processing.

datetime

2012-04-14 16:10:21+01:00

recipientCount

Total number of recipients for the message (0 for postal).

int

123 134

channel

Which communication channel the message was sent through.

string

sms, email or postal

sendList

Tells you which send list the message was connected to. (Send lists are unique for each client)

string

Campaign, Newsletter

messageSource

Tells you if the message was sent manually or through an automation

string

Automation

isTransactional

Tells if a message was sent transactionally (if true, it doesn't take opt-out into account)

boolean

True

controlGroupPercent

Shows the percentage of recipients that were included to the control group of the message sendout.

decimal

5,0

senderStoreId

Presents the store id if message was chosen to be sent as a specific store.

string

101

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE

MessageDelivery

Field

Description

Data type

Example value

deliveryId

Unique delivery id for each contact

GUID

4A220CBG-EAEA-4237-A59A-B98101209FA2

messageId

Unique id for Message

GUID

BA270CBB-EAEA-4237-AA4A-A53100909FA2

contactId

Unique contact id

GUID

5307c938-55fc-4fd8-9512-aab500977e67

deliveryDateTime

Delivery date or planned delivery date for postal sendouts.

datetime

2020-04-14 15:12:33+01:00

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE

MessageDeliveryStatus

Field

Description

Data type

Example value

deliveryId

Unique delivery id for each contact

GUID

4A220CBG-EAEA-4237-A59A-B98101209FA2

deliveryStatus

The current status of the delivery.

string

delivered, waiting, hardbounce, softBounce

optOutDateTime

Timestamp for when the customer unsubscribed from email communication.

datetime

2020-04-15 15:19:33+01:00

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE

MessageOpen

Field

Description

Data type

Example value

openId

Unique open id (Several id:s can be connected to one delivery)

GUID

9B520C7G-YAEA-4237-A59A-B98101209FA2

deliveryId

Unique id for delivery

GUID

4A220CBG-EAEA-4237-A59A-B98101209FA2

messageId

Unique id for the message

GUID

BA270CBB-EAEA-4237-AA4A-A53100909FA2

openDateTime

Timestamp on when customer opened the email.

datetime

2020-04-15 18:19:33+01:00

userAgent

UserAgent tells us in what platform the contact opened the email.

string

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/602.3.12 (KHTML, like Gecko) Version/10.0.2 Safari/602.3.12

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE

MessageClick

Field

Description

Data type

Example value

clickId

Unique id for logged click (Several id:s can be connected to one delivery)

GUID

7C420CBG-RARA-3437-A59A-B98701209FA2

messageId

Unique id for the message

GUID

6A220CBG-EAEA-4237-A59A-B98101209FA2

deliveryId

Unique id for the delivery

GUID

4A220CBG-EAEA-4237-A59A-B98101209FA2

clickDateTime

Timestamp on when customer clicked a link in the email.

datetime

2020-04-15 18:19:33+01:00

url

The link adress which was clicked.

string

https://integrate.voyado.com

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE

MessageControlGroup

Field

Description

Data type

Example value

messageControlGroupId

Unique control group id (identity)

int

12345

messageId

Unique id for the message

GUID

BA270CBB-EAEA-4237-AA4A-A53100909FA2

contactId

Unique id for the contact

GUID

5307c938-55fc-4fd8-9512-aab500977e67

changeType

An indication that tells you if the row have been created, updated or deleted.

string

CREATE/UPDATE/DELETE