New — reach out now
+ New ListAdded in the last 10 days, never reached, nothing attempted in 12 hours.
What puts someone on this list
p.stage = 'new' AND p.created_at > UTC_TIMESTAMP() - INTERVAL 10 DAY AND p.last_contacted_at IS NULL AND ((SELECT MAX(occurred_at) FROM touches tt WHERE tt.person_id = p.id) IS NULL OR (SELECT MAX(occurred_at) FROM touches tt WHERE tt.person_id = p.id) < UTC_TIMESTAMP() - INTERVAL 12 HOUR)Nobody is added or removed by hand. The list re-runs on every page load, so logging a conversation drops that person off it immediately.
Clear.
Nobody is on this list right now.