google-ads-scripts

Files (2)

• SKILL.md
• scripts-catalog.md · references/

SKILL.md (first lines)

## Process

1. **Identify the repetitive task** — What are you doing manually that a script could handle?
2. **Match to script category** — Use the decision tree below
3. **Select specific script** — Read `references/scripts-catalog.md` for detailed options
4. **Understand prerequisites** — API access, spreadsheet setup, email notifications
5. **Install and configure** — Follow the standard installation process
6. **Test in preview mode** — Always preview before authorizing
7. **Schedule and monitor** — Set appropriate frequency, check logs regularly

Read `references/scripts-catalog.md` for the complete catalog of 50+ top scripts with sources, use cases, and implementation notes.

## Script Category Decision Tree

**What problem are you solving?**

| Problem | Category | Example Scripts |
|---------|---------|----------------|
| Finding wasted spend on bad search terms | N-gram / Search term mining | Brainlabs Search Query Mining, PEMAVOR Search Term Miner |
| Bid changes based on rules | Bid management | Day-of-week bid modifiers, weather-based bidders |
| Budget overspend/underspend | Budget pacing | Optmyzr-style pacing scripts, redistribution scripts |
| Catching broken URLs or disapprovals | Monitoring / Anomaly detection | Link checker, Vallaeys anomaly detector |
| Automated reporting | Reporting | Monthly deck generators, heat map scripts |
| Profit-based product bidding | Ecommerce | Jack Felsted's revenue maximizer |
| Finding best-performing ad copy language | Ad copy analysis | Vallaeys RSA n-gram analyzer |
| Tracking competitor movement | Competitive monitoring | Auction insights trend scripts |

## Top Categories & Use Cases

### 1. Search Term / N-Gram Analysis

**Purpose:** Mine search query reports to find negative keyword candidates and promotion opportunities at scale.

**Top pick:** Brainlabs Search Query Mining Script (updated for GAQL by Nils Rooijmans, March 2025)

**What it does:**
- Breaks queries into 1-grams, 2-grams, 3-grams
- Aggregates performance by n-gram
- Highlights high-spend / zero-conversion patterns
- `checkNegatives` parameter: verifies new negatives don't block existing keywords

**When to run:** Weekly for new campaigns, bi-weekly for stable ones.

**Output:** Google Sheet with n-gram breakdown, sorted by spend and CPA.

### 2. Bid Management

**Purpose:** Adjust bids automatically based on performance patterns or external signals.

**Common scripts:**
- Day-of-week bid modifiers — Apply bid adjustments based on historical day-of-week conversion rates
- Hour-of-day bid modifiers — Same for hour of day
- Weather-based bid adjusters — Modify bids based on local weather (umbrella sales → increase on rainy days)
- Impression share targeting scripts — Dynamically adjust bids to hit target impression share

**Warning:** These scripts predate Smart Bidding. For accounts running tCPA/tROAS, most bid scripts are unnecessary — Smart Bidding handles these optimizations automatically. Use bid scripts mainly for:
- Accounts with <30 conversions/month (pre-Smart Bidding)
- Specific signals Smart Bidding doesn't know (weather, inventory, external factors)

### 3. Budget Pacing & Redistribution

**Purpose:** Prevent overspend/underspend. Automatically shift budget between campaigns.

**Common scripts:**
- Budget pacing monitors — Alert when a campaign will overspend or underspend by month-end
- Budget redistribution — Shift unused budget from underperformers to high-performers
- Seasonal budget automation — Adjust budgets based on expected seasonal demand

**ECPC deprecation note (March 2025):** Some older budget scripts reference ECPC. If you encounter one, update or replace — ECPC is gone.

### 4. Performance Monitoring & Anomaly Detection

**Purpose:** Catch problems before they waste money.

**Top scripts:**
- **Anomaly detection** (Frederick Vallaeys) — Alerts on sudden metric changes (CTR, CPC, conversion rate deviations from baseline)
- **Zero-impression keyword pause** — Pause keywords with zero impressions over X days
- **Quality Score tracking** — Historical QS tracking (Google doesn't store QS history natively)
- **Broken landing page URL monitor** — Tests all landing page URLs, alerts on 404s or slow loads
- **Emergency stop button** — Pauses account if website is down (integrates with uptime monitors)

**When to run:** Daily for anomaly detection, weekly for URL checks and QS tracking.

### 5. Reporting Automation

**Purpose:** Generate client-ready reports without manual grind.

**Common scripts:**
- Monthly presentation deck generator (Optmyzr-style)
- Client performance heat maps (Kratu)
- Hourly performance trend heat maps (Daniel Gilbert)
- Change history reports
- Custom metric dashboards

### 6. Ecommerce-Specific

**Purpose:** Profit-based optimization beyond ROAS.

**Top pick:** Jack Felsted's Revenue Maximizer Tiering

**What it does:**
- Tiers products by gross profit margin using custom labels
- Applies different tROAS targets per tier
- High-margin products get lower tROAS target (more volume), low-margin get higher (tighter efficiency)
- 7/14/28/90-day ROI lookback for dynamic tier updates

**Requires:** Merchant Center feed with custom labels (use the **google-merchant-center** skill to set these up).

### 7. Ad Copy Analysis

**Purpose:** Find winning language patterns in ads.

**Top pick:** Frederick Vallaeys' RSA n-gram analyzer

**What it does:** Analyzes which words/phrases in your ad copy correlate with higher CTR and conversion rates. Applies n-gram analysis methodology to ad copy instead of search terms.

### 8. Competitive Monitoring

**Purpose:** Track competitor movement in auctions.

From narayan-metaflow/metaflow-marketing-skills, MIT.

More from narayan-metaflow/metaflow-marketing-skills