LogoLogo
HomepageCase studiesBook a demo
Technical Guide
Technical Guide
  • Introduction
  • Getting Started Guide
    • Authentication
    • Member Registration Configuration
    • Add Webhook
    • Add Member
    • Create Campaign
    • Add Transaction
    • Add Custom Event Schema
    • Create Achievement
    • Add Custom Event
  • Terms Reference
  • Backward Compatibility Policy
  • API Reference
  • Postman Collection
  • User Guide
  • Integration
    • Introduction
    • Overview of Integration Methods
    • Tools and Technologies
    • Integration Examples
      • Lambda
      • Zapier
      • AWS EventBridge
      • Kafka
  • API Fundamentals
    • Overview
    • Environments Capabilities
    • How to Query
    • Limits
    • Best Practices
  • Authentication
    • Admin Token
    • Access Token (API Key)
    • Enabling SSO Login
      • Okta
      • Microsoft Entra ID
  • Webhooks
    • Overview
    • Best Practices
  • S3 Bucket Data exports
    • Overview
    • Set Up S3 Bucket Integration
    • Data Structure and Types
      • Achievements
      • Achievement Usage
      • Campaigns
      • Campaign Calculated Effect Result
      • Campaign Execution
      • Custom Events
      • Members
      • Rewards
      • Rewards Redemption
      • Tiers
      • Transactions
      • Tenants
      • Unit Transfers
Powered by GitBook
On this page
  • Approaches available for leveraging Open Loyalty's data exporting capabilities
  • Use Case
  • Learn more about

Was this helpful?

  1. S3 Bucket Data exports

Overview

Here, you will learn more about S3 Bucket Exports - how to use them, what data can be found there, and the best approaches to leveraging Open Loyalty export capabilities.

Last updated 1 month ago

Was this helpful?

With Open Loyalty, you have the ability to seamlessly export your data as a CSV file directly to the AWS S3 (Simple Storage Service) buckets. This allows you to access and retrieve the data effortlessly, empowering you to construct detailed reports that go beyond simple data sets, perform insightful analyses, visualize your data with tools like Quicksight, and much more.

Approaches available for leveraging Open Loyalty's data exporting capabilities

  • Exporting a CSV file and importing it into tools like Quicksight: With this approach, you can easily export your data to a CSV file and import it into popular data visualization tools such as Quicksight. This enables you to create visually appealing reports and gain valuable insights.

  • Directly connecting data visualization tools to S3: Open Loyalty offers the convenience of connecting your preferred data visualization tool directly to the AWS S3 buckets. By doing so, you can streamline the data retrieval process

  • Implementing advanced ETL processes or integrating with existing ones: For those seeking more advanced capabilities, Open Loyalty enables you to implement advanced ETL processes or seamlessly integrate your data with existing ETL workflows. This empowers you to create custom reports that merge your data with the organization's comprehensive dataset


Use Case

The Analytical Dashboard version 0.1 in the QuickSight application enables quick and accurate analysis of units within the Open Loyalty system.

We have the option to select the date range for transfers from 01/06/2023 to 31/07/2023. Beyond this date, we can efficiently observe the distribution of five unit types: Issued Units, Active Units, Pending Units, Spent Units, and Expired Units.

Furthermore, we can track the progress of key metrics such as breakage and Redemption growth over a specific period of time.


Learn more about

Integration

How to set up integration with S3 Bucket

Export Types

Check all available data exports and their structure