Get campaign performance report by date

Returns campaign performance data grouped by date and campaign. Use get_report_campaign_performance_by_date with ReportStartDate and ReportEndDate in the WITH clause (e.g. monthstart, today-1d).

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