- Shipped
- November 11, 2026 at 7:17 PM UTC
- Author
- Kamo
- Commit
- b522113
- Lead filter "veteran": mortgage leads whose borrower is (or isn't) marked a veteran. - Email History works: the first open and click are stamped on the recipient row (opened_at / clicked_at), the audience reads them as per-org address sets through **************** and a one-time backfill dates the opens of the last 180 days from their Redis marks' remaining expiry. - Account filter "Has An Open Lead": accounts with an active Fresh/Reckoning lead, read first through the partial ix_leads_account_uid (~2 ms) and named in the WHERE. - Enters A Saved Audience now sees an EXISTING account enter: the drip keeps who was in its account audience (email_drip_audience_accounts) and looks again every 15 min. - Loan change sweeps are index ranges on loan_files (status_updated_at / the greatest(...) expression): ~10 ms on the largest org, was ~280 ms; every minute.