funnel-analysis

Compute SQL-based conversion rates and drop-offs across multi-step funnels.

6|1|Updated Mar 5, 2026

Search Tags:#analytics #sql #conversion #analyze #cohorts #funnel #drop-off

Ready to run

npx skills add https://github.com/pwv-vc/agentcribs-community --skill funnel-analysis-pwv-vc

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: funnel-analysis
Source: https://github.com/pwv-vc/agentcribs-community/tree/main/resources/tearsheets/arsenal/dot-claude/skills/funnel-analysis
Command: npx skills add https://github.com/pwv-vc/agentcribs-community --skill funnel-analysis-pwv-vc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze user conversion funnels and identify drop-off points in multi-step flows to understand where users churn and how to improve retention.

Core Features & Use Cases

Two funnels: Standard funnel (28+ days) and Onboarding funnel (7+ days) with clear step definitions.
SQL-based analytics: Compute first-message dates, weekly activity, and conversion metrics across steps.
Reporting & guidance: Output step-wise drop-offs and conversion rates to guide optimization and experiments.

Quick Start

Use the funnel-analysis skill to identify drop-offs across the standard and onboarding funnels in your dataset and report step-by-step conversion.

Frequently Asked Questions about funnel-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I identify user drop-off points in a multi-step conversion funnel?▼

Funnel analysis identifies and quantifies where users drop off in multi-step flows to improve activation and retention. It calculates step-wise conversion rates and drop-offs to pinpoint exactly where users churn in your onboarding or standard funnels.

Can I calculate conversion rates across different user cohorts and time windows using SQL?▼

Yes, you can compute SQL-based conversion metrics across cohorts and time windows. The analysis calculates first-message dates, weekly activity, and step-by-step conversion rates for both standard 28+ day funnels and 7+ day onboarding funnels.

What is the difference between a standard funnel and an onboarding funnel for drop-off analysis?▼

A standard funnel tracks user flows over 28 or more days, while an onboarding funnel tracks activation over 7 or more days. Both use SQL to quantify step-wise drop-offs and conversion rates to guide optimization.

How do I report step-by-step conversion metrics to guide optimization experiments?▼

Generate SQL-based outputs that detail step-wise drop-offs and conversion rates across defined funnel steps. Reporting these metrics clearly highlights churn points, guiding your optimization experiments and retention improvements.