Detect approved content items that have been sitting unpublished for over 24 hours and emit escalation alerts. Use when checking whether the content pipeline has stalled — specifically when approved articles, content runs, or deliverables are not moving to shipped/distributed status within the expected window.
