Update reports for improved meter names

Translate between the old and new meter names based on the meter ID (resource GUID)

You can use the following steps to filter the mapping spreadsheet we’ve provided to only the meters that you consume. Note that the examples are from a direct customer subscription. The values in each column might be different depending on your subscription.

1. Download the list of standardized meters (you can find localized download files at the bottom of this page), and save the file locally (for example, c:\AzureMeterMapping-en.xlsx).
2. Either download a detailed usage summary or create a workbook based on the output from one of the Azure APIs, and save the file locally (for example, c:\AzureUsage.xlsx). See an example using a detailed usage file below.
   • If you're a CSP partner, download a usage-based reconciliation file from Partner Center. Note that currently, the unit of measure is not found in the reconciliation file.
   • If you're a Direct customer, download the Version 2—Preview file from the Azure Account Portal.
   • If you're an EA customer, download the Usage Detail report under Reports > Download Usage in the Enterprise Portal.
3. Open the AzureUsage.xlsx file and remove any data that's unrelated to your daily usage (for example, statement or provisioning status information). Rename the worksheet to Sheet 1 if it isn’t already named Sheet 1.
4. Clean up the data in AzureUsage.xlsx before running a vlookup to interpret meter naming changes.
   • To ensure that vlookups return valid results, remove the quotation marks around the meter ID (resource GUID) of AzureUsage.xlsx by using the Find/Replace function in Excel. Then, move the Meter ID (Resource GUID) column to the left to become column A to help with vlookups, and save the file. Note that the variations in meter attribute names shown as column headers in the following table will depend on your specific Azure subscription.

5. Open the AzureMeterMapping-en.xlsx file and build a standard vlookup on the meter ID (resource GUID) to the AzureUsage.xlsx file.

• Add a column to the right of column A in the AzureMeterMapping-en.xlsx file.
• Enter the vlookup function in cell B2: =VLOOKUP(A2,'[AzureUsage.xlsx]Sheet 1'!$A:$A,1,FALSE)
• Filter out the "N/A" values from column B to eliminate any meters you don't use. Your updated file will look like the following example.

• The results in the AzureMeterMapping-en.xlsx file will display only the meters you have consumed that are in your usage summary. See columns C through G for the old meter naming conventions. See columns H through L for the new naming conventions.

Summarize my usage and see both old and new names displayed in one report by using a pivot table before the name changes take effect

This section provides guidance on how to summarize the meters you’ve consumed into one combined report that displays both the old and new names. Follow these instructions if you want to see how your reports will look after the new names are implemented. You can learn more about the improvements to meter names. Note that the examples below are from a Direct customer subscription. The values in each column might be different depending on your subscription.

1. Download the list of standardized names (you can find localized download files at the bottom of this page), and save the file locally (for example, c:\AzureMeterMapping-en.xlsx).
2. Either download a detailed usage summary or create a workbook based on the output from one of the Azure APIs, and save the file locally (for example, c:\AzureUsage.xlsx). See an example using a detailed usage file below.
   • If you're a CSP partner, download a usage-based reconciliation file from Partner Center. Note that currently, the unit of measure is not found in the reconciliation file.
   • If you're a Direct customer, download the Version 2—Preview file from the Azure Account Portal.
   • If you're an EA customer, download the Usage Detail report under Reports > Download Usagein the Enterprise Portal.
3. Open the AzureUsage.xlsx file and remove any data that's unrelated to your daily usage (for example, statement or provisioning status information).
4. Clean up the data in AzureUsage.xlsx before running a vlookup to interpret meter naming changes.
   • To ensure that vlookups return valid results, remove the quotation marks around all cells of the AzureUsage.xlsx file by using the Find/Replace function in Azure. Then, move the Meter ID (Resource GUID) column to the left to become column A to help with vlookups, and save the file. Note that the variations in meter attribute names shown as column headers in the table below will depend on your specific Azure subscription.
5. Open a new Excel file and name it Usage Summary – New Names.xlsx. Save the file locally.
6. Copy and paste the data from the AzureUsage.xlsx file to the Usage Summary – New Names.xlsx file in the order shown in the following example.

7. In the Usage Summary – New Names.xlsx file, build a vlookup in columns O–S to pull in columns G–K in the AzureMeterMapping-en.xlsx file. Include the headers as well. See the following example.

