Reporting Ideas

fivetran · ‎03-09-2021

In every zuora table we have created_by_id and updated_by_id. These technical ids are not very helpful by themselves. However on joining the table with USER table, we are able to identify the users. For our Client's reporting requirement, we will need Status and LastLoginTime from the USER table. This will enable us to: 1. Filter out the rows which are updated/created by Active users. 2. Create a scheduled report on Last login time

tianhuashi · ‎11-30-2020

It'd be very helpful to make Discount MRR available in Zuora reports

ConnorRoebuck · ‎07-07-2020

We have a lot of accounts billed for other account subscriptions. When running a subscription data export, we can only get Invoice Owner ID, and have to do a seperate account data source report to VLOOKUP the account name and number in. Is there a way of including account name and number in the subscription data source, along with the

nicholasuzoni · ‎10-05-2020

It would be beneficial to export all Reporting documents in .xlsx format in addition to .csv Files that are emailed on Schedule Distribution cadences have notable compatibility issues with ETA tools such as Alteryx (Unicode txt).

MariaSuarez · ‎04-23-2020

Hello, It would be great to be able to delete a report created by another user, who is no longer working with the application. The creator user is disabled and the report was create as read-only. Thanks

Rossi · ‎07-09-2020

When running a report in Zuora Reporting tool, the InvoiceItem.UnitPrice and InvoiceItem.ChargeAmount field values are rounded to currency value. The Data Source Export, ZOQL Query, and Data Query does provide unrounded values for those fields. However, some non-technical users do not have access to ZOQL Query or Data Query, therefore, this is the request to enhance the reporting tool to provide unrounded values. The feature enhancement request is currently tracked by ANA-6898.

Owen · ‎05-25-2017

Customer has raised the enhancement request that there should be the ability to get an 'Average Days Outstanding' figure from Reporting rather than having to export data and do the calculation themselves or rely on the 'Aging Buckets' currently in the system. This development would be a useful metric for tracking and forecasting.

MK_STP · ‎01-24-2020

Hey guys, we would appreciate it very much if Zuora gets the ability to run reports on the attached files in subscriptions or other database objects. Would be very helpful in analyzing for ex. all subscription without any attached contract or all accounts without a valid SEPA direct debit mandate or something else. The only way to filter it out at the moment is to create a custom field and enter it manually there for all objects. This is very impracticable in the daily business and not a really good solution for everyone. We would also appreciate it if Zuora gets more logic into the custom fields, like formulas or rollups, like in Salesforce for ex. Best regards, Matthias

PaulShearn · ‎09-04-2017

When making changes to the configuration on Zuora such as setting up accounting periods, I would like to be able to extract the data down to Excel. This would be useful as I am using multi tenants and can then use Excel to quickly check that each tenent is cofigured in the same way.

bsanders · ‎12-05-2016

Currently in the Zuora UI there is a Data Source called Rate Plan Charge which contains summary charge level information such as Charge Name, Quantity, TCV, etc, however there is no Amount / Value field. When looking at the Rate Plan Charges within a Subscription Version there is a Total column which provides a calculated value representative of what the actual invoice charge will be (for Recurring charges), however this field does not exist in the related Data Source. This means that if I wanted to pull a report of upcoming Rate Plan Charges I would be unable to have this value available without exporting the report to excel and then creating a Calculated Field which divides the TCV by the Billing Period / Specific Billing Period, or multiplies the MRR by the Billing Period / Specific Billing Period. It would be very useful to have the Rate Plan Charge Total available as a Data Source / Reporting field

bsanders · ‎11-08-2016

In the old reporting tool there was an option to have 0 or more values per filter and each one would be evaluated based on the filter Operator. This was critical to our business process as each user running a given report has different requirements for what they need in the results. Some users would require the report to provide all data from the system, and some would require anywhere from 1 - 100 filter values. In the new reporting tool the only way to have multiple values per filter is to use the "In" operator which requires an exact match, and if there is a filter a value must be entered to return results. This is a problem when the full value is unknown or if there are no filter values needed. eg. If I have 30 accounts which have variations of the same account name "Spam Eggs and Spam" and another 30 with variations of "Meridian Memories Photography." If I want to pull back all accounts which have "Eggs" or "Memories" in their names I would need to use the "Contains" filter on these words.In the current reporting tool I would be able to add both of these as Filter Values at Run-Time and would get a single report containing all 60 accounts. However since the new reporting tool only allows a single value to be used for the "Contains" operator, these would need to be run as separate reports. Alternately if I wanted to use this same report and return All accounts in the system, I would have no way to do so since if the filter is left blank the report will not return any results and there is no way to omit a filter at Run-Time. Since there is no way to know in advance how many filter values need to be added (or if they are needed at all), we need the ability to either leave the value blank or have multiple values for a filter regardless of the operator type or filter key.

