S3 Bucket Exports
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.
With OL, 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.
Data available for export to AWS S3
The export frequency is set to daily to ensure consistent and timely access to the data for all our customers.
Achievements
The Achievements file shows the data of achievements like the achievement ID, achievement name, status, and date of creation. Below you can find the sample file:
Achievement Usage
The Achievement Usage shows the achievement progression of a specific member including data like achievement ID, achievement name, achievement description, member ID, if the limit is reached, amount of achievement completion, and the member progress rules. Below you can find the sample file:
Campaigns
The Campaigns file shows the information about the campaign configuration set in the Open Loyalty. Below you can find the sample file:
Campaign Execution
The Campaign Execution shows When and what transaction triggered the campaign. Below you can find the sample file:
Campaign Calculated Effect Result
The file shows the calculation of the effect results of the campaign. Below you can find the sample file:
Members
The Members file shows information about all your members. Below you can find the sample file:
Custom Events
The Custom Events file shows information about custom events associated with the members in the Open Loyalty. Below you can find the sample file:
Rewards
The Rewards file shows information about rewards set in the Open Loyalty. Below you can find the sample file:
Rewards Redemption
The Rewards Redemption file shows information about members' rewards redemptions. Below you can find the sample file:
Transactions
The Transactions file shows information about transactions matched with members. Below you can find the sample file:
Tiers
The Tiers file shows the data of tiers. Below you can find the sample file:
Units transfers
The Units transfers file shows the points transactions connected to the specific members. Below you can find the sample file:
Approaches available for leveraging OL'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: OL 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 OpenLoyalty 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.
Last updated