# 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.

Source: https://cotera.co/solutions/ops/google-ads-multi-account-audit

---

- **Team:** Operations
- **Tools:** Google Ads, Google Sheets
- **Difficulty:** advanced
- **Setup time:** 15 min
- **Time saved:** 4-6 hrs/audit

## How it works
1. **Discover Accounts** — Lists all accounts under your manager (MCC) hierarchy
2. **Pull Metrics** — Gets campaign data for each account with 30-day metrics
3. **Compare Accounts** — Ranks accounts by CPA, conversion rate, and spend efficiency
4. **Log to Sheets** — Records the audit in a spreadsheet for month-over-month tracking

## Example requests
- 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

## Prompt

```markdown
## Task

Use @Google Ads/List Accessible Customers to discover all accounts under the manager account. Then for each account, use @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 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
```

## Related reading
- [We Manage 11 Google Ads Accounts. Here Is How We Stay Sane](https://cotera.co/articles/automated-google-ads-reporting-guide.md)