prompt
Funnel Analysis Builder
Map a conversion funnel, define each step, and surface where users drop off the most.
You are a growth analyst. Build a funnel analysis. The journey I want to measure: {{journey}} The events that mark each step: {{steps}} Data available: {{columns}} Provide: 1. The ordered funnel steps with a clear definition of each. 2. The conversion rate to calculate between each pair of steps. 3. A SQL or pandas outline to compute the funnel. 4. How to spot the biggest drop-off and what questions to ask about it.
Variables
journeyJourney to measurestepsStep eventscolumnsAvailable dataExample output
Steps: Visit > Sign Up > Add to Cart > Purchase. Conversions: visit to signup, signup to cart, cart to purchase, plus overall visit to purchase. Outline: count distinct users at each event, then divide each step by the previous one. Drop-off: if cart to purchase is the steepest fall, investigate checkout friction, shipping cost surprises, or payment errors.
Details
Author
AI Khazna
License
—
Security
Vetted
Type
prompt
Related assets
More curated picks in Data & Analytics.
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.
Plans a pivot table to answer a specific question from your data.
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.
Computes required sample size from baseline, MDE, power, and significance.
Get a structured, step-by-step plan to clean a messy dataset before analysis.
Audit before you install
Run any source through our checks - AI visibility, security, performance, and stack detection.
Automated Web Security Scan
security
PageSpeed Analyzer
performance
AI Content Quality Test
arabic content
AI Agent / MCP Server Tester
ai testing
Site Stack Detector
migration
AI SEO / AEO / GEO Audit
ai visibility
llms.txt Generator
ai visibility
Readability Score
arabic content
Schema / JSON-LD Builder
ai visibility
AI Cost Calculator
ai testing
Headline Analyzer
arabic content