HLT-DC-MCN-001 — Executive Progress Report

Timeline

SOW Phase Gantt — 8 Weeks

Phase

W1
16–23 Apr

W2
23–30 Apr

W3
30 Apr–7 May

W4
7–14 May

W5
14–21 May

W6
21–28 May

W7
28 May–4 Jun

W8
4–11 Jun

1 — Discovery & Audit

✓ DONE

CLOSING

2 — DC Remediation

PLANNED

3 — Audience Building

PLANNED

4 — MCN Configuration

PLANNED

5 — Validation & Handover

PLANNED

Phase 1 — Discovery & Audit

Substantially Complete

Overall Phase Progress 90%

#76 — Data Stream baseline: All 176 streams audited. All healthy, 344M+ records. Dual SFMC architecture documented.

#72 — Access provisioning: Salesforce prod, sandbox, JIRA, GitHub, Snowflake, Marketing Cloud — all confirmed.

#77 — Repo scaffold: Spec-driven workflow, issue templates, board, folder structure live.

#74 — CI write-back diagnosis: Root cause identified — source stream at 0 records since Feb 2026. 409 values are stale residuals. Superseded by #126.

#75 — Opportunity 3-stream audit: Architecture confirmed intentional. Custom Field History is audit log, not Opp projection. Finance stream separate.

#126 — CI inventory: 47 Calculated Insights documented with SQL, schedule, status, DMO lineage. Jira HULTMKT1-9731 raised.

#129 — DLO/DMO/DSO inventory: 137 DMOs, 203 DLOs, 224 DSOs, 3,454 field-level mappings. Zero coverage gap. DBML lineage diagrams published.

#130 — Segments inventory: 60 Data Cloud segments audited with criteria, runtime stats, and health checks.

#96 — BI architecture review: In progress — open decisions (Approach A vs B, consent layer, CI compute) pending meeting week of 27 Apr.

#73 — Two-org Data Space/Share: Backlog — to be resolved as part of architecture meeting.

Detailed Timeline

What Happened — Week by Week

Week 1
16–23 Apr

Kick-off, Discovery, BI Deep Dive & Full Audit

Kick-off with full team (James, Jessica, Ku Chung, Chris, Hristo, Ash). Stakeholder map confirmed. BI technical discovery: Bronze/Silver/Gold architecture, Zero Copy strategy, dbt adoption, ML model inputs. Snowflake access granted. 176 Data Streams baselined — all healthy. GitHub board created with 21 issues. Simon marketing call — MCN migration priorities, consent complexity. BI sessions #2 and #3 — Zero Copy strategy, email_master migration, Identity Resolution cost insight, field mapping strategy. V3 CRM Data Kit retrieved (963 field maps). Full DLO/DMO/DSO inventory completed — zero coverage gap. 47 CIs audited. 60 segments inventoried. 7 issues closed.

Complete · 1 week ahead of plan

Week 2
23–30 Apr

Architecture Decisions & Phase 2 Start

Architecture meeting (James + Chris + Hristo + Ku): Approach A vs B, consent layer, CI compute location. Sandbox refresh + companion cleanup. MC connection recreation spec review with Ash. Begin Phase 2 remediation work post-architecture decision.

Planned

Week 3–4
30 Apr – 14 May

Remediation + Audience Building

MC connection recreation (sandbox → production). Consent architecture implementation. Segment activation and audience calibration. Data Graph calibration and field inclusion.

Planned

Week 4–6
7–28 May

MCN Configuration

Calculated Insights build (PipeAge, Suppression Flags, Footer CTAs). Email migration — UG lead welcome journey first. Sender profiles + SPF/DKIM. All Subscribers migration. End-to-end send validation.

Planned

Week 7–8
28 May – 11 Jun

Validation & Handover

QA of all configurations. Team enablement sessions (MAT, BI, Tech). Documentation handover via GitHub. Sprint review and SOW closure.

Planned

Critical Findings

Issues Requiring Attention

Consent Architecture — Hard Blocker for MCN Email Sends

MCN defaults all contacts to Opt-Out. The MessagingConsentV2 stream has only 7 records. No MessagingConsent action exists anywhere. Zero emails will send from MCN without a net-new consent build. Two-way sync essential during parallel Classic+MCN period. (#79)

Architecture Decision Pending — Week of 27 April

Key decisions on Approach A (Data Cloud as integration layer) vs Approach B (full canonical DMO model), consent source of truth (CRM field vs Consent DMO), CI compute location, and paid social routing remain open. Meeting confirmed with James, Chris, Hristo, and Ku.

Data Architecture

Data Cloud Object Model — Interactive Diagram

Full DLO → DMO lineage covering all 137 DMOs, 203 DLOs, and 224 DSOs across both Enrollment and MyStudents orgs. Interactive — zoom, pan, and click to explore relationships.

Open full diagram in dbdiagram.io →

Password: Hult2026

Issue Board

Full Workstream Status

#	Issue	Phase	Status	Spec
76	Data Stream baseline — 176 streams	1	Done	—
77	Repo scaffold + spec-driven workflow	1	Done	—
72	Access provisioning (sandbox, JIRA, GitHub, MC)	1	Done	—
74	CI write-back diagnosis — CC_TopChoiceCampus__c	1	Done	—
75	Opportunity 3-stream split audit	1	Done	—
112	V3 CRM Data Kit field maps (963 mappings)	1	Done	—
126	Calculated Insights inventory (47 CIs)	1	Done	—
129	DLO/DMO/DSO inventory (137/203/224)	1	Done	—
130	Segments inventory (60 segments)	1	Done	—
96	BI architecture review — open decisions	1	In Progress	—
80	MC connection recreation + Data Graph fix	4	In Progress	✅
73	Two-org Data Space/Data Share architecture	1	Backlog	—
79	Consent architecture — MCN consent solution	4	Backlog	Needed
81	Calculated Insights build — PipeAge, Suppression, CTAs	4	Backlog	Needed
82	All Subscribers migration	4	Backlog	Needed
83	Sender profiles + Reply Mail Management	4	Backlog	Needed
85	BigQuery DLO — batch data transform workaround	2	Backlog	Needed
87	Programme-specific footers + application link CTAs	4	Backlog	Needed
92	Lead Source deduplication	2	Backlog	Needed
84	WhatsApp / Unified Messaging — 5 bugs	4	Backlog	Needed
93	Team enablement sessions	5	Backlog	—

Financial

Budget & Utilisation

Weeks Completed

1 of 8

Budget Used

€2,500 of €20,000

Accelerated delivery: Discovery phase compressed from the planned 2-week window into Week 1 through intensive upfront investment. Phase 1 is at 90% completion — enabling Phase 2 remediation to begin in Week 2, one week ahead of SOW schedule.
INV-001: Wk 1 + Wk 2 · Fortnightly invoicing, NET 30

Looking Ahead

Next Steps — Week 2

Architecture decision meeting (week of 27 Apr) — Approach A vs B, consent source of truth, CI compute, paid social routing

Sandbox refresh + companion cleanup — Jessica to re-authenticate connections; Falak's plan reviewed first

MC connection recreation spec review with Ash — DMO mapping review is the gate for sandbox testing

Consent architecture spec (#79) — understand Classic DE stack, then design MCN bridge

Polly Pillar journey walkthrough — scheduled with Ash for detailed email flow mapping

Begin Phase 2 remediation — post-architecture decision, starting with #85 (BigQuery DLO) and #92 (Lead Source dedup)