> ## 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, delivered as CSV files. For example:

* The "Receipt" export is one file with a list of all transaction headers
* The "Message" export is one file with a list of all messages and their settings
* The "Contact" export provides a list of all contacts in your Engage environment delivered as one file per contact type

Some important points about exports:

* Each export runs independently and produces its own file (or files).
* 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" />