8. Build a pivot from the Usage Summary – New Names.xlsx file.

1. Add a new sheet to the Usage Summary – New Names.xlsx file workbook and name the sheet After-Before Summary.
2. Highlight all cells in the Usage Summary – New Names.xlsx file.
3. Select the Insert tab and select PivotTable. Create the Pivot table to After-Before Summary sheet.
4. Add the following PivotTable fields to Rows:
   1. Meter ID (Resource GUID)
   2. Meter Category (Service Name or Name)
   3. Meter Sub-category (Service Type or Type)
   4. Meter Name (Resource Name, Resource, Service Resource)
   5. Meter Region (Region)
   6. Unit (Unit of Measure)
   7. New convention - Service Name, Name, or Meter Category
   8. New convention - Service Type, Type, or Meter Sub-category
   9. New convention - Resource Name, Resource, Service Resource or Meter Name
   10. New convention - Meter Region or Region
   11. New convention - Unit or Unit of Measure
5. Add the Consumed Quantity field to Values as a Sum of Consumed Quantity.
6. Go to the Design tab and select Report Layout. Select Show in Tabular Form in the drop-down menu.
   • Right-click each column header and clear “Subtotal<header name>” (for example, Subtotal “Meter Category (Service Name or Name)”).

Your final output should look like the following example:

Summarize my usage and see both old and new names displayed in one report by using a pivot table after the name changes take effect

This section provides guidance on how to summarize the meters you’ve consumed into one combined report that displays both the old and new names. Follow these instructions if you need to keep using the old names in your reports temporarily after the new names are implemented. You can learn more about the improvements to meter names. Note that the following examples are from a Direct customer subscription. The values in each column might be different depending on your subscription.

1. Download the list of standardized meters (you can find localized download files at the bottom of this page), and save the file locally (for example, c:\AzureMeterMapping-en.xlsx).
2. Either download a detailed usage summary or create a workbook based on the output from one of the Azure APIs, and save the file locally (for example, c:\AzureUsage.xlsx). See an example using a detailed usage file below.
   • If you're a CSP partner, download a usage-based reconciliation file from Partner Center. Note that currently, the unit of measure is not found in the reconciliation file.
   • If you're a Direct customer, download the Version 2—Preview file from the Azure Account Portal.
   • If you are an EA customer, download the Usage Detail report under Reports > Download Usage in the Enterprise Portal.
3. Open a new Excel file and name it Usage Summary – Old Names.xlsx. Save the file locally.
4. Clean up the data in AzureUsage.xlsx before running a vlookup to interpret meter naming changes.
   • To ensure that vlookups return valid results, remove the quotation marks around all cells of the AzureUsage.xlsx file by using the Find/Replace function in Excel. Then, move the Meter ID (Resource GUID) column to the left to become column A to help with vlookups, and save the file. Note that the variations in meter attribute names shown as column headers in the following table will depend on your specific Azure subscription.
5. Copy and paste the data from the AzureUsage.xlsx file to the Usage Summary – Old Names.xlsx file in the order shown in the following example.

6. In the Usage Summary – Old Names.xlsx file, build a vlookup in columns O–S to pull in columns B–F in the AzureMeterMapping-en.xlsx file. Include the headers as well. See the following example.

7. Build a pivot from the Usage Summary – Old Names.xlsx file.

1. Add a new sheet to the Usage Summary – New Names.xlsx file workbook, and name the sheet After-Before Summary.
2. Highlight all cells in the Usage Summary – New Names.xlsx file.
3. Select the Insert tab and select PivotTable. Create the Pivot table to After-Before Summary sheet.
4. Add the following PivotTable fields to Rows:
   1. Meter ID (Resource GUID)
   2. Meter Category (Service Name or Name)
   3. Meter Sub-category (Service Type or Type)
   4. Meter Name (Resource Name, Resource, Service Resource)
   5. Meter Region (Region)
   6. Unit (Unit of Measure)
   7. Old convention - Service Name, Name, or Meter Category
   8. Old convention - Service Type, Type, or Meter Sub-category
   9. Old convention - Resource Name, Resource, Service Resource or Meter Name
   10. Old convention - Meter Region or Region
   11. Old convention - Unit or Unit of Measure
   12. Add the Consumed Quantity field to Values as a Sum of Consumed Quantity.

