Skip to content

About

Google Ads Scripts from the Marketing Watch House YouTube videos, updated for 2026 (GAQL). By Roman Petrochenkov.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

2 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 

Repository files navigation

RP Data: Roman Petrochenkov's website    Roman Petrochenkov on LinkedIn

Google Ads Scripts — from the Marketing Watch House videos

Restored and updated scripts from my Marketing Watch House Google Ads Scripts tutorials (2019–2020). Something missing or not working? Open an issue, and I'll fix it.

The original code lived on pastebin and on my old blog, which no longer exists. Here it is again, one folder per video, rewritten for today's Google Ads Scripts: GAQL instead of the retired AWQL reports, current field names and modern JavaScript. The teaching steps are the same as in the video, so you can still follow along.

Scripts

# Video Folder
GAS #1 Create your first report gas-01-first-report
GAS #2 Pause low-CTR ads inside ad groups gas-02-pause-low-ctr-ads
GAS #3 Apply labels at scale gas-03-bulk-apply-labels
GAS #4 Add negative keywords gas-04-add-negative-keywords
GAS #5 Track MCC account budgets in Google Sheets gas-05-mcc-budgets-from-sheets
GAS #6 Reporting for beginners — lesson 1 gas-06-reporting-first-report
GAS #7 Reporting for beginners — lesson 2 gas-07-reporting-to-sheets
GAS #8 Reporting — send the report by email (lesson 3) gas-08a-reporting-email
GAS #8 Reporting — MCC report (lesson 4) gas-08b-reporting-mcc
GAS #9–#11 Read data from Sheets · part 2 · part 3 gas-09-read-data-from-sheets
GAS #12 Create callouts at scale from Sheets gas-12-callouts-from-sheets
GAS #13–#14 Apply callouts · final gas-13-apply-callouts
GAS #15 Simple bidding gas-15-simple-bidding

New to Google Ads Scripts? Start with the 2026 guide: Google Ads Scripts — 2026 Full Guide.

How to run a script

  1. In Google Ads: Tools → Bulk actions → Scripts → + New script.
  2. Paste script.js from the folder and edit the CONFIG block at the top.
  3. Authorize, then Preview. Preview never changes your account; read the logs.
  4. Scripts that change things start with DRY_RUN: true, so they only log what they would do. Set it to false when the preview looks right, then run or schedule the script.

Each folder's README covers the settings, any sheet layout, and what changed since the video.

Writing your own scripts with AI

These scripts were written and checked against my Google Ads Scripts Claude skill: an up-to-date reference that stops AI tools writing outdated syntax such as AWQL filters, metrics.cost or pre-ES6 code. Use them together: this repo for the scripts from the videos, the skill when you want Claude to write or fix a new one.

About me

I'm Roman Petrochenkov. I work in marketing analytics: paid media measurement and automation, attribution, cost and conversion pipelines, Google/Meta API integrations, GTM and server-side tracking. I made these videos to show that the boring parts of Google Ads can be automated.

Need help with automation, data or tracking, or want 1:1 mentoring? Get in touch.

Licence

MIT © Roman Petrochenkov. Use these scripts at your own risk: always preview first, and test on a small scope before you run anything against a live account.

About

Google Ads Scripts from the Marketing Watch House YouTube videos, updated for 2026 (GAQL). By Roman Petrochenkov.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages