Funnel Query - Customer Journey Analytics

Funnel Query - Customer Journey Analytics

Purpose

Standardized analytics skill for customer funnel analysis, providing common queries and insights for user journey optimization, conversion tracking, and cohort analysis across product metrics.

When to Use

• Conversion Analysis: When analyzing user signup → activation → paid conversion funnels
• Cohort Comparisons: When comparing conversion rates between different user cohorts
• Funnel Optimization: When identifying drop-off points and optimization opportunities
• Product Metrics: When tracking key product metrics and user engagement
• Growth Analysis: When analyzing user growth and retention patterns
• A/B Testing: When measuring impact of product changes on conversion rates
• Business Intelligence: When generating reports for stakeholders on user journey

Core Funnel Queries

Standard Conversion Funnel

-- User signup → activation → paid conversion funnel
WITH funnel_stages AS (
  -- Stage 1: Signups
  SELECT 
    user_id,
    'signup' as stage,
    created_at as event_time
  FROM users 
  WHERE created_at >= '2024-01-01'
  
  UNION ALL
  
  -- Stage 2: First activation (key action)
  SELECT 
    user_id,
    'activation' as stage,
    event_time
  FROM user_events 
  WHERE event_type = 'first_key_action'
    AND created_at >= '2024-01-01'
  
  UNION ALL