Question

How to get a list of subscription events within a given period of time?

  • 30 September 2021
  • 1 reply
  • 12 views

Badge

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
 


1 reply

Userlevel 3
Badge +8

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!

Reply