Build a Comprehensive Funnel Analysis with Drop-Off Insights

You are a senior product analyst with deep expertise in funnel analysis, user behavior analytics, and conversion optimization. Conduct a detailed funnel analysis based on the following data and provide actionable insights. **Funnel Context:** - Product/Platform: [PRODUCT_NAME, e.g., SaaS onboarding flow, e-commerce checkout, mobile app signup] - Funnel type: [FUNNEL_TYPE, e.g., acquisition, activation, purchase, retention] - Time period analyzed: [TIME_PERIOD, e.g., January 2024 - March 2024] - User segment (if applicable): [SEGMENT, e.g., mobile users, enterprise accounts, first-time visitors] **Funnel Steps and Data:** - Step 1: [STEP_1_NAME] — [STEP_1_USERS] users - Step 2: [STEP_2_NAME] — [STEP_2_USERS] users - Step 3: [STEP_3_NAME] — [STEP_3_USERS] users - Step 4: [STEP_4_NAME] — [STEP_4_USERS] users - Step 5: [STEP_5_NAME] — [STEP_5_USERS] users (Add or remove steps as needed) **Please deliver the following analysis:** 1. **Funnel Visualization Table**: Create a formatted table showing each step with: absolute users, step-to-step conversion rate, cumulative conversion rate from Step 1, and absolute drop-off count at each stage. 2. **Biggest Drop-Off Identification**: Identify the largest drop-off point(s) in the funnel. Rank all transitions by severity of drop-off and flag any that fall below industry benchmarks for [INDUSTRY, e.g., SaaS, e-commerce, fintech]. 3. **Root Cause Hypotheses**: For each major drop-off point, generate at least 3 specific, testable hypotheses explaining why users may be leaving. Consider UX friction, cognitive load, trust signals, technical issues, and value proposition clarity. 4. **Benchmarking**: Compare each step's conversion rate against typical industry benchmarks for [INDUSTRY]. Highlight where performance is above or below average and by how much. 5. **Segmentation Recommendations**: Propose 4-6 segmentation dimensions (e.g., traffic source, device, user tenure, geography, plan type) that could reveal hidden patterns in the funnel. For each, explain what insight you expect to uncover. 6. **Optimization Roadmap**: Prioritize improvement opportunities using an impact-effort matrix. For each recommendation, specify: - The specific change to implement - Expected impact on conversion (estimated % improvement) - Implementation effort (low/medium/high) - How to measure success 7. **Metrics Dashboard Spec**: Recommend 8-10 KPIs to monitor ongoing funnel health, including leading indicators that predict future drop-offs. Format the output with clear headers, data tables, and a prioritized action list. Use bullet points for readability.