From google-ads
Analyze day-of-week performance to recommend daily budget allocation and monthly pacing strategies.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Analyze day-of-week performance patterns to optimize daily budget allocation and ensure proper monthly budget pacing. This helps capture more conversions on high-efficiency days while avoiding under/overspend.
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.
Analyze day-of-week performance patterns to optimize daily budget allocation and ensure proper monthly budget pacing. This helps capture more conversions on high-efficiency days while avoiding under/overspend.
Data Source: Custom GAQL Required
The standard export does not include day-of-week segmented data.
GAQL Query:
SELECT
campaign.name,
campaign.id,
segments.day_of_week,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value
FROM campaign
WHERE segments.date BETWEEN '{start_date}' AND '{end_date}'
AND campaign.status = 'ENABLED'
ORDER BY campaign.name, segments.day_of_week
Run via /google-ads:get-custom with query name day_of_week_performance.
| Condition | Severity |
|---|---|
| Day CPA > 50% above average | Critical |
| Monthly underpacing > 20% | Warning |
| Monthly overpacing > 10% | Warning |
| Day efficiency variance > 30% | Info |
Short format (default):
## Budget Pacing Audit
**Account:** [Name] | **Monthly Budget:** $[X] | **Pacing:** [On Track/Under/Over]
### Day-of-Week Efficiency
| Day | CPA | Efficiency | Recommended Multiplier |
|-----|-----|------------|----------------------|
| Monday | $[X] | +20% | 1.2x |
| Saturday | $[X] | -30% | 0.7x |
### Pacing Status
- Days remaining: [X]
- Budget remaining: $[X]
- Required daily: $[X] (current avg: $[Y])
### Recommendations
1. Increase [Day] budget by [X]% (best efficiency)
2. Reduce [Day] budget by [X]% (lowest efficiency)
Detailed adds: