Question

Best source of truth for analyzing historical raw data?

  • 16 February 2024
  • 2 replies
  • 15 views

Badge +6

We’ve been storing raw webhooks in our db for quite some time but then have also had the GCS cloud storage export going for a while. 

 

What would you recommend when it comes to analyzing raw data? is there a difference in the data structures? We want to create some of our own LTV charts, etc with our user context. 

 

CC @Jens 🙏


This post has been closed for comments

2 replies

Userlevel 5
Badge +7

Definitely the scheduled data exports, not the webhooks. They have a lot richer data. We even have example queries here: https://www.revenuecat.com/docs/integrations/scheduled-data-exports#sample-queries-for-revenuecat-measures

Badge +6

amazing thanks @Jens - think the biggest challenge will be coordinating the app_user_id (and the alias stuff) with our db as a way to link by say sign up date, track engagements, etc