This version has been deprecated and will only be included for customers who first enabled Data Export prior to May 20, 2025. A newer version of this export is available (see here for the latest). We recommend you consume the latest version.
Once you have successfully configured Data Export, updates will be published to your S3 bucket every 24 hours. This article describes the organization and structure of the Autonomous Discount Management for AWS - Savings (v1) export.
Organization
Directory Structure
ProsperOps will create the following directory structure in your export S3 bucket.
- savings
- compute
- v1
- <file>
- v1
- compute
File Structure
The v1 directory contains a single CSV file representing AWS Compute Savings Dashboard metrics, with rows representing each month Autonomous Discount Management has been enabled.
- Name
- prosperops-savings-[managementAccountNumber]-compute-monthly.csv
- Example: prosperops-savings-123456789012-compute-monthly.csv
- Rows
- One row for each month ProsperOps has been active
- The final row of this file represents the current (unfinalized) month
- Columns (see below)
-
Actual values match your AWS bill (with prepayments amortized). This provides an accurate view of monthly cost and savings but is not useful when comparing across months since the number of days in each month can vary.
- Normalized values (also with prepayments amortized) have been adjusted to a 30-day month to remove number of day variance and provide a useful representation that can be compared across months.
-
Column Name | Type | Description |
month_start | date | The first day of the month represented by the corresponding row (yyyy-mm-dd) |
is_finalized | boolean | TRUE if the month is complete, FALSE if not |
effective_savings_rate | decimal | Effective Savings Rate achieved in the given month |
effective_savings_rate_prior_to_subscription | decimal | effective_savings_rate_prior_to_subscription |
compute_usage | decimal | What you would have paid your cloud provider without discounts (actual) |
compute_spend | decimal | What you actually paid your cloud provider, with prepay amortized (actual) |
gross_savings | decimal | How much you saved on your cloud bill (actual) |
net_savings | decimal | Your savings net of ProsperOps' charge (actual) |
compute_usage_normalized | decimal | What you would have paid your cloud provider without discounts (normalized) |
compute_spend_normalized | decimal | What you actually paid your cloud provider, with prepay amortized (normalized) |
gross_savings_normalized | decimal | How much you saved on your cloud bill (normalized) |
net_savings_normalized | decimal | Your savings net of ProsperOps' charge (normalized) |
savings_share_actual | decimal | ProsperOps share of savings generated |
portfolio_actions | integer | The number of actions our service has taken to purchase, modify, and optimize your commitments |
reserved_instance_utilization_percentage | decimal | Your overall reserved instance utilization |
savings_plan_utilization_percentage | decimal | Your overall savings plan utilization |
inherited_savings | decimal | Savings generated from commitments you purchased before ProsperOps (actual) |
base_savings | decimal | Savings generated from savings plans |
flex_savings | decimal | Savings generated from ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_savings | decimal | Savings generated from Flex Boosted Convertible RIs (AWS Compute only) |
smart_savings | decimal | Savings generated from ProsperOps smart commitments |
unbilled_savings | decimal | Savings generated from unbilled commitments |
inherited_savings_normalized | decimal | Savings generated from commitments you purchased before ProsperOps (normalized) |
base_savings_normalized | decimal | Savings generated from savings plans (normalized) |
flex_savings_normalized | decimal | Savings generated from ProsperOps optimized Convertible RIs (normalized - AWS Compute only) |
flex_boost_savings_normalized | decimal | Savings generated from Flex Boosted Convertible RIs (normalized - AWS Compute only) |
smart_savings_normalized | decimal | Savings generated from ProsperOps smart commitments (normalized) |
unbilled_savings_normalized | decimal | Savings generated from unbilled commitments (normalized) |
base_one_year_percentage | decimal | Percent of your portfolio composed of 1 Year savings plans |
base_one_year_discount_percentage | decimal | Discount percentage received from 1 Year savings plans |
base_three_year_percentage | decimal | Percent of your portfolio composed of 3 Year savings plans |
base_three_year_discount_percentage | decimal | Discount percentage received from 3 Year savings plans |
flex_one_year_percentage | decimal | Percent of your portfolio composed of 1 Year ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_one_year_discount_percentage | decimal | Discount percentage received from 1 Year ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_three_year_percentage | decimal | Percent of your portfolio composed of 3 Year ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_three_year_discount_percentage | decimal | Discount percentage received from 3 Year ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_one_year_percentage | decimal | Percent of your portfolio composed of 1 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_one_year_discount_percentage | decimal | Discount percentage received from 1 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_three_year_percentage | decimal | Percent of your portfolio composed of 3 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_three_year_discount_percentage | decimal | Discount percentage received from 3 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only) |
unbilled_one_year_percentage | decimal | Percent of your portfolio composed of 1 Year unbilled commitments |
unbilled_one_year_discount_percentage | decimal | Discount percentage received from 1 Year unbilled commitments |
unbilled_three_year_percentage | decimal | Percent of your portfolio composed of 3 Year unbilled commitments |
unbilled_three_year_discount_percentage | decimal | Discount percentage received from 3 Year unbilled commitments |
on_demand_percentage | decimal | Percent of your total spend made up of on-demand usage |
blended_discount_percentage | decimal | Your total discount percentage, weighted by allocation |
inherited_spend_coverage | decimal | Dollar amount coverage of inherited commitment |
inherited_spend_coverage_percentage | decimal | Percent coverage of inherited commitment |
base_spend_coverage | decimal | Dollar amount coverage of savings plans |
base_spend_coverage_percentage | decimal | Percent of savings plan coverage |
flex_spend_coverage | decimal | Dollar amount coverage of ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_spend_coverage_percentage | decimal | Percent of ProsperOps optimized Convertible RIs (AWS Compute only) |
flex_boost_spend_coverage | decimal | Dollar amount coverage of ProsperOps Flex Boosted Convertible RIs (AWS Compute only) |
flex_boost_spend_coverage_percentage | decimal | Percent coverage of ProsperOps Flex Boosted Convertible RIs (AWS Compute only) |
smart_spend_coverage | decimal | Dollar amount coverage of ProsperOps smart commitments |
smart_spend_coverage_percentage | decimal | Percent coverage of smart commitments |
unbilled_spend_coverage | decimal | Dollar amount coverage of unbilled commitments |
unbilled_spend_coverage_percentage | decimal | Percent coverage of unbilled commitments |
uncovered_usage | decimal | Dollar amount of on-demand spend |
overall_spend_coverage | decimal | Dollar amount of total spend coverage |
overall_spend_coverage_percentage | decimal | Percent of total spend coverage |