New Idea
0 Kudos
Zuora-Support Community Manager

Community Manager

Hi,

I know we have a report for User list which is good. The other report that should be made available is one that indicates the role and the permission values for what is selected. An example for this would be an OOTB report that pulls all roles and lists out the available permissions and indicates which permissions are selected for each role.

Thanks,

LColeborn Honor Student

Honor Student

We would like to be able to customise the MRR momentum report to add in product information - SKU/rate plan charges etc in order for us to get a deeper understanding & visibility of revenue & churn by product. This will also help with our supplier bill reconciliation and product profitability understanding. 

 

So by month we would know the start MRR, the end MRR, the gains and losses for each product with each customer within the month.

 

The link between Account and product already exists via different data sources but cant be added into this report as it stands 

Status: Coming Soon
0 Kudos
ashwiniy Newly Enrolled

Newly Enrolled

 

 

The field(Invoice Balance Impact) is seen under section 'Transaction(s) associated to this Invoice'. It shows the negative values of the Item adjustments made on that invoice.

 

This Invoice Balance Impact is generated by the internal query system that looks for all payment types tied to the invoice. That is how it generates the "Invoice Balance Impact" column. Unfortunately, this "Invoice Balance Impact" field is not accessible in report/datasource.

 

It would be great to see this field in the reports.

Status: Coming Soon
0 Kudos
Zuora-Support Community Manager

Community Manager

Feature Request: Data Sources and Reporting column should use the same type of name in UI

Reference Number: DE9755

Business Need: in Data Source tab, it displayed the label name, but in Reporting column Selection tab, it displayed the field name. The inconsistant type used may confuse customer.

0 Kudos
vgibilisco New Student

New Student

Can a report be created for foreign currency to include revenue from beginning to today, including the exchange rates and amount in foreign currency and in USD conversion. Currently, the "Revenue over Time" report doesn't convert to home currency.

ashimshock Student

Student

For downstream systems, we need to pull the list/base price information from data exports, while starting at the Invoice Item and IIA level.  While you can join to the product rate plan charge table, you cannot pull any pricing information.  We would need base price info, in addition to any volume or tiered price information.  This is currently a gap for performing downstream calculations in revenue recognition tools.  

0 Kudos
Jim Advanced Tutor

Advanced Tutor

Both theStreet and Return Path have asked for the ability to track and report on whether revenue is from new subscriptions, renewals, or existing accounts.

 

 

Zuora-Support Community Manager

Community Manager

We are creating a report identifying Invoice Owners on Subscriptions. On both the data export and Reports, Invoice Owner shows up as Invoice Owner ID which is a long string of numbers. This string of numbers means nothing to us - we would like to see this field or to add a field that shows the actual account number that is being translated into the Invoice Owner ID. Is this possible? <!--?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-comSmiley SurprisedfficeSmiley Surprisedffice" /-->

For example: an Invoice Owner ID is: 2c92a0fb404190340140496c46531967
When translated into the Account number, the account number is 698

So the only way to translate that Invoice Owner ID so that it is meaningful and useful to us, is we have to pull the export of Customer Accounts and cross reference the ID on that spreadsheet to get the Account Number.

Is there a way you can put Invoice Owner Account Number in the Reports and/or Data Export as well?

0 Kudos
williamliu1 New Student

New Student

Tying usage to revenue

Status: Under Consideration
by New Student williamliu1 on ‎01-23-2017 09:08 AM

------------------------ I was told to post this support ticket question as an "idea" ------------------------

Hi Zuora,

Is there a way to pull a report in Zuora with both usage and revenue?

I was expecting just a simple pull, but actually the usage fields and revenue fields are not available on a single report. Here is the screenshot from the usage report. You can see it has usage and usage rate and usage quantity, but Revenue Schedule Item is only available in a separate file.

Seems like a pretty standard thing to be able to tie usage to revenue but I can’t find it anywhere. This would be a major win/loss in terms of the analysis we want to do so please let me know of workarounds as well.

Thank you,

Bill

0 Kudos
icheung Newly Enrolled

Newly Enrolled

Subscription export: Would like to have datetime data for all date fields that contain time info.

 

Some fields include Created Date, Original Created Date, Updated Date.

MattPicio Partner

Partner

Screen Shot 2016-10-06 at 10.52.34 AM.png

