modeling-conversion-metrics
Build reusable conversion models — funnel/step conversion rates, drop-off, and time-to-convert — on either PostHog data-warehouse views (HogQL) or an external dbt project. Use when the user wants to model, define, or compute a conversion rate, funnel, step completion, drop-off, activation-funnel, signup-to-paid, or any "what % of users who did A went on to do B (within N days)" metric. Covers the funnel model (ordered steps, the conversion-window time-box, strict vs any-order), the person-vs-group aggregation unit, overall vs step-to-step conversion (two different numbers), breakdown attribution, and when a saved funnel insight beats a warehouse view. On PostHog, model funnels in HogQL with windowFunnel; in dbt, stage the event stream and compute an fct_conversion mart with tests. Read modeling-warehouse-foundations first for the view-vs-dbt mechanics; pairs with query-funnel for interactive analysis.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/modeling-conversion-metrics/SKILL.md
- skills/modeling-conversion-metrics/references/conversion-metric-definitions.md
- skills/modeling-conversion-metrics/references/dbt/fct_conversion.sql
- skills/modeling-conversion-metrics/references/dbt/schema.yml
- skills/modeling-conversion-metrics/references/dbt/stg_funnel_events.sql
- skills/modeling-conversion-metrics/references/posthog/conversion_by_breakdown.sql
- skills/modeling-conversion-metrics/references/posthog/funnel_conversion.sql
Every link opens the file at its source, pinned to the revision this page describes.