Update weekly approval scores for executive dashboards before review

Your approval metrics sit stale each week, causing visibility gaps and delayed leadership decisions. Keep dashboards accurate with computed approval scores and week-over-week deltas before the weekly review.