> ## Documentation Index
> Fetch the complete documentation index at: https://developer.voyado.com/llms.txt
> Use this file to discover all available pages before exploring further.

# BI Export

BI Export delivers your Engage data as *structured CSV files on your FTP server*. The data is cleaned, curated, and organized into ready-to-use exports. You don't need to build ingestion logic or transform the data yourself before analyzing it.

## What is an export?

An **export** is a flat-file dataset for a single entity in Engage. Each export contains one logical table, delivered as a CSV file. For example:

* The "Contact" export is a list of all contacts in your Engage instance
* The "Receipt" export is a list of all transaction headers
* The "Message" export is a list of all messages and their settings

Each export runs independently and produces its own file. Exports are performed once per day, during the night. The exact time is configurable in the Engage back-end.

<Tip>
  Contact your implementation manager or CSM if you want to make changes to the export schedule.
</Tip>

While Delta Share delivers data as "data products" (packaged datasets that group multiple related tables around one business domain) BI Export delivers one table per file, per entity.

## How exports relate

Although each export is delivered as an independent file, the exports are *designed to be joined together*. Every export contains shared identifier fields (GUIDs) that let you reconstruct relationships across the dataset.

* Most exports revolve around "Contact" as the central entity
* From there, "Receipt" and "ReceiptItem" connect via the `receiptId` value
* Messages and their delivery events connect via `messageId` and `deliveryId`
* And stores are joined via `storeId`

This matters when you plan your analytics. You will typically load multiple exports into your warehouse or BI tool and join them to generate insights. Here are some analysis examples:

