Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add PostHog/ai-plugin --skill modeling-conversion-metrics -a claude-code
Open on GitHub

What 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_conversion mart

Example prompts for the agent

  • Model conversion from signed_up to purchased with a 30-day window, and show both overall and step-to-step rates.
  • Build the activation funnel per account using $group_0 and tell me which step loses the most people.
  • Create an fct_conversion mart 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-code

2Manually: put the files in place

~/.claude/skills/modeling-conversion-metrics/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/modeling-conversion-metrics/

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.

Similar skills

All skills for Data and databases →

From the same set82

The whole set →
setting-up-data-catalog setting-up-data-catalog fills a project's data catalog: canonical metric definitions, trust marks on warehouse tables, and reviewed join proposals. CX Codex +1 182installs signals-scout-tasks signals-scout-tasks — a scout skill for PostHog Tasks: it tracks how task runs get delivered and, on a slower pass, looks for the same request coming up again in tasks people wrote. CX Codex +1 179installs managing-streamlit-apps managing-streamlit-apps controls Streamlit apps in PostHog sandboxes using MCP tools, handling everything from provisioning to safe code patching. CX Codex +1 179installs modeling-activation-metrics modeling-activation-metrics builds an activation model: a per-user or per-account activated flag plus an activation-rate metric. Useful while the “aha moment” is still a guess. CX Codex +1 178installs writing-streamlit-apps The writing-streamlit-apps skill guides Python code for Streamlit apps that read PostHog data inside a sandbox. Use it when building or debugging dashboards with tables and charts. CX Codex +1 177installs modeling-revenue-metrics modeling-revenue-metrics builds reusable revenue models for MRR, ARR, churn, ARPU and LTV from PostHog views or dbt. Use it for revenue analysis by customer, product or period. CX Codex +1 175installs modeling-product-usage-metrics modeling-product-usage-metrics builds retention, frequency, and lifecycle models using PostHog HogQL views or dbt data marts with built-in tests. CX Codex +1 175installs modeling-dimension-tables modeling-dimension-tables builds star-schema dimension tables in PostHog HogQL views or dbt projects so you avoid repetitive joins across your metrics. CX Codex +1 174installs

Project sponsors

Companies that keep this analytics open