AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

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.

Original source
posthog
License
MIT
Pinned revision
cac7c80a9e5b73484d18eda1bffb47297c938e0c

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

This skill also requires local files or dependencies. Remote reading alone may not be enough.

Ask your assistant

Use Agentic Memory skills to read posthog--modeling-conversion-metrics at revision cac7c80a9e5b73484d18eda1bffb47297c938e0c, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 2

references/conversion-metric-definitions.md

Conversion metric definitions

| Metric | Definition | | --------------------------- | --------------------------------------------------------------------------------------------------------------------- | | Overall conversion rate | units reaching step k / units entering step 1, within the conversion window. | | Step-to-step conversion | units reaching step k / units reaching step k-1. Isolates per-step drop-off. | | Drop-off | 1 − step-to-step conversion at each step; the count that entered step k-1 but not step k. | | Time to convert | elapsed time between step entries for converted units; report median and mean (mean is skewed by long tails). | | Conversion window | max elapsed time from step 1 to the final step for a unit to count as converted. A hard filter, not a display option. |

Order modes

  • Ordered — steps happen in order; other events may occur between them. The usual default.
  • Strict — no other tracked event may occur between two steps. Rare; use for tight flows.
  • Any order — steps in any sequence within the window.

Attribution (for breakdowns)

When you break a funnel down by a property whose value can differ across a unit's events, pick how the unit gets its breakdown value:

  • First-touch — the value on the unit's first step. Most common for acquisition analysis.
  • Last-touch — the value at conversion.
  • Per-step — the value on each step (a unit can appear in different buckets at different steps).

The rates change with the choice, so state it explicitly in the model's column annotations.

Aggregation unit

person_id for user funnels; a group key ($group_0, account id) for B2B/account funnels — an account "converts" if any of its users completes the steps. Keep this consistent with your revenue and activation models so the numbers reconcile.