Forecast versus actual at month end
Check known_gaps first, then compare the open Deals snapshot from 1 September with the deals that reached closed won since.
With daily snapshots appended by extraction timestamp, a finance analyst sees how much month-start pipeline closed, and ChatGPT says up front if any snapshots are missing.