Running SAP CX 2105 and having an issue with our email marketing dashboard. After our email campaigns complete sending, the delivery rate metrics on the dashboard remain stuck at the in-progress values and don’t update to show final statistics. For example, a campaign that finished yesterday still shows 67% delivery rate on the dashboard, but when I export the raw data, the actual delivery rate is 89%. The dashboard should auto-refresh these metrics, but it seems like the backend metric update job isn’t triggering properly. I’ve checked the real-time reporting settings and they appear configured correctly. Has anyone dealt with stale delivery metrics in their email dashboards?
I had a similar issue in 2105. The problem was that my delivery rate widget was configured to use a materialized view that only refreshed once daily. Check if your widgets are using materialized views versus direct queries. Materialized views are faster but can show stale data if not refreshed properly. Switch to direct query mode for real-time metrics, or configure the materialized view refresh schedule to align with campaign completion times.
I checked the job scheduling and found that the Email Campaign Metrics Aggregation job is running, but it’s showing warnings in the logs about “stale data sources” and “cache invalidation failures.” Not sure what this means or how to fix it.
Check if your dashboard refresh interval is set too high. In 2105, the default is 30 minutes which might not be frequent enough for email campaigns. Try reducing it to 10 minutes in the dashboard settings.