Skip to main content

Introduction to BI export

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

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

Warning

The Engage FTP server should only be used for transfer of BI export files and NOT for storage. Files older than 180 days are removed by housekeeping jobs.

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. The columns to be exported can be configured. 

Message

Information about a created message and its settings.

MessageDelivery

Information about which contact received a message (not those included in a control group).

MessageControlGroup

The contacts in a control group. (Read more about control groups)

MessageDeliveryStatus

Contains information on delivery status listing different kind of delivery statuses for each sendout. Example status: Delivered, Blocked. Unsubscription is also included, with a timestamp. (Read more about delivery statuses)

MessageOpen

Information about email openings. Also contains user agent-data, which is raw data formatted from the email distribution system sendgrid.

MessageClick

Data on what has been clicked on, and when.

Promotion

Information regarding a created promotion template.

PromotionRecipient

Information about who the recipients of a promotion are and what status the promotion has.

BonusPointTransaction

This export gives you information on all bonus point transactions. WARNING: this export is deprecated.

MasterControlGroupHistory

Which contacts are included in the master control group. (Read more about master control groups)

Receipt

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

ReceiptItem

Information on the transaction rows.

PointAccount

This exports all point balances.

PointTransaction

This exports all points transaction.

SavedSearch

This export contains all saved searches.

TargetAudienceToContact

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

SendList

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

SendListOptOut

This gives you all historical opt-outs from the list supplied by the customer.

SendListOptIn

This gives you all historical opt-ins from the list supplied by the customer.

PredictiveScoring

This 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 with labels tagged to them, and shows you which labels they are.