SCRUM-92 — Agentic Outbound Email Marketing: Full Code-Flow Map

Story: SCRUM-92 — LEO CDP v2.0 Beta · Agentic Outbound Email Marketing Execution Engine Sprint board (artifact): https://claude.ai/code/artifact/142c8998-b9fd-4abb-9d92-2416c34611a1 Branch of record: feat/SCRUM-92/subtask-05-06 (commit 807df9f) Generated: 2026-09-12 · Scope: maps the Jira story + its 8 sub-tasks to the actual code, end to end.

This document is the single reference for how the agentic email-marketing flow is wired across the repo. It follows the target business sequence and, for every stage, names the real files, functions, endpoints, tables and Dagster ops that implement it — and flags what is still design-only.

0. Legend — implementation status

Jira status is the ticket state; Code state is what actually exists in the branch above.

Badge	Meaning
✅ Implemented	Code exists and is exercised (unit and/or E2E tested).
🟡 Partial	Some building blocks landed; headline behaviour not complete.
📐 Designed only	Tables/models/spec exist; the feature logic is not built yet.

1. The story in one picture

Business outcome (target flow):

Segment → CRM-sync routing → AI template draft → AI campaign draft
        → Human approval → Dispatch → Track → Feedback into Customer 360

flowchart LR
  subgraph Decide["Decide & prepare"]
    S1[Select segment_id] --> S2[Recompute + sync to crm_*]
    S2 --> S3[AI email template draft]
    S3 --> S4[AI campaign draft]
    S4 --> S5{Human approval}
  end
  subgraph Run["Execute & deliver"]
    S5 -->|Approved| S6[Dagster: activate campaign]
    S6 --> S7[Dagster: render + dispatch email]
    S7 --> S8[Recipient inbox]
  end
  subgraph Feedback["Track & feed back"]
    S8 --> S9[Open / click / unsubscribe / webhook]
    S9 --> S10[S3/MinIO event lake + suppression]
    S10 --> S11[Customer 360 + campaign metrics]
  end
  S11 -. re-segment .-> S1

Sub-task → stage → code state

#	Jira	Sub-task	Jira status	Code state	Owner
01	SCRUM-93	Schema & Migration Foundation	Done	✅ Implemented	Liêm
02	SCRUM-94	Segment-ID Driven CRM Sync Engine	Done	✅ Implemented	Liêm
03	SCRUM-95	AI Email Template Authoring (Gemini/OpenAI)	To Do	📐 Designed only	—
04	SCRUM-96	AI Campaign Strategy & Draft Creation	To Do	🟡 Partial (CRUD + gate; AI not built)	—
05	SCRUM-97	Dagster Execution Modernization	In Progress	✅ Implemented	Liêm
06	SCRUM-98	Tracking, Webhooks & Compliance Feedback	In Progress	✅ Implemented	Liêm
07	SCRUM-99	Customer 360 Feedback & Performance Rollups	To Do	🟡 Partial (capture only)	—
08	SCRUM-100	End-to-End Automated Test Suite	In Progress	✅ Implemented	Liêm

Dependency order (from the epic): 01 → 02 → 03 → 04 → 05 → 06 → 07 → 08; 08 is the Beta release gate.

2. Runtime architecture

Two deployables cooperate over PostgreSQL, Redis and the Dagster GraphQL API.

flowchart TB
  Admin["Marketer / Admin"]
  subgraph API["customer360-api · FastAPI"]
    R2["campaign_activation_api.py<br/>POST /admin/campaigns/:id/activate"]
    R1["crm_sync_api.py<br/>POST /admin/crm/sync-segment/:id"]
    R3["email_tracking_api.py<br/>/track/email/* (public)"]
    R4["crm_api.py<br/>campaign CRUD + analytics"]
    DCL["utils/dagster_client.py<br/>GraphQL client"]
  end
  subgraph BE["customer360-backend · Dagster"]
    J1["campaign_activation_job"]
    J2["email_engine_job"]
    J3["segmentation_job + poll sensor"]
    J4["analytics_job"]
  end
  DB[("PostgreSQL<br/>RLS by app.tenant_id")]
  RS[("Redis<br/>provider-config cache")]
  ESP[["SMTP / mock adapter"]]
  INBOX["Recipient inbox"]

  Admin --> R2
  R2 -->|"trigger"| DCL
  DCL -->|"GraphQL submit"| J1
  J1 -->|"GraphQL submit"| J2
  J2 --> ESP
  ESP --> INBOX
  INBOX -->|"open / click / unsubscribe / webhook"| R3
  R1 --> DB
  R2 --> DB
  R3 --> DB
  R4 --> DB
  J1 --> DB
  J2 --> DB
  J3 --> DB
  J2 -->|"read provider config"| RS
  R4 -->|"write-through invalidate"| RS

Key facts:

Tenant isolation: every table is RLS ENABLE+FORCE with a fail-closed tenant_policy keyed on current_setting('app.tenant_id'). Public tracking routes set that GUC from the signed token, not a header.
Cross-service hand-off is not one job graph. campaign_activation submits a separate email_engine_job run via the Dagster webserver GraphQL API (customer360-backend/campaign_activation/campaign_activation/triggers.py:29).
Connector config resolves DB (crm_connector_config, connector_type='EMAIL') → SMTP_* env → mock. The outbound activation connector model is separate from inbound sys_data_source.

2A. Detailed code graph — implemented path (activate → dispatch → track)

Function-level call sequence for the implemented happy path (SCRUM-97 + SCRUM-98). Every participant is a real module; every message is a real call/query.

sequenceDiagram
  autonumber
  actor Admin
  participant API as "campaign_activation_api.py"
  participant DC as "utils/dagster_client.py"
  participant CA as "campaign_activation/activation.py"
  participant TR as "campaign_activation/triggers.py"
  participant EE as "email_engine/send.py"
  participant PC as "email_engine/connector_config.py"
  participant AD as "email_engine/adapters.py"
  participant PG as "PostgreSQL (RLS)"
  actor User as "Recipient"
  participant TK as "email_tracking_api.py"
  participant CR as "crud/email_tracking.py"

  Admin->>API: POST /admin/campaigns/{id}/activate
  API->>API: require_tenant_admin · assert approval_status==Approved · template+segment set
  API->>DC: campaign_activation.activate(campaign_id, tenant_id)
  DC-->>CA: GraphQL submit campaign_activation_job
  CA->>PG: _load_campaign · gate approval · _template_status==Approved
  CA->>PG: _segment_snapshot_count · UPDATE crm_campaign status=Running
  CA->>TR: trigger_email_engine_job(campaign_id, tenant_id)
  TR-->>EE: GraphQL submit email_engine_job
  EE->>PG: pg_try_advisory_lock(1, hashtext(campaign_id))
  EE->>PC: load_email_config(tenant_id)
  PC->>PG: active crm_connector_config EMAIL row
  EE->>AD: build_adapter(config) → smtp | mock
  EE->>PG: re-validate campaign/template/segment (defense in depth)
  EE->>PG: iter_recipients(...) keyset batches
  loop per recipient (SAVEPOINT)
    EE->>PG: _current_status → skip if Sent/Suppressed
    EE->>PG: _suppressed_recipients (email + profile suppression)
    EE->>EE: _render_for_recipient (encode_tracking_token · sign click links · pixel)
    EE->>AD: adapter.send(...)
    EE->>PG: _upsert_dispatch → cdp_campaign_dispatch_logs (ON CONFLICT terminal-guard)
  end
  EE->>PG: commit per batch
  AD-->>User: email delivered
  User->>TK: GET /track/email/open?u=token
  TK->>CR: record_engagement_event(...)
  CR->>TK: Redis handoff -> immutable S3/MinIO event object
  User->>TK: GET /track/email/click?u&url&k
  TK->>TK: verify_click_url(url,k) — else 302 to /
  TK->>CR: record_engagement_event(...)
  Note over TK: POST /track/email/webhook — 503 if secret unset, 401 if bad HMAC
  TK->>CR: record provider event + suppression reason in S3/MinIO
  CR-->>PG: Activation reads crm_suppression_list before dispatch

