Supplementing the standard Zuora MRR that does not include discounts in the calculation, this report includes the impact of discounts at the subscription level and rate plan level. For example, if a 10% discount is applied to a rate plan on a $100 charge, the reported MRR value is $90.

This feature is deprecated and is not enabled by default. Contact Zuora Global Support to enable this feature in your tenant.

Report Description

Each row represents an account's MRR value over a specified timeframe. Each time column represents the MRR value starting as of the duration start date. The next set of columns represents the MRR value as of the first day of each period. For example, such as:

First day of the week

First day of the month

First day of the quarter

The last column is the MRR value as of the duration end date.

The following shows the MRR values viewed by month, for last 12 months (click image to see a larger view).

Limitations

Account-Level Discount

This report does not support account-level discounts. If an account has account-level discounts, the reported MRR value is the full MRR value - the impact of the discount is not factored in.

Data in Inactive Account

The MRR Trend report will not include any data from the account that is in Inactive status.

Export File Size

The maximum export file size is 2047MB. If you have large data requests that go over this limit, you will get the following 403 HTTP response code from Zuora: <security:max-object-size>2047MB</security:max-object-size>

We can work with you to determine if large file optimization is an option for you.

How to Filter and Export MRR Data

The selected View By period and the timeframe determines the MRR data that is exported to a .csv file for further analysis. The exported report is saved as a .zip file. The downloaded and unzipped file uses the following naming convention: MRRTrendReport_20150407201650, where 20150407201650 is the year, month, day, and time the export was created.

Navigation: Reporting > Exports​

Do the following

Select MRR (As of Day) Trend from Export Data drop-down.

Select your filters:

Group By: Account (only option) controls

View By: Week, Month, or Quarter

Specify the start and end dates for the Time Frame Duration.
The timeframe you can specify is based on the selected View By period:

Week: Up to three months, where Sunday is the start of a seven day week

Month: Up to one year

Quarter: Up to three years
If you must export data beyond these timeframes, run several exports with different start and end dates to cover your required reporting ranges.

Export.

View by Week Example

For example if viewing MRR by week from July 8, 2015 to October 8, 2015, the time period columns represent the MRR values as follows:

Time Period Column

MRR as of

Example

First Column

Duration Start Date

7/8/15

Middle Columns

First Day of the Week

7/12/15, 7/26/15, 9/27/2015, 10/4/2015

Last Column

Duration End Date

10/8/2015

View by Month Example

For example if viewing MRR by month for the last 12 months, the time period columns represent the MRR values as follows:

Time Period Column

MRR as of

Example

First Column

Duration Start Date

10/8/2014

Middle Columns

First Day of the Month

11/1/2014, 12/1/2014, 1/1/2015

Last Column

Duration End Date

10/8/2015

View by Quarter Example

For example if viewing MRR by quarter for the last 12 months, the columns represent the MRR values as follows:

Time Period Column

MRR as of

Example

First Column

Duration Start Date

10/8/2014

Middle Columns

First Day of the Quarter

11/1/14, 2/1/2015, 5/1/2015

Last Column

Duration End Date

10/8/2015

Export Column Descriptions

Column

Description

Account Number

The unique account number assigned to the customer account on creation.