What is untagged spend rate?
Definition
Untagged spend rate is the share of cloud cost carrying no owner tag — no team, project, or cost-center attribution. It is the ceiling on every allocation dashboard: if 30% of spend is untagged, team cost views are at best 70% true. Mature FinOps practices treat it as a first-class KPI with an owner.
What data do you need?
- Billing line items with tags and labels preserved through the pipeline
- The list of required tag keys (team, environment, service)
- A tag-to-owner mapping that normalizes variants and typos
- Resource identifiers so top untagged resources can be assigned
- Untaggable-spend classification (some charges can't carry tags)
SQL pattern
SELECT
date_trunc('month', usage_date) AS month,
ROUND(
100.0 * SUM(amortized_cost_usd) FILTER (WHERE team_tag IS NULL)
/ NULLIF(SUM(amortized_cost_usd), 0), 1
) AS untagged_spend_pct,
ROUND(SUM(amortized_cost_usd) FILTER (WHERE team_tag IS NULL), 2)
AS untagged_usd
FROM billing_line_items
WHERE line_item_type NOT IN ('Credit', 'Refund', 'Tax')
GROUP BY 1
ORDER BY 1;Common pitfalls
Where does this metric apply?
This metric commonly uses data from AWS Billing, Google Cloud Billing, Kubecost, Vantage, plus any warehouse models built on raw billing exports at the same grain.