# Overview

Open Loyalty allows you to automatically export your system data—such as members, transactions, and points—directly to your organization's cloud storage. By accessing this raw data, you can build powerful custom reports, feed your internal Data Warehouses, or connect directly to Business Intelligence (BI) tools.

### Why use Data Exports?

While the Open Loyalty Admin Panel provides quick insights, Data Exports allow for deeper analysis:

* **Granular Access:** Access row-level data for every transaction, member, and event.
* **Historical Analysis**: Analyze trends over long periods without UI limitations.
* **Data Sovereignty:** Keep a copy of your loyalty data in your own infrastructure (AWS, Azure, or Google Cloud).
* **Advanced Reporting:** Combine loyalty data with your e-commerce or ERP data to calculate advanced metrics like *Customer Lifetime Value (CLV)* or *ROI*.

### Common Use Cases

Here are a few ways our clients leverage these exports:

1\. Financial Reporting & Liability Track the exact number of active points in your system to calculate financial liability. By importing the `Points` and `Transactions` files into Excel or a BI tool, you can see exactly how many points are pending, active, or expiring in the coming month.

2\. Campaign Performance Dashboards Connect tools like Tableau, PowerBI, or AWS QuickSight directly to your storage bucket. You can visualize which campaigns are driving the most revenue and how reward redemption rates fluctuate seasonally.

3\. Enterprise Data Warehousing Use ETL tools (like AWS Glue or Azure Data Factory) to automatically ingest the daily CSV files into your company's central Data Warehouse (e.g., Snowflake or BigQuery). This ensures your marketing and sales teams have a 360-degree view of the customer, including their loyalty status.

### Supported Cloud Providers

We support seamless integration with the major cloud providers. You can choose the one that fits your current technology stack:

* **Amazon Web Services (AWS):** We can grant access to our S3 bucket or replicate data directly to yours.
* **Google Cloud Platform (GCP):** We upload files directly to your Google Cloud Storage buckets.
* **Microsoft Azure:** We upload files directly to your Azure Blob Storage containers.

### How it Works

1. **Daily Exports:** Every day (after midnight), Open Loyalty generates CSV files containing the data changes (deltas) from the previous day.
2. **File Structure:** Files are organized by type (e.g., `Transactions/`, `Members/`, `Points/`).
3. **Automation**: Your system detects the new files and processes them according to your needs.

***

## Learn more about

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Set Up Integration</strong></td><td>Learn how to configure the connection for AWS, Azure, or GCP</td><td></td><td><a href="set-up-integration">set-up-integration</a></td></tr><tr><td><strong>Data Structure &#x26; Types</strong></td><td>Explore the detailed schema of the CSV files available for export</td><td></td><td><a href="data-structure-and-types">data-structure-and-types</a></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.openloyalty.io/technical-guide/data-exports/overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.