How do I segment customers with iDBQuery?

Ask iDBQuery 'Segment customers by total spend, recency and region, and show the count and revenue in each group,' and it writes the SQL, runs it on your live data, and returns a cited segment breakdown you can refine, chart, or save as a dashboard.

Customer segmentation groups your customers by shared traits so you can target, prioritise or report on each group. iDBQuery builds segments from a plain-language description: - Connect your customer, order and revenue sources. - Ask 'Segment customers by total spend, recency and region, and show the count and revenue in each group.' - iDBQuery writes the SQL, buckets the customers, and returns a cited breakdown you can chart or refine.

A worked example: a growth team asks for an RFM-style split, 'group customers by how recently and how often they bought and how much they spent, then label the top and bottom segments.' iDBQuery computes the scores, forms the segments, and lets you drill into the members of any group.

The differentiator is flexibility without modelling overhead. You refine segments in conversation, 'now split the high-value group by acquisition channel,' instead of editing a semantic model or rebuilding a pivot. Because iDBQuery blends sources, a segment can combine product usage, billing and support data in one definition. And every count is cited to the underlying customer rows, so a segment you hand to marketing or finance is verifiable, not a black box. Save the segmentation as a live dashboard and the groups update as customers move between them.

Updated 2026-06-22