funnel-analysis

Analyze SQL-based funnel data to identify drop-offs in multi-step user journeys.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/cncorp/arsenal --skill funnel-analysis
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: funnel-analysis
Source: https://github.com/cncorp/arsenal/tree/main/dot-claude/skills/funnel-analysis
Command: npx skills add https://github.com/cncorp/arsenal --skill funnel-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides SQL-based templates to analyze user conversion funnels and identify drop-off points in both standard and onboarding funnels.

Core Features & Use Cases

  • Two funnels: "the funnel" (standard) and "the onboarding funnel".
  • Drop-off metrics: identify where users drop off and quantify conversion rates.
  • ** Ready-to-use templates**: includes sample SQLs to adapt to your schema.

Quick Start

Use the provided SQL templates to compute funnel metrics for your data and interpret the results to optimize onboarding and activation flows.

Frequently Asked Questions about funnel-analysis

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

FAQPage Schema
How do I identify where users drop off in my conversion funnel?

Funnel analysis reveals drop-off points by computing per-step metrics—users, conversion rate, and drop-off percentage—across multi-step user journeys. SQL templates extract and aggregate your data to show exactly where users stall or churn in standard and onboarding funnels.

What's the difference between analyzing a standard funnel vs. an onboarding funnel?

Standard funnels track conversion over 28+ days for general user flows, while onboarding funnels focus on the first 7+ days of user activation. Both use the same SQL-based approach but apply different time windows to diagnose where users fail to complete initial steps versus long-term retention stages.

Do I need SQL knowledge to use funnel analysis templates?

The Skill includes ready-to-use SQL templates you adapt to your schema, so basic SQL familiarity helps but you can modify provided queries. Templates handle the aggregation and metric computation; you supply your data structure.

Can I analyze funnels with predefined steps or do I need custom sequences?

Funnel analysis works with predefined steps baked into the templates for standard and onboarding flows. You extract and adapt the SQL to match your step definitions and data schema, then compute metrics for each step.

What metrics does funnel analysis produce for each step?

Per-step metrics include step name, user count, percentage of starting users, conversion rate to the next step, and drop-off quantity. These outputs let you pinpoint exactly which steps lose the most users and by what margin.

How do I optimize my onboarding flow after finding drop-off points?

Once funnel analysis identifies where users stall in onboarding, you use drop-off metrics and conversion rates to prioritize fixes—simplifying high-drop steps, removing friction, or adjusting messaging. Re-run analysis after changes to measure improvement.