📈

Campaign Reporting

beta

Connect to Google Ads and BigQuery to generate daily campaign performance reports.

analytics

Tools 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

  1. Connect your Google Ads account (one-time OAuth setup)
  2. The skill queries campaign data overnight
  3. Morning briefing is generated with key metrics
  4. 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 integration
  • bigquery — Advanced data queries
  • OAuth2 — Secure authentication