Overspend Underperformer Pause-Recommendation Alert

This workflow catches campaigns that are burning budget without returning pipeline and pushes an actionable recommendation, not just a metric. It identifies UTM campaigns that have both exceeded a configured spend cap and stayed under a target ROAS over a trailing window, then routes each one to its owner with the spend, pipeline, ROAS, and a recommended action.

Use it when budgets leak into campaigns that quietly stopped converting, and you want a recurring forcing function that puts a pause-or-keep decision in front of the right person twice a week.

A twice-weekly schedule triggers the check. The flow queries the warehouse for trailing-window spend and matched pipeline by UTM campaign. A logic step selects only campaigns breaching both the spend cap and the ROAS floor, and looks up each campaign's owner from an ownership map. For each flagged campaign it composes a recommendation message — pause, reallocate, or investigate — with the numbers inline, and delivers it as a direct, owner-targeted Slack alert.