How do I do marketing attribution with iDBQuery?
Ask iDBQuery 'Which channels drove the most closed-won revenue last quarter, and what was cost per acquisition by channel?' and it joins your ad-spend, campaign and revenue data into one model, computes attribution, and returns a cited table linking each figure to source rows.
Attribution connects marketing effort to revenue, which usually means stitching ad-spend, campaign and sales data together by hand. iDBQuery does the stitching in a question: - Connect your ad-platform exports, campaign data, and the revenue or CRM source. - Ask 'Which channels drove the most closed-won revenue last quarter, and what was cost per acquisition by channel?' - iDBQuery joins the sources into one live model, matches spend to outcomes, and returns a cited attribution table.
A worked example: a growth lead asks 'Compare cost per lead and cost per closed deal across paid search, social and email.' iDBQuery blends spend with pipeline outcomes and ranks the channels, letting you drill into the deals behind any figure.
The differentiator is that you do not need a warehouse or a dedicated attribution tool to answer this; iDBQuery federates the sources live. And because every figure is cited, a CAC number you report is traceable to the exact spend and revenue rows behind it, not a black-box model. iDBQuery uses a transparent attribution you define in the question, first-touch, last-touch, or a window you specify, rather than an opaque algorithm, so marketing and finance can agree on the method. Save it as a live dashboard to watch channel efficiency week over week.
Updated 2026-06-22