modeling-conversion-metrics — Claude Code skill: funnels
modeling-conversion-metrics builds a reusable conversion model: funnel steps, a conversion window, drop-off and time to convert. Works on PostHog warehouse views in HogQL or in a dbt project.
no license 178 installs ★ 101 updated 2026-10-24
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a claude-codeWhat modeling-conversion-metrics does
The skill turns a sequence of events into a durable conversion model: how many units reached each step, where they fall off, how long the trip takes. Four parameters get pinned down: the steps in order, the conversion window, the aggregation unit (person_id for B2C or a group key for B2B), and the order mode — ordered, strict or any order.
On PostHog it computes the funnel per unit with windowFunnel(window)(timestamp, cond_1, …, cond_n), rolls the furthest step reached into rates, then saves the result through view-create. Reused views get monthly rollups synced daily via sync_frequency. In dbt it stages the event stream and builds an fct_conversion mart with tests. Recipes sit in references/posthog/ and references/dbt/; exact definitions are in references/conversion-metric-definitions.md.
modeling-warehouse-foundations comes first, because the view-versus-dbt choice is made there. Before any persistent view the skill checks that the events exist (read-data-schema) and asks you to confirm step names, since the same-sounding event means different things to different teams. No pinned window means no funnel. Overall conversion and step-to-step conversion are two separate numbers, and the skill keeps them apart.
What it helps with
- model a signup-to-paid funnel with a fixed conversion window
- find the step where most users drop off
- report conversion per account instead of per person
- turn a one-off funnel chart into a reusable warehouse view
- add dbt tests around an
fct_conversionmart
Example prompts for the agent
- Model conversion from
signed_uptopurchasedwith a 30-day window, and show both overall and step-to-step rates. - Build the activation funnel per account using
$group_0and tell me which step loses the most people. - Create an
fct_conversionmart in dbt with tests for the onboarding steps.
How to install modeling-conversion-metrics
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a claude-code2Manually: put the files in place
~/.claude/skills/modeling-conversion-metrics/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/modeling-conversion-metrics/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a codex2Manually: put the files in place
.agents/skills/modeling-conversion-metrics/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a cursor2Manually: put the files in place
.cursor/skills/modeling-conversion-metrics/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install PostHog/ai-plugin skills/modeling-conversion-metrics2Manually: put the files in place
.github/skills/modeling-conversion-metrics/SKILL.md1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a gemini-cli2Platform CLI
gemini skills install https://github.com/PostHog/ai-plugin --path skills/modeling-conversion-metricsManually: put the files in place
.devin/skills/modeling-conversion-metrics/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about modeling-conversion-metrics
How do I install modeling-conversion-metrics in Claude Code?
Run npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a claude-code. The skill lands at ~/.claude/skills/modeling-conversion-metrics/SKILL.md.
What does modeling-conversion-metrics do?
It builds a reusable conversion model with funnel steps, a fixed window, drop-off and time to convert, on PostHog views in HogQL or in dbt.
When is a saved funnel insight better than a warehouse view?
A saved funnel insight (posthog:query-funnel) suits interactive analysis with native breakdowns and dashboards. The skill is for metrics that get reused, joined to other models or exposed in SQL.