budget_pacing_summary_v2

UNION ALL of budget_pacing_platform_v2 and budget_pacing_region_v2 into a single data source. Use the BudgetScope column to filter by dimension in Looker Studio.

View Details

Property	Value
Full path	paidteam-data-warehouse.customer_ads_suse.budget_pacing_summary_v2
Architecture	UNION ALL of platform + region pacing views
Purpose	Single Looker Studio data source for all budget pacing
Created	2026-02-08

Columns

Column	Type	Description
BudgetScope	STRING	Dimension type: "Platform" or "Region"
Dimension	STRING	The specific platform or region name
Quarter	STRING	Fiscal quarter
QuarterStart / QuarterEnd	DATE	Quarter boundaries
QuarterBudget	FLOAT64	Budget for this dimension/quarter
PlannedBudget	FLOAT64	Sum of planned/forecasted spend from media plan
UnplannedMargin	FLOAT64	QuarterBudget - PlannedBudget
PctPlanned	FLOAT64	PlannedBudget / QuarterBudget
QTD_Spend / MTD_Spend	FLOAT64	Actual spend
BudgetRemaining	FLOAT64	Budget minus spend
DaysElapsed / DaysInQuarter / DaysRemaining	INT64	Time progress
PctBudgetConsumed / PctTimeElapsed	FLOAT64	Progress ratios
PacingRatio	FLOAT64	1.0 = on pace
ProjectedSpend / ProjectedVariance	FLOAT64	Linear projections

Looker Studio Usage

In Looker Studio, add this view as a data source, then:

1. Add a control (dropdown) on BudgetScope to toggle between Platform and Region views
2. Add a control on Quarter to select the fiscal quarter
3. Use PacingRatio for conditional formatting (green < 1.1, yellow 1.1-1.3, red > 1.3)
4. Use ProjectedVariance for over/under budget indicators

Sample Query

-- Executive summary: all dimensions, current quarter
SELECT BudgetScope, Dimension, ROUND(QuarterBudget, 0) AS Budget, ROUND(QTD_Spend, 0) AS Spent, ROUND(PacingRatio, 2) AS Pacing
FROM `paidteam-data-warehouse.customer_ads_suse.budget_pacing_summary_v2`
WHERE Quarter = '2026-Q2'
ORDER BY BudgetScope, PacingRatio DESC;

Future Extensions

• Phase 2: Product Line pacing will be added as a third BudgetScope = 'ProductLine' UNION
• Phase 2: Campaign Objective pacing (Brand Awareness, Lead Gen, etc.) as a fourth UNION