How do I compare marketing channels and attribute conversions with iDBQuery?

Ask iDBQuery 'Which channels touched customers who converted, and how much revenue should each get credit for?' It joins touch-point data to closed revenue, returns first-touch and last-touch credit by channel as a chart, and cites every attributed figure to its source rows.

Channel attribution assigns credit for a conversion across the touch-points that led to it, so you can see which channels really drive revenue rather than just the last click. iDBQuery lets you run practical attribution against your own data instead of trusting a platform's self-reported numbers.

  • You'd ask iDBQuery: 'For deals closed last quarter, show revenue credited to each channel under first-touch and last-touch attribution, side by side.'
  • It joins your touch-point or session data to closed revenue, applies each rule, and returns a comparison chart plus a table.
  • Each figure is cited to its source rows, so a channel's credited revenue traces to the specific touches and deals behind it.

Because attribution logic is a business decision, iDBQuery shows the SQL it used so an analyst can adjust the window or weighting. You can ask follow-ups like 'How does credit shift under a linear model?' and it keeps the context. This complements campaign-level ROI: attribution tells you which channels assist, ROI tells you which campaigns pay back. With every source unified in one live model, ad platforms, web analytics exports, and CRM data resolve into a single answer, and the Analyst agent can flag channels that consistently assist conversions but get no last-touch credit.

Updated 2026-06-22