Does this evaluate ad quality?

No. It only counts enabled ads. It is a coverage script, not a quality-scoring script.

Why is this useful if I already use RSAs?

Even with RSAs, you may want to see whether ad groups are underpopulated or unevenly maintained across the account.

Can I filter to search campaigns only?

Yes. You can add a campaign channel condition if you want a narrower output.

Will empty ad groups appear?

No. This version reports ad groups that have enabled ads returned by the query.

Back to scripts

Enabled Ad Count By Ad Group

Counts enabled ads per ad group and exports the result into a Google Sheet so thin ad groups are easy to spot.

adsad-groupsaccount-hygiene

Script Code

Use this to find ad groups with too few enabled ads and create a simple creative coverage check.

Preview is public. Unlock full code with name and email.

/**
 * ==========================================================
 * Enabled Ad Count By Ad Group
 * ==========================================================
 * Description: Counts enabled ads per ad group.
 *
 * Copyright (c) 2026 TwoSquares. All Rights Reserved.
 * Developed by Kiril Ivanov
 */
function main() {
  var SPREADSHEET_URL = "";
  var SHEET_NAME = "Ad Count By Ad Group";
  // ... preview shortened
}

About This Script

Enabled Ad Count By Ad Group is a lightweight reporting script for surfacing ad groups that may be under-supported creatively. It gives you a count of enabled ads per ad group in a format that is easy to review in a sheet.

This is useful for basic RSA coverage checks, post-migration QA, and creative maintenance routines. It does not try to score asset quality or performance, only coverage.

Because it is intentionally simple, it works well as an operational checklist tool. Once the output is useful, you can extend it with labels, campaign filters, or low-count warnings.

Implementation Notes

Leave SPREADSHEET_URL blank to auto-create a report sheet, or add your own sheet URL.
Run the script once manually and inspect the ad counts.
Filter low-count rows to identify ad groups needing fresh creative.
Optionally add a threshold column in the sheet if your team has a minimum ad-count rule.
Schedule it monthly or after major ad uploads.

More Scripts In This Library

Previous Script

Duplicate Query Conflict Finder

Next Script

Final URL UTM Consistency Audit

Ad Group CPA Outlier Watchlist

Flags ad groups with unusually high CPA (or spend with no conversions) to prioritize optimization efforts.

Delete Disapproved Ads

Finds ads with non-approved policy status and removes them, with a dry-run mode enabled by default for safer review first.

Disapproved Ad Alert

Monitors enabled ads for policy issues and can email a daily alert with disapproved/limited ads before delivery is impacted.

Disapproved Ad Checker

Exports disapproved ads with campaign and ad group context so you can review policy issues quickly without hunting through the interface.