Skip to main content

Reporting on MRR and TCV

Zuora

Reporting on MRR and TCV

Reporting on Current MRR

Zuora Reporting provides standard reports that report the MRR as of today. The standard MRR reports include Total MRR, MRR by account, and MRR by product. You can find these reports in the Booking folder within Zuora Standard Reports. See Standard Reports for more information.

Each of the standard MRR reports is based on the Rate Plan Charge Data Source. You can edit these standard reports to change the object that MRR is reported by, or to change the point in time that MRR is reported as of. To change the object that MRR is reported by, specify a different field in the Row Groups section:

reporting_mrr_product.png

For example, replace Product: Name by Subscription: Name. You can specify any dimension available in the Rate Plan Charge data source.

Reporting on MRR at Any Point in Time

You can report on MRR at any point in time by editing one of the standard reports in the Booking folder. To report on MRR as of a particular date, edit the filters of the standard report, then change the filters for Rate Plan Charge: Effective Start Date and Rate Plan Charge: Effective End Date.

For example, to report on MRR as of 10/1/2016, replace:

reporting_mrr_before.png

by:

reporting_mrr_after.png

Reporting on Current TCV

You can use the Rate Plan Charge Data Source to determine the current TCV for each of your accounts or products.

  1. Create a report based on the Rate Plan Charge Data Source:

    reporting_rate_plan_charge.png

  2. Specify Row Groups, Value Fields, and Filters:

    reporting_tcv.png

     You can group the report by any dimension available in the Rate Plan Charge data source, including Product: Name, Account: Name, Subscription: Name, Product Rate Plan: Name, and so on.