get_campaign_performance_metrics
Retrieve daily campaign spend, impressions, clicks, and platform-reported conversions across Meta, Google Ads, TikTok, and Reddit. Filter results by date range, platform, or campaign ID.
Instructions
Query daily campaign spend, impressions, clicks, and platform-reported conversions across all active channels (Meta, Google Ads, TikTok, Reddit) from the unified v_unified_daily_spend BigQuery view. Returns one row per (date × campaign) combination. Filter by date range, platform, or campaign_id to narrow the result set. Results are capped at 150 rows — apply tighter filters if you receive a truncation notice. Requires PAID_MEDIA_GCP_PROJECT and PAID_MEDIA_BQ_DATASET environment variables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_date | No | ||
| platform | No | ||
| start_date | No | ||
| campaign_id | No |