Tutorial - How to set up Stripe reports

[ivanagas]

Summary

Write a short paragraph on what this article is about. If applicable, what's the opinion or point we want to make in this article?

How to set up Stripe reports in PostHog using the data warehouse.

Where will it be published?

select any that apply

• Blog
• Founders Hub
• Newsletter
• Product engineers Hub
• Tutorials
• Other (please specify)

Why type of article is this?

select any that apply

• High intent (i.e. comparisons and similar)
• Brand / opinionated (how we work and why, etc.)
• High-level guide (concepts, frameworks, ideas, etc.)
• Low-level guide (step-by-step guide / tutorial)
• Other (please specify)

Who is the primary audience?

select any that apply

• Founders
• Engineers
• Growth
• Marketing
• HackerNews
• Existing PostHog users
• Potential PostHog users

What (if any) keywords are we targeting?

list any that apply

Stripe reports

Headline options

suggest a few angles

How to set up Stripe reports

How to set up Stripe reports in PostHog

Will it need custom art?

• Yes
• No

Outline (optional)

draft headings / questions you want to answer

• You need a Stripe and a PostHog account
• Link Stripe as a source in data warehouse
  • https://posthog.com/docs/data-warehouse/setup#stripe
• Start querying
  • Count of subscriptions, charges, customers
  • Gross revenue
  • Monthly recurring revenue
    • This is tricky actually https://www.getlago.com/blog/calculating-stripe-mrr-is-difficult
  • Average order size
  • Average revenue per user
    • Maybe combine with product data?
  • Revenue churn
  • Big customer pageview count
  • Big customer usage