td-3aa180

AM event data — historical tracking in Redshift

open task P2 Parent: td-0c802d
Created Mar 11, 2026 12:29 PM Updated Mar 12, 2026 10:15 PM
Handoff
Session Log (2 entries)
Mar 11, 12:29 PM
lg-4dee3150 ses_006c72
progress
Started work
Mar 11, 12:29 PM
lg-2d069156 ses_006c72
decision
From product-forum 2026-03-11: No historical AM data in Redshift — only records who is currently an AM. Decided to prioritize adding an AM kind of event (tracks when someone became/left the AM role). This is foundational before AI can properly query AM history. Albert flagged current numbers differ from manually-verified CSVs. See [[meetings/product-forum/2026-03-11]].
Git State
Started 6787414 (master) Current 3fc233e (claude/peaceful-cerf)
Sessions Involved