<AccordionGroup>
  <Accordion title="Purchase analysis">
    * Combine the "Receipt" and "ReceiptItem" exports using the `receiptId` value
    * Add also "Contact" using `contactId` to gain customer-level insight
  </Accordion>

  <Accordion title="Campaign performance">
    Using the `messageId` and `deliveryId` values, join these four exports:

    * "Message"
    * "MessageDelivery"
    * "MessageOpen"
    * "MessageClick"
  </Accordion>

  <Accordion title="Store-level reporting">
    * Join the "Receipt" and "Store" exports using `storeId`
  </Accordion>

  <Accordion title="Loyalty tracking">
    Using the `contactId` value, join these exports:

    * \`Contact
    * "PointAccount"
    * "PointTransaction"
  </Accordion>
</AccordionGroup>

## BI exports available

Exports marked `*` are only available for customers using Design Studio.

### Contact and loyalty

<Card title="Contact" href="/docs/data-access/bi-exports/contact" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Contact records per contact type. Exported columns are configurable
</Card>

<Card title="Consent" href="/docs/data-access/bi-exports/consent" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Consent records and associated fields.
</Card>

<Card title="PointAccount" href="/docs/data-access/bi-exports/point-account" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Point balances per contact.
</Card>

<Card title="PointTransaction" href="/docs/data-access/bi-exports/point-transaction" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  All point transactions.
</Card>

<Card title="PredictiveScoring" href="/docs/data-access/bi-exports/predictive-scoring" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Predictive scoring fields from the contact card.
</Card>

## Transactions

<Card title="Receipt" href="/docs/data-access/bi-exports/receipt-and-items" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Transaction headers. One row per transaction. Joined to "ReceiptItem" export via `receiptId`.
</Card>

<Card title="ReceiptItem" href="/docs/data-access/bi-exports/receipt-and-items" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Transaction line items. Each row links back to its "Receipt" export header.
</Card>

## Messages & campaigns

<Card title="Message" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  All created messages and their settings. The root of the message-related exports.
</Card>

<Card title="MessageDelivery" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Which contacts received a message. Excludes control groups.
</Card>

<Card title="MessageDeliveryStatus" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Delivery status per sendout (Delivered, Blocked, and so on).
</Card>

<Card title="MessageOpen" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Email-open events including user agent data.
</Card>

<Card title="MessageClick" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Click events with timestamps and target URLs.
</Card>

<Card title="MessageControlGroup" href="/docs/data-access/bi-exports/message-and-delivery" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Contacts that were assigned to the control group for a message.
</Card>

## Promotions

<Card title="Promotion" href="/docs/data-access/bi-exports/promotions" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Promotion template information.
</Card>

<Card title="PromotionRecipient" href="/docs/data-access/bi-exports/promotions" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Recipients and their promotion status.
</Card>

## Segmentation

<Card title="Labels" href="/docs/data-access/bi-exports/labels" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  All labels stored in Engage.
</Card>

<Card title="LabelsToTaggedContact" href="/docs/data-access/bi-exports/labels" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Contacts with labels and which labels are applied.
</Card>

<Card title="SavedSearch" href="/docs/data-access/bi-exports/saved-search-target-audience" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  All saved searches.
</Card>

<Card title="TargetAudienceToContact" href="/docs/data-access/bi-exports/saved-search-target-audience" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Which contacts belong to which target audience.
</Card>

<Card title="MasterControlGroupHistory" href="/docs/data-access/bi-exports/mcg-history" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Contacts included in the master control group.
</Card>

## Stores

<Card title="Store" href="/docs/data-access/bi-exports/store" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  All store records. Joined to "Receipt" export via `storeId`.
</Card>

## Design Studio

With the introduction of the Design Studio, new BI exports were introduced to Engage, enabling BI teams to analyze campaign structure, market distribution, and cross-market performance.

In these exports, the central concepts are sendouts and marketing groups.

<Columns cols={2}>
  <Card title="Learn about the sendout builder" href="https://help.engage.voyado.com/hc/en-gb/articles/21713422086684-Introduction-to-the-sendout-builder" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />

  <Card title="Learn about marketing groups" href="https://help.engage.voyado.com/hc/en-gb/articles/19093164265500-Introduction-to-marketing-groups" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />
</Columns>

<Warning>
  The Email, Sendout and MarketingGroup exports are *only* available for customers using Design Studio.
</Warning>

<Card title="Email" href="/docs/data-access/bi-exports/design-studio" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Email-level data for sendouts created in Design Studio.
</Card>

<Card title="Sendout" href="/docs/data-access/bi-exports/design-studio" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  Records of sendouts created and managed in Design Studio.
</Card>

<Card title="MarketingGroup" href="/docs/data-access/bi-exports/design-studio" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/developer-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=fbd08f956358ab12f664a7158e1a1399" horizontal width="128" height="128" data-path="icons/developer-link.png">
  The marketing Groups used to segment contacts by market.
</Card>

## Accessing your exports

To set up BI Export for your Engage instance, follow the setup guide on Help Center:

<Card title="See how to export data to BI exports" href="https://help.engage.voyado.com/hc/en-gb/articles/17236102112284-Export-data-to-BI" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />

Your exports, once processing is complete, are placed on Engage's internal FTP server.

```http theme={null}
[base-ftp-url]/integration/export
```

<Warning>
  The Engage FTP server should only be used for transfer of BI export files and NOT for storage. Files older than 180 days will be automatically removed by housekeeping jobs.
</Warning>

## Additional information

* Exports run once per day. If you need higher-frequency access, consider using Delta Share.
* The columns in the "Contact" export are configurable. To add or remove files, or to adjust exported fields, contact Support.
* Exports marked `*` above require Design Studio.

## Learn more

<Card title="See about control groups in message exports" href="https://help.engage.voyado.com/hc/en-gb/articles/17233959620508-Control-groups" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />

<Card title="Understand message delivery statuses" href="https://help.engage.voyado.com/hc/en-gb/articles/17233959620508-Control-groups" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />

<Card title="Read about target audiences and saved searches" href="https://help.engage.voyado.com/hc/en-gb/articles/17233034026396-Working-with-target-audiences" icon="https://mintcdn.com/voyado/Ns4bBcK3LNctK_Un/icons/help-center-link.png?fit=max&auto=format&n=Ns4bBcK3LNctK_Un&q=85&s=3e7ca2ce0b8cfb9fbd27a4bdf53b2ce1" horizontal width="128" height="128" data-path="icons/help-center-link.png" />
