HLT-DC-MCN-001 — Executive Progress Report

Executive Summary · 30-sec read

v5 Spec Merged · Campus Seed Live · 12 Decisions Locked Wk 6+7

12

Decisions locked

11

PRs merged Wk 7 D1

3

Live DC artifacts

5

Open SF blockers

3

For James decision

Status By Team · As of EOD Thu 28 May

Where Each Team Is

BI · Snowflake

Hristo · Chris

Snow_Preference stream LIVE (1.81M rows in DC sandbox)
Build silver dbt models with R1 (drop 3.4M converted leads · CONVERTED_CONTACT_ID NOT NULL) + R2 (drop 21k ghost leads · NOT EXISTS Contact with same email) per #312 locked decision · Hristo to scope timing
Inventory GA ID fields tracked on Lead + Contact (informs Phase 2 anonymous→known stitch · WebsiteEngagement stream repair gated) · Hristo
Review raw campus value list against canonical · 15,499 case-sensitive misroutes + 66 orphan canonical codes in #149 harmonisation audit · Chris
Campus canonical codes (LON/BOS/etc) — pending Chris commitment · only 3 of 7 campuses currently resolve in SNOW_GLD_APPLICATION_PREFERENCE.CAMPUS_RESOLVED
Programme canonical codes — 19 codes computed in SNOW_GLD_PROGRAM_PREFERENCE.PROGRAM_CANONICAL but NOT yet propagated to DC consumable layer (GLD_PREFERENCE_DLM per p2-149 not built)

MAT · Marketing

Polly · Simon · Ash

Simon CSV upload autonomy validated end-to-end (campus seed today)
BDT design spec ready (single-source Excel formulas on Preference DLO · 2 output fields · matches p2-149 BDT pattern)
Polly authors Preference_CampusNormalize_BDT · gates campus journey personalisation
MAT-guidance workshop scheduled Thu 5 Jun · Polly + Simon + Ash · walkthrough Data Graph + Segments + BDT authoring
Decision #5 multi-approach pilot workshop (#334) · Wk 8 · 60 min · empirical Track A vs Track B comparison · separate event from MAT-guidance
Dual preference centre planning session (GH #289) with Ash + Simon

DC Config

Jess

STUDENT_ID cross-org match confirmed (student__id__c MS Contact = Enrollment STUDENT_ID · Rule 2 IR unblocked)
SFMC sandbox + Companion + CRM reauth complete (Phase 1 fully closed)
HULT-22242 SF Support escalation case (14 API paths exhausted · 423-line draft ready · handed off)
MC connection recreation (#80) + UMA packages reinstall · gates email personalisation in prod
DSDMFM mapping Track A delivery (post silver build)
IR ruleset config (Rule 1 EmailExact on CPE DMO + Rule 2 StudentIdCrossOrg on Individual)

Ohana Cloud

Jonatan

v5 cross-org IR spec FINAL merged (4 normalised gold tables 1:1 with DC DMOs)
Campus seed end-to-end LIVE in DC sandbox (DLO + DMO + DSDMFM mapping · 8 rows queryable)
GH #334 workshop tracker + James weekly close report
Programme + Staff seeds (Fri 29 May · same DC pattern as Campus)
Coordinate MAT-guidance workshop (Thu 5 Jun) + Decision #5 workshop (Wk 8)

Active MCN + Consent + Canonical Workstreams

9 Open Workstreams Tracked

Ticket	Workstream	Owner	Status
Salesforce / Platform Escalations
HULT-22242	331 orphan DLO fields · 14 API paths tested · all add-only · platform limitation · SF Support case ready (423-line draft)	Jess · SF Engineering	HIGH · open
MCN Cutover · Email Sending
GH #80	MC connection recreation + UMA packages reinstall · gates Data Graph + email personalisation in prod MC	Jess	In flight
GH #219	MCN deliverability — IP warming · subdomain reputation · Classic→Next sending strategy	Ash + Polly	Pending
GH #291	IP strategy — verify dedicated vs shared IP · Classic IP reusability	Ash	Pending
GH #83	Sender profiles + Reply Mail Management — per-campus sender setup · seed CSV currently TBD-#83 placeholder	Ash	Pending
Preference Center · Consent
GH #221	MCN Preference Center config — Next-native page + CloudPage migration cutover	Ash + Simon	Pending
GH #289	Dual preference centre — planning session with Ash + Simon	Ash + Simon	Planning
GH #79	Consent architecture — scope + implement MCN consent solution (MessagingConsentV2 currently 7 rows · need full build)	Jess + Simon	In flight
Consent Business Doc	Business-side consent policy document (cohort opt-in/out rules · regulatory mapping · feeds #79 implementation)	Simon · drafted by Simon side	Pending review
Canonical Layer (Both Seeds Pending Deployment)
GH #312	Campus canonical: only 3 of 7 resolved in `SNOW_GLD_APPLICATION_PREFERENCE.CAMPUS_RESOLVED` · Chris's commitment to deploy LON/BOS/etc pending · DC-native seed live as workaround (8-row `GLD_CAMPUS__dlm`)	Chris (Snow side) · Jonatan (DC side)	Partial
GH #312	Programme canonical: 19 codes computed in `SNOW_GLD_PROGRAM_PREFERENCE.PROGRAM_CANONICAL` · NOT yet propagated to DC consumable layer (`GLD_PREFERENCE_DLM` per p2-149 design not built)	Hristo + Chris	Computed · not deployed

Decisions Concluded · Wk 6 + Wk 7 Day 1

12 Decisions Across 3 Sessions

Session	Decision	Status
Sprint Review Wed 27 May	MC Personalization → DC deprioritized	LOCKED
	Business Enablement EPIC (Simon + James co-own)	LOCKED
	Transforms primarily in Snowflake (silver/gold)	LOCKED
	MC Classic → Sandbox workaround for prod stream blockers	LOCKED
#281 Naming Mon 26 May	UPPERCASE gold layer · snow_ vs DC_ origin prefix	LOCKED
	_DLL + _DLM single-underscore suffix conventions	LOCKED
	L6 Custom DMO drops SNOW_ prefix + _SF source suffix	LOCKED
	MAT naming preserved (PG_/UG_ pillar)	LOCKED
	Segments live in DC not MCN	LOCKED
	No B1/B2/B3 version suffixes for DC assets	LOCKED
	Snowflake-side canonical seed JOINs (campus + programme)	PARTIAL
	BDT formula syntax = Excel-flavour · single-source DMO	LOCKED
#312 Cross-org IR Thu 28 May	R1 drop 3.4M converted leads at silver layer	LOCKED
	R2 drop 21k ghost leads at silver layer	LOCKED
	Filters land at Snowflake silver (not gold · not DC)	LOCKED
	Marketing autonomy for canonical seed CSV uploads	LOCKED
	Decision #5 multi-approach pilot · workshop Wk 8	LOCKED

Artifacts Created · Wk 6 + Wk 7 Day 1

What's Shipped

Type	Artifact	Status
DC sandbox	`DC_GLD_CAMPUS_SEED__dll` · 8 rows · uploaded via UI	ACTIVE
DC sandbox	`GLD_CAMPUS__dlm` · 11 fields · category Other · via d360 MCP	CREATED
DC sandbox	DSDMFM mapping 1:1 · 15 fields incl system	ACTIVE
Spec	v5 cross-org IR spec · 4 normalised gold tables · 1503 lines (PR #333)	MERGED
Spec	Campus BDT design spec · single-source pattern (PR #335)	MERGED
Spec	Naming convention canonical doc (~360 lines · PR #319)	MERGED
GH ticket	GH #334 · Workshop tracker for Decision #5 multi-approach pilot	OPEN
Audit	Cross-org duplication audit · 177 lines verbatim SQL	COMMITTED
Audit	HULT-22242 14-path API exhaustion audit + 423-line SF Support draft	HANDED OFF
Deck	p2-312 13-slide architecture deck (HTML + PPTX)	COMMITTED
Deck	Naming convention 18-slide deck (HTML + PPTX)	COMMITTED
Tool	d360 MCP server installed · 187 tools · 21 families	ACTIVE

Strategic Finding

Canonical Layer Both Seeds Pending DC Deployment

CAMPUS

3 of 7 resolved in Snowflake · 0 deployed to DC

London · Boston · Dubai resolved in CAMPUS_RESOLVED. NYC · SF · Shanghai · Ashridge → NULL. Canonical 3-letter codes (LON/BOS/etc) pending Chris's commitment to deploy. DC-native seed already live (GLD_CAMPUS__dlm · 8 rows · Wk 7 Day 1) bridges gap independent of Snowflake-side decision.

PROGRAMME

19 codes computed in Snowflake · 0 deployed to DC

BBA · MBA · MIM · HEMBA · MFIN · MBAN · MMKT · BPEP · BCSB · OnlineMBA · 9 others in PROGRAM_CANONICAL. Codes exist at PRD_GLD layer but not yet propagated to DC consumable DMOs (GLD_PREFERENCE_DLM per p2-149 §1.4 design not built). Polly's BDT formulas can't consume yet.

Decision #5 workshop (Wk 8 · separate event from MAT-guidance Thu 5 Jun): empirical Track A (dbt seed + Snowflake JOIN) vs Track B (DC native seed + BDT) comparison with all 5 owners (Jess · Chris · Hristo · Simon · Jonatan) · scope = which approach Hult adopts for ongoing maintenance.

Open Items · James Decision Needed

3 Items for Your Attention This Week

#	Item	Decision needed	When
1	Decision #5 workshop scheduling (GH #334)	Confirm 60-min slot · proposed Tue 3 Jun OR Wed 4 Jun pre-sprint-review (11:00 UK). Required: Jess · Chris · Hristo · Simon · Jonatan. Empirical Track A vs Track B canonical maintenance comparison. Separate event from MAT-guidance workshop already scheduled Thu 5 Jun.	Wk 7
2	F-15 issuance (Wks 5+6 · 5,000 GBP)	Approve sending to finance. F-13 + F-14 sent 15 May (pending payment) · F-15 (Wks 5+6) being prepared now · F-16 (Wks 7+8) end of Wk 8.	This week
3	Canonical layer strategic direction	Both Campus + Programme canonical pending DC deployment. Pre-workshop decision: (a) align with Chris on Snowflake-side ownership · (b) accept DC-native maintenance (already proven) as new standard · (c) parallel paths. Workshop empirically decides · your strategic preference helps frame.	Pre-workshop

Budget & Utilisation

£10,000 Sent (50% of SOW) · Both Pending Payment · Net-Absorbed +50.8h

Wk	Dates	Hours	Invoice	Status
1+2	16-29 Apr	64.5h	F-13 (GBP)	Sent 15 May · pending payment
3+4	30 Apr-13 May	61.3h	F-14 (GBP)	Sent 15 May · pending payment
5+6	14-27 May	39.0h	F-15 (GBP)	Being sent · James OK
7+8	28 May-10 Jun	12.0h (Day 1)	F-16 (GBP)	Pending end Wk 8
Total		176.8h	£10,000 sent · £10,000 to send	+50.8h absorbed · cap rule honored

Carry Forward · Fri 29 May + Wk 7 Remainder

Next 6 Workstreams

#	Item	Owner
1	Build Programme seed v1 in DC sandbox · CSV with the 19 PROGRAM_CANONICAL codes (BBA · MBA · MIM · HEMBA etc) + DLO + DMO + DSDMFM mapping (same flow as Campus)	Jonatan
2	Build Staff DMO shell per p2-149 §1.6 schema (composite key programme_code + region + pipeline_phase · 4 assigned_rh/vp fields) · no CSV until Polly provides data	Jonatan
3	Share v5 cross-org IR spec with Chris (action from #312 session · for his review before Hristo starts silver build)	Jonatan
4	Ping Hristo to scope timing for silver R1+R2 filter build (drop 3.4M converted leads + 21k ghost leads · per #312 lock)	Jonatan
5	Coordinate Decision #5 workshop (GH #334 · Wk 8 · 60 min · all 5 owners) + send pre-read · separate from MAT-guidance workshop already scheduled Thu 5 Jun	Jonatan
6	F-15 invoice issuance (Wks 5+6 · 5,000 GBP) — with James approval	Jonatan + James

Health Check · Day 42 of 56 (75%)

On Schedule · Build Unblocked · 2 Weeks Remaining

Schedule

On plan

Phase 2 at 95% · Phase 3 specs locked · Phase 4 in flight

Budget

Cap honored

50% sent · 50.8h net absorbed · no overruns

Scope

No expansion

SOW §5 boundaries respected · new tickets within envelope

Risk

Amber

5 SF/perm blockers · all named owners · mitigations in flight