Verify your discounts after migration

Your discounts won't change after migration, because your current contractual rates are guaranteed for the duration of your contract. As long as your usage remains the same, your total costs won't increase. To see how your billing and discounts will look after the migration, you can use the BigQuery Sample Data Export. To understand your savings, commitment utilization, and effective savings rate, you can use the Compute flexible CUD example queries. To view your discount percentages before migration (old CUD model) or after migration (new CUD model), choose one of the following steps.

View discount percentages before migration (old CUD model)

  • To view your effective CUD discount compared to List On-Demand Price, see Calculate your overall flexible CUDs savings.
  • To view your effective CUD discount compared to Contracted On-Demand Price: (0.01 - Flex CUD SKU price) * 100

View discount percentages after migration (new CUD model)

After you migrate to the new model, SKUs can have different usage rates based on the consumption model you use them under.

In the following example, we analyze the SKU named N2 Instance Core running in Americas (SKU ID: BB77-5FDA-69D9). This SKU has three primary consumption models:

  • On-Demand: Standard, pay-as-you-go usage (consumption model 7754-699E-0EBF).
  • 1-Year Flexible CUD: Usage covered by a 1-year commitment (consumption model D97B-0795-975B).
  • 3-Year Flexible CUD: Usage covered by a 3-year commitment (consumption model 70D7-D1AB-12A4).

Use the Pricing user interface to see details about the pricing for each model:

  1. In the Google Cloud console, go to your Cloud Billing account.

    [Go to your Cloud Billing account](https://console.cloud.google.com/billing){: target="console" track-type="tutorial" track-name="consoleLink" track-metadata-position="body" class="button button-primary" } 
    
  2. Select Pricing from the sidebar.

  3. Both the public list price and your contractual prices are displayed.

In this example, we add two columns to show the savings ($/%) compared to the on-demand consumption model.

Fields from pricing UI Added fields to show savings calculations
SKU ID Consumption model ID Consumption model description List price ($) Contract price ($) Effective discount
(consumption model list vs contract)
Savings from on-demand contract rates Savings from on-demand list rates
BB77-5FDA-69D9 7754-699E-0EBF Default $0.03161 $0.02055 ($0.03161 -$0.02055)

35%
-

-
($0.03161 -$0.02055)

-$0.01106 (-35.0%)
BB77-5FDA-69D9 70D7-D1AB-12A4 Compute Flexible CUD - 3 Year $0.01707 $0.01408 ($0.01707 -$0.01408)

17.5%
($0.02055 -$0.01408)

-$0.00646 (-31.5%)
($0.03161 -$0.01408)

-$0.01753 (-55.5%)
BB77-5FDA-69D9 D97B-0795-975B Compute Flexible CUD - 1 Year $0.02276 $0.01878 ($0.02276 - $0.01878)

17.5%
($0.02055 -$0.01878)

-$0.00177 (-8.6%)
($0.03161 -$0.01878)

-$0.01283 (-40.6%)

The preceding chart uses five formulas to calculate the dollar savings in the columns named Savings from on-demand contract rates and Savings from on-demand list rates.

The calculations use the formula New Price - Baseline Price to show savings as a negative value. The accompanying percentage is then calculated by dividing that dollar saving by the baseline price.

Savings from on-demand list rates (for on-demand usage)

This formula calculates your initial savings from using the discounted On-demand Contract Price instead of the public On-demand List Price.

Formula: On-demand Contract Price − On-demand List Price Example from chart: $0.02055 − $0.03161 = −$0.01106

Savings from on-demand contract rates (for 3-Year CUD)

This formula calculates the additional savings gained by using a 3-Year Flexible CUD compared to the already discounted On-demand Contract Price.

Formula: 3-Year CUD Contract Price − On-demand Contract Price Example from chart: $0.01408 − $0.02055 = −$0.00647

Savings from on-demand list rates (for 3-Year CUD)

This formula calculates the total savings gained by using a 3-Year Flexible CUD compared to the public On-demand List Price.

Formula: 3-Year CUD Contract Price − On-demand List Price Example from chart: $0.01408 − $0.03161 = −$0.01753

Savings from on-demand contract rates (for 1-Year CUD)

This formula calculates the additional savings gained by using a 1-Year Flexible CUD compared to the on-demand Contract Price.

Formula: 1-Year CUD Contract Price − On-demand Contract Price Example from chart: $0.01878 − $0.02055 = −$0.00177

Savings from on-demand list rates (for 1-Year CUD)

This formula calculates the total savings gained by using a 1-Year Flexible CUD compared to the public On-demand List Price.

Formula: 1-Year CUD Contract Price − On-demand List Price Example from chart: $0.01878 − $0.03161 = −$0.01283

Calculate the effective savings rate (ROI)

To calculate your effective savings rate (ROI), use the CUD KPI sample queries. Separate sample queries are available specifically for the legacy data model and the new data model to facilitate comparison.