How do I analyse unit economics with iDBQuery?
Ask iDBQuery 'What are our unit economics per customer, comparing lifetime value to acquisition cost and contribution margin?' It joins revenue, cost, and acquisition data across your sources, returns LTV, CAC, payback, and margin per unit as a chart, and cites each figure to its source rows.
Unit economics break your business down to the profit and cost of a single unit, whether that is a customer, order, or subscription. They tell you whether growth is actually profitable. iDBQuery assembles them from data spread across finance, sales, and marketing systems.
- You'd ask iDBQuery: 'Show unit economics per customer: average LTV, CAC, LTV:CAC ratio, contribution margin, and payback period, split by segment.'
- It joins revenue, direct cost, and acquisition spend, computes each metric, and returns a summary table plus a chart by segment.
- Every figure is cited to its source rows, so 'payback = 9 months' can be traced to the underlying revenue and cost records.
The value is seeing the whole picture in one thread and drilling in: 'Which segment has payback over 18 months?' or 'How do unit economics change if CAC rises 20%?' iDBQuery keeps context and reworks the query. Because the inputs live in separate systems, the one live model unifies them with no ETL, and the semantic layer keeps definitions like contribution margin consistent. Save it as a live report for board updates, and let the Analyst agent flag which segment's unit economics are deteriorating and cite the rows that explain it. This ties directly to LTV, CAC, and margin analyses.
Updated 2026-06-22
Related questions
- How do I calculate customer lifetime value (LTV/CLV) with iDBQuery?
- How do I analyse customer acquisition cost (CAC) by channel with iDBQuery?
- How do I analyse gross margin by product with iDBQuery?
- How do I calculate burn rate and runway with iDBQuery?
- How do I analyse ARPU (average revenue per user) with iDBQuery?