ConnorRoebuck · ‎01-18-2021

Feature: Add the ability to schedule reports based on triggering events as well as time based. E.g: - A completed payment run triggers a report for failed payments - Triggering an invoice report when a bill run finishes processing This would save time continuously checking bill/payment runs for when they complete. It also means the reporting exports can be sent to those on the distribution list, rather than having to export and send manually.

abreen23 · ‎12-02-2020

Currently, the analytics data refreshes daily. In our case, it's in the middle of the day, which isn't beneficial. I would recommend changing this to refresh 2X per day - one at midday and the other around midnight. Often we are making changes throughout the day and I'd like to come in the morning and pull the data set to have a working report rather than waiting for midday for it to refresh with yesterday's data.

Jayaram · ‎10-27-2020

Hello, When a schedule report is completed, for example the report " Accounts with subscriptions to be cancelled in the next 30 days" in Summary Mode, the Output format is Account Number, Account Name, Count Distinct of Subscription ID One the report is completed, a email will be delivered with the The {ReportName} report results are now available. Report Name: {ReportName} Report Date/Time: {DateTimeStarted} Scheduled by: {UserName} The report results are attached to this mail as a CSV file. In Addition to the Above message, can we also print the Output of the Account Number, Account Name, Count Distinct of Subscription ID in the Email Body it self. If not only the result of Count Distinct of Subscription ID In Short, can we print the Output of any Query used in the report in the Email body? Thanks

jalley · ‎05-14-2020

For our AR recon purposes, we need a report that shows all invoice activity. This would include invoice amount, tax amount, payments applied, credit memos applied, to get to the ending balance. The current invoice settlement reporting does not allow credit memos to be added to an invoice report. This makes no sense. We should be able to create a report the properly walks through the beginning invoice amount to the ending balance in a time period.

brzhang · ‎04-27-2020

Right now, there are existing in different data sources. When I tried to use indexes to join the reports together, I cannot get away from duplicated records. Can you add a data source with order quantity and order MRR together? Thanks.

brzhang · ‎04-27-2020

The report formats are actually TSV, when they have the extensions of TSV. This caused issues to use the function Importdata() with Google Sheet. Can you make the format consistent with the file extensions?

brzhang · ‎04-27-2020

For the reports, can you add an option of adding a timestamp to the reports? I am running automatic reporting, and it would be great if I can retrieve the time from the files when the reports are pulled. Thanks.

jlastruck · ‎02-03-2020

When creating a Data Source export, there is no option to filter or search making finding an export difficult if it is not recent and on the first page of exports displayed. Search and filter capabilities would solve this problem

skho · ‎01-15-2020

The concept of Contracted MRR already exists under the Rate Plan Charge architecture. The metric is called CMRR. Conceptually it gives you an insight into MRR + MRR that is contracted to start in the future. This is a great metric, especially for GTM motions where sales bookings are oftentimes many months ahead of start date of the subscription (e.g., Enterprise with ramp deals, or Enterprise with a few months free pilots before start of subscription). CMRR gives you that visibility. The issue today is that 1) CMRR is always a point in time, which makes reporting historical growth and performance extremely difficult, especially for business with Enterprise customers 2) CMRR has the same RPC limitation that cannot factor recurring discounts into the MRR number. Order MRR solves the recurring discount limitation found in RPC architecture, but it doesn't solve the Contracted Order MRR view. All in all, time-series view is still missing. The ask here is this 1) Contracted Order MRR 2) a way to report (natively or through data exports) on snapshots of Contracted Order MRR

Happy Business Starts Here

Vision

Products

Zuora Central Platform

Products

Zuora Marketplace

Solutions

By Industry

By Role

Customers

Resources

Resources

Subscribed

Support

Company

Reporting Ideas

Expose USER.Status and USER.LastLoginTime time in USER table via DataQuery

Make Discount MRR available in Zuora reports

Add Invoice Owner to Subscription Data Source

Reporting export file format .xlsx

Remove a report created by another user

Reporting to display rounded value for InvoiceItem.UnitPrice & InvoiceItem.ChargeAmount

Ability to get 'Average Days Outstanding' on invoices

Reporting on attachments

The ability to report on standing data such as "Accounting Periods"

Need Rate Plan Charge Total added to Data Source

Allow No or Multiple Values for All Filter Operators

Schedule Event Based Reports

Refresh Zuora analytics more efficiently

Summary of the Report results in the Email Body

Credit Memos

Can you have a datasouce with order quantity and order Mrr together?

Can you change the format of reports to real CSV or change the extension to TSV?

Can you add a timestamp to the reports?

Ability to search/filter data source reports

Contracted Order MRR (and a way to see this on a time series basis)

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

Rate plan charge data source modification

DMRC for Remove a Product should show the correct amount