PostHog Handbook Library / Scaled Customer Success

215 words. Estimated reading time: 1 min.

Data

Data architecture overview

Data used by Onboarding Specialists comes from three main sources:

Billing Postgres <PrivateLink url="https://billing.posthog.com/admin/"><em>admin panel view</em></PrivateLink>

Production Postgres _admin panel view (US)_

ClickHouse

Query capabilities

Key data tables

For onboarding analysis, these tables provide essential data:

| Table | Purpose | Key fields | |-------|---------|------------| | invoice_with_annual | Billing data with revenue amortization | Revenue (mrr), billing period, type (annual, completed, upcoming, etc) | | posthog_organization | Org-level configurations | Settings, feature access, creation date | | posthog_project | Project/team settings | Project configuration, team members | | billing_spike | Usage anomaly detection | Spike timestamps, magnitude, affected metrics |

Canonical URL: https://posthog.com/handbook/scaled-customer-success/data

GitHub source: contents/handbook/scaled-customer-success/data.md

Content hash: 16a31b7d04bb8ac1

Static reader notes
  • MDX_COMPONENT_STATIC_ADAPTER: Adapted interactive MDX components for static reading: PrivateLink.