From google-ads
Conduct placement reports to identify high-impression, low-conversion placements for optimization or exclusion.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Conduct placement reports to identify high-impression, low-conversion placements for optimization or exclusion. Monthly placement reviews can recover 10-30% of Display/Video spend.
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.
Conduct placement reports to identify high-impression, low-conversion placements for optimization or exclusion. Monthly placement reviews can recover 10-30% of Display/Video spend.
Data Source: Custom GAQL Required
GAQL Query - Display Placements:
SELECT
detail_placement_view.display_name,
detail_placement_view.placement,
detail_placement_view.placement_type,
detail_placement_view.target_url,
campaign.name,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value
FROM detail_placement_view
WHERE segments.date DURING LAST_30_DAYS
AND metrics.impressions > 0
GAQL Query - YouTube Placements:
SELECT
detail_placement_view.display_name,
detail_placement_view.placement,
campaign.name,
campaign.advertising_channel_type,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions
FROM detail_placement_view
WHERE segments.date DURING LAST_30_DAYS
AND campaign.advertising_channel_type = 'VIDEO'
Note: CTR and view rate not directly available on detail_placement_view — calculate client-side from clicks/impressions.
Run via /google-ads:get-custom with query name placement_review.
| Condition | Severity |
|---|---|
| Placement with >$100 spend and 0 conversions | Critical |
| CTR >5% (potential click fraud) | Warning |
| Video view rate <10% | Warning |
| >20% spend on non-converting placements | Warning |
Short (default):
## Placement Performance Review
**Account:** [name] | **Period:** Last 30 days | **Placements Analyzed:** [count]
### Summary
- **Total Display/Video Spend:** $[amount]
- **Non-Converting Placement Spend:** $[amount] ([%])
### Critical - Exclude Immediately
| Placement | Type | Cost | Conv | Reason |
|-----------|------|------|------|--------|
| [name] | [type] | $[amount] | 0 | Zero conversions |
### Warnings
- **[count] placements with suspicious CTR** - Potential click fraud
- **[count] YouTube placements with <10% view rate** - Poor engagement
### Recommendations
1. Exclude [count] zero-conversion placements - Save $[amount]/month
2. Investigate [count] high-CTR placements for fraud
3. Set up monthly placement review
Detailed adds: