Skip to main content

Examples

This page provides examples that demonstrate typical ways to monitor and analyze your operation using analytical reports.

Cost metrics

Metrics in the hierarchy

This section includes examples for each tenant level in the hierarchical model.

  • Distributor view.

    • Billed Cost: The amount the distributor is charged by the cloud provider.

    • Resold Cost: The amount the distributor charges its resellers (the current example has no discount exclusions or up-charges).

      Revenue Management - Cost and Cost MSRP

  • Reseller view.

    • Billed Cost: The amount the reseller is charged by its distributor.

    • Resold Cost: The amount the reseller charges the end customer, Customer C in the example.

    • Margin: The reseller's gross margin. Margin = Resold CostBilled Cost

      Revenue Management - Reseller margin

  • End customer view.

    • Billed Cost: The amount the end customer is charged by its reseller.

    • Cost MSRP: The amount the end customer would pay if purchasing directly from the distributor.

      Revenue Management - End customer billed cost and MSRP

Effective Cost

This section demonstrates how to use the Effective Cost metric on end customer reports.

  • The example below compares the Effective Cost and the Billed Cost across different charge categories.

    End customer billed cost and effective cost

  • In the following example, the Tier-3 contract contains custom line items or price book rules that are stored as separate items. For a generated split such as SP/RI +1%, Effective Cost stays with the source row and shows 0 on the generated CustomCharge row.

    End customer billed cost and effective cost - CustomCharge

  • This example filters to the Savings Plan categories to inspect unused commitment and amortized upfront, grouped by day:

    End customer billed cost and effective cost - SavingsPlan

    • The Effective Cost on the SavingsPlanRecurringFee row shows the unused hourly share of the commitment.

    • The difference between the Effective Cost Total and the Billed Cost Total is due to amortized upfront (Partial/All Upfront).

Marketplace transactions

In this example, an end customer user tracks Marketplace transactions using the Host Provider Name dimension.

Revenue Management - T3 Marketplace transactions

A distributor or reseller user can also use Host Provider Name or Service Provider Name to track Marketplace transactions.

The example below is run at the distributor level.

Revenue Management - T2 and T3 Marketplace transactions

External IDs

In the example below, a distributor user segments analytics data using external identifiers along with other dimensions.

Revenue Management - Distributor external identifiers

See also