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 deprecated and is not enabled by default. If you need to get insights about your subscription businesses, Zuora recommends Zuora Analytics. For details about Zuora Analytics, see Analytics overview.
This feature is unavailable if you have the Orders or Order Metrics feature enabled. See Order Metrics for more information.
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>
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
Procedure
- 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. |
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. |