Happy Business Starts Here

Zuora Alumni

Plans for expanded standard reports

Hi all - we have received a lot of great feedback over the past few weeks. As part of our response to that, we are planning to significantly expand the list of standard reports that are available and also improve how our standard reports are organized. Below is the updated structure and list of reports. Thoughts welcome.


Some quick notes:

* Since we are adding a lot of content, we are introducing another level of organization. For each area (booking, billing, cash, and revenue), there are three subcategories:

-- Outcomes - these are reports that capture the top level business outcomes.

-- Drivers - these provide several different breakdowns of the top level metric and give you a means of figuring out why the top level metrics may be good or bad or what may be driving them to go up or down.

-- Actions - these are typically lists of items where some action should be taken. For instance, it might be a list of subscriptions coming up for renewal or a list of accounts whose default payment method is expiring soon.

* We are not planning to remove any existing reports as part of this. This is about reorganizing and adding rather than removing. I am tagging each report below to indicate whether it is net new, has a new name, or already exists.

* We plan to add more to this list in the coming months as we further expand the types of metrics that you can calculate in Zuora, so please view this as a starting point.

* If any of the report names below are ambiguous, feel free to ask questions about them below.


Hopefully this will be a helpful addition that accelerates reporting and analysis.



* Outcomes

-- Total MRR [New]

* Drivers

-- Cancelled CMRR [New]

-- Cancelled subscriptions [Formerly 'Churned Subscriptions']

-- MRR by account [New]

-- MRR by product [Formerly 'Today's MRR by product']

-- New CMRR [New]

-- New subscriptions [New]

-- Subscription changes [New]

-- Subscription retention by cohort [New]

-- Subscription term length [New]

* Actions

-- Accounts with subscriptions to be cancelled in the next 30 days [New]

-- Accounts with subscriptions up for renewal in the next 30 days [Existing]



* Outcomes

-- Gross billing over time [New]

-- Invoice item adjustments over time [New]

* Drivers

-- Billed usage over time [Formerly 'Billed usage over time without tax by UOM']

-- Gross billing by customer account over time [New]

-- Gross billing by product over time [Formerly 'Gross billing over time without tax']

-- Invoice item adjustments by cusotmer account over time [New]

-- Invoice item adjustments by product over time [Formerly 'Invoice item adjustments over time']

-- Invoice item adjustments by reason code [Existing]

-- Raw usage over time [New]

* Actions

-- Draft, cancelled, or error invoices [New]

-- Unprocessed usage [New]



* Outcomes

-- Payments over time [Existing]

-- Refunds over time [Existing]

* Drivers

-- Invoice aging [Existing]

-- Payment errors by error code [Existing]

-- Refunds by reason code [Existing]

-- Successful and failed payments [New]

* Actions

-- Accounts with expiring credit cards [New]

-- Accounts with largest outstanding balances [Existing]

-- Accounts with recent payment errors [Existing]

-- Accounts with unused credit balances [New]

-- Invoices with negative balances [New]

-- Longest outstanding invoices [Existing]



* Outcomes

-- Deferred revenue [New]

-- Recognized revenue [New]

* Drivers

-- Deferred revenue by accounting code [New]

-- Deferred revenue by charge type [New]

-- Deferred revenue by customer account [New]

-- Deferred revenue by product [New]

-- Recognized revenue by accounting code over time [New]

-- Recognized revenue by charge type over time [New]

-- Recognized revenue by customer account over time [New]

-- Recognized revenue by product over time [Formerly 'Recognized revenue over time']

* Actions

-- Undistributed unrecognized revenue [New]

-- Current accounting period revenue details [New]


Look forward to your thoughts.


Re: Plans for expanded standard reports

Looks great, I'll share with our teams to get their feedback; but of course the first question will be your least favorite... whats the timeline for these new reports to go live ;-)

Valued Scholar

Re: Plans for expanded standard reports

A lot of these are reports we are currently using GoodData for, many of these new reports would help us reduce reliance on an outside reporting solution that has the added complexity of an ETL process to get data out of Zuora and into GoodData.

Zuora Alumni

Re: Plans for expanded standard reports

Thanks, @feisley and @rlaker.


Jacob - we're aiming to deploy these updates next month.

Savvy Scholar

Re: Plans for expanded standard reports

Any plan for a report simliar to the " Summary of Monthly Recurring Revenue (MRR) and Total Contract Value (TCV) of new subscriptions by month and sales rep." that is in the old reporting platform?


Zuora Alumni

Re: Plans for expanded standard reports

@BrianHarris - today, you could show MRR for a single month and group that by sales rep. Are you looking for that or do you want to see the evolution of MRR over time within a single report?


If it's the latter, then that's one of the things that we'll be working on in this next phase of our reporting project. We want to replicate that capability to see MRR over time and also provide more flexibility in how you can do that (e.g., more options for how you can filter and group the results).

Savvy Scholar

Re: Plans for expanded standard reports

i'm looking for the latter. good to hear it's on your radar

Zuora Alumni

Re: Plans for expanded standard reports

Got it - thanks, Brian!


By the way, the standard reports above should now be released in our sandbox environment.

Valued Scholar

Re: Plans for expanded standard reports

What's the status on the trend reporting functionality? You mentioned coming in a future release. Being able to look at things on a trend basis is essential to our reporting needs to internal and external stakeholders.

Zuora Alumni

Re: Plans for expanded standard reports

Yes, with the roll-out of the new reporting solution now mostly complete, enhancing MRR reporting (breaking down changes and trends) is our primary focus right now.