We’re running SAP CX 2205 and recently imported a large batch of campaign performance data from our external email service provider. After the import completed successfully, our marketing dashboard is showing conflicting KPI values across different widgets. The campaign ROI widget displays a 23% return rate, but when I check the detailed campaign performance table on the same dashboard, it shows 31% for the identical time period and campaign set.
I’ve verified the data source connections for both widgets, and they appear to point to the same underlying dataset. The issue seems related to how different widgets calculate or aggregate the imported metrics. Has anyone experienced similar KPI inconsistencies after bulk data imports? I’m particularly concerned about widget data source alignment and whether our validation process during import might have caused calculation discrepancies.
Thanks everyone. I checked the filter criteria as suggested and found that the ROI widget had an additional filter excluding campaigns with status ‘Draft’ that I didn’t notice before. However, I’m still concerned about the data import validation process. Are there specific validation rules I should configure before importing to prevent these alignment issues in the future?
I’ve seen this before with marketing dashboards. The widget data source alignment can get out of sync when you have complex aggregation rules. Check if your ROI widget is using a different time zone or date range filter than the table widget. Sometimes widgets cache their queries differently, especially after large imports.
Good catch on the filter! For future imports, you need to address this systematically. The validation rules should be consistent with your dashboard widget configurations. I’d suggest running a data quality check before importing - make sure campaign statuses, date formats, and currency codes are standardized. This prevents the validation layer from making assumptions that conflict with your widget logic.
I experienced something similar in 2205. The problem was that my ROI widget was configured to exclude certain campaign types during aggregation, while my table widget showed all campaigns. This created the KPI mismatch. Navigate to the widget settings and check the filter criteria - even subtle differences in how campaigns are filtered can cause significant percentage variations. Also, double-check if one widget is using gross ROI while the other calculates net ROI. The naming conventions in SAP CX dashboards can be confusing, and it’s easy to mix up similar-sounding KPI definitions.
Let me provide a comprehensive solution to address all three aspects of your KPI inconsistency issue.
Widget Data Source Alignment:
First, you need to ensure both widgets are truly using the same data source. In Dashboard Designer, select each widget and navigate to Data Source Configuration. Verify that both the ROI widget and performance table are pointing to the identical Marketing Campaign Analytics dataset. More importantly, check the “Query Scope” setting - one widget might be set to “Campaign Level” while the other uses “Activity Level” aggregation. This is a common cause of percentage mismatches. Set both to the same scope, preferably “Campaign Level” for ROI calculations.
Data Import Validation:
For your import process, configure proper validation rules in the Data Import Management section. Create a validation profile specifically for marketing campaign data that includes:
- Mandatory field validation for campaign_id, start_date, end_date, and status
- ROI calculation validation to ensure revenue and cost fields are populated
- Duplicate detection rules that flag campaigns with identical IDs but different metrics
- Status filter validation to exclude Draft campaigns consistently across all import batches
This ensures your imported data is clean before it reaches the dashboard layer.
KPI Consistency:
To maintain consistency going forward, standardize your KPI definitions. Create a custom KPI template in the Analytics Reporting module that defines ROI calculation as: (Revenue - Cost) / Cost * 100. Apply this template to all widgets that display ROI metrics. This eliminates calculation variations between widgets. Also, set all marketing dashboard widgets to use “Real-time” refresh mode with a 5-minute cache timeout. This ensures that after imports, all widgets reflect the same data state within a reasonable timeframe.
Finally, after each bulk import, run the “Validate Dashboard Metrics” utility from the System Administration panel. This tool compares KPI values across all widgets on a dashboard and flags inconsistencies, helping you catch alignment issues before users notice them.
Check the widget refresh settings. After bulk imports, some widgets auto-refresh while others require manual refresh or cache clearing. Go to Dashboard Designer, select each widget, and verify the data refresh policy. You might need to set both widgets to “Real-time” refresh mode instead of “Scheduled” to ensure KPI consistency across your dashboard.