Data Export Format: Autonomous Discount Management for AWS - Savings (v1)

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>

    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