Microsoft Azure Enterprise Agreement Bill-Based Data Dimensions
Data for Microsoft Azure is sourced from the Enterprise billing Cost Details API. The following source columns are the fields from that API response. For more information, see Microsoft’s documentation on Azure Billing API.
| Cloud Cost Optimization Dimension | Source Column | Notes |
|---|---|---|
| Bill Entity | PublisherType | Use this dimension to identify marketplace spend and nonmarketplace spend. |
| Billing Account ID | BillingAccountId | |
| Cloud Vendor | N/A | Always Microsoft Azure\. |
| Cloud Vendor Account | SubscriptionId | Unique identifier for the Azure subscription. |
| Cloud Vendor Account Name | SubscriptionName | Name of the Azure subscription. |
| Commitment ID | ReservationId benefitId | |
| Commitment Name | ReservationName benefitName | |
| Datacenter | N/A for Azure. | |
| Instance Type | AdditionalInfo\.ServiceType | |
| Invoice ID | InvoiceId | The unique document ID listed on the invoice PDF. |
| Manufacturer Name | PublisherName | Publisher for Marketplace services. |
| Operating System | N/A The name is derived from details from the virtual machine and virtual machine license. | Name of the operating system, such as Windows, Linux, Red Hat Enterprise, etc. |
| Product Order Name | ProductOrderName | Unique name for the product order. |
| Purchase Option | PricingModel | Identifier that indicates how the meter is priced. (Values: On Demand, Reservation, and Spot). On demand Non-Discountable is not an option for Azure EA. |
| Region | MeterRegion | Name of the datacenter location for services priced based on location. |
| Resource Group | ResourceGroup | Name of the resource group the resource is in. Not all charges come from resources deployed to resource groups. Charges that don't have a resource group are shown as null or empty, Others, or Not applicable. |
| Resource ID | InstanceId | Available in Cloud Cost Optimization for the last 31 days in daily granularity or last 3 months in monthly granularity. |
| Resource Type | MeterCategory | SubCategory is excluded if it's the same as Category. “Marketplace Charge-[PublisherName]” for marketplace charges. “Reservation Order-[Description]” for Reserved Instance charges. |
| Service | ConsumedService | Prepends “Microsoft.” if not already present. |
| Usage Type | MeterName | The name of the meter. Purchases and Marketplace usage may be shown as blank or unassigned. |
| Usage Unit | UnitOfMeasure | This dimension represents the units in which the “Usage Amount” metric is measured. |