Closed ivanagas closed 3 months ago
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.
select any that apply
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.) [x] Low-level guide (step-by-step guide / tutorial) [ ] Other (please specify)
select any that apply [ ] Founders [x] Engineers [x] Growth [x] Marketing [ ] HackerNews [x] Existing PostHog users [ ] Potential PostHog users
list any that apply
Stripe reports
suggest a few angles
How to set up Stripe reports
How to set up Stripe reports in PostHog
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
draft headings / questions you want to answer
Summary
How to set up Stripe reports in PostHog using the data warehouse.
Where will it be published?
Why type of article is this?
Who is the primary audience?
What (if any) keywords are we targeting?
Stripe reports
Headline options
How to set up Stripe reports
How to set up Stripe reports in PostHog
Will it need custom art?
Outline (optional)