Amazon Web Services (AWS) Bill-Based Data Dimensions

Data for AWS is sourced from the AWS Cost and Usage Report CSV. The following source columns are the column names that correlate to data in those billing files.

Table 1 • AWS Bill-Based Data Dimensions

Cloud Cost Optimization Dimension

Source Column

Notes

Availability Zone

lineItem/AvailabilityZone 

 

Bill Entity

bill/BillingEntity 

Use this dimension to identify marketplace spend and nonmarketplace spend.

Cloud Vendor

N/A 

Always Amazon Web Services

Cloud Vendor Account

lineItem/UsageAccountId 

AWS Line Item Details 

Cloud Vendor Account Name

account_name 

 

Commitment ID

reservation/ReservationARN 

savingsPlan/SavingsPlanArn 

 

Commitment Name

reservation/ReservationARN 

savingsPlan/SavingsPlanArn 

 

Datacenter

lineItem/AvailabilityZone 

Available only in Monthly CSV Reports in Billing Centers 

Instance Type

product/instanceType 

AWS Product Details 

Line Item Type

lineItem/lineItemType 

For details, see the AWS lineItem/LineItemType descriptions.

Note:If lineItem/lineItemType is not populated in the AWS bill, the Cloud Cost Optimization Dimension Line Item Type will be populated with None.

Region

product/location 

Note:AWS GovCloud (US) is treated as any other AWS Region and comes through in the AWS Hourly Cost and Usage Report (HCUR) that Cloud Cost Optimization uses to ingest AWS bill data.

AWS Product Details 

Resource Group

 

N/A for AWS

Resource ID

lineItem/ResourceId 

Available in Cloud Cost Optimization for the last 31 days in daily granularity or last 3 months in monthly granularity

Resource Name

resourceTags/user:Name 

Available only in Monthly CSV Reports in Billing Centers 

Resource Type

product/productFamily

AWS Product Details 

Service

lineItem/ProductCode 

AWS Line Item Details 

Usage Type

lineItem/UsageType 

If lineItem/LineItemType is DiscountedUsage or UsageType matches HeavyUsage, MediumUsage, or LightUsage, UsageType is set to DiscountedUsage.

Usage Unit

pricing/unit 

This dimension represents the unit in which the “Usage Amount” metric is measured.