` "Steps (N)" + a row per step: grid `40px 110px 1fr 1fr 1fr auto`: - step # · **Delay (hours)** number input + grey `formatFiresHint` line · **Template** `` (`{name} ({slug})`) · **Skip If** input · **Exit Goal** input · `↑`/`↓`/`×` `iconBtn`s (move up/down/remove). - `lead_magnet` trigger shows a non-editable "Instant delivery email · AUTO · DAY 0" row at top (code-defined, §13). - footer `+ Add Step` (`.btn.btn-solid`). `addStep` appends `{ delay_hours:0, template_slug: templates[0]?.slug ?? '' }`. `handleSave` sanitizes: `delay_hours = max(0, floor(Number||0))`, trims slug, drops empty `skip_if`/`exit_goal`. 6. **Audience & Fire — only when `trigger_event === 'manual'`:** 4 selectable audience cards (All confirmed / Paid `plan≠free` / Trial-free `plan=free` / Pick users). `select` lazy-loads `GET users`. The user picker (search + select-visible + scroll box `maxHeight:320`, plan + `OPTED OUT` chips) toggles a `Set`. Fire footer: `Fire Campaign →` (`.btn.btn-solid`) disabled when `firing || dirty || status !== 'active'`; `handleFire` guards then `POST campaigns/[id]/enroll { audience, userIds? }` and shows `lastFireResult` (enrolled / already-active / matched / worker-fired). 7. Conditions reference footer card documenting the DSL + evaluation order (campaign `exit_goal` → step `exit_goal` → step `skip_if`). --- ## 6. Page — Templates (`email/templates/page.tsx`) Reference: `src/app/admin/dashboard/email/templates/page.tsx`. **Full-height 3-pane layout** (the only page that breaks the centered-container pattern): ``` root: display:flex; flexDirection:column; height:calc(100vh - 64px); padding:'0.85rem 1.25rem'; gap:'0.75rem'; overflow:hidden grid: 200px 1fr 1.1fr (list / editor / live preview), fills remaining height ``` **Data:** ```ts type Template = { id; slug; name; subject; html_body; text_body; from_email; from_name; updated_at: string } type Layout = { html_wrapper: string; text_wrapper: string } ``` Loads `GET templates` + `GET layout` in parallel. **Panes:** 1. **List** — scrollable; each item = name + mono slug; selected gets `borderLeft:'3px solid --brand-accent'` + `--brand-bg-0`. 2. **Editor** — Slug (editable only when `adding`, sanitized `[a-z0-9-]`, disabled+`opacity:0.6` when editing) + Name; From Name + From Email; Subject (note "supports {{first_name}}"); Body (HTML) ``. Footer: **Archive** (danger) + **Duplicate** (when not adding) + Save (`.btn.btn-solid`, label `Create`/`Save Changes`/`Saved`). 3. **Live preview** — FROM line + merge-rendered SUBJECT + `<iframe srcDoc={wrapPreview(html_body, layout, SAMPLE_CTX)}>` (`flex:1`, bg `#FAFAF7`). **Preview helpers (mirror server `render-template.ts`):** ```ts function renderMergeTags(input: string, ctx: Record<string,string>) { return input.replace(/\{\{\s*([a-z0-9_]+)\s*\}\}/gi, (_m, k) => ctx[k.toLowerCase()] ?? '') } function wrapPreview(body: string, layout: Layout|null, ctx) { const wrapped = layout ? layout.html_wrapper.replace('{{content}}', body) : body return renderMergeTags(wrapped, ctx) } const SAMPLE_CTX = { first_name:'Alex', full_name:'Alex Rivera', email:'preview@yourapp.com', trial_days_left:'5' } ``` **API:** `POST templates` (create), `PATCH templates/[slug]` (edit OR `{archive:true}`), `POST templates/[slug]/duplicate {newSlug}`. `startNew()` seeds a sample body (orange eyebrow / display headline / `{{first_name}}` body / orange CTA table) + `from_email`/`from_name` defaults. --- ## 7. Page — Layout (`email/layout/page.tsx`) Reference: `src/app/admin/dashboard/email/layout/page.tsx`. Container `maxWidth:1300`. ```ts type Layout = { html_wrapper: string; text_wrapper: string; updated_at: string } ``` `GET layout` / `PATCH layout`. **Before save, BOTH wrappers must contain `{{content}}`** (else toast error — it's where the template body injects). 2-col grid: left = HTML Wrapper `<textarea rows=26>` + Plain Text Wrapper `<textarea rows=10>`; right = HTML preview in an `<iframe srcDoc={wrapPreview(html_wrapper, SAMPLE_CONTENT_HTML)}>` + plain-text preview in a `<pre>`. `SAMPLE_CONTENT_HTML` is a hardcoded sample body so the wrapper renders with realistic content. --- ## 8. Page — Enrollments (`email/enrollments/page.tsx`) Reference: `src/app/admin/dashboard/email/enrollments/page.tsx`. Container `maxWidth:1300`. The most stateful page. **Data:** ```ts type EnrolledUser = { id; email; full_name:string|null; plan:string|null; email_opt_out:boolean; created_at:string } type EnrollmentRow = { id; campaign_id; status:'active'|'completed'|'exited'|'paused' current_step:number; next_send_at:string|null; exit_reason:string|null enrolled_at:string; completed_at:string|null campaign: { id; name; trigger_event; status; steps:unknown[] } | null } type SendRow = { id; template_slug; step_index:number; subject; sent_at; opened_at; clicked_at; bounced_at; unsubscribed_at; error_message:string|null } ``` **Enrollment status color (verbatim):** ```ts function statusColor(s: string): string { if (s === 'active') return 'var(--brand-success)' // green if (s === 'paused') return 'var(--brand-accent)' // orange if (s === 'exited') return 'var(--brand-danger)' // red return 'var(--brand-text-2)' // completed/other = grey } ``` **Surfaces:** - **Search form** — email input → `GET enrollments?email=`. - **4 filter cards** (All confirmed / Paid / Trial-free / Pending) → `GET users?filter=`. Active card = `2px solid --brand-accent`. - **Cohort list** — in-list search, counter (`total · shown · selected`), select-visible, multi-select `Set`. **Bulk enroll panel** (campaign `<select>` → `POST campaigns/[id]/enroll {audience:'select', userIds}`). Each row: checkbox + name/email + `plan` chip + `PENDING` chip (`!email_confirmed`) + `OPTED OUT` chip. - **User detail card** — name/email/chips + actions: **Send template…** (panel → `POST send-one` per target, **concurrency 4** worker pool), **Enroll in campaign…**, **Re-subscribe / Opt out** (`PATCH users/[id] {email_opt_out}`). When a cohort is selected, actions target the checked set (`getActionTargetIds()`). - **Enrollments list** — campaign name (→ editor) + `trigger · step X/Y`; status chip via `statusColor` + `exit_reason`; timing (`Next:`/`Ended:`/`Enrolled:`); action `iconBtn`s by status (active → `⏭` skip / `⏸` pause / `×` exit; paused → `▶` resume / `×` exit) → `PATCH enrollments/[id] {action}`. - **Recent Sends table** — subject + `template_slug · step N` + sent_at + status chips (`error` danger / `bounced` danger / `clicked` success / `opened` / `unsub` accent). --- ## 9. Page — Analytics (`email/analytics/page.tsx`) Reference: `src/app/admin/dashboard/email/analytics/page.tsx`. Container `maxWidth:1400`. ```ts type AnalyticsResponse = { windowDays: number; since: string overview: { sent; opened; clicked; bounced; unsubscribed; spam; errors: number } daily: { date: string; sent; opened; clicked: number }[] byCampaign: { campaign_id; name; trigger_event; status; is_transactional; sent; opened; clicked; bounced; unsubscribed; errors }[] byTemplate: { template_slug: string; sent; opened; clicked: number }[] } const pct = (n: number, d: number) => d === 0 ? '—' : `${(n/d*100).toFixed(1)}%` ``` `GET analytics?days=` (default 30). Window buttons `[7,14,30,60,90]` → selected = `border:'2px solid --brand-accent'` over `--brand-bg-0`. - **5 stat cards** (`StatCard`: `cardStyle` + uppercase mono label + `1.75rem` value + optional sub): Sent (sub `{errors} send errors`, danger if >0) · Open rate · Click rate · Bounce rate (danger sub) · Unsub rate. - **Daily chart** — hand-rolled inline SVG (`viewBox 0 0 100 100`, `preserveAspectRatio none`): grey full-height bar = sent, orange overlay (opacity 0.7) = opens share, green overlay = clicks share, `<title>` tooltip per bar; x-labels every `floor(points/8)`. Legend: Sent grey / Opened orange / Clicked green. - **Per-campaign table** — Campaign (→ editor) · Trigger chip · Sent · Open · Click · Bounce · Unsub · Errors (rates via `pct`; bounce/errors cells turn danger when >0; `TRANSACTIONAL` chip on flagged rows). - **Per-template table** — slug · Sent · Open rate · Click rate. --- ## 10. The 14 admin API routes (reference) All `runtime='nodejs'`, `requireAdmin`, `zod`-validated. Reference dir: `src/app/api/admin/email/`. | Route | Methods | Notes | |---|---|---| | `campaigns` | GET, POST | GET rolls up counts from parallel `email_enrollments` + `email_sends` queries (head-count overrides for `lead_magnet` from `magnet_leads`/`magnet_lead_sends`). POST validates `is_transactional` only on `payment_failed` (`TRANSACTIONAL_ALLOWED_TRIGGERS`). | | `campaigns/[id]` | GET, PATCH | PATCH **403s if name starts `_`** (system lock); re-checks effective-transactional guard (patch-value-else-existing for both flag + trigger). | | `campaigns/[id]/enroll` | POST | Audience `all` (auth.listUsers, confirmed only, ≥1000 = truncation note) / `paid` / `free` (profiles) / `select` (trusted userIds). Skips already-active. INSERT in chunks of 500. `next_send_at = now + floor(steps[0].delay_hours)`. Best-effort `triggerAndRecord('email-drip-tick')`. 400 if archived or `steps.length===0`. | | `templates` | GET, POST | GET active only (`archived_at is null`). POST slug regex `^[a-z0-9][a-z0-9-]{0,63}$`; derives `text_body` via `htmlToPlainText` if omitted; 23505 → 409. | | `templates/[slug]` | GET, PATCH | PATCH `{archive:true}` sets `archived_at`; else updates + auto-derives `text_body`. | | `templates/[slug]/duplicate` | POST | Copies an active template under `{newSlug}`; default name `"<src> (Copy)"`; 23505 → 409. | | `layout` | GET, PATCH | Singleton `id=1`. Each provided wrapper **must contain `{{content}}`** (400 otherwise). | | `enrollments` | GET | `?email=` → match via `auth.listUsers` (no get-by-email API), then profiles + enrollments(+campaign) + last 50 sends. | | `enrollments/[id]` | PATCH | State machine `{action: pause|resume|exit|skip}`. pause: active→paused (next_send_at null). resume: paused→active (next_send_at now). exit: →exited (+exit_reason, completed_at). skip: active→ current_step+1, next_send_at now. **No DELETE.** Invalid transitions → 400. | | `analytics` | GET | `?days=` 1–90. Reads `email_sends` window + campaign labels; all rollups computed in JS. `sent` = rows with `postmark_message_id`; `errors` = rows with `error_message` and no message id. | | `send-one` | POST | The **only** admin route that sends. `{userId, templateSlug, force?}`. Blocks opted-out unless `force`; 30-min same-template 409 guard; find-or-creates `_Ad-hoc Sends (system)` campaign; inserts synthetic completed enrollment + `email_sends` (`dedupe_key='<enrollmentId>:0'`); `wrapAndRender` + `sendBroadcastEmail` with `unsubscribe_url`. | | `users` | GET | `?filter=all|paid|free|pending` from `auth.listUsers({perPage:1000})` + profiles join. `truncated` flag at ≥1000. | | `users/[id]` | PATCH | `{email_opt_out}` flip on profiles only (does NOT exit enrollments). | | `users/[id]/opt-out` | POST | Full opt-out: flip flag + **exit ALL active enrollments** (`exit_reason:'support_opt_out'`) + stamp latest send `unsubscribed_at` + optional `conversation_events` audit row (`ticketId`). | --- ## 11. The engine layer ### 11.1 Drip worker (`email-drip-tick`) Owned by EMAIL-INFRASTRUCTURE. This console relies on its contract: cron `*/15 * * * *`, ≤200 due active enrollments/tick, insert-`email_sends`-row-before-send (`dedupe_key` UNIQUE), optimistic-lock advance (`.eq('current_step', old)`), retryable (5xx/429 → delete send row + back off 15min, stay on step) vs hard (4xx → keep row + advance), opt-out gate (`email_opt_out && !is_transactional` → exit this enrollment), per-user 2-emails/UTC-day marketing cap. See [s-tier/EMAIL-INFRASTRUCTURE-PLAYBOOK.md §6](../s-tier/EMAIL-INFRASTRUCTURE-PLAYBOOK.md). ### 11.2 Condition DSL (`src/lib/email/conditions.ts`) — owned here Reference: `src/lib/email/conditions.ts`. Conditions are **plain strings** stored in `email_campaigns.exit_goal` and `steps[].skip_if` / `steps[].exit_goal`. Evaluated by the drip worker. **Fail-soft**: unknown/errored → `false` (a typo can't silently nuke a campaign). ```ts export const KNOWN_CONDITIONS = ['converted_to_paid','has_published','onboarding_complete','trial_expired','unsubscribed'] type ConditionContext = { userId: string; enrolledAt: string profile: { plan; account_status; email_opt_out; onboarding_step_completed? } | null supabase: SupabaseClient; isTransactional?: boolean } export async function evaluateCondition(key: string, ctx: ConditionContext): Promise<boolean> { const k = key.trim().toLowerCase(); if (!k) return false try { switch (k) { case 'converted_to_paid': return !!ctx.profile?.plan && ctx.profile.plan !== 'free' case 'has_published': { // any scheduled_posts published AFTER enrollment const { data } = await ctx.supabase.from('scheduled_posts').select('id') .eq('user_id', ctx.userId).eq('status','published').gt('published_at', ctx.enrolledAt).limit(1) return (data?.length ?? 0) > 0 } case 'onboarding_complete': return (ctx.profile?.onboarding_step_completed ?? 0) >= 3 case 'trial_expired': return ctx.profile?.account_status === 'trial_expired' case 'unsubscribed': return ctx.isTransactional ? false : ctx.profile?.email_opt_out === true default: console.warn('[email-conditions] unknown key', k); return false } } catch { return false } } ``` **To add a condition:** extend the switch + `KNOWN_CONDITIONS`, keep fail-soft. `has_published` is the app-specific "activated" signal — swap `scheduled_posts`/`published_at` for whatever your app's activation event is. ### 11.3 Trigger-event model + enroll helpers (`src/lib/email/enroll.ts`) Reference: `src/lib/email/enroll.ts`. Both helpers are best-effort (return counts, never throw — enrollment is a retention nicety, never blocks a signup/webhook). ```ts type CampaignTriggerEvent = | 'trial_signup' | 'paid_signup' | 'inactive_7d' | 'trial_ending_3d' | 'trial_expired' | 'manual' | 'subscription_canceled' | 'payment_failed' | 'lead_signup' | 'abandoned_checkout' | 'lead_magnet' | 'welcome_offer' enrollUserInCampaignsByEvent(admin, userId, event, opts?: { repeatable?: boolean; cooldownDays?: number }) → { enrolled, skipped, errored } exitActiveEnrollmentsByEvent(admin, userId, fromEvent, reason) → { exited, errored } ``` De-dupe: `repeatable=false` (default) skips if ANY prior enrollment in that campaign exists; `repeatable=true` only blocks an **active** one — unless `cooldownDays` is set (then also blocks if most-recent `enrolled_at` within the window — load-bearing for daily sweeps so a still-dormant user isn't re-enrolled every day). 23505 on the active-partial unique index counts as success. Where events fire: `lead_signup`/`paid_signup`/`welcome_offer` from signup + Stripe webhooks (one-shot); `inactive_7d`/`trial_ending_3d` from `email-lifecycle-tick` (repeatable, cooldown 14d); `trial_expired` from `trial-expire-tick`; `payment_failed`/`subscription_canceled` dunning (transactional); `lead_magnet` rides `magnet_leads` (not `email_enrollments`); `manual` from admin fire / `_Ad-hoc Sends (system)`. ### 11.4 Supporting workers | Worker | Cron (UTC) | Role | |---|---|---| | `email-lifecycle-tick` | `0 13 * * *` | `plan='free'` only. Inactive cohort (`inactive_7d`, opt-out pre-filtered, dormancy via no recent activity) + trial-ending cohort (`trial_ending_3d`, credits expiring ≤3d still on free plan). Both `{repeatable:true, cooldownDays:14}`. Uses `Date.parse` not string compare. | | `trial-expire-tick` | `0 12 * * *` | 1h BEFORE lifecycle. Flip expired free-trial users `account_status='trial_expired'` (`.eq('account_status','active')` = idempotent one-shot) then enroll into `trial_expired` win-back. Upsert-only. | | `trial-day2-gift` | `30 14 * * *` | App-specific return-loop (gift a free generation 24–48h post-first-use + announce email). **Optional** — only if your app has a per-output gift to give. | | `lead-nurture-tick` | `*/30 * * * *` | Anonymous `magnet_leads` funnel (recipient = `magnet_leads.email`, no auth user). Claims `(lead_id, step_index)` in `magnet_lead_sends` before send; exits on `user_id`/`converted_at`. Mirrors the drip worker's at-most-once + retry pattern. | All workers use the **service-role admin client** (`NEXT_PUBLIC_SUPABASE_URL` + `SUPABASE_SERVICE_ROLE_KEY`), not the RLS client. Redeploy Trigger.dev after editing any worker. --- ## 12. Schema additions beyond EMAIL-INFRASTRUCTURE EMAIL-INFRASTRUCTURE ships the 4 core tables + `email_layouts` + `profiles.email_opt_out`. This playbook adds: **1. Widen `email_campaigns.trigger_event` CHECK** to the full final list (build it directly — don't replay incremental ALTERs): ```sql check (trigger_event in ( 'trial_signup','paid_signup','inactive_7d','trial_ending_3d','trial_expired','manual', 'subscription_canceled','payment_failed','lead_signup','abandoned_checkout','lead_magnet','welcome_offer' )) ``` **2. Profile-insert enrollment triggers** (`security definer`, `search_path=public`) — fire on `after insert on profiles`, enroll into active campaigns matching the event, idempotent via the active-partial unique index (catch `unique_violation`): ```sql create or replace function public.enroll_user_in_lead_signup_campaigns() returns trigger language plpgsql security definer set search_path = public as $$ declare rec record; v_delay int; begin for rec in select id, steps from public.email_campaigns where trigger_event = 'lead_signup' and status = 'active' loop v_delay := greatest(0, coalesce((rec.steps->0->>'delay_hours')::int, 0)); begin insert into public.email_enrollments (user_id, campaign_id, current_step, next_send_at) values (new.id, rec.id, 0, now() + (v_delay || ' hours')::interval); exception when unique_violation then null; end; end loop; return new; end; $$; create trigger trg_profiles_enroll_lead_signup after insert on public.profiles for each row execute function public.enroll_user_in_lead_signup_campaigns(); ``` Clone the same function for `welcome_offer` (`enroll_user_in_welcome_offer_campaigns` + `trg_profiles_enroll_welcome_offer`). **Why a DB trigger, not app code:** if email confirmation is OFF, email/password signups skip `/auth/callback` — the DB trigger fires on every profile insert regardless of auth path. App-side `enrollUserInCampaignsByEvent` stays as the OAuth/webhook belt-and-suspenders. **3. Lead-magnet tables** (only if building the cold-traffic funnel): ```sql create table public.magnet_leads ( id uuid primary key default gen_random_uuid(), email text not null, name text, magnet_slug text not null, qualifier text, source text, utm_medium text, utm_campaign text, referrer text, landing_path text, visitor_id text, session_id text, nurture_step integer not null default 0 check (nurture_step >= 0), nurture_status text not null default 'active' check (nurture_status in ('active','completed','exited')), next_email_at timestamptz, user_id uuid references auth.users(id) on delete set null, -- lead→paid join converted_at timestamptz, created_at timestamptz not null default now(), updated_at timestamptz not null default now() ); create unique index ux_magnet_leads_email on public.magnet_leads (email); create index ix_magnet_leads_nurture_due on public.magnet_leads (next_email_at) where nurture_status = 'active'; create table public.magnet_lead_sends ( id uuid primary key default gen_random_uuid(), lead_id uuid not null references public.magnet_leads(id) on delete cascade, step_index integer not null, sent_at timestamptz not null default now(), unique (lead_id, step_index) ); ``` Both **service-role-only RLS** (every `email_*` and `magnet_*` table follows the same single policy): ```sql alter table public.<t> enable row level security; create policy "<t> service role" on public.<t> for all using (auth.role() = 'service_role') with check (auth.role() = 'service_role'); ``` **Gotchas:** table is `email_layouts` (plural, singleton `id=1`). `magnet_leads` has no `updated_at` trigger (app sets it). The layout wrapper row + its `<!--@marketing-only-start/end-->` markers were seeded via Management-API `apply_migration` (not checked-in SQL) — **export the live wrapper HTML** from the source app, don't reconstruct it. --- ## 13. Seed campaigns Seed idempotently (`where not exists` on the campaign's `trigger_event`; dollar-quote JSONB steps). Two reference sequences: **Lead-magnet nurture** (`trigger_event='lead_magnet'`, active, no exit_goal) — 6 templates `lead-nurture-1..6`, steps `[24,24,24,24,24,48]` hours. Driven by `lead-nurture-tick` against `magnet_leads`. The **instant delivery** email is code-defined in `src/lib/email/lead-nurture.ts` (`buildDeliveryEmail`) — sent transactionally the moment a lead opts in; only the follow-ups live in the admin-editable campaign row. **Welcome offer** (`trigger_event='welcome_offer'`, active, **`exit_goal='converted_to_paid'`**) — 3 templates `welcome-offer-1..3`, steps `[0,24,21]` hours (immediately → day-1 → "expires tonight" at ~T-3h). Merge tag `{{offer_expires_at}}` supplied by the drip worker's merge context (`offer_started_at + window`, formatted ET). Templates seed with `from_email`/`from_name` matching the app (`hello@yourapp.com` / `"<Founder> at <App>"`) and merge tags `{{first_name}}`, `{{magnet_name}}`, `{{pricing_url}}`, `{{offer_expires_at}}` + the layout's `{{unsubscribe_url}}`. --- ## 14. Invariants to preserve (do not regress) 1. **No DELETEs.** Campaigns archive (`status='archived'`), enrollments transition status, sends are append-only. The only legit DELETE is the soft-fail Postmark retry freeing a dedupe row. 2. **System-campaign lock.** Names starting `_` are PATCH-locked (403). `_Ad-hoc Sends (system)` backs `send-one` + day-2 gift. 3. **Transactional allowlist.** `is_transactional=true` only on `payment_failed` (or your dunning events) — enforced on create AND patch (effective-state). Transactional bypasses opt-out + strips footer + omits List-Unsubscribe in 3 coordinated places (worker opt-out gate, `evaluateCondition('unsubscribed')`, `wrapAndRender({transactional})`). 4. **`{{content}}` required** in both layout wrappers (validated on PATCH). 5. **Insert-send-row-before-send** with `dedupe_key` UNIQUE = at-most-once. 23505 → advance, don't resend. 6. **Optimistic-lock advance** (`.eq('current_step', old)`) against concurrent double-fires. 7. **Fail-soft conditions** — unknown/errored → `false`. 8. **PostgREST int columns:** `Math.floor`/`max(0,...)` on `delay_hours` before any `.eq/.gte/.lte`. 9. **Opt-out parity** — `users/[id]/opt-out`, the public unsubscribe page, and the Postmark SubscriptionChange/Bounce/Spam handlers all perform the same flag-flip + exit-active-enrollments mutation. 10. **`send-one` is the only admin send path.** Everything else writes campaign/enrollment state; the drip worker does the bulk sending. --- ## 15. Build sequence (slices — pause after each for review) 1. **Schema** — widen trigger_event CHECK, add enrollment triggers, (optional) magnet tables, seed campaigns. Apply via Management API, track applied status (SUPABASE-MIGRATION-PLAYBOOK). 2. **API layer** — the 14 routes + `requireAdmin`. Ship `campaigns` + `campaigns/[id]` + `templates*` + `layout` first (the CRUD the editor needs), then `enrollments*` + `users*` + `send-one` + `analytics`. 3. **conditions.ts + enroll.ts extensions** — DSL + the two enroll helpers. 4. **Pages 1-2** (list + editor) — the core management loop. Review the design against the BKE screenshots before continuing. 5. **Pages 3-4** (templates + layout) — content authoring. 6. **Pages 5-6** (enrollments + analytics) — ops + reporting. 7. **Workers** — lifecycle + expire (+ lead-nurture if magnet tables shipped). Redeploy Trigger.dev. Wire the lifecycle cohort queries to your app's real activity signal. 8. **Seed + smoke** — create a draft campaign in the UI, add a step, flip to active, fire a manual enroll to yourself, confirm a send lands + analytics counts it. --- ## 16. Kickoff prompt > Execute the Email Automation Console Playbook at `<workspace>/Templates/a-tier/EMAIL-AUTOMATION-CONSOLE-PLAYBOOK.md` for this app. **Prerequisite:** run the Email Infrastructure Playbook first (`Templates/s-tier/EMAIL-INFRASTRUCTURE-PLAYBOOK.md`) so Postmark, the 4 core tables, the layout singleton, opt-out, unsubscribe, and `email-drip-tick` exist. The admin console shell (`requireAdmin`, `TopNav`, `--brand-*` tokens) from `Templates/s-tier/ADMIN-CONSOLE-PLAYBOOK.md` must also exist. > > Mirror the BKE implementation: `src/app/admin/dashboard/email/*` (6 pages), `src/app/api/admin/email/*` (14 routes), `src/lib/email/conditions.ts` + `enroll.ts`, `src/trigger/{email-lifecycle-tick,trial-expire-tick,lead-nurture-tick}.ts`. When in doubt about a pattern, READ the BKE file rather than re-deriving — the design system (§2), STATUS_COLORS (§4), statusColor (§8), and the route contracts (§10) must be byte-faithful so the console looks and behaves identically. > > Inputs: > - App name + founder display name (for template from-lines): [App / "<Founder> at <App>"] > - Sending domain + from addresses: [hello@, support@] > - Build the cold-traffic lead-magnet funnel? [yes → magnet tables + lead-nurture worker | no → skip §12.3 + lead-nurture] > - Build the day-2 gift worker? [only if the app has a per-output gift to give] > - App's "activation" signal for `has_published` condition: [e.g. first published post / first generation / first project] > - Trigger events to seed campaigns for at launch: [typically lead_signup + welcome_offer + trial_expired] > > Follow the §15 slice order. Pause after the schema slice and again after pages 1-2 for review. Redeploy Trigger.dev after the workers slice. Re-theme by confirming `--brand-accent` + font vars in the new app's globals.css — do not hardcode Kompozy orange. --- ## 17. Reference files in BKE **Pages:** `email/page.tsx` · [email/[id]/page.tsx](file:///<reference-app>/src/app/admin/dashboard/email/%5Bid%5D/page.tsx) · `templates/page.tsx` · `layout/page.tsx` · `enrollments/page.tsx` · `analytics/page.tsx` **API:** `api/admin/email/` (all 14 routes) · `lib/admin-auth.ts` **Engine:** `lib/email/conditions.ts` · `lib/email/enroll.ts` · `lib/email/render-template.ts` · `lib/email/lead-nurture.ts` **Workers:** `email-drip-tick.ts` · `email-lifecycle-tick.ts` · `trial-expire-tick.ts` · `trial-day2-gift.ts` · `lead-nurture-tick.ts` **Migrations:** 00065 (core tables) · 00066 (layout) · 00068/00150 (enrollment triggers) · 00069/00089/00150/00166/00169 (trigger_event widening) · 00070 (transactional flag) · 00164 (magnet_leads) · 00166 (lead nurture seed) · 00167 (magnet_lead_sends) · 00169 (welcome offer seed) — under `supabase/migrations/`. **Sibling playbook:** [s-tier/EMAIL-INFRASTRUCTURE-PLAYBOOK.md](../s-tier/EMAIL-INFRASTRUCTURE-PLAYBOOK.md) (the engine/plumbing half).