From google-ads
Analyze performance by hour of day and day of week to optimize ad scheduling and bid adjustments.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Performance varies by time of day and day of week. This skill analyzes hourly and daily performance patterns, identifies high and low converting periods, and recommends schedule adjustments or bid modifications. Note: For Smart Bidding, only complete schedule exclusions are honored.
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.
Performance varies by time of day and day of week. This skill analyzes hourly and daily performance patterns, identifies high and low converting periods, and recommends schedule adjustments or bid modifications. Note: For Smart Bidding, only complete schedule exclusions are honored.
Data Source: Custom GAQL Required
The standard export does not include time-segmented performance metrics.
Standard Data:
data/account/campaigns/*/campaign.md - Current ad schedule settingsGAQL Queries:
Hourly Performance:
SELECT
campaign.name,
campaign.id,
segments.hour,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
AND metrics.impressions > 0
Day of Week Performance:
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 DURING LAST_30_DAYS
AND metrics.impressions > 0
Run via /google-ads:get-custom with query names hourly_performance and daily_performance.
Fetch time-segmented performance data: Run hourly and day-of-week queries, load current ad schedule settings.
Calculate performance metrics: CVR, CPA, ROAS per time segment. Efficiency Ratio = Conversion Share / Cost Share.
Identify optimization opportunities: High-value (Efficiency Ratio >1.2), Low-value (<0.8), Exclusion candidates (zero conversions with spend).
Generate schedule recommendations: Bid increases/decreases for Manual CPC, potential exclusions for all strategies.
| Condition | Severity |
|---|---|
| Time period with zero conversions + >$100 spend | Critical |
| Efficiency Ratio <0.50 | High |
| Efficiency Ratio >1.50 | High (increase opportunity) |
| Efficiency Ratio 0.50-0.75 | Warning |
| Efficiency Ratio 1.25-1.50 | Warning (increase opportunity) |
| Efficiency Ratio 0.90-1.10 | Info |
Short (default):
## Ad Schedule Audit
**Account:** [Name] | **Campaigns Analyzed:** [X]
### High-Performing Periods
- **[Time Period]**: Efficiency [X], CPA $[Y] → Increase bid +[Z]%
### Low-Performing Periods
- **[Time Period]**: Efficiency [X], CPA $[Y] → Decrease bid -[Z]%
### Recommendations
1. [Priority schedule adjustment]
2. [Secondary adjustment]
Note: Schedule bid adjustments are ignored on Smart Bidding campaigns (only exclusions work).
Detailed adds: