PMax Channel Distribution Alert

This free script helps you monitor how Performance Max spend is distributed across Display, Video, Shopping, and Search by comparing recent channel performance with a longer-term average.

It records channel data for each Performance Max campaign, then compares the rolling average, which defaults to 7 days, with the longer reporting period, which defaults to 30 days. When a channel’s cost distribution changes beyond your configured threshold, the script sends an email alert with a campaign-level breakdown.

Set the spreadsheet URL, email recipients, alert threshold, and reporting periods before running the script. It only reports campaigns with eligible Performance Max data.