cotera

Google Ads Multi-Account Audit

Manage multiple Google Ads accounts? Audit them all at once. See which accounts are performing and which ones are wasting budget.

Multi-accountPerformance auditCross-account reportingAgency operations

The Challenge

If you manage Google Ads for multiple clients or business units, auditing each account is a full-day project. You log into each account separately, export reports, paste them into a master spreadsheet, and try to compare apples to apples. With 10+ accounts, this easily takes an entire day every month.

What This Prompt Does

Discover Accounts

Lists all accounts under your manager (MCC) hierarchy

Pull Metrics

Gets campaign data for each account with 30-day metrics

Compare Accounts

Ranks accounts by CPA, conversion rate, and spend efficiency

Log to Sheets

Records the audit in a spreadsheet for month-over-month tracking

The Prompt

The Prompt

Task

Use @Google Ads/List Accessible CustomersName it "Google Ads/List Accessible Customers" and call it with @Google Ads/List Accessible Customers to discover all accounts under the manager account. Then for each account, use @Google Ads/List CampaignsName it "Google Ads/List Campaigns" and call it with @Google Ads/List Campaigns to pull performance data for the last 30 days. Compare accounts side-by-side and log the audit results to @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row.

Input

The user provides the manager (MCC) customer ID. Optionally, they can specify which accounts to audit or a date range.

Example: "Audit all accounts under MCC 999-888-7777 for the last 30 days"

Context

What to Audit

Account-level health:

  • Total spend and conversion volume per account
  • Average CPA across accounts (identify which accounts are most/least efficient)
  • Accounts with spend but zero conversions

Campaign mix:

  • How many active vs. paused campaigns per account
  • Channel breakdown (Search, Display, Video, Shopping)
  • Budget allocation per account

Efficiency comparison:

  • Rank accounts by CPA (best to worst)
  • Rank accounts by conversion rate
  • Flag accounts significantly underperforming the group average

Audit Strategy

  1. List all accessible customer accounts
  2. For each account, pull campaign data with LAST_30_DAYS metrics
  3. Aggregate totals per account (spend, conversions, impressions)
  4. Calculate CPA and conversion rate per account
  5. Rank and compare accounts
  6. Log results to Google Sheets for tracking over time

Output

Multi-Account Summary:

  • Number of accounts audited
  • Total aggregate spend and conversions
  • Best and worst performing accounts

Account-by-Account Breakdown:

  • Account name/ID, total spend, conversions, CPA, CTR
  • Number of active campaigns
  • Channel mix (% Search, Display, Video)

Flags and Recommendations:

  • Accounts with unusually high CPA
  • Accounts spending without converting
  • Budget reallocation suggestions across accounts

Sheet Log: One row per account with key metrics appended to tracking sheet

Example Usage

Try asking:

  • →"Audit all Google Ads accounts under my MCC and rank them by CPA"
  • →"Which of my client accounts has the worst conversion rate this month?"
  • →"Compare spend efficiency across all accounts and log the results to my tracking sheet"