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
Answer
How to get a list of subscription events within a given period of time?
+5Best answer by sharif
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!
This post has been closed for comments
+9You 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!
+3
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.