Automated Performance Reporting
SQL · Scheduled Automation · HTML Email
SQL in. Decision signal out.
A scheduled Salesforce query validates campaign performance, renders an HTML report and delivers it before the working day starts.
Query Activity / Daily Reactivation Report06:00 CET
01SELECT CampaignKey, Market, Delivered, CTR
02 ConversionRate, ReactivationRate
03FROM SFMC_DataViews
04LEFT JOIN ConversionEvents
05GROUP BY CampaignKey, Market
Primary1–24 of 24
CRM Reporting AutomationDaily Reactivation Performance — 10 Aug 2026
Lifecycle OpsWeekly planning notes and launch coverage
Data PlatformWarehouse maintenance completed
Campaign QAMobile validation summary
CRM Reporting AutomationDaily Reactivation Performance — 09 Aug 2026
Lifecycle StrategyMonthly campaign learnings
Reactivation / Daily operating report
Email performance at 06:00 CET
Validation passed
SQL 03.2s · Data fresh 05:55
HTML email delivered 06:00
Delivered
1,213,402
+3.8% vs 7D median
CTR
4.32%
+0.28pp vs 7D median
Conversion
21.6%
+1.7pp click-to-order
Reactivation
0.93%
+0.09pp delivered-to-order
Salesforce Marketing Cloud · SQL Query Activity · HTML Email
Public reconstruction · Synthetic campaign data