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 Cost − Billed 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​