budget_pacing_monthly_v2

Compares monthly planned budgets (from the media plan) against actual monthly spend from unified_performance_v2. Provides both Platform and Region scopes in a single view.

View Details

Property	Value
Full path	paidteam-data-warehouse.customer_ads_suse.budget_pacing_monthly_v2
Architecture	CTEs for monthly actuals (platform + region) joined with planned monthly table
Planned source	suse_budget_planned_monthly_v2 (from Google Sheets via external table)
Spend source	unified_performance_v2 (all 6 platforms)
Created	2026-02-08

Columns

Column	Type	Description
PacingScope	STRING	"Platform" or "Region" — use to filter in Looker Studio
Dimension	STRING	Platform name (e.g., "Google Ads") or region name (e.g., "EMEA")
Quarter	STRING	Fiscal quarter (e.g., "2026-Q1")
Month	DATE	First day of month (e.g., 2025-11-01)
MonthLabel	STRING	Month in YYYY-MM format (e.g., "2025-11")
MonthlyPlannedBudget	FLOAT64	Total planned budget for this month/dimension
MonthlyActualSpend	FLOAT64	Total actual spend for this month/dimension
MonthlyVariance	FLOAT64	PlannedBudget - ActualSpend. Positive = underspend
MonthlyPacingRatio	FLOAT64	ActualSpend / PlannedBudget. 1.0 = spent exactly as planned

Sample Query

-- February 2026 monthly pacing by platform
SELECT
  Dimension AS Platform,
  ROUND(MonthlyPlannedBudget, 0) AS Planned,
  ROUND(MonthlyActualSpend, 0) AS Actual,
  ROUND(MonthlyPacingRatio, 2) AS Pacing
FROM `paidteam-data-warehouse.customer_ads_suse.budget_pacing_monthly_v2`
WHERE PacingScope = 'Platform' AND MonthLabel = '2026-02'
ORDER BY MonthlyPacingRatio DESC;

Looker Studio Usage

1. Connect budget_pacing_monthly_v2 as a separate data source
2. Add a control on PacingScope to toggle Platform/Region
3. Add a control on Quarter to select the fiscal quarter
4. Use MonthLabel as the time dimension for trend charts
5. Use MonthlyPacingRatio for conditional formatting

Notes

• Multi-region planned budgets are split evenly across constituent regions before aggregation.
• Months with no actual spend show MonthlyActualSpend = 0 and MonthlyPacingRatio = 0.
• Future months will have planned budget but zero actual spend — use for forecasting.