How do I calculate marketing campaign ROI with iDBQuery?

Campaign ROI compares what you spent on a marketing campaign to the revenue it produced. The hard part is that spend lives in ad platforms and revenue lives in your CRM or billing system. iDBQuery joins them into one answer with no pipeline.

• You'd ask iDBQuery: 'For each campaign last quarter, show total spend, attributed revenue, ROI, and cost per acquisition, ranked best to worst.'
• It aligns your ad-spend export with closed deals or orders, computes the ratios, and returns a ranked chart plus a table.
• Each number is cited to its source rows, so 'Campaign A returned 4.2x' traces to the exact spend and revenue records used.

Because the result is a live query rather than a static export, you can immediately ask 'Now break ROI down by channel within the winning campaign' or 'Exclude organic conversions.' iDBQuery keeps the context. This differs from broad attribution modelling: here you are measuring payback per campaign, which finance and marketing can both trust because every figure is verifiable. Save it as a recurring report so the ROI table refreshes each week, and let the Analyst agent surface campaigns that are burning budget with negative return, backed by the underlying rows.