How do I run a funnel or conversion analysis with iDBQuery?

Ask iDBQuery in plain language to build a funnel, such as 'Show the conversion rate from signup to activation to paid subscription last quarter.' It writes the SQL across your event and billing tables, returns each step's drop-off as a chart, and cites every count back to its source rows.

A funnel analysis measures how many people move from one step to the next in a process, and where they fall off. With iDBQuery you describe the funnel in words instead of hand-writing multi-stage SQL.

  • You'd ask iDBQuery: 'For users who signed up in Q2, show conversion from signup to first-project to paid, and the drop-off at each step.'
  • It infers the joins between your `users`, `events`, and `subscriptions` tables, writes the staged query, and returns a funnel chart plus a table of counts and percentages.
  • Every number is cited to its source rows, so you can click the '412 activated users' figure and see exactly which records were counted.

Because iDBQuery builds one live model across all your sources, the funnel can span a product database, a marketing spreadsheet, and a billing export at once without any ETL. You can then drill in with follow-ups like 'Where does the drop-off get worse on mobile?' and it keeps the funnel context. The Analyst agent can also investigate the biggest leak on its own and report back the segment most responsible. Nothing about the query is a black box: the SQL is visible and editable, and the answer traces to real rows you can audit.

Updated 2026-06-22