You can create and customize summary reports in Zuora Reporting. Summary reports are similar to pivot tables in Excel.
To create a summary report:
- Navigate to Reporting > Reporting, then click Create New Report.
- Select the data source.
- Build and preview the report.
- Run and view the report.
Alternatively, Zuora Standard Reports can be a useful starting point because you can save any Zuora Standard Report with a new name and modify it for your specific needs.
After saving your report, you can schedule report runs. Zuora will deliver updated results to you and your stakeholders.
You can use the Manage Report Runs page to check the status of report runs and download results from completed report runs. Each report run is listed on the Manage Report Runs page for 60 days.
Select the Data Source
Select the data source that best matches the values that you want to report.
For example, if you want to report data about every customer account, select the Account data source. You should not select the Subscription data source, even though the Subscription data source also includes account data, because:
- The Subscription data source only includes account data for subscription owners; the report results may not represent all accounts.
- Different subscriptions can have the same owner; the report results may contain duplicate rows or unrepresentative aggregate values.
To locate a data source on the Datasources page:
- Hover over the data source to see a summary description of the data source.
- Click All to view all the available data sources instead of only the default data sources. Zuora administrators can specify the default data sources.
- Click List View to display a list of available data sources and expand all summaries.
- Search the data source summary descriptions to help you find the right data source fields for your report. Searching will search the name and description of each data source.
Build and Preview the Report
The field list on the left of the report builder displays all objects from the data source that you selected. Click an object name to show or hide the object's fields. For example:
To build the summary report, drag and drop fields from the field list into the following parts of the report:
- Column Groups
- Row Groups
- Value Fields
As you add fields, you will see a preview of what your final report will look like. The preview data is based on sample data from your tenant and is meant to give you an idea of how the report will be structured. The results shown in the preview mode will typically not match the results in your final report.
Fields in Column Groups correspond to nested groups of columns. For example:
Fields in Row Groups correspond to nested groups of rows. For example:
The order of fields in Column Groups and Row Groups determines the nesting of groups in the summary report. For fields in Column Groups, the first field corresponds to the topmost group of columns in the summary report. For fields in Row Groups, the first field corresponds to the leftmost group of rows in the summary report.
For a field in Column Groups or Row Groups, click Settings to specify how the field values are grouped. For example, for the "Account: Account Balance" field, you might want to have two groups: one group for accounts with a balance of less than $1,000 and a second group for accounts with a balance of $1,000 or higher.
The grouping settings that are available depend on the type of field:
Numeric fields - Numeric fields can be configured to use No Grouping, Even Intervals, or Custom Intervals.
When grouping with Even Intervals, you must define the numeric range for the intervals. When grouping by Custom Intervals, you can specify the interval names and customize the start and end of each interval. For example:
Numeric interval grouping causes many queries to be generated for each report. See Notes and Limitations for limitations that apply.
Datetime fields - Datetime fields can be grouped by calendar week, month, quarter, or year. For example:
Value Fields determine which aggregated values are displayed in the body of the summary report. Click Settings to specify how a field is aggregated.
You can aggregate field values in the following ways:
- How much ...? What is the total ...? (SUM)
- What is the average ...? (AVG)
- How many ...? (COUNT)
- How many unique ...? (COUNT UNIQUE)
- What is the least or smallest ...? (MIN)
- What is the most or greatest ...? (MAX)
The following example shows a summary report with "Invoice Item: Charge Amounts" aggregated by SUM:
Subtotals and Rolling Totals
Reporting can display subtotals for each field in Row Groups. For example, in the summary report shown above, the "Total for Enterprise Platform" row contains the subtotals of the field values in the "Enterprise Platform" group.
For a field in Row Groups, click Settings to specify whether the summary report includes subtotals for the field.
If the summary report's columns are a sequence of dates, the summary report can also display totals that rollover from one column to the next. To enable this feature, click Settings at the top right, then select Enable Rolling Totals.
When the rolling totals feature is enabled, the calculation of each column's total starts with the previous column's total. The summary report displays the starting and ending totals for each column. For example:
If the summary report contains row groups with subtotals, the summary report displays the starting and ending subtotal for each row group. For example:
In the above example, there is no Starting Grand Total row and no Ending Grand Total row because the row groups have different currencies.
See Notes, Limits, and Limitations for more limitations that apply to the rolling totals feature.
Filter conditions determine which records are included when your report is calculated. For example, if you are reporting the amount you have billed customers, you should only include Invoices with Status equal to "Posted", not Invoices with Status equal to "Draft".
Filters can be based on static values and conditions. Alternatively, parameterized filters can be set to prompt the user to specify filter values at the time of the report run. Filters on datetime fields can be defined relative to the future date that the report is run.
See Filters for more information.
Run and View the Report
You can save and run the report at any time during the configuration of the report.
To save a report, click Save. When you save the report, you can specify the report name, report description, and the folders to save the report in. After you have saved the report, you can use the Save menu button to rename or move the report. See Folders and Sharing for more information.
To save and immediately run the report, click Save Report & Run. You can also use the Save Report & Run menu button to schedule a run of the report. See Schedule Report Runs for more information.
If you choose to run the report, Zuora displays the final report results based on all the data from your tenant. At the top of the report, Zuora displays the date and time when the report was run (Report Complete) and the number of items in the report results (Total Items).
To rerun the report, click Run Again. To return to the report builder and reconfigure the report, click Edit Report.
To export the final report results as a CSV file, click Export. The rows and columns in the exported CSV file are grouped in the same way as the displayed report results. This results layout is called the crosstab layout. To export the report results as a flat table, select Unpivoted Layout from the Export menu button.
Notes, Limits, and Limitations
If a field has no value, Reporting displays "(none)" in the summary report results. If the value of a field is the empty string, Reporting displays "(blank)" in the summary report results.
The following limits and limitations apply to summary reports:
The time for running a summary report is limited to 1 hour. If the running time exceeds 1 hour, the process will be stopped.
Summary reports are limited to ten dimensions at a time, meaning you can have any combination of column groups and row groups as long as they don't add up to more than ten.
The number of columns is limited to 100. In contrast, the number of row groups is essentially unlimited. If you want to create a summary report with a dimension that has more than 100 values (date and datetime data types can easily reach hundreds of values), you can do one of the following things:
- Make that large dimension a row group.
- Group-by time into years, quarters, months, or weeks if the data type is date or datetime.
- Group-by intervals if the data type is an integer, decimal, or numeric data type.
Only one column group and one row group may use bucketing. Bucketing results from using intervals for numeric, or selecting fiscal years or accounting period fields. The column using bucketing can not have more than ten buckets (intervals).
The total number of queries produced by one report may not exceed 50. The number of queries is not visible in the user interface, but behind the scenes, the number of buckets and groups in columns and rows creates as many queries as the cross product or the number of table cells.
Reports using COUNT DISTINCT can have only one value field and they must have at least one column or row group.
Reports using COUNT DISTINCT do not display subtotals.
Preview for a report is disabled when COUNT DISTINCT is used with date or datetime data types.
The following limitations apply to the rolling totals feature:
The report must have at least one field in Row Groups, exactly one field in Column Groups, and exactly one field in Value Fields.
For the field in Value Fields, the only supported aggregation is SUM.
The field in Column Groups must be a date or datetime field and must be sorted in ascending order.
There can be at most one filter on the field in Column Groups and the supported filter conditions are "is during", "is greater than" and "is greater than or equal to". Using OR to join filters is not supported at this time.
Rolling totals are not influenced by data that is not included in the report. This means that the ending total of the first column is equal to the sum of the values in the first column.
Rolling totals are not calculated across different currencies. For example, if the fields in Row Groups are "Account: Name" then "Account: Currency", rolling totals are not be calculated because each "Account: Name" group could contain values in several different currencies.
However, if the fields in Row Groups are "Account: Currency" then "Account: Name", rolling totals are calculated for the "Account: Currency" groups.
The Days Overdue field cannot be used as a value field in a report.
If your organization uses Zuora Multi-entity, each report represents data from the entity in which you created the report. It is not possible to create a report that represents data from multiple entities in your multi-entity hierarchy.