3 ms·

Stripe data is messy – is it for profit maximisation?

• maxisaurus 3y ago
  Same for Chargebee lol. Was an analytics lead at a fintech company. We computed our revenues in our data warehouse based on Chargebee data. It was a nightmare because: #1 - raw data is indeed very messy. #2 - MRR can be theoretically be computed on either the invoice or the subscription table. Using invoice: sum the subscriptions fees by month. Using subscription: sum the subscription fees for the period where the subscription was active . Well, does not really work that way. In practice, invoice table holds a lot of noisy information not useful for MRR and get the active period for a subscription is not straightforward (involves snapshots and scd). #3 — Discounts and offers. Chargebee's coupons and discount pretty much are a blackbox with some pecking order. Long story short: we never had the same number as Chargebee UI.
  • maxisaurus 3y ago
    (love what you do at Lago btw!)
    • AnhTho_FR 3y ago
      Thanks! Really appreciate it!