Analyze tag coverage

Asset Library / FinOps Use Cases / Analyze tag coverage

Context

Analyzing the amount of costs for a provider that have been tagged with a specific tag can enable the FinOps practitioner to check the amount of costs being allocated via tags.

FOCUS Columns

Charge Period Start
Charge Period End
Tags
Effective Cost
Provider

FOCUS SQL Query

SELECT 
    SUM(CASE 
        WHEN JSON_CONTAINS_PATH(tags, 'one', '$.?') 
        THEN EffectiveCost 
        ELSE 0 
    END) / SUM(EffectiveCost) * 100 AS TaggedPercentage
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
     AND EffectiveCost > 0
     AND ProviderName = ?

Related KPIs

Percentage of CSP Cloud Carbon that is Tagging Policy Compliant

This KPI measures the amount of compliance for cloud sustainability tagging, and requires an established organizational tagging policy.
The sophistication of determining what acceptable tag criteria are, and the stringency of the KPI should evolve with the organization’s FinOps maturity.

Formula

(Total emissions Associated with Tagging Policy Compliant CSP Cloud Resources During a Period of Time / Total CSP Cloud Emissions During a Period of Time) x 100

Data Sources:

CSP billing data,
Cloud Console,
carbon emission data source

Related Capabilities

Cloud Sustainability

Intersecting Disciplines

Related Assets

Cloud Sustainability and Its Intersection with FinOps

This project helps practitioners understand how they can positively contribute to their organizations drive to reduce digital carbon footprint and accelerate their path to net-zero.

Percentage of CSP Cloud Costs that are Tagging Policy Compliant

This KPI measures the amount of compliance for cloud cost tagging, and requires an established organizational tagging policy.

The sophistication of determining what acceptable tag criteria are and the stringency of the KPI should evolve with the organization’s FinOps maturity.

Formula

(Total Effective Costs Associated with Tagging Policy Compliant CSP Cloud Resources During a Period of Time / Total CSP Cloud Effective Costs During a Period of Time) x 100

Data Sources: