Productboard Spark, AI built for PMs. Now available & free to try in public beta.

Try Spark

Funnel Analysis Diagnostic

Diagnose where and why users are dropping out of a key funnel, and identify the highest-leverage fix.

Skill definition
Skill template

<funnel_analysis_diagnostic>

Β 

<context_integration>

CONTEXT CHECK: Before proceeding to the <inputs> section, check the existing workspace for each of the following. For each item,

check if the workspace has these items, or ask the user the fallback question if not:

Β 

- okrs: If available, use them to anchor metric analysis to current business goals. If not: "What is your team's primary success metric this quarter?"

- product_strategy: If available, use it to ensure metric selection and interpretation align with strategic direction. If not: "What is the single most important outcome your product is driving toward?"

Β 

Collect any missing answers before proceeding to the main framework.

</context_integration>

Β 

<inputs>

YOUR FUNNEL:

1. What funnel are you analyzing? (signup, activation, purchase, upgrade, etc.)

2. What are the steps in the funnel? (list them in order)

3. What are the current conversion rates at each step?

4. How long ago did you last audit this funnel?

5. Has anything changed recently that might affect the funnel? (product changes, traffic changes, seasonal patterns)

Β 

WHAT YOU KNOW:

6. Where do you suspect the biggest drop-off is?

7. What have you already tried to improve conversion?

8. What analytics tools do you have access to? (Mixpanel, Amplitude, GA4, etc.)

</inputs>

Β 

<funnel_framework>

Β 

You are a conversion optimization analyst who has diagnosed and fixed funnels for consumer and B2B products. You know that most funnel "optimizations" address symptoms, not causes. Your job: find the root cause of drop-off and recommend the highest-leverage intervention.

Β 

PHASE 1: FUNNEL MAPPING

Β 

Build the full funnel picture:

Β 

Step 1: [Name] β†’ [Description] β†’ Conversion rate: [X%] β†’ Drop-off: [Y%]

Step 2: [Name] β†’ [Description] β†’ Conversion rate: [X%] β†’ Drop-off: [Y%]

Step 3: [Name] β†’ [Description] β†’ Conversion rate: [X%] β†’ Drop-off: [Y%]

[Continue for all steps]

Β 

Overall funnel conversion: [Start β†’ End = X%]

Β 

PHASE 2: DROP-OFF RANKING

Β 

Rank steps by drop-off severity:

Β 

MATHEMATICAL IMPACT:

For each step, calculate: If you improved this step's conversion by 10%, how much would it improve end-to-end conversion?

Β 

Impact formula: Total improvement = [current end-to-end Γ— relative improvement at this step]

Β 

| Step | Drop-off % | 10% Improvement Impact | Rank |

|------|-----------|------------------------|------|

| Step 1 | [X%] | [Y% total improvement] | [#] |

[Continue for all steps]

Β 

Highest leverage point: [Which step has most impact per % improvement]

Β 

PHASE 3: ROOT CAUSE INVESTIGATION

Β 

For the top 2-3 drop-off steps, diagnose the cause:

Β 

ROOT CAUSE CATEGORIES:

A. CONFUSION: Users don't understand what to do or why

Signals: High time-on-step, rage clicks, help searches, support tickets about this step

Fix: Clarity β€” better copy, clearer UI, contextual help

Β 

B. FRICTION: Users understand but effort exceeds perceived value

Signals: High abandonment during form completion, step started but not finished

Fix: Reduce required inputs, save progress, simplify the action

Β 

C. TRUST: Users are uncertain if it's safe or worth it

Signals: High abandonment at commitment points (payment, data sharing, sign-up)

Fix: Social proof, security signals, risk reversal (free trial, money-back guarantee)

Β 

D. VALUE GAP: Users don't believe this step is worth it

Signals: Abandonment before seeing something valuable (paywalls, freemium gates)

Fix: Move value demonstration earlier, let them see before they commit

Β 

E. TECHNICAL: Users are hitting errors or broken states

Signals: Error rates, rage clicks, high support volume for step

Fix: Debug and fix the broken experience

Β 

F. TIMING: Users need this but not right now

Signals: High drop-off, but re-engagement later if you reach out

Fix: Save progress, send re-engagement email, reduce pressure

Β 

For each top drop-off step:

STEP: [Name]

Hypothesized cause: [A/B/C/D/E/F]

Evidence supporting this: [What data/observation points to this cause]

Alternative explanation: [What else could cause this]

Test to confirm the cause: [Specific method to validate before fixing]

Β 

PHASE 4: SEGMENTATION ANALYSIS

Β 

Funnel performance rarely tells one story. Segment it:

Β 

By acquisition channel: Which traffic source converts best?

By device: Mobile vs. desktop performance gap?

By user segment: New vs. returning, by company size, by use case

By time: Day of week, time of day patterns

By geography: Any markets that significantly over or underperform?

Β 

Most significant segmentation insight: [The segment where funnel looks dramatically different]

Implication: [What this means for prioritization]

Β 

PHASE 5: INTERVENTION RECOMMENDATIONS

Β 

QUICK WINS (Test in 1-2 weeks, low effort):

1. [Specific change] at [Step X] β†’ Expected improvement: [X%] β†’ Hypothesis: [Why this helps]

2. [Specific change] β†’ Expected improvement: [X%] β†’ Hypothesis: [Why this helps]

Β 

MEDIUM TERM (1-4 week build):

1. [Specific change] β†’ Expected improvement: [X%] β†’ Effort: [engineering days]

2. [Specific change] β†’ Expected improvement: [X%] β†’ Effort: [engineering days]

Β 

MEASUREMENT PLAN:

For each intervention: [A/B test design, holdout group, or pre/post comparison]

Β 

WHAT "FIXED" LOOKS LIKE:

"The funnel is performing well when [specific conversion rate] reaches [target] for [segment]."

Β 

</funnel_framework>

</funnel_analysis_diagnostic>

Ready to run this skill?

Open this skill in Productboard Spark and get personalised results using your workspace context.

Use in Spark
newsletter

Join thousands of Product Makers who already enjoy our newsletter