How do I find my most profitable customers with iDBQuery?
Ask iDBQuery which customers are most profitable and it ranks accounts by margin, not just revenue, by netting cost, discounts, refunds and support against what each customer pays. The answer is a cited table you can trust and act on immediately.
Your biggest customers by revenue are not always your most profitable. Heavy discounts, high return rates or expensive support can turn a large account into a thin-margin one. iDBQuery lets you see true profitability per customer without building a model by hand.
- It joins orders, costs, discounts, refunds and (if available) support or service data into one live model
- It ranks customers by net contribution, so you see who actually funds the business
- It cites every figure back to the underlying rows, so account teams can trust the ranking
- You can segment on the fly: *now show me only accounts over 50k in revenue but under 20 percent margin*
For example, ask *who are my twenty most profitable customers this year after discounts and returns?* iDBQuery returns the ranked list with the math visible. That often reveals mid-sized, full-price accounts quietly out-earning a few loud, heavily discounted whales.
With cited answers you can bring this to a QBR or renewal conversation and defend every number. Sales and success teams use it to decide where to invest attention, where to hold the line on discounting, and which accounts genuinely deserve premium treatment.
Updated 2026-06-22