Update sponsorship records and alert campaign managers before deadlines

Your artwork submissions arrive without status updates, causing production delays and missed placement windows. Keep sponsorship records current and notify campaign managers before the next publishing run.