HomepageCase studiesBook a demo

Overview

Unlock the full potential of your loyalty data with automated cloud exports.

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

Set Up Integration

Learn how to configure the connection for AWS, Azure, or GCP

Data Structure & Types

Explore the detailed schema of the CSV files available for export

Last updated

Was this helpful?