Track contract commitment burn-down over time
Monitor the consumption of contract commitments across billing periods to track progress toward fulfilling contractual obligations and identify potential under-utilization risks.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Track Contract Commitment Burn-Down Over Time
Not in v1.0 sample- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
ContractApplied and its ContractCommitmentID / ContractCommitmentAppliedCost elements are absent from the v1.0 sample, so contract-commitment burn-down cannot be tracked.
Original FOCUS SQL
SELECT CU.BillingPeriodStart, CU.ServiceProviderName, CU.BillingAccountId, JSON_VALUE(CA, '$.ContractCommitmentID') AS ContractCommitmentId, SUM(CAST(JSON_VALUE(CA, '$.ContractCommitmentAppliedCost') AS FLOAT64)) AS AppliedCost, SUM(CU.EffectiveCost) AS TotalEffectiveCost FROM focus_data_table CU CROSS JOIN UNNEST(JSON_EXTRACT_ARRAY(CU.ContractApplied, '$.Elements')) AS CA WHERE JSON_VALUE(CA, '$.ContractCommitmentID') IS NOT NULL AND BillingPeriodStart >= ? AND BillingPeriodStart < ? GROUP BY CU.BillingPeriodStart, CU.ServiceProviderName, CU.BillingAccountId, JSON_VALUE(CA, '$.ContractCommitmentID') ORDER BY BillingPeriodStart, ContractCommitmentId
Columns used
Column names from the source use case.