Google Ads Multi-Account Audit

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