Hey all! I’m researching different ways to do our next feature and I have some doubts about if RevenueCat can handle the following use case:
We want to build a cashback feature with certain rules based on the app usage of the user in a given period of time. To be able to do that we need to know all the payments received in a given period of time to be able to calculate the amount of money to cashback and to whom.
Is there a way to easily do that with RevenueCat?
An example flow that might be enough:
Every first of the month, we can download a .csv file with a list of events occurred in a given period (past month) including:
userId - amount ($) - event (renewal/initial_purchase) - timestamp - duration (monthly, annual) - productId
Best answer by sharifView original
You can use our ETL export feature to get a daily CSV file in your AWS bucket/GCP Storage containing all of your app’s transaction data. You’d be able to query the CSV file (you can import it into BigQuery or any other database) for every transaction a user made and be able to calculate the sum of their payments. Let me know if you have any other questions!