Daily brief
Choose reference day T — the daily row where you store the flash, raw AI, and prompt. Metrics in the pack come from T−1; posts/events cover T−2 through T−1. Rebuild anytime for the same T if data changes.
Row tuo_mbs_daily.record_date = T. Needs metric source row for T−1 before build.
Build a pack to show the derived window, or open a saved row.
Kicker
Optional extra instruction appended to the pack. Change kicker → click Build & save prompt again — a new pack is generated and saved the same way.
Copy prompt for AI — clipboard only; does not save. Load saved fields — discard unsaved edits and pull kicker / prompt / raw / flash from tuo_mbs_daily for this date.
AI output → daily record
The pack asks the model for two parts: a full analyst brief and a short Executive flash. Paste the entire reply in Full model output (archive). Copy only the flash into Executive flash — that is what the home dashboard shows (ai_morning_brief).
Maps to daily_extract_raw_ai_markdown — full length is OK.
Short scannable brief only (~250 words). Maps to ai_morning_brief.