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.
Last updated
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
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.
The export frequency is set to daily to ensure consistent and timely access to the data for all our customers.
There is one report set for the environment, regardless of the number of tenants created. There is a unique identifier (tenant_id) for all the reports. Then you can create pipelines to further split the data per tenant.
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:
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:
The Campaigns file shows the information about the campaign configuration set in the Open Loyalty. Below you can find the sample file:
The Campaign Execution shows When and what transaction triggered the campaign. Below you can find the sample file:
The file shows the calculation of the effect results of the campaign. Below you can find the sample file:
The Members file shows information about all your members. Below you can find the sample file:
The Custom Events file shows information about custom events associated with the members in the Open Loyalty. Below you can find the sample file:
The Rewards file shows information about rewards set in the Open Loyalty. Below you can find the sample file:
The Rewards Redemption file shows information about members' rewards redemptions. Below you can find the sample file:
The Transactions file shows information about transactions matched with members. Below you can find the sample file:
The Tiers file shows the data of tiers. Below you can find the sample file:
The Units transfers file shows the points transactions connected to the specific members. Below you can find the sample file:
The Tenants file shows the list of tenants that exist in the system. Below you can find the sample file:
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.
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.