AI Pillar Campaign Performance — wireframefor review· connecting…
Reviewing as
Your comments are only saving to this browser. Nobody else can see them, and you cannot see theirs.
Download them from the Feedback summary page before you close this tab, and let Maurice know.
The uploaded workbook specifies *what to measure and how metrics map*, not production SQL tables or live data. Source-table names and field contracts shown here are proposed design conventions to confirm with Martech, Salesforce and DBE teams.
Data Model: Required Keys & Fact Grain
Trace a KPI from Source to Visual
Data Quality Gates Before Production
Campaign hierarchyEvery event/digital campaign maps to one AI Pillar child and parent Campaign ID. Avoid name-based matching when stable IDs exist.
Person resolution & dedupeMap Marketo lead, event registrant and Salesforce Contact/Lead to one governed person key; retain anonymous activity separately.
Response-status definitionNormalize registered vs attended, responded vs non-responded, known content engagement and qualified MQL transitions.
Timing & attributionProgression must follow first engagement; opportunity influence requires an earlier qualifying touch within a governed lookback window.
Different measure grainsPeople ≠ content actions ≠ pageviews ≠ media impressions ≠ opportunities ≠ orders. Never combine units in one sum.
Finance & cancellationsCompleted eStore sales use canonical order ID, completed status, net amount and the finance-approved revenue recognition date.
Sample Data Inspector See normalized records behind the illustrations
First 10 rows of the current filtered sample; data generated deterministically in the browser
Executive KPI Definitions
Individual Metrics → Executive Outcomes Directly mapped from the workbook’s KPI Mapping Detail tab
“Proposed / needs validation” means a business rule or integration has not been verified. The demo numbers reflect illustrative model behavior only; they do not imply data readiness.
Feedback summary Every comment left on this wireframe, by page
Reference design: Bentley Sale Week dashboard screenshot · KPI source: AI Pillar Campaign Metrics workbook (Sheet1, Executive Scorecard, KPI Mapping Detail) · All displayed numbers, products, opportunities, and accounts are synthetic. Filters affect simulated data and metric measures; nothing is queried from production systems.