All case studies ETL, pipelines and analytics

Problem the client raised We can't see where users drop off before paying.

Connecting payments to product behavior

Onboarding drop-off can now be traced all the way to revenue.

Client
Consumer subscription app in the privacy space
Tools
  • PostHog
  • Stripe
  • Customer.io

Client names and data are withheld under confidentiality agreements.

The leak

Payment data was separate from product usage. The team couldn't see where users dropped off between signup, onboarding and paying.

How it fits together

  • Stripe webhooks
  • Production database
  • App and consent gate
  • Backend
  • PostHog
  • Funnel and retention dashboards
  • Lifecycle messages
Illustrative data flow.

What was built

  1. Real-time payment events captured from billing webhooks in the backend and sent to product analytics.
  2. A historical backfill of payment and user data from the production database.
  3. Dashboards for conversion funnels, onboarding drop-off, retention, stickiness, lifecycle and user paths.
  4. A lifecycle messaging tool wired into the codebase.
  5. An analytics consent flow built to meet GDPR.

Got a process that has annoyed you for a year?

45 minutes. We map it, cost it, and tell you if it's worth fixing.

Book a Systems Review