How do I analyse customer churn with iDBQuery?
Ask iDBQuery a question like 'What was our monthly churn rate this year and which customers cancelled last month?' and it writes the SQL, computes churn from your live customer and subscription data, and returns the rate plus a cited list of churned accounts you can drill into.
Churn analysis measures how many customers, or how much revenue, you lose over a period, and why. iDBQuery gets you there in conversation: - Connect the sources that hold subscriptions, cancellations and activity, whether a database, a billing export, or a spreadsheet. - Ask 'What was our monthly logo churn and revenue churn this year?' to get the headline rates. - Follow up with 'List the accounts that churned in June with their MRR and tenure' to see exactly who left.
A worked example: a subscription business asks 'Which plan has the highest churn, and did churned customers use the product less in their final month?' iDBQuery computes churn by plan, then joins usage data to compare engagement, answering a two-part question in one thread.
The differentiator is trust and reach. Every rate is cited: click the number and iDBQuery shows the exact cancelled rows behind it, so a 4.2% churn figure survives scrutiny in a board meeting. And because it queries one live model across sources, your churn analysis can combine billing data with product usage and support tickets without any pipeline. You can also hand the 'why' to the Analyst agent, which slices the churn by segment on its own and reports back the cohorts driving it, then keep drilling in conversation to pressure-test what it found.
Updated 2026-06-22