From google-ads
Identify and recommend exclusion of geographic areas with high cost but low or zero conversions to eliminate wasted spend.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Geographic areas with high cost but low or zero conversions waste budget that could be spent on proven performing areas. This skill identifies exclusion candidates, quantifies waste, and provides prioritized exclusion recommendations.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Builds scalable data pipelines, modern data warehouses, and real-time streaming architectures using Spark, dbt, Airflow, Kafka, and cloud platforms like Snowflake, BigQuery.
Builds production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. For data pipelines, workflow orchestration, and batch job scheduling.
Geographic areas with high cost but low or zero conversions waste budget that could be spent on proven performing areas. This skill identifies exclusion candidates, quantifies waste, and provides prioritized exclusion recommendations.
Data Source: Custom GAQL Required
The standard export does not include location-segmented performance metrics.
Standard Data:
data/account/campaigns/*/bid_adjustments.md - Current location exclusionsGAQL Query:
SELECT
campaign.name,
campaign.id,
geographic_view.country_criterion_id,
geographic_view.location_type,
segments.geo_target_region,
segments.geo_target_city,
segments.geo_target_metro,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value
FROM geographic_view
WHERE segments.date DURING LAST_30_DAYS
AND metrics.cost_micros > 0
Run via /google-ads:get-custom with query name location_exclusion_analysis.
Fetch geographic performance data: Use custom GAQL, load current exclusions from bid_adjustments.md files.
Identify exclusion candidates: Zero conversions with Cost >$50, CPA >3x account average, CVR <0.5x account average with 100+ clicks, locations outside service area.
Calculate waste and impact: Total waste (30 days), projected annual savings, % of budget wasted.
Prioritize exclusions: High priority (zero conversions + significant spend), Medium (very high CPA >3x), Low (borderline cases).
| Condition | Severity |
|---|---|
| Zero conversions with cost >$100 | Critical |
| CPA >3x account average | High |
| Zero conversions with cost $50-100 | High |
| CVR <0.5x average with 100+ clicks | Warning |
| Locations outside service area (any spend) | High |
Short (default):
## Location Exclusion Audit
**Account:** [Name] | **Locations Analyzed:** [X] | **Exclusion Candidates:** [Y]
**Current Waste:** $[X]/month | **Projected Annual Savings:** $[Y]
### High Priority Exclusions ([Count])
- **[Campaign] / [Location]**: $[X] cost, 0 conversions → Exclude
### Medium Priority ([Count])
- **[Campaign] / [Location]**: CPA $[X] ([Y]x average) → Exclude
### Recommendations
1. Exclude [X] locations to save $[Y]/month
2. [Secondary action]
Detailed adds: