← ClaudeAtlas

google-ads-auditlisted

Weekly Google Ads campaign health check. Pull data via API, analyze performance, generate actionable optimization recommendations with copy-paste fixes.
puretechnyc/purebrain-skills · ★ 0 · AI & Automation · score 78
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