Student pricing is available for eligible university email holders. View plans

NextSprints
NextSprints Icon NextSprints Logo
Product Design

Master the art of designing products

Product Improvement

Identify scope for excellence

Product Success Metrics

Learn how to define success of product

Product Root Cause Analysis

Ace root cause problem solving

Product Trade-Off

Navigate trade-offs decisions like a pro

All Questions

Explore all questions

Meta (Facebook) PM Interview Course

Practice Meta-focused PM cases

Amazon PM Interview Course

Practice Amazon-focused PM cases

Apple PM Interview Course

Practice Apple-focused PM cases

Google PM Interview Course

Practice Google-focused PM cases

Microsoft PM Interview Course

Practice Microsoft-focused PM cases

All Courses

Explore all courses

1:1 PM Coaching

Practice in a one-to-one session

Resume Review

Narrate impactful stories via resume

Guides Pricing
nextsprints logo

Not a member?

By proceeding, you agree to our Terms of Use and confirm you have read our Privacy and Cookie Statement.

nextsprints logo

Register to continue.

Login with Google Login with LinkedIn

By proceeding, you agree to our Terms of Use and confirm you have read our Privacy and Cookie Statement .

Company focus

PostHog

Net revenue retention for PostHog's Data Warehouse fell from 118% to 104% over two quarters. What is going on?

Prepared by NextSprints

13 mins
Report an error
Revenue Analysis Root Cause Analysis Pricing Strategy Data Infrastructure B2B SaaS Developer Tools Root-Cause-Analysis Net-Revenue-Retention Usage-Based-Pricing Data-Warehouse
Product Management Root Cause Analysis Question: PostHog Data Warehouse net revenue retention decline

Introduction

PostHog's Data Warehouse (now part of its broader "data stack" with Sources, Destinations and batch exports) lets teams sync data from Stripe, Postgres, HubSpot, Zendesk and other sources, then query it with SQL alongside product events. Customers pay per synced row beyond a free tier of 1 million rows a month. Net revenue retention (NRR) measures how much revenue a cohort of existing Data Warehouse customers generates now compared with a year earlier, including expansion, contraction and churn. A fall from 118% to 104% over two quarters means existing customers are expanding much less, or contracting and churning more. Because Data Warehouse is what lets PostHog answer revenue questions ("which features do our highest-paying customers use?"), weakness here threatens the all-in-one strategy. This is a hard question because NRR is a lagging, composite metric, and the cause could be pricing, product, customer mix or competition.

Framework overview

Decompose NRR into its components before forming hypotheses: gross expansion, contraction and churn. Each points to a different kind of root cause.

Step 1

Clarifying Questions (3 minutes)

  • How is NRR calculated for Data Warehouse?

  • Why it matters: Usage-based products have volatile monthly revenue.
  • Hypothetical answer: Trailing 12-month revenue from customers who paid for Data Warehouse a year ago, divided by their revenue a year ago, measured monthly.
  • Impact: Changes in billing rules show up directly.
  • Did anything change in pricing or billing?

  • Why it matters: Pricing changes are a common cause of revenue shifts.
  • Hypothetical answer: Two quarters ago, incremental syncs became the default for large tables, and historical syncs became an add-on.
  • Impact: Fewer synced rows could reduce revenue even with stable value.
  • Are customers churning from PostHog entirely or only from Data Warehouse?

  • Why it matters: Separates a product problem from a platform problem.
  • Hypothetical answer: Overall PostHog NRR is stable.
  • Impact: The problem is specific to Data Warehouse.
  • Has the positioning or target user changed?

  • Why it matters: The handbook notes research into data engineers' needs after Data Warehouse was repositioned.
  • Hypothetical answer: Yes, it was repositioned from "a warehouse for product engineers" towards a broader data stack.
  • Impact: Customer mix and expectations may have shifted.

Subscribe to access the full answer

Image of author NextSprints

NextSprints

Updated Oct 31, 2026