Data Export Organization and Format

Once you have successfully configured Data Export, updates will be published to your S3 bucket every 24 hours. The organization and structure of these exports is specified below.

Organization

Directory Structure

ProsperOps will create the following directory structure in your export S3 bucket.

intelligent_showback
- v1
  - <file>

savings
- compute
  - v1
    - <file>

The intelligent_showback directory contains CSV files representing the visible data in the Intelligent Showback view of the ProsperOps console.

The savings directory contains a single CSV file representing Savings dashboard metrics, with rows representing each month Autonomous Discount Management has been enabled. The final row of this file represents the current (unfinalized) month.

File Structure

Intelligent Showback
- One file is available for each month ProsperOps has been active

- The naming and structure of these export files mimics that which is displayed and available for download in the ProsperOps console
  - Name
    - prosperops-showback-yyyy-mm-managementAccountNumber-savingsReallocationMethod-savingsShareIfIncluded.csv
    - Example:
      - prosperops-showback-2024-12-XXXXXXXXXXXX-shared_benefit-savings_share.csv

- See the articles below
  - Intelligent Showback: Introduction and Overview
  - Intelligent Showback: Savings Reallocation Methods
Savings
- One file is available in total

- Name
  - prosperops-savings-managementAccountNumber-compute-monthly.csv
  - Example:
    - prosperops-savings-XXXXXXXXXXXX-compute-monthly.csv

- Rows
  - One row for each month ProsperOps has been active
- Columns
  - month_start
    - The first day of the month represented by the corresponding row
    - String
      - Format: yyyy-mm-dd
  - is_finalized
    - TRUE if the month is complete, FALSE if not
    - Boolean
  - effective_savings_rate
    - Effective Savings Rate achieved in the given month
    - Decimal
  - effective_savings_rate_prior_to_subscription
    - Effective Savings Rate achieved before ProsperOps
    - Decimal
  - compute_usage
    - What you would have paid your cloud provider without discounts (actual)
    - Decimal
  - compute_spend
    - What you actually paid your cloud provider, with prepay amortized (actual)
    - Decimal
  - gross_savings
    - How much you saved on your cloud bill (actual)
    - Decimal
  - net_savings
    - Your savings net of ProsperOps' charge (actual)
    - Decimal
  - compute_usage_normalized
    - What you would have paid your cloud provider without discounts (normalized)
    - Decimal

- - compute_spend_normalized
    - What you actually paid your cloud provider, with prepay amortized (normalized)
    - Decimal

- - gross_savings_normalized
    - How much you saved on your cloud bill (normalized)
    - Decimal

- - net_savings_normalized
    - Your savings net of ProsperOps' charge (normalized)
    - Decimal
  - savings_share_actual
    - ProsperOps share of savings generated
    - Decimal
  - portfolio_actions
    - The number of actions our service has taken to purchase, modify, and optimize your commitments
    - Integer
  - reserved_instance_utilization_percentage
    - Your overall reserved instance utilization
    - Decimal
  - savings_plan_utilization_percentage
    - Your overall savings plan utilization
    - Decimal
  - inherited_savings
    - Savings generated from commitments you purchased before ProsperOps (actual)
    - Decimal
  - base_savings
    - Savings generated from savings plans
    - Decimal

- - flex_savings
    - Savings generated from ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_savings
    - Savings generated from Flex Boosted Convertible RIs (AWS Compute only)
    - Decimal

- - smart_savings
    - Savings generated from ProsperOps smart commitments
  - unbilled_savings
    - Savings generated from unbilled commitments
    - Decimal

- - inherited_savings_normalized
    - Savings generated from commitments you purchased before ProsperOps (normalized)
    - Decimal
  - base_savings_normalized
    - Savings generated from savings plans (normalized)
    - Decimal

- - flex_savings_normalized
    - Savings generated from ProsperOps optimized Convertible RIs (normalized - AWS Compute only)
    - Decimal

- - flex_boost_savings_normalized
    - Savings generated from Flex Boosted Convertible RIs (normalized - AWS Compute only)
    - Decimal

- - smart_savings_normalized
    - Savings generated from ProsperOps smart commitments (normalized)
    - Decimal

- - unbilled_savings_normalized
    - Savings generated from unbilled commitments (normalized)
    - Decimal

- - base_one_year_percentage
    - Percent of your portfolio composed of 1 Year savings plans
    - Decimal
  - base_one_year_discount_percentage
    - Discount percentage received from 1 Year savings plans
    - Decimal

- - base_three_year_percentage
    - Percent of your portfolio composed of 3 Year savings plans
    - Decimal

- - base_three_year_discount_percentage
    - Discount percentage received from 3 Year savings plans
    - Decimal
  - flex_one_year_percentage
    - Percent of your portfolio composed of 1 Year ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_one_year_discount_percentage
    - Discount percentage received from 1 Year ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_three_year_percentage
    - Percent of your portfolio composed of 3 Year ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_three_year_discount_percentage
    - Discount percentage received from 3 Year ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_one_year_percentage
    - Percent of your portfolio composed of 1 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_one_year_discount_percentage
    - Discount percentage received from 1 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_three_year_percentage
    - Percent of your portfolio composed of 3 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_three_year_discount_percentage
    - Discount percentage received from 3 Year Flex Boosted ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - unbilled_one_year_percentage
    - Percent of your portfolio composed of 1 Year unbilled commitments
    - Decimal

- - unbilled_one_year_discount_percentage
    - Discount percentage received from 1 Year unbilled commitments
    - Decimal

- - unbilled_three_year_percentage
    - Percent of your portfolio composed of 3 Year unbilled commitments
    - Decimal

- - unbilled_three_year_discount_percentage
    - Discount percentage received from 3 Year unbilled commitments
    - Decimal

- - on_demand_percentage
    - Percent of your total spend made up of on-demand usage
    - Decimal

- - blended_discount_percentage
    - Your total discount percentage, weighted by allocation
    - Decimal
  - inherited_spend_coverage
    - Dollar amount coverage of inherited commitment
    - Decimal
  - inherited_spend_coverage_percentage
    - Percent coverage of inherited commitment
    - Decimal
  - base_spend_coverage
    - Dollar amount coverage of savings plans
    - Decimal

- - base_spend_coverage_percentage
    - Percent of savings plan coverage
    - Decimal

- - flex_spend_coverage
    - Dollar amount coverage of ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal

- - flex_spend_coverage_percentage
    - Percent of ProsperOps optimized Convertible RIs (AWS Compute only)
    - Decimal
  - flex_boost_spend_coverage
    - Dollar amount coverage of ProsperOps Flex Boosted Convertible RIs (AWS Compute only)
    - Decimal

- - flex_boost_spend_coverage_percentage
    - Percent coverage of ProsperOps Flex Boosted Convertible RIs (AWS Compute only)
    - Decimal
  - smart_spend_coverage
    - Dollar amount coverage of ProsperOps smart commitments
    - Decimal

- - smart_spend_coverage_percentage
    - Percent coverage of smart commitments
    - Decimal
  - unbilled_spend_coverage
    - Dollar amount coverage of unbilled commitments
    - Decimal
  - unbilled_spend_coverage_percentage
    - Percent coverage of unbilled commitments
    - Decimal
  - uncovered_usage
    - Dollar amount of on-demand spend
    - Decimal
  - overall_spend_coverage
    - Dollar amount of total spend coverage
    - Decimal
  - overall_spend_coverage_percentage
    - Percent of total spend coverage
    - Decimal