A Free Script That Monitors Your Google Ads and Emails You a Weekly Brief

One of the biggest time drains in managing Google Ads is the weekly check-in. Pull the data, scan for problems, compare to last week, check if budgets are pacing right, look for disapproved ads, flag wasteful search terms. It is the same routine every week, and it is easy to miss something.

So I built a script to do it for me. I wrote it with Claude, and I want to share it here because it is useful and I think more Google Ads business owners should have something like this running.

What the Script Does

It is a Google Ads Script (runs directly inside your Google Ads account) that pulls the last 7 days of data and emails you a full health brief every week. Here is what it covers:

• Account snapshot with week-over-week comparison. Spend, conversions, conversion value, ROAS (Value/Cost), CPA, CVR, CTR, and CPC all compared to the prior 7-day period so you can spot trends fast.

• Budget pacing. It checks every active campaign against its 7-day budget and flags anything that is overpacing, underpacing, or limited by budget.

• Ad disapprovals. Any enabled ad that is not serving due to a policy issue gets flagged immediately. This one alone has saved me more than once.

• Device performance outliers. If mobile or desktop is converting significantly better or worse than your account average, you will know.

• Ad group outliers. Ad groups spending above a set threshold that have low CVR, high CPA, or zero conversions get surfaced.

• Wasteful search terms. Any search term that has spent over a configurable threshold with zero conversions gets listed so you can consider adding it as a negative.

• Network settings audit. A quick view of which campaigns are opted into Search Partners or Display Network, in case something was accidentally opted in.

• Geographic spend. Flags any spend outside your target countries. Helpful if you have a tight geographic focus.

Everything lands in a clean HTML email with color-coded flags so you can scan it in under two minutes.

How to Set It Up

1. In your Google Ads account, go to Tools > Bulk Actions > Scripts

2. Click the + button to create a new script

3. Paste in the full script (link below)

4. Update the CONFIG section at the top with your email address(es), spend thresholds, and target countries

5. Authorize the script and run it once manually to test

6. Set it to run on a weekly schedule

   
   

The only part you need to touch is the CONFIG block at the very top. Here is what it looks like:

const CONFIG = {
  LOOKBACK_DAYS            : 7,
  EMAIL_RECIPIENTS         : [
    'you@yourdomain.com',       // ← add your email here
  ],
  SEARCH_TERM_SPEND_THRESHOLD  : 100,   // flag terms with $100+ spend and 0 conversions
  MIN_SPEND_OUTLIER            : 150,   // minimum spend before flagging an ad group
  OUTLIER_THRESHOLD            : 0.30,  // flag if CVR/CPA is 30%+ off account average
  MIN_IMPRESSIONS_OUTLIER      : 50,
  UNDERPACING_THRESHOLD        : 0.70,  // flag campaigns using less than 70% of budget
  OVERPACING_THRESHOLD         : 0.95,  // flag campaigns at 95%+ of budget
  TARGET_COUNTRIES             : [
    'United States',            // ← update to your target markets
  ],
  GEO_SPEND_THRESHOLD          : 1,
  WOW_DROP_THRESHOLD           : 0.20,  // alert if Conv. Value or ROAS drops 20% WoW
};

Everything else runs on its own. You do not need to touch anything below the CONFIG block.

Get the full script on GitHub Gist →

Here is a preview of what the email looks like:

Final Thoughts

If you run Google Ads for clients or your own business and you are doing this check manually every week, this will save you time. Set it once, let it run on a schedule, and get a clean brief in your inbox every Monday morning instead of spending an hour pulling data.

And if you need help setting this up, interpreting what the brief is telling you, or just want a second set of eyes on your account, that is exactly what I do. Get in touch and we can go from there.