Reporting Ideas

tanayj · ‎04-17-2018

Currently the datasource export of Currency field on Account object returns the Currency Description (Ex."US Dollar"). This should either return the Currency ISO code (so that it is consistent with the API and reports export, which provides the currency ISO code), or there should be another field available for Currency ISO code.

Stephanietang · ‎07-12-2019

How do you report on emails that have bounced?

ashimshock · ‎08-24-2016

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.

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

Zuora-Community · ‎01-13-2016

There is an obvious operator missing from the filters in the export data sources functionality. While it is possible to filter a list by a LIKE operator, there is no NOT LIKE operator. Thus if I want to export all subscriptions that start with "NF" I can do a filter "LIKE NF%" but if I want all the other subscriptions i.e. the ones that don't start with NF, I don't have a way of doing that. So, can we please have a NOT LIKE operator on the filters...

Emmanuel · ‎11-26-2017

Hello! I often run reports to check for erreurs... and usually everything goes fine, and hence the reports just come empty. When errors do occur, the report lists the items I should double check or fix. Today, there's no way NOT to send empty reports... which in my situation would be useful... That's would be a good addition I believe, a checkbox 'Only send if no empty' r something similar... Thanx! -e

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.

Zuora-Community · ‎01-13-2016

Feature Request: Allow ability to combine different data source objects together freely Reference Number: DE9569 Business Need: Current behavior is that export ZOQL has pre-joint objects, some customers want the ability to combine them in a way as they want and do not want to be limited by those pre-joint objects.

vmanie · ‎04-06-2016

The MRR (As of Day) Trend report is great, except that it pulls MRR on the first day of each month (unless I pull 1 month at a time). Can this be adjusted to pull on the last day of each month for the designated range instead of the first day? This would be extremely helpful, and I can't imagine it would take a lot to make this change.

TraciLowry · ‎03-24-2016

Zuora should have a way to report in a base currency with pre-defined exchange rates (e.g. aging report in US dollars, converting Canadian dollar invoices into US dollars for report purposes). At this time, there is a third party offering some client's don't need. We need a static.

steve · ‎11-18-2019

would be great to have reporting to audit all communications/notifications sent from Zuora. thanks!

LColeborn · ‎05-08-2017

We would like to be able to customise the MRR (Contracted) Reports 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

peterwalsham · ‎04-07-2017

Currently the reporting options only allow for Calendar Year and Calendar Quarter. Financial Year and Financial Quarter options would also be extremely useful. We end up creating many reports by month, exporting to spreadsheets and then manually summing over the financial year and quarter periods. Financial periods in reporting would remove a lot of this extra manual work! Related to request for " Biannual / Half Year option for reporting - not just Year or Quarter " https://community.zuora.com/t5/Reporting-Ideas/Biannual-Half-Year-option-for-reporting-not-just-Year-or-Quarter/idi-p/12942

Zuora-Community · ‎01-13-2016

I've already submitted this as a request. It's logged under PMT-1751 Summary of the enhancement? Data is not stored consistently in Zuora. A field that has a NULL value in it when the record is created will be changed to empty string '' when that record is updated via the Zuora UI even if that field's value isn't explicitly being changed. What is the business problem? The problem with this data inconsistency is that ZOQL treats NULL and '' as distinct values (which is fine, although Salesforce treats them as the same in SOQL). We have custom integrations with Zuora that use the SOAP API to make ZOQL calls and it makes it difficult to find records in the Zuora database when we are looking for records with "empty" values (NULL or ''). Since the ZOQL language is also limited with it's ability to use AND and OR statements together we end up having to make 2 separate calls. One to find records meeting a certain criteria and with a NULL value in a particular field and then another almost identical call but with '' in that particular field. What is the business impact? We have to implement inefficient code to find the records we are looking for. Is there a workaround or is the customer blocked? If there is a workaround, what is it? Is the customer willing to apply this workaround? The workaround currently is to have two different ZOQL calls. What is the proposed solution (if available)? A solution would be to treat NULL and '' as the same value in ZOQL queries (or perhaps have that be an option to choose in the QueryRequest) or to preserve NULL values when records are edited through Zuora UI.

Zuora-Community · ‎01-13-2016

Feature Request: Add the ability to query MRR of a past day Status: Currently being reviewed by our Product Management Reference Number: PMT-1317 Business Need: Currently Zuora can only support getting "Today's MRR" with the query like "RatePlanCharge: ((Subscription.Status = 'Active' and RatePlanCharge.EffectiveStartDate <= '2013-05-20') and RatePlanCharge.EffectiveEndDate >= '2013-05-20') ". Customer wants the a bility to query Zuora for MRR in the past, not only for MRR of the day. And at any level, from invoice item up to account level or Zuora instance level. Because according to our customers, MRR is a key metric and it is essential to be able to analyze it over time, not just today's snapshot. C ustomers expect that such metric information is part of Zuora's core capabilities.

peterwalsham · ‎11-01-2016

There are multiple reporting features where you can choose to group by time period. A Biannual / Half Year option between Year and Quarter would be great. Use cases include: Reports where there is too much variation at quarterly level, but an annual grouping would not give enough detail Sales or Customer Success targets that are measured twice a year

Stephanietang · ‎08-23-2019

We currently have the option for 'Invoice: Last Emailed Sent Date," can we also have a field for: First Emailed Sent Date? I want to be able to identify when invoices were first sent from a Bill-run. Let me know if there are any work arounds.

Zuora-Community · ‎01-13-2016

Include USD, currency conversion date, and home currency, to the out of the box Aging report. The client needs an aging report that includes both the home currency of the account as well as the USD amount (since they track everything in USD at the GL level).

twest · ‎03-24-2017

I see the Staus field in the Product Page w/in the Product Catalog. I can even sort the product catalog on this field values (active or cancelled). So, this should be added to reporting. The start/end dates are a way, but not as straight forward

skennedy · ‎03-22-2017

how do you manage people who are subscribed to reports? specifically - if they leave the company - how can i easily see a list of all reports that that person was subscribed to, so i can then remove them from the sceduled report.

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

Ability to export currency ISO code as part of datasource export

Reporting on Emails that have Bounced

Provide the ability to pull list/base price info into Invoice Item and IIA Data Exports UI

Reporting on attachments

Add "not like" operator to data source filters

Ability to send scheduled report by mail ONLY if these are not empty

Ability to get 'Average Days Outstanding' on invoices

Allow ability to combine different data source objects together freely

Customize MRR (As of Day) Trend report

Reporting Currency

Enable reporting on email notifications sent from Zuora

Customise MRR (Contracted) Reports to include product sku/rate plan charge

Financial Year and Quarter options in reporting

Be consistent with use of NULL values. Don't replace NULL with '' upon save from UI.

Add the ability to query MRR of a past day

Biannual / Half Year option for reporting - not just Year or Quarter

Reporting on 'Invoice: First Email Sent Date'

Include USD, currency conversion date, and home currency, to the out of the box Aging report

Please add Product Status to Reporting Tool

Managing Subscribers on a scheduled report

Additional contact information for canned report in Z-Reporting (Invoice Aging)

Add Tax Reporting that shows the items State Tax, County Tax, City Tax and Sold to fields

Ability to calculate the revenue generated so far in the month at month end without actually generat...