ODBC guide

Get campaign performance report by month


Returns campaign performance data grouped by year, month, and campaign. Use get_report_campaign_performance_by_month with ReportStartDate and ReportEndDate in the WITH clause.

SELECT * FROM get_report_campaign_performance_by_month
WITH(ReportStartDate='monthstart', ReportEndDate='today-1d')