📈
Campaign Reporting
betaConnect to Google Ads and BigQuery to generate daily campaign performance reports.
analyticsTools Used
google-ads-api bigquery oauth2
What This Skill Does
Campaign Reporting connects to your advertising platforms and delivers daily performance summaries.
Capabilities
- Daily Summaries — Morning briefings on yesterday’s performance
- Campaign Comparison — Compare performance across campaigns
- Creative Analysis — Identify top and bottom performing ads
- Budget Tracking — Monitor spend pacing and projections
How It Works
- Connect your Google Ads account (one-time OAuth setup)
- The skill queries campaign data overnight
- Morning briefing is generated with key metrics
- Recommendations are prioritized by potential impact
Example Usage
"How did my campaigns perform yesterday?"
"Which campaigns have the best ROAS?"
"What creatives are underperforming?"
"Compare this week to last week"
Sample Output
Campaign Summary - Dec 18
Top Performers:
- Campaign "Holiday_iOS_US" - ROAS 3.2x
- Creative "Video_30s_v2" - CTR 4.1%
Watch List:
- Campaign "Android_EU" - below target
Budget: 78% spent, 85% through month
Tools Used
google-ads-api— Google Ads API integrationbigquery— Advanced data queries- OAuth2 — Secure authentication