Skip to main content
Question

Best source of truth for analyzing historical raw data?

  • February 16, 2024
  • 2 replies
  • 101 views

Seth Miller
Forum|alt.badge.img+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

Jens
RevenueCat Staff
Forum|alt.badge.img+7
  • RevenueCat Staff
  • February 16, 2024

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


Seth Miller
Forum|alt.badge.img+6
  • Author
  • Member
  • February 16, 2024

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