What is budget burn rate for cloud spend?
Definition
Budget burn rate compares how much of a cloud budget has been consumed against how much of the period has elapsed. Burn tracking above elapsed time is the earliest cheap warning that a month will overrun — long before the invoice arrives.
What data do you need?
- Budget amounts per scope (team, account, project) per period
- Daily cost rollups matched to the same scopes
- The period calendar (fiscal months differ from calendar months)
- Known one-time charges to annotate spikes
- Forecast data where available for the exhaustion view
SQL pattern
WITH period AS (
SELECT
date_trunc('month', CURRENT_DATE)::date AS period_start,
EXTRACT(day FROM CURRENT_DATE)::numeric AS days_elapsed,
EXTRACT(day FROM (date_trunc('month', CURRENT_DATE)
+ INTERVAL '1 month - 1 day'))::numeric AS days_in_period
), spend AS (
SELECT
team,
SUM(amortized_cost_usd) AS spend_to_date
FROM cost_daily_rollups
WHERE usage_date >= date_trunc('month', CURRENT_DATE)
GROUP BY team
)
SELECT
b.team,
b.budget_usd,
ROUND(s.spend_to_date, 2) AS spend_to_date,
ROUND(100.0 * s.spend_to_date / NULLIF(b.budget_usd, 0), 1)
AS budget_consumed_pct,
ROUND(
(s.spend_to_date / NULLIF(b.budget_usd, 0))
/ NULLIF(p.days_elapsed / p.days_in_period, 0), 2
) AS burn_ratio
FROM budgets b
JOIN spend s USING (team)
CROSS JOIN period p
WHERE b.month = p.period_start
ORDER BY burn_ratio DESC;Common pitfalls
Where does this metric apply?
This metric commonly uses data from AWS Billing, Google Cloud Billing, Vantage, CloudZero, plus any warehouse models built on raw billing exports at the same grain.