Currently, there is no method in the Data Sources export tool to tell which fields on a given data source are native Zuora fields, and which are custom fields or system fields belonging to Zuora integrations such as Z-Suite.  It would be very helpful if the non-native fields had an identifier at the end of the name - e.g. instead of "ClonedSubscriptionId" in the attached screen shot, it would display "ClonedSubscriptionId (custom)", or even better - "ClonedSubscriptionId (custom, non-indexed)".  Would you please add this feature?  Thanks.

0 Kudos
Zuora-Support Community Manager

Community Manager

Increase the number of batches 20+ or infinite amount of batches

Status: Implemented
by Community Manager ‎01-13-2016 11:26 AM - edited ‎01-19-2016 08:01 PM

Feature Request: Increase the number of batches 20+ or infinite amount of batches

Reference Number: DE8396

Business Need: As businesses grow, a need for more batches for bill runs and payments runs is being requested. Using batches for different lines of business. 

Status: Implemented
0 Kudos
Zuora-Support Community Manager

Community Manager

Add Parent Name to Account Object in DataSources

Status: Under Consideration
by Community Manager ‎01-13-2016 11:26 AM - edited ‎01-20-2016 12:19 PM

Feature Request: Add Parent Name to Account Object in DataSources

Reference Number: DE7951

Business Need: Customers need to group reports by parent name. They can do it by parent id, however this is not a user friendly or easy way for customers to understand who the parent account is.

Zuora-Support Community Manager

Community Manager

"Data source exports pull the Account information associated with the subscription and not the Account information of the invoice owner (if it happens to be different than the account associated with the subscription). In the cases where the invoice owner is a different Account, than the Account associated with the subscription, one can obtain the Account information of the invoice owner by: 

1. Getting a report of the invoice related information

2. Getting a report of all Accounts' information

3. Identifying / pulling the Account information of the invoice owner by matching the invoice owner ID from the invoice report (step #1) with the Account ID from the Account report (step #2)". This can be performed via Excel V-Lookup.

0 Kudos
CecilieS Tutor

Tutor

Bucket Values

Status: Under Consideration
by Tutor CecilieS on ‎09-15-2016 04:41 AM

Hi

 

It could be nice to be able to bucket some of your values to be able to create more readable reports. T.ex products into productfamiliy

0 Kudos
Zuora-Support Community Manager

Community Manager

Aging Report: Credits, USD Values, Collections Team Member, Salesperson, Country & State

 

0 Kudos
Zuora-Support Community Manager

Community Manager

Feature Request: Report that will show New MRR/TCV by account instead of for all accounts

Reference Number: DE8091

Business Need: 

Report that will show New MRR/TCV by account instead of for all accounts since they are trying to match new sales to partners so they can pay the partner a percent of the sales

0 Kudos
bsanders Valued Scholar

Valued Scholar

While there is value in having Summary Reports display in the UI at runtime, Detail Reports are rarely going to be used within the web-browser. This would also avoid the additional steps and time involved with exporting the report. In current functionality when a report is run, only after the web view has been rendered is the option to Export it made available. Depending on the report, its parameters, and result set, this can take a considerable amount of time.

 

It would be very useful to have the option to choose if the report should rendered to the web interface or saved to a file at runtime.

0 Kudos
Zuora-Support Community Manager

Community Manager

To show the total amount paid of customer accounts in one CSV file

Status: Implemented
by Community Manager ‎01-13-2016 11:26 AM - edited ‎01-20-2016 12:26 PM

Feature Request: To show the total amount paid of customer accounts in one CSV file

Reference Number: DE7360

Business Need: Some customers are requesting if they can export one single report from Data Source to show the total amount paid by customer accounts so they can visualize how much revenue each account has generated to a certain date. With this feature, customers can also view which accounts have $0 payment during their lifetime in Zuora.

Status: Implemented
0 Kudos
yuri Tutor

Tutor

Import report definitions

Status: Under Consideration
by Tutor yuri on ‎01-26-2016 08:05 PM

Zuora allows to create custom report definitions.

It's possible to export report definition to rapidReportDesign file, but there is no import functionality.

There should be a way to export custom report definition from one tenant and import it to another.

 

 

Status: Under Consideration

Hi Yuri - in the new reporting redesign that we have been working on, we will have REST APIs that you can use to both retrieve and create new report definitions, giving you the flexibility to import and export from one tenant to another. Let me know if that would help address the need here.