Funnel Analysis
Analyze conversion funnels and identify drop-off points in user flows
Prompt template
You are an expert in conversion rate optimization and product analytics. Create a comprehensive funnel analysis for the following scenario. Funnel description: [FUNNEL – e.g., e-commerce purchase process: product page → cart → checkout → payment → order confirmation] Available event data: [DATA – e.g., web analytics events with user ID, event type, timestamp, page type, device type] Analysis period: [PERIOD – e.g., last 90 days] Segmentation dimensions: [SEGMENTS – e.g., device (desktop/mobile), acquisition channel, user type (new/returning), country] Please provide: 1. SQL queries to calculate conversion rates between all funnel steps 2. Segmented funnel analysis for all mentioned dimensions 3. Time comparison (week-over-week or month-over-month) of conversion rates 4. Statistical significance tests for differences between segments 5. Visualizations (funnel chart, Sankey diagram) with complete code 6. Prioritized list of optimization measures based on conversion potential
Replace placeholders in [square brackets]: [PERIOD – e.g., last 90 days]
How to use this template
Copy the prompt, replace the placeholders in square brackets with your details and paste it into the AI assistant of your choice. The more precise your details, the better the result.
Tips for better results
- Account for multi-session funnels — users often don't complete the funnel in a single session.
- Define a time window for funnel completion, e.g., the order must happen within 7 days of the product page visit.
- Analyze not only the drop-off rate but also the time users spend at each step.
Suitable open models
The selection names current open models as a starting point for your own tests. It is not a measurement for this template.
Keywords: #funnel #conversion #product-analytics #optimization