Knowledge Center

Knowledge Center > Reporting > Quick Reference > Reporting Overview > D Data Sources and Exports > Data Exports > MRR Trend Export

MRR Trend Export

The MRR Trend Report provides as-of-date monthly recurring revenue (MRR) data.

View MRR data by weekly, monthly, or quarterly periods over a specified timeframe. Export this report to analyze the past, present, and future MRR trends, net of discounts. 

Monthly recurring revenue (MRR) calculates subscription recurring fees normalized to a monthly value.

See Monthly Recurring Revenue for information on how MRR is calculated.

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 in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support

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).

MRR Trend Export  Filtered by Account and View by Month for the Last 12 Months

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. 

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>

Submit a request at Zuora Global Support if you require additional assistance.

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

Filter and Timeframe Options for MRR Trend Report

Do the following
  1. Select MRR (As of Day) Trend from Export Data drop-down.
  2. Select your filters:
    • Group By: Account (only option) controls
    • View By: Week, Month, or Quarter
  3. 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.
  4. Export. 

View by Week Example

Detail View By Weekly MRR Trend Report

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

Detail View By Month MRR Trend Report

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

Detail of View By Quarter MRR Trend Report

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.
Account The name of the customer account.
Currency Code The currency code associated with the transaction.
Date Columns (MRR values) The reported MRR values in these columns are as of the date specified in the column headings. The dates and the timeframe will vary based on the View By filter and Timeframe you select when exporting.
Last modified
21:04, 14 May 2017

Tags

Classifications

(not set)