How do I build a retention curve with iDBQuery?

A retention curve shows what share of a starting group is still active over time. It is one of the clearest signals of product health, but assembling it by hand means fiddly self-joins and date maths. iDBQuery does that for you from a plain request.

• You'd ask iDBQuery: 'Plot the retention curve by monthly signup cohort, as a percentage still active at months 1, 3, 6, and 12.'
• It writes the query against your activity and signup tables, produces the classic decaying curve (or a triangle table), and labels each cohort.
• Each point is cited back to its source rows so a stakeholder can verify the 'month-6 retention = 38%' figure against actual accounts.

Unlike a static dashboard tile, you can immediately ask follow-ups in the same thread: 'Split the curve by acquisition channel' or 'Compare this year's cohorts to last year's.' Because retention often lives in one system and revenue or plan data in another, iDBQuery's one live model lets you retain by paid vs free without exporting anything. If the curve dips for a recent cohort, the Analyst agent can investigate which behaviour separates retained users from churned ones and hand you the evidence.