How do I calculate customer lifetime value (LTV/CLV) with iDBQuery?
Ask iDBQuery 'What is the average lifetime value per customer, and how does it differ by plan and acquisition channel?' It joins your revenue, subscription, and customer tables, computes LTV, returns it as a chart, and cites each figure back to the transactions behind it.
Customer lifetime value (LTV or CLV) estimates the total revenue a customer generates over their whole relationship with you. Calculating it usually means stitching together billing history, churn, and margin. iDBQuery assembles all of that from a plain-language request.
- You'd ask iDBQuery: 'Show average LTV per customer by plan tier and signup channel, using total revenue divided by churned customers.'
- It builds the joins across `customers`, `invoices`, and `subscriptions`, computes the metric, and returns a comparison chart plus a breakdown table.
- The number is cited to its source rows, so finance can audit 'Enterprise LTV = £41,200' down to the invoices that produced it.
Because LTV only means something next to acquisition cost, you can chain it: 'Now show LTV divided by CAC by channel.' iDBQuery keeps the context and pulls marketing spend from a separate source into the same one live model, with no pipeline to build. You can also define lifetime value once in the semantic layer as a business metric so everyone's answer matches. When a segment's LTV looks off, the Analyst agent can investigate whether it is driven by higher retention, larger contracts, or fewer refunds, and cite the rows behind its conclusion.
Updated 2026-06-22