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')