📗 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.
Cols 1-5. Identifiers: Campaign, Ad Group, Ad ID, Ad Name, Assessment.
Col D — Asset. 🎬 = video ad · 🖼️ = image ad (multi-asset, carousel or product).
Cols 7-14. Whole-period metrics: Impr, Clicks, CTR, CPC, Cost, Conv, Cost/Conv, Conv rate.
Cols 15-19. Score, Rank, Gap vs Best, Maturity, Trend last 30d.
Summary colours
Light green. Best of the group (mature).
White. OK: mature, evaluated, not a pause candidate.
Light red. Pause candidate under Rule 1 (mature ad).
Orange. Pause candidate under Rule 2 (early discard).
Grey. Accumulating: not enough impressions yet.
Frequently asked questions
I want to turn off the trend alerts. Set A20 = "No".
I want to change the trend threshold. Change the number in A22 (e.g. 30 to alert only on trends of -30% or worse).
I want to turn off the early discard. Raise B14 to a very high value (e.g. 999), or raise the first figure of B12 to an impression count you will never reach.
I only want to analyse some campaigns. Set B4 = OFF and list the IDs in column D.
I want to turn off the fatigue module. Set A35 = "No". The Creative Fatigue and AssetHistory sheets stay but stop updating.