get_monthly_budget_pacing
Retrieve current month pacing status for active campaigns, including MTD spend vs budget, pacing velocity, and recommended daily rate to hit monthly cap.
Instructions
Retrieve current calendar-month pacing status for all active campaigns from the v_reporting_monthly_pacing BigQuery view. Key fields:
• mtd_spend_usd — spend so far this month
• monthly_cap_usd — normalized monthly budget (daily × days / lifetime pro-rated)
• pacing_velocity_pct — actual MTD vs. expected at this point in the month (%)
• mtd_pacing_status — over_pacing | on_pace | under_pacing | no_budget_data
• recommended_daily_rate — USD/day needed to exhaust cap by month end
• projected_month_end — projected total if current run-rate holds
This view is always scoped to the current calendar month — no date filter is available. Results are capped at 150 rows. Requires PAID_MEDIA_GCP_PROJECT and PAID_MEDIA_BQ_DATASET.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| platform | No | ||
| campaign_id | No |