AWS Billing and Cost Management
User Guide (Version 2.0)

Creating and Saving Custom Reports

To create a custom Cost Explorer report for visualizing your costs, choose the New report dropdown list on the Cost Explorer console, choose one of the following report types, and then modify the report filters.

Cost and Usage Reports

The Cost and Usage reports show how you use services and how your costs are distributed by service. To create your custom report, you can use all the features that are discussed in Analyzing Your Costs with Cost Explorer.

RI Utilization Reports

The RI Utilization reports show how much of your Amazon EC2, Amazon Redshift, Amazon RDS, and Amazon ElastiCache Reserved Instance (RIs) that you use, how much you saved by using RIs, how much you overspent on RIs, and your net savings from purchasing RIs during the selected time range. This helps you to see if you have purchased too many RIs.

The RI Utilization charts display the number of Reserved Instance (RI) hours that your account uses, helping you to understand and monitor your combined usage (utilization) across all of your RIs and services. It also shows how much you saved over On-Demand Instance costs by purchasing a reservation, the amortized costs of your unused reservations, and your total net savings from purchasing reservations. AWS calculates your total net savings by subtracting the costs of your unused reservations from your reservations savings.

The following table shows an example of potential savings (all costs are in USD).

RI Utilization Example

Account RI Utilization RI Hours Purchased RI Hours Used RI Hours Unused On-Demand Cost of RI Hours Used Effective RI Cost Net Savings Total Potential Savings

Martha

0.50

100

50

50

$200

$150

$50

$250

Liu Jie

0.75

100

75

25

$300

$150

$150

$250

Saanvi

1.00

50

50

0

$200

$75

$125

$125

As shown in the preceding table, Martha, Liu Jie, and Saanvi purchase RIs at $1.50 an hour and On-Demand hours at $4.00 an hour. Breaking down this example further, you can see how much each of them saves by purchasing RIs:

  • Martha purchases 100 RI hours for $150. She uses 50 hours, which would cost $200 if she used On-Demand Instances. She saves $50, which is the cost of 50 On-Demand hours minus the cost of the RI. She could optimize her savings by using more of her purchased RI hours, by converting her RI to cover other instances, or by selling her RIs on the RI Marketplace. For more information about selling an RI on the RI Marketplace, see Selling on the Reserved Instance Marketplace in the Amazon EC2 User Guide for Linux Instances.

  • Liu Jie purchases 100 RI hours for $150. He uses 75 of them, which would cost $300 if he used On-Demand Instances. So he saves $150, which is the cost of 300 On-Demand hours minus the cost of the RI.

  • Saanvi purchases 50 RI hours for $75. She uses all 50 of them, which would cost $200 if she used On-Demand Instances. So she saves $125, which is the cost of 200 On-Demand hours minus the cost of the RI.

The reports allow you to define a utilization threshold, known as a utilization target, and identify RIs that meet your utilization target and RIs that are underutilized. The chart shows RI utilization as the percentage of purchased RI hours that are used by matching instances, rounded to the nearest percentage.

Target utilization is shown on the chart as a dotted line in the chart and in the table under the chart as a colored RI utilization status bar. RIs with a red status bar are RIs with no hours used. RIs with a yellow status bar are under your utilization target. RIs with a green status bar have met your utilization target. Instances with a gray bar are not using reservations. You can change the utilization target in the Display Options section. To remove the utilization target line from the chart, clear the Show target line on chart check box. You can also create budgets that enable AWS to notify you if you fall below your utilization targets. For more information, see Managing Your Costs with Budgets.

