Manages ad customizer attributes based on a Google Sheets promotion schedule. Automatically creates customizer attributes and assigns promo text to Search campaigns based on labels, brand name matching, and date ranges.
by Dmytro Tonkikh, chiliad·gist.github.com/tonkikh/49425aba1a223fdc24159150d9ad1832
Proofreads every enabled RSA for outdated years, double spaces, repeated punctuation, placeholder text, policy-risky ALL-CAPS words and stray spaces — the embarrassing details reviews always miss.
Ad Strength distribution across all enabled RSAs plus a worklist of POOR and AVERAGE ads ranked by impressions — so rewriting effort goes where the traffic actually is.
Write RSAs in a Google Sheet — one row per ad, 15 headline and 4 description columns — and the script validates character limits and creates them in bulk. Copywriters work in the sheet; nobody pastes ads into the UI one by one.
Finds the silently broken ad insertions: countdowns pointing at past dates, keyword-insertion defaults that are empty or too long, and malformed braces that serve literally as ad text.
Finds RSAs with identical headline sets reused across multiple ad groups — the copy-paste ads that show the same generic message everywhere regardless of each ad group's keywords.
Finds promotion assets whose redemption window has passed but that are still attached to campaigns, plus promotions expiring within the week — so ad real estate never quietly goes dark.
Define promotions in a Google Sheet with start/end dates, target labels, and brand filters — the script creates customizer attributes automatically and assigns the promo text to matching Search campaigns (used in ads as {CUSTOMIZER.<name>}). It reconciles each run: customizers on campaigns that no longer match (or whose text changed) are removed. MCC accounts are handled automatically by the loader. Runs in preview by default.
| Variable | Default |
|---|---|
SPREADSHEET_URL | "" |
DRY_RUN | true |
=== Promotion Ad Customizer === Assignments: 36 | removals: 4 | new attributes: 1 [DRY RUN] 41 operation(s) planned. Set DRY_RUN = false to apply.
The "promo" tab needs columns: customizer, text, enabled, start date, end date, label, brand. Brand matching is a case-insensitive regex — separate multiple brands with "|"; labels are also "|"-separated for multi-label targeting. Branded promotions take priority over Global (no label/brand) ones for the same campaign. Only ENABLED Search campaigns are targeted. Missing customizer attributes are created automatically.