8. Go to the Design tab and select Report Layout. Select Show in Tabular Form in the drop-down menu.

• Right-click each column header and clear Subtotal“<header name>” (for example, Subtotal “Meter Category (Service Name or Name)”).

Your final output should look like the following example:

Translate the old to new names without the meter ID (resource GUID) 

You can use the following steps to filter the mapping spreadsheet we’ve provided to only the meters that you consume based solely on the meter name attributes. You would use these steps before the name changes take effect if you don't have a usage file with the meter ID (resource GUID). You can learn more about the improvements to meter names.

1. Download the list of standardized names (you can find localized download files at the bottom of this page), and save the file locally (for example, c:\AzureMeterMapping-en.xlsx).
2. Open a new Excel file and name the file (for example, Old Names.xlsx). Save the file locally. Add the headers shown in the following example, and customize them based on your Azure subscription.

3. Add the old name data from your file to the Old Names.xlsx file based on the headers you’ve created. See the following example.

4. In the Old Names.xlsx file, in column F, you need to concatenate the data in each row. Enter the following formula in cell F2: =CONCATENATE(A2," ",B2," ",C2," ",D2," ",E2). See the following example.

• Copy and paste the content in column F as text only. This will remove formulas but keep the results in the cells. Then, move column F to column A. Your file should appear like the following one.

5. In the AzureMeterMapping-en.xlsx file, add a column after column F. In column G, repeat step 4 by concatenating columns B–F.

6. In the AzureMeterMapping-en.xlsx file, add another column to the right side of column G.

7. Build a standard vlookup on column G in the AzureMeterMapping-en.xlsx file to column A in the Old Names.xlsx file. The legacy names might have changed over time and therefore won't display a match. See your current detailed usage summary from the Azure Management Portal to find the current name of your meter if a match is not found.

8. Filter column H to remove results with "N/A." After you’ve filtered, the AzureMeterMapping-en.xlsx file will only display the meters in your Old Names.xlsx file. To view the new names aligned for the meters in your Old Names.xlsx file, scroll to the right of the workbook to view columns I–M. See the results in the following example.

Translate the new to old names without the meter ID (resource GUID)

You can use the following steps to filter the mapping spreadsheet we’ve provided to only the meters that you consume based solely on the meter name attributes. You would use these steps after the name changes take effect if you don't have a usage file with the meter ID (resource GUID). You can learn more about the improvements to meter names.

1. Download the list of standardized meters (you can find localized download files at the bottom of this page), and save the file locally (for example, c:\AzureMeterMapping-en.xlsx).
2. Open a new Excel file and name the file (for example, New Names.xlsx). Save the file locally. Add the headers shown in the following example, and customize them based on your Azure subscription.

3. Add the new name data from your file to the New Names.xlsx file based on the headers you’ve created. See the following example.

4. In the New Names.xlsx file, in column F, you need to concatenate the data in each row. Enter the following formula in cell F2: =CONCATENATE(A2," ",B2," ",C2," ",D2," ",E2). See the following example.

• Copy and paste the content in column F as text only. This will remove formulas but keep the results in the cells. Then, move column F to column A.

5. In the AzureMeterMapping-en.xlsx file, in column L, repeat step 4 by concatenating columns G–K.

6. Build a standard vlookup on column G in the AzureMeterMapping-en.xlsx file to column A in the Old Names.xlsx file. The legacy names might have changed over time and therefore won't display a match. See your current detailed usage summary from the Azure Management Portal to find the current name of your meter if a match is not found.

7. Filter column M to remove results with "N/A." After you’ve filtered, the AzureMeterMapping-en.xlsx file will only display the meters in your New Names.xlsx file. To view the old names aligned for the meters in your New Names.xlsx file, scroll to the left of the workbook to view columns B–F. See the results in the following example.

Download language versions of the naming mapping file

This section provides translated meter mapping files for different locales. Select the language to download the translated meter mapping file for the indicated locale. You can learn more about the improvements to Azure names.

Contact Support

If you have further questions concerning the naming changes, please contact Azure Support.