📗 This content is the Demand Gen Ads Optimizer user manual, the same one the script writes in the «Manual» tab of its spreadsheet. Here you can search it, listen to it, highlight it and save it to favourites.
What it is. An information-only alert. When an ad has a negative trend over the last 30 days that meets or beats the A22 threshold, it goes into the email.
It does not recommend pausing. The trend alert is purely informational. It does not recommend pausing. It goes into the daily email when A20 = Yes. The pause rules work independently.
A20 — Enable. "Yes" turns the trend alerts on in the email. "No" turns them off (the trend is still calculated and shown in Summary).
A22 — Threshold. Negative trend percentage that fires the alert. E.g. 20 = if the trend is -20% or worse, it goes into the email.
Example. With A22 = 20, an ad with a -25% trend goes into the alerts section of the email. One at -15% does not.
Settings — quick reference
A2 — Account name. For information only. It shows up in the emails.
A4 — MCC account ID. Numeric ID of the account inside the MCC. Leave it empty if the script runs directly in the account.
A7 — Use CV. "Yes" turns on the weekly Coefficient of Variation analysis for maturity. "No" uses impressions only.
A9 — Weeks to analyse. Number of weeks analysed for the CV (Y). Recommended: 5.
A11 — Stable weeks. Weeks with a stable CV needed for full maturity (X). Recommended: 3.
A15 — Email. Address for the pause and trend alerts.
A20 — Trend alert. "Yes" turns on the negative trend alerts in the email. "No" turns them off.
A22 — Trend %. Negative trend threshold to send the alert (e.g. 20 = alert when the trend is <= -20%).
B4 — Campaign scope. ON = every active DG campaign. OFF = only the ones listed in column D with status ON in E.
B8 — Scoring weights. Format CTR/Conv/CPC/CPA. The 4 must add up to 100.
B10 — Dual score. Format All time/30d (e.g. 60/40). How much the historical data weighs against the last 30 days in the final score. It lets you catch recent declines.
B12 — Minimum impressions. Format score/maturity (e.g. 10000/100000). First figure: minimum to enter the ranking. Second: minimum for maturity.
B14 — Gap %. Score gap threshold for both pause rules.
B19 — Conversion type. "Campaign level": uses the conversions set at campaign level (the default). "By name": only counts the conversion action named in B21.
B21 — Conversion name. Exact name of the conversion action to use (case-insensitive). Only applies when B19 = "By name". If it is empty, Campaign level is used.
Col D — Campaign ID. Only active when B4 = OFF. Numeric IDs of the campaigns to analyse.
Col E — Campaign status. Only active when B4 = OFF. ON = analyse, OFF = ignore.