Skip to main content

Voyado Engage

Introduction to BI export

Engage's BI (business intelligence) export functionality allows our clients to export data, enabling analysis with third party tools. Using these separate data stores, Engage's data can be combined with other sources, allowing for deeper and more flexible analysis.

Exports are done on a nightly schedule. The exported files will appear on Engage's internal FTP-server, from where you can fetch the files and import them into a third party tool.

FTP location

[base ftp-url]/integration/export

Below are the different entities available for export:

Exports

Description

Contact

The contact export is a file definition for each contact type. What columns to export are optional. 

Message

This export contains information about a created message and its settings.

MessageDelivery

This export contains information regarding which contact received a message (not those included in a control group).

MessageControlGroup

This export contains information regarding which contact were included in a control group. (Read more about control groups)

MessageDeliveryStatus

This export contains information regarding delivery status where you can see different kind of delivery statuses for each sendout. Example status: Delivered, Blocked. Even unsubscription is included with a timestamp. (Read more about delivery statuses)

MessageOpen

This export gives you information regarding email openings. It also contains user agent-data, raw data formatted from email distribution system sendgrid.

MessageClick

This export gives you all the click-data. What, when and what links have been clicked.

Promotion

This export contains information regarding a created promotion template.

PromotionRecipient

This export gives you information regarding who the recipients are and what status the promotion has.

BonusPointTransaction

This export gives you information on all bonus point transactions. 

MasterControlGroupHistory

Tells you what contacts are included in the master control group. (Read more about master control groups)

Receipt

This export gives you information on all transaction. Only the head of the transaction is exported.

ReceiptItem

This export gives you information of the transaction rows.

SavedSearch

This export contains all saved searches.

TargetAudienceToContact

This export contains information on which contact belongs to what target audience. (Read more about Target audiences)

SendList

This export contains information on all subscription lists setup for the specific client. (Read more about subscription lists)

SendListOptOut

This export gives you all historical opt-outs from the list made by the customers.

SendListOptIn

This export gives you all historical opt-ins from the list made by the customers.

PredictiveScoring

This export gives you all the fields visible in the predictive scoring box on the contact card.

Consent

This export gives you the fields associated with consents.

Labels

This export returns all the labels stored in Engage.

LabelsToTaggedContact

This exports all contacts that have labels tagged to them, and shows you which labels they are.