Data questions worth asking

Your warehouse already holds all your PostHog data. Add an external source or two and you can answer questions neither could answer alone - these skills show you how.

Turn product usage into revenue

Which features drive revenue?

PostHog events+Stripe

Join PostHog's usage data to Stripe to discover which features drive the most revenue per user.

Read the guide

Which onboarding steps turn trials into paying customers?

PostHog funnels+Stripe

Build a funnel, flag who pays, and find the correlations so you can optimize the onboarding.

Read the guide

Which accounts are ready to upsell?

PostHog usage+Stripe plans

Compare product usage against current plan limits in Stripe to automatically flag users ready to be upsold.

Read the guide

See churn coming

What do customers do right before they cancel?

PostHog events+Stripe / Chargebee

Pull cancellation data from Stripe or Chargebee and examine the usage patterns preceding them to spot early-warning signals.

Read the guide

Do support tickets predict churn?

PostHog usage+Zendesk / Intercom

Was that last ticket the last straw? This skill joins data from PostHog, Zendesk, Chargebee, and Stripe to spot which support trends lead to churn.

Read the guide

Are our biggest accounts our happiest ones?

PostHog groups+Salesforce / HubSpot

Map ARR against engagement to flag at-risk accounts and protect your biggest accounts before they wobble.

Read the guide

Spend smarter on growth

Which channels bring customers who stick?

PostHog acquisition+Stripe+Google / Meta Ads

Rank marketing channels by the revenue they bring in, so you can spend budget better.

Read the guide

Which leads deserve the sales team's time?

PostHog usage+HubSpot / Salesforce

Score leads by usage and highlight the warmest ones that Sales have overlooked to create a PQL list.

Read the guide

Did the feature we shipped move revenue?

PostHog experiments+Stripe

Usage went up after launch. But did revenue? This skill creates an experiment to find out and ship what works.

Read the guide

From a one-off answer to a model that lasts

A query answers the question today. A model answers it every day. These skills turn a metric definition into a durable, reusable model, strengthened by an opinion on what good looks like, just for spiciness.

modeling-warehouse-foundationsStart here

The groundwork for everything else: PostHog views or dbt, the view-create to view-materialize workflow, warehouse joins, currency conversion, and registering a model in the data catalog so nobody builds a rival copy.

The rule it enforces

Decide person vs. group once. That choice shapes every model you build after it.

Read the guide

modeling-revenue-metrics

MRR, ARR, expansion and contraction, ARPU, LTV, and revenue per account.

The rule it enforces

MRR right now and MRR over time are two different models. A live snapshot never turns into a trend, so know which one you need before you build it.

Read the guide

modeling-conversion-metrics

Funnel and step conversion rates, drop-off, and time-to-convert.

The rule it enforces

Pin the time box first: signup to paid within 30 minutes and within 30 days are different metrics, not the same one measured loosely.

Read the guide

modeling-activation-metrics

An activated flag per user or account, plus an activation rate.

The rule it enforces

Activation is the early behavior that predicts whether people stick around — test it against retention lift. If it doesn't lift, it isn't activation.

Read the guide

modeling-product-usage-metrics

Retention, stickiness, and lifecycle models.

The rule it enforces

Retention of $pageview and retention of your core action tell very different stories. Model the one that means "got value".

Read the guide

modeling-dimension-tables

dim_country, dim_plan, dim_date, and the other lookup tables every model joins to.

The rule it enforces

One row per entity — a duplicate key multiplies every fact joined to it. And don't hand-roll currency: convertCurrency() already ships with PostHog.

Read the guide

Install the PostHog AI plugin in your coding agent, or open PostHog Desktop, then ask for the model you want, the Skills are already pre-loaded. More on views and data modeling.

Got a different question?

With 800+ warehouse sources including payments, CRMs, support desks, ad platforms, your production database, chances are your question is already answerable. See every source →

Get Started

Not using PostHog? Sign up