From google-ads
Analyze prior-year data for seasonal periods to set realistic targets and inform investment decisions.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Pull and analyze prior-year performance data for seasonal periods to establish data-driven targets and budget recommendations. Historical benchmarking transforms seasonal planning from guesswork into informed strategy, preventing over- or under-investment during critical periods.
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.
Pull and analyze prior-year performance data for seasonal periods to establish data-driven targets and budget recommendations. Historical benchmarking transforms seasonal planning from guesswork into informed strategy, preventing over- or under-investment during critical periods.
Data Source: Custom GAQL Required
Standard 30-day export cannot provide prior-year comparisons. Need multi-year historical data for accurate benchmarking.
GAQL Query (Prior Year Seasonal Period):
SELECT
campaign.name,
campaign.advertising_channel_type,
segments.date,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value,
metrics.average_cpc
FROM campaign
WHERE campaign.status IN ('ENABLED', 'PAUSED')
AND segments.date BETWEEN '[PRIOR_YEAR_START]' AND '[PRIOR_YEAR_END]'
Run via /google-ads:get-custom for each seasonal period needing analysis (e.g., Black Friday 2025 to plan for 2026).
| Condition | Severity |
|---|---|
| Major event planned without historical benchmark data | Critical |
| YoY efficiency decline >20% without acknowledged market shift | Warning |
| Budget target significantly higher than historical spend capacity | Warning |
| No multi-year comparison (single year data only) | Warning |
| Historical data unavailable (new account/campaign) | Info |
Short format (default):
## Historical Benchmarking Report
**Account:** [Name] | **Periods analyzed:** [X] | **Planning gaps:** [Y]
### Key Findings
- **[Event]**: [Year] ROAS [X]% vs [Prior Year] [Y]% ([Z]% change)
- **[Event]**: Budget utilization [X]%, lost [Y]% IS to budget
### Projections for [Upcoming Event]
| Metric | Prior Year | Projection | Change |
|--------|------------|------------|--------|
| Budget | $X | $Y | +Z% |
| Conv | X | Y | +Z% |
| ROAS | X% | Y% | Z% |
### Recommendations
1. [Budget recommendation with rationale based on historical trends]
Detailed adds: