google-ads-auditlisted
Install: claude install-skill puretechnyc/purebrain-skills
# Google Ads Audit & Optimization
## When to Use
- Weekly campaign health checks
- When reviewing a client's Google Ads performance
- After applying optimizations (verification pass)
- When onboarding a new Google Ads client
## Tools Required
- Google Ads API access (via `google-ads` Python client)
- Your Google Ads customer ID(s)
---
## PHASE 1: DATA PULL (What to collect)
### CRITICAL RULE: Cross-reference ALL levels
Settings exist at account, campaign, ad group, AND criterion levels. NEVER report something as "missing" without checking all levels. Present findings as "API shows X at [level] -- verify in UI" when uncertain.
### 1.1 Campaign Settings (ALL campaigns)
```sql
SELECT campaign.name, campaign.status, campaign.advertising_channel_type,
campaign.bidding_strategy_type,
campaign.maximize_conversions.target_cpa_micros,
campaign.maximize_conversion_value.target_roas,
campaign.geo_target_type_setting.positive_geo_target_type
FROM campaign ORDER BY campaign.status, campaign.name
```
### 1.2 Campaign Performance (30 days)
```sql
SELECT campaign.name, campaign.status,
metrics.impressions, metrics.clicks, metrics.cost_micros,
metrics.conversions, metrics.conversions_value
FROM campaign
WHERE campaign.status = 'ENABLED'
AND segments.date DURING LAST_30_DAYS
ORDER BY metrics.cost_micros DESC
```
### 1.3 Keywords with Quality Scores
```sql
SELECT campaign.name, ad_group.name,
ad_group_criterion.keyword.text,
ad_group_criterion.k