You can filter the chart to analyze the purchasing accounts, instance types, and more. RI reports use a combination of RI-specific filters and regular Cost Explorer filters. The RI-specific filters are available only for the Cost Explorer RI Utilization and RI Coverage reports. They are not available anywhere else that AWS uses Cost Explorer filters. The following filters are available:

  • Availability Zone – Filter your RI usage by specific Availability Zones.

  • Instance Type – Filter your RI usage by specific instance types, such as t2.micro or m3.medium. This also applies to Amazon RDS instance classes, such as db.m4, and Amazon Redshift and ElastiCache node types, such as dc2.large.

  • Linked Account – Filter your reservations by specific member accounts.

  • Platform – Filter your RI usage by platform, such as Linux or Windows. This also applies to Amazon RDS database engines.

  • Region – Filter your RI usage by specific regions, such as US East (N. Virginia) or Asia Pacific (Singapore).

  • Scope (Amazon EC2–specific) – Filter your Amazon EC2 usage to show RIs that are purchased for use in specific Availability Zones or regions.

  • Tenancy (Amazon EC2–specific) – Filter your Amazon EC2 usage by tenancy, such as Dedicated or Default. An RI with a Dedicated tenancy is reserved for a single tenant, and an RI with a Default tenancy might share hardware with another RI.

In addition to changing your utilization target and filtering your RIs, you can choose a single RI or a group of RIs to show in the chart. To choose a single RI or a selection of RIs to see in the chart, select the check box next to the RI in the table under the chart. You can select up to 10 leases at one time.

Cost Explorer shows the combined utilization across all of your RIs in the chart and shows utilization for individual RI reservations in the table under the chart. The table also includes a subset of the information for each RI reservation. You can find the following information for each reservation in the downloadable .csv file:

  • ACCOUNT NAME – The name of the account that owns the RI reservation.

  • SUBSCRIPTION ID – The unique subscription ID for the RI reservation.

  • RESERVATION ID – The unique ID for the RI reservation.

  • INSTANCE TYPE – The RI instance class, instance type, or node type, such as t2.micro, db.m4, or dc2.large.

  • RI UTILIZATION – The percentage of purchased RI hours that were used by matching instances.

  • RI HOURS PURCHASED – The number of purchased hours for the RI reservation.

  • RI HOURS USED – The number of purchased hours that were used by matching instances.

  • RI HOURS UNUSED – The number of purchased hours that were not used by matching instances.

  • ACCOUNT ID – The unique ID of the account that owns the RI reservation.

  • START DATE – The date that the RI starts.

  • END DATE – The date that the RI expires.

  • NUMBERS OF RIS – The numbers of RIs that are associated with the reservation.

  • SCOPE – Whether this RI is for a specific Availability Zone or region.

  • REGION – The region that the RI is available in.

  • AVAILABILITY ZONE – The Availability Zone that the RI is available in.

  • PLATFORM(Amazon EC2) – The platform that this RI is for.

  • TENANCY(Amazon EC2) – Whether this RI is for a shared or dedicated instance.

  • PAYMENT OPTION – Whether this RI is a Full Upfront, Partial Upfront, or No Upfront RI.

  • OFFERING TYPE – Whether this RI is Convertible or Standard.

  • NET SAVINGS – The amount that Cost Explorer estimates that you saved by purchasing reservations.

  • ON-DEMAND COST OF RI HOURS USED – The cost of the RI hours that you used, based on the public On-Demand prices.

  • AMORTIZED UPFRONT FEE – The upfront cost of this reservation, amortized over the RI period.

  • AMORTIZED RECURRING FEE – The monthly cost of this reservation, amortized over the RI period.

  • TOTAL AMORTIZED FEE – The combined amortized upfront and amortized recurring costs of the RI hours that you purchased.

  • POTENTIAL SAVINGS – The total potential savings that you might see if you use your entire RI.

You can use this information to track how many RI usage hours you used and how many RI hours you reserved but didn't use during the selected time range.

The Daily RI Utilization chart displays your RI utilization for the previous three months on a daily basis. The Monthly RI Utilization chart displays your RI utilization for the previous 12 months on a monthly basis.

RI Coverage Reports

The RI Coverage reports show how many of your Amazon EC2, Amazon Redshift, Amazon RDS, and Amazon ElastiCache instance hours are covered by RIs, how much you spent on On-Demand Instances, and how much you might have saved had you purchased more reservations. This allows you to see if you have under-purchased RIs.

The RI coverage charts display the percentage of instance hours that your account used that were covered by reservations, helping you to understand and monitor the combined coverage across all of your RIs. It also shows how much you spent on On-Demand Instances, and how much you might have saved had you purchased more reservations.

You can define a threshold for how much coverage you want from RIs, known as a coverage target, which allows you to see where you can reserve more RIs.

Target coverage is shown on the chart as a dotted line, and the average coverage is shown in the table under the chart as a colored status bar. Instances with a red status bar are instances with no RI coverage. Instances with a yellow status bar are under your coverage target. Instances with a green status bar have met your coverage target. Instances with a gray bar are not using reservations. You can change the coverage target in the Display Options section. To remove the coverage target line from the chart, clear the Show target line on chart check box. You can also create coverage budgets that enable AWS to notify you if you fall below your coverage target. For more information, see Managing Your Costs with Budgets.

The RI coverage reports use the Cost Explorer filters instead of the RI Utilization filters. You can filter the chart to analyze the purchasing accounts, instance types, and more. RI reports use a combination of RI-specific filters and regular Cost Explorer filters. The RI-specific filters are available only for the Cost Explorer RI Utilization and RI Coverage reports, and are not available anywhere else that AWS uses Cost Explorer filters. The following filters are available:

  • Availability Zone – Filter your RI usage by specific Availability Zones.

  • Instance Type – Filter your RI usage by specific instance types, such as t2.micro or m3.medium. This also applies to Amazon RDS instance classes such as db.m4.

  • Linked Account – Filter your RI usage by specific linked accounts.

  • Platform – Filter your RI usage by platform, such as Linux or Windows. This also applies to Amazon RDS database engines.

  • Region – Filter your RI usage by specific regions, such as US East (N. Virginia) or Asia Pacific (Singapore).

  • Scope (Amazon EC2-specific) – Filter your Amazon EC2 usage to show RIs that are purchased for use in specific Availability Zones or regions.

  • Tenancy (Amazon EC2-specific) – Filter your Amazon EC2 usage by tenancy, such as Dedicated or Default. A Dedicated RI is reserved for a single tenant, while a Default RI might share hardware with another RI.

In addition to changing your coverage target and filtering your instance types with the available filters, you can choose a single instance type or a group of instance types to show in the chart. To choose a single instance type or a selection of instance types to see in the chart, select the check box next to the instance type in the table under the chart. You can select up to 10 instances at one time.

Cost Explorer shows the combined coverage across all of your instance types in the chart and shows coverage for individual instance types in the table under the chart. The table also includes a subset of the information for each instance type. You can find the following information for each instance type in the downloadable .csv file:

  • INSTANCE TYPE (Amazon EC2), INSTANCE CLASS (Amazon RDS), or NODE TYPE (Amazon Redshift or Amazon ElastiCache) – The RI instance class, instance type, or node type, such as t2.micro, db.m4, or dc2.large.

  • DATABASE ENGINE (Amazon RDS–specific) – Filter your Amazon RDS coverage to show RIs that cover a specific database engine, such as Amazon Aurora, MySQL, or Oracle.

  • DEPLOYMENT OPTION (Amazon RDS–specific) – Filter your Amazon RDS coverage to show RIs that cover a specific deployment option, such as Multi-AZ deployments.

  • REGION – The region that the instance ran in, such as us-east-1.

  • PLATFORM(Amazon EC2) – The platform that this RI is for.

  • TENANCY –(Amazon EC2) Whether this RI is for a shared, dedicated, or host instance.

  • AVERAGE COVERAGE – The average number of usage hours that are covered by a reservation.

  • RI COVERED HOURS – The number of usage hours that are covered by reservations.

  • ON-DEMAND HOURS – The number of usage hours that are not covered by reservations.

  • ON-DEMAND COST – The amount that you spent on On-Demand Instances.

  • TOTAL RUNNING HOURS – The total number of usage hours, both covered and uncovered.

You can use this information to track how many hours you use, and how many of those hours are covered by RIs.

The daily chart displays the number of RI hours that your account used on a daily basis for the last three months. The monthly chart displays your RI coverage for the previous 12 months, listed by month.

Saving a Report

After you finish editing the Cost Explorer settings for your new report, choose Save as.... Enter a name for your report, and then choose Save Report.