Send-engine internals (customer360-backend/email_engine/email_engine/send.py) — the per-recipient call graph and where each branch lands in the ledger:

flowchart TD
  A["send_campaign() · send.py:255"] --> B["pg_try_advisory_lock(1, campaign)"]
  A --> C["load_email_config() · connector_config.py"]
  C --> D["build_adapter() · adapters.py:115"]
  A --> E["load_campaign / load_template / load_segment_tag — re-validate"]
  A --> F["iter_recipients() · send.py:107 — keyset batches"]
  F --> G["_process_batch() · send.py:347"]
  G --> H["_current_status() — terminal guard"]
  G --> I["_suppressed_recipients()"]
  G --> J{"eligible?"}
  J -->|"suppressed"| K["status = Suppressed"]
  J -->|"no email / opted-out"| L["status = Skipped"]
  J -->|"send"| M["_render_for_recipient() · send.py:235"]
  M --> M1["encode_tracking_token() · tracking.py:37"]
  M --> M2["rewrite_links_for_click_tracking + inject_tracking_pixel · rendering.py"]
  M --> N["adapter.send() — SMTP | mock"]
  K --> O["_upsert_dispatch() · send.py:179"]
  L --> O
  N --> O
  O --> P[("cdp_campaign_dispatch_logs<br/>ON CONFLICT(campaign_id, master_profile_id)<br/>WHERE status NOT IN (Sent, Suppressed)")]

Sync-engine internals (customer360-dao/src/leo_customer360_dao/crud/crm_sync.py) — the routing + idempotent upsert graph for Stage 1 (SCRUM-94):

flowchart TD
  S["sync_segment_to_crm() · crm_sync.py"] --> V["validate_sql_where_fragment()"]
  S --> RC["recompute_segment_membership() — skipped on dry_run"]
  S --> IT["_iter_segment_members() — keyset, tenant-scoped"]
  IT --> CL["classify_route(lifecycle_stage)"]
  CL --> RA{"route"}
  RA -->|"customer"| CA1["_upsert_customer_contact() → crm_customer_contacts"]
  RA -->|"customer"| CA2["_upsert_transactions() → crm_transactions"]
  RA -->|"lead"| LB1["_upsert_lead_source() → crm_lead_source"]
  RA -->|"lead"| LB2["_upsert_lead() → crm_lead (lead_source_id)"]
  RA -->|"contact"| CC["_upsert_contact() → crm_contact"]
  CA1 --> DK["_deterministic_id() uuid5 → ON CONFLICT DO UPDATE"]
  CA2 --> DK
  LB1 --> DK
  LB2 --> DK
  CC --> DK
  S --> AU[("crm_segment_sync_runs<br/>per-route counts · audit row")]

Line numbers are anchors as of commit 807df9f; treat them as “near here”, not exact forever.

3. End-to-end code flow (stage by stage)

Stage 1 — Select & sync the audience — ✅ (SCRUM-94)

Entry: POST /api/v1/admin/crm/sync-segment/{segment_id}?dry_run= → customer360-api/core/routers/crm_sync_api.py:42 sync_segment_crm (tenant-admin gated; GET /admin/crm/sync-runs[/{id}] for audit).

Engine: customer360-dao/src/leo_customer360_dao/crud/crm_sync.py sync_segment_to_crm:

Validate sql_rules (leo_customer360_dao.utils.sql_safety.validate_sql_where_fragment).
recompute_segment_membership(db, segment) (reused from leo_customer360_dao/crud/segmentation.py) — unless dry_run.
_iter_segment_members(...) — keyset-paginated read of cdp_master_profiles (tenant-scoped, status_code=1).
classify_route(lifecycle_stage) → route + upsert, each member inside a SAVEPOINT:
- customer → _upsert_customer_contact (crm_customer_contacts) + _upsert_transactions (crm_transactions, facts never fabricated).
- lead → _upsert_lead_source (crm_lead_source) + _upsert_lead (crm_lead, sets lead_source_id).
- contact (any other stage) → _upsert_contact (crm_contact).
Idempotency: every target PK is a deterministic uuid5 (_deterministic_id) so re-runs ON CONFLICT DO UPDATE the same rows; the run is audited in crm_segment_sync_runs.

Stage 2 — AI email template draft — 📐 (SCRUM-95, design only)

Exists: crm_message_templates table + MessageTemplate model (core/models/crm.py) and MessageTemplate{Base,Create,Update,Read} schemas (core/schemas/crm.py), status default Draft.

Not built: no generation endpoint, no template CRUD/review router (the generic router factory in crm_api.py deliberately does not build one for MessageTemplate), no Gemini/OpenAI integration, no prompt code. core/config.py has no LLM settings. Intended contract: docs/action-plans/AGENTIC-EMAIL-MARKETING-FLOW.md:172-212.

Reference provider-switch code to model the build on (not wired to this feature): customer360-seeding/adjust_faker.py, customer360-seeding/web_user_simulator.py, customer360-dao/src/leo_customer360_dao/agentic_engines/persona_engine.py:874-911.

Stage 3 — AI campaign draft — 🟡 (SCRUM-96)

Exists (data + human gate):

crm_campaign columns segment_id, pinned workflow fields, approval_status, approved_by/at, strategy_summary, ai_plan (JSONB) — core/models/crm.py:23.
crm_campaign_content_items (content plan; UNIQUE(campaign_id, content_item_id)) — core/models/crm.py:271.
Campaign CRUD via build_crud_router and analytics sub-router — core/routers/crm_api.py.

Not built: the AI planning endpoint (…campaigns:plan) and a real state-machine. Today approval_status is only regex-validated (APPROVAL_STATUS_PATTERN, leo_customer360_dao/schemas/crm.py); the single enforced transition is the activation gate in Stage 5. Spec: AGENTIC-EMAIL-MARKETING-FLOW.md:214-255, AGENTIC-MARKETING.md.

Stage 4 — Human approval — ✅ gate (part of SCRUM-96/97)

A human sets approval_status='Approved' (today via generic PATCH /api/v1/campaigns/{id}). The gate is enforced at activation, below.

Stage 5 — Dagster: activate the campaign — ✅ (SCRUM-97)

API entry: POST /api/v1/admin/campaigns/{campaign_id}/activate → core/routers/campaign_activation_api.py:44 activate_campaign — tenant-admin gated; re-checks approval_status == "Approved" and pinned workflow_id/workflow_version + segment_id present (else 409); submits a Dagster run via core/utils/dagster_client.py:445 CampaignActivationDagsterService.activate (503 if Dagster unreachable). Returns run_id.

Job: campaign_activation_job → activate_campaign_op (customer360-backend/campaign_activation/dagster_defs.py:52, RetryPolicy(max_retries=2, delay=10)) → campaign_activation/activation.py:71 activate_campaign:

set_tenant_context (RLS) → _load_campaign (crm_campaign).
Gate: campaign approval + approved pinned workflow + segment present (else CampaignActivationError).
Validate cdp_segments row + segment_tag.
UPDATE crm_campaign SET status='Running' + commit.
triggers.trigger_campaign_workflow_job(...) → GraphQL submit_job_execution("campaign_workflow_job", location="campaign_activation", …).

Stage 6 — Dagster: execute the persisted workflow — ✅ (SCRUM-97)

Job: email_engine_job → send_campaign_op (customer360-backend/email_engine/dagster_defs.py:53, RetryPolicy(max_retries=2, delay=15), passes run_id) → email_engine/send.py:255 send_campaign:

Per-campaign advisory lock pg_try_advisory_lock(1, hashtext(campaign_id)) — a concurrent/retry run that can’t acquire it exits skipped_locked (no double-send). Released in finally.
build_adapter(load_email_config(tenant_id, conn)) — provider resolution (see §4).
Re-validate approval (defense in depth) — load_campaign/load_template/load_segment_tag.
iter_recipients(...) — keyset batches of cdp_master_profiles (status_code=1, segment_tag).
_process_batch (send.py:347), per recipient inside a SAVEPOINT:
- Terminal-state guard _current_status — skip if already Sent/Suppressed.
- Branch: suppressed → Suppressed; no-email / opted-out → Skipped; else render + dispatch.
- _render_for_recipient — subject/html/text via rendering.py, click-links rewritten & HMAC-signed, tracking pixel + unsubscribe URL injected; token via email_engine/tracking.py:37 encode_tracking_token (HMAC tenant|campaign|master_profile).
- adapter.send(...) → _upsert_dispatch (send.py:179) writes cdp_campaign_dispatch_logs.
- Commit per batch.

Idempotency of the ledger: cdp_campaign_dispatch_logs has UNIQUE (campaign_id, master_profile_id); the upsert is ON CONFLICT (campaign_id, master_profile_id) DO UPDATE … WHERE status NOT IN ('Sent','Suppressed') — terminal rows are never re-sent or downgraded.

Stage 7 — Track, webhook & suppress — ✅ (SCRUM-98)

Public router (core/routers/email_tracking_api.py:41, prefix /api/v1/track/email, all in PUBLIC_PATHS — core/apps/http_api_app.py):

Method + path	Function	Behaviour
`GET /track/email/open`	`track_open` (58)	records `email-opened`; always returns 1×1 GIF even on bad token
`GET /track/email/click`	`track_click` (69)	302 only if `verify_click_url(url,k)` passes & http/https (anti open-redirect), else 302→`/`
`GET /track/email/unsubscribe`	`unsubscribe` (87)	records `email-unsubscribed` with suppression reason `unsubscribe`
`POST /track/email/webhook`	`email_webhook` (107)	HMAC-verified provider callback; dedup; suppress on hard bounce/complaint

Token & auth — core/utils/email_tracking.py: decode_tracking_token (87, constant-time compare), verify_click_url (66), verify_webhook_signature (76, fail-closed), WEBHOOK_EVENT_TO_NAME (36), SUPPRESSION_EVENTS (55). Webhook is fail-closed: 503 if CRM_EMAIL_WEBHOOK_SIGNING_SECRET unset, 401 on bad signature.

Write side — email tracking normalizes engagement events through the customer360-event-api Redis/S3 contract. The public tracking service does not open a PostgreSQL connection or insert behavioral-event rows. Deduplication is represented by the canonical event ID/dedup key and immutable S3 state.

Email tracking carries the provider event and suppression reason into the S3/MinIO event envelope.
Activation reads the canonical mailed address from the profile and checks crm_suppression_list by tenant, channel='EMAIL', identifier_type='EMAIL', active status, expiry, and campaign scope.

The customer360-event-api/ service owns both generic web behaviour and normalized email engagement ingestion (Redis Streams → S3/MinIO).

Stage 8 — Feedback into Customer 360 — 🟡 (SCRUM-99, capture only)

Landed: email events are captured in the S3/MinIO event lake and compliance suppression is modeled in crm_suppression_list (Stage 7). A change-gated segmentation sensor exists (customer360-backend/segmentation/dagster_defs.py:136 segmentation_poll_sensor, watches cdp_master_profiles via count_recently_changed_master_profiles). Campaign performance is exposed read-only through vw_campaign_performance_metrics + CampaignRepository (core/repositories/campaign_repository.py).

Not built (the three headline SCRUM-99 behaviours):

Writing email touchpoints/engagement back to cdp_master_profiles — nothing propagates S3 Silver event projections → profile fields. The ai_agents_runners Dagster location provides the tenant-scoped workflow orchestration hook (customer360-backend/ai_agents_runners/dagster_defs.py).
Email-event-driven segment refresh — the sensor watches profiles, and email events don’t touch profiles, so opens/clicks don’t trip it.
Email-metric rollup into campaign performance — crm_campaign_performance_daily has ad-metric columns only and no email write path (only a demo seeder populates it).

4. Connector config & dispatch adapter — ✅ (SCRUM-97)

Resolution order — customer360-backend/email_engine/email_engine/connector_config.py load_email_config: active outbound crm_connector_config EMAIL row → SMTP_* env → mock default.
Write side — customer360-api/core/crud/email_provider.py: get_active_config, upsert_config (keeps one active EMAIL connector per tenant). Exposed at GET/PUT /api/v1/admin/email-provider-config (campaign_activation_api.py); smtp_password is write-only (never returned).
Adapter selection — email_engine/adapters.py:115 build_adapter: provider=='smtp' → SMTPDispatchAdapter (real smtplib); anything else → MockDispatchAdapter (unknown provider logs a warning and falls back to mock — a typo never triggers a real send). Additional connector providers are represented in the generic table and can be implemented by adding adapters.

5. Data model (SCRUM-93) — ✅

Fresh-cluster DDL: customer360-database/database-schema.sql:2914-3218. Incremental migrations (applied by deployments/postgres/run-sql.sh, which runs forward *.sql in name order and excludes *.down.sql):

Table	Migration (fwd / down)	Change	Idempotency / key constraint	RLS
`crm_message_templates`	`003`	renamed/generalized	message type, persona, context, variables, and approval status	✔
`crm_campaign` (+cols)	`002` + `015`	alter: `segment_id`, workflow pin, approval fields, strategy/AI fields; direct template link removed	FK → `cdp_segments`	(base)
`crm_campaign_content_items`	`002`	new	`UNIQUE(campaign_id, content_item_id)`	✔
`crm_segment_sync_runs`	`002`	new (audit)	status check; `segment_id` FK CASCADE	✔
`crm_lead.lead_source_id`	`002`	alter: FK col	FK → `crm_lead_source` ON DELETE SET NULL	(base)
`cdp_campaign_dispatch_logs`	`003`	new (send ledger)	`UNIQUE(campaign_id, master_profile_id)`	✔
`crm_connector_config`	`002_crm_connector_config`	new/migrated	`UNIQUE(tenant_id,name)` + partial-unique default-per-channel	✔
`crm_suppression_list`	`003_crm_suppression_list`	new/migrated	Active global/campaign uniqueness by channel and identifier	✔
`cdp_event_catalog` (seed)	`004`	data: `email-delivered/…/-unsubscribed`	`ON CONFLICT (event_name) DO NOTHING`	n/a

SQLAlchemy models: customer360-dao/src/leo_customer360_dao/models/crm.py (Campaign, MessageTemplate, CampaignContentItem, SegmentSyncRun, CampaignDispatchLog, ConnectorConfig). Pydantic schemas: customer360-api/core/schemas/crm.py (APPROVAL_STATUS_PATTERN:18).

erDiagram
  cdp_segments ||--o{ crm_campaign : "segment_id"
  crm_campaign ||--o{ crm_campaign_content_items : "campaign_id"
  cdp_content_items ||--o{ crm_campaign_content_items : "content_item_id"
  crm_campaign ||--o{ cdp_campaign_dispatch_logs : "campaign_id"
  cdp_master_profiles ||--o{ cdp_campaign_dispatch_logs : "master_profile_id"
  crm_lead_source ||--o{ crm_lead : "lead_source_id"
  cdp_segments ||--o{ crm_segment_sync_runs : "segment_id"
  crm_campaign ||--o{ crm_suppression_list : "campaign_id"

6. Configuration reference (env)

From the epic checklist (SCRUM-92 §D) and the code that reads it:

Group	Vars	Status
AI provider	`CRM_EMAIL_AI_PROVIDER`, `OPENAI_API_KEY/MODEL` or `GEMINI_API_KEY/MODEL`	📐 not read yet (SCRUM-95/96)
Sender identity	`CRM_EMAIL_FROM_NAME/FROM_ADDRESS/REPLY_TO`	via provider config / env
Compliance URLs	`CRM_EMAIL_UNSUBSCRIBE_BASE_URL`, `…TRACKING_BASE_URL`, `EMAIL_PUBLIC_BASE_URL`	✅ used at render
Tracking secret	`EMAIL_TRACKING_SECRET` (must match in both services)	✅
Webhook secret	`CRM_EMAIL_WEBHOOK_SIGNING_SECRET` (empty ⇒ webhook disabled/503)	✅
SMTP	`SMTP_HOST/PORT/USERNAME/PASSWORD/USE_TLS`	✅ fallback config
Dispatch	`EMAIL_DISPATCH_ADAPTER` (`mock`/`smtp`), `EMAIL_ENGINE_BATCH_SIZE`, `EMAIL_PROVIDER_CONFIG_TTL_SECONDS`	✅
Dagster	`DAGSTER_GRAPHQL_HOST/PORT` (default `localhost:3000`)	✅

Template: .env.example (§ around EMAIL_* / CRM_EMAIL_*).

7. Testing & release gate (SCRUM-100) — ✅

E2E suite — customer360-api/tests/e2e/ (drives live UAT over HTTP; inert unless E2E_BASE_URL set):

File	Ticket	Covers
`test_schema_foundation_e2e.py`	93	new columns / `ai_plan` round-trip, approval boundary, FKs, sync-runs queryable
`test_crm_sync_e2e.py`	94	dry-run, zero-match sync, audit, idempotent replay, guards, cross-tenant isolation
`test_routing_e2e.py`	94	opt-in write tests (`E2E_ALLOW_DATA_WRITES=1`) asserting routes A/B/C + idempotency
`test_campaign_activation_e2e.py`	97	approval gate (404/401/409), dispatch-logs, provider-config, opt-in real activation
`test_email_tracking_e2e.py`	98	pixel/click/redirect-block, forged webhook → 401/403/503 never 200, unsubscribe

Harness: conftest.py (env config, --case selection mapped to TEST_PLAN.md, GitHub summary, LIFO cleanup, token/URL signing re-implemented to avoid importing app code), test.sh (mints Keycloak token), README.md, TEST_PLAN.md (AC → case traceability). Simulator pattern mirrored from customer360-seeding/run_tracking_analytics_e2e.sh.

CI/CD gate:

.github/workflows/ci.yml → e2e job: needs [changes, test], runs only when customer360-api changed and after unit tests pass; self-skips (exit 0) if Keycloak secrets are absent.
.github/workflows/cd.yml: on workflow_run [CI] completed; deploys only when the whole CI run (incl. e2e) concluded success. main→UAT, vX.Y.Z→prod (protected environment).
⚠️ Because e2e self-skips without KC secrets / when customer360-api is untouched, a green CI can occur without E2E actually running — the gate blocks on E2E only when it executes.

8. What remains to reach the story’s Definition of Done

Area	Gap	Where it would land
SCRUM-95	AI template generation (Gemini/OpenAI) + template CRUD + approve/reject/edit APIs	`customer360-api/core` (new `ai/` + template router); model on the reference provider-switch code
SCRUM-96	AI campaign planning endpoint + real Draft→InReview→Approved/Rejected→Scheduled/Running state machine	`customer360-api/core` (planning service + transition validator)
SCRUM-97	(optional) SES adapter	`email_engine/adapters.py` (one subclass + branch); DB CHECK allows `mock/smtp` only today
SCRUM-99	profile touchpoint/engagement writeback; email-driven segment refresh; email-metric rollup into `crm_campaign_performance_daily`	`customer360-backend/ai_agents_runners` + new perf columns/aggregation

Appendix — file index

customer360-api

core/routers/crm_sync_api.py — segment→CRM sync + audit endpoints
customer360-dao/src/leo_customer360_dao/crud/crm_sync.py — the sync engine (routing, deterministic upserts, audit)
core/routers/campaign_activation_api.py — approval gate + activation + dispatch-logs + provider-config
customer360-dao/src/leo_customer360_dao/crud/email_provider.py — provider-config write side + Redis invalidation
core/routers/email_tracking_api.py — public open/click/unsubscribe/webhook
core/crud/email_tracking.py — event capture (dedup) + suppression
core/utils/email_tracking.py — token sign/verify, webhook verify, event maps
core/utils/dagster_client.py — GraphQL clients for the Dagster jobs
core/routers/crm_api.py / core/repositories/campaign_repository.py — campaign CRUD + analytics
customer360-dao/src/leo_customer360_dao/models/crm.py, customer360-dao/src/leo_customer360_dao/schemas/crm.py — ORM + Pydantic
core/apps/http_api_app.py — PUBLIC_PATHS allowlist
tests/e2e/* — E2E suite + plan

customer360-backend

campaign_activation/dagster_defs.py, campaign_activation/{activation,triggers,rls,db}.py
email_engine/dagster_defs.py, email_engine/{send,adapters,rendering,connector_config,provider_config,tracking,rls,db}.py
segmentation/dagster_defs.py + segmentation/recompute.py — recompute + poll sensor
ai_agents_runners/dagster_defs.py — tenant-scoped API/cron workflow orchestration
workspace.yaml — Dagster code-location registration

customer360-database

database-schema.sql (2914-3218), migrations/002_…, 003_…, 004_… (+ .down.sql)
deployments/postgres/run-sql.sh — migration runner

docs (design specs)

docs/action-plans/AGENTIC-EMAIL-MARKETING-FLOW.md, AGENTIC-MARKETING.md, AGENTIC-AD-TECH-FLOW.md

LEO Customer 360 — Documentation

Explorer

SCRUM-92 — Agentic Outbound Email Marketing: Full Code-Flow Map

SCRUM-92 — Agentic Outbound Email Marketing: Full Code-Flow Map

0. Legend — implementation status

1. The story in one picture

2. Runtime architecture

2A. Detailed code graph — implemented path (activate → dispatch → track)

3. End-to-end code flow (stage by stage)

Stage 1 — Select & sync the audience — ✅ (SCRUM-94)

Stage 2 — AI email template draft — 📐 (SCRUM-95, design only)

Stage 3 — AI campaign draft — 🟡 (SCRUM-96)

Stage 4 — Human approval — ✅ gate (part of SCRUM-96/97)

Stage 5 — Dagster: activate the campaign — ✅ (SCRUM-97)

Stage 6 — Dagster: execute the persisted workflow — ✅ (SCRUM-97)

Stage 7 — Track, webhook & suppress — ✅ (SCRUM-98)

Stage 8 — Feedback into Customer 360 — 🟡 (SCRUM-99, capture only)

4. Connector config & dispatch adapter — ✅ (SCRUM-97)

5. Data model (SCRUM-93) — ✅

6. Configuration reference (env)

7. Testing & release gate (SCRUM-100) — ✅

8. What remains to reach the story’s Definition of Done

Appendix — file index

Graph View

Table of Contents