Get the SQL for a funnel question in plain English

A working funnel query against your real warehouse tables, with the SQL laid out to verify the joins and a shareable notebook link to drop in Slack.

Tuned for Hex

First

Open a new Hex project connected to your warehouse, add a SQL cell, open Magic, and paste this.

The prompt

Build a funnel from the events table for the last 60 days with these
ordered steps: sign_up -> activated -> day7_return.
Count distinct user_id at each step. Show the count and the step-to-step
conversion rate. Assume one row per event; ask me if a step name is ambiguous.

Built-in guardrail: Counts distinct user_id (not raw rows) so a chatty user can't inflate a step, and tells the model to ask rather than guess when a step name is ambiguous.

Then

Read the generated SQL before running — confirm the right table, a sane date filter, and distinct user_id; if the numbers look too clean or too grim, paste the SQL to a data-team member with "does this join look right?" before you ship the decision.

Field-tested Jul 21, 2026. If it stops working, tell us.