Skip to main content
Select Reports in the Insights group of the sidebar (/reports). Reports is where you run the standard report library, schedule reports for email delivery, collect finished files, and build custom reports and dashboards for your customers’ portal.

Tabs

Custom reports only appears when your role includes the custom reports permission. Dashboards and Custom measures need the dashboards permission.

Library

The Library tab lists the reports available to you under Available reports. Each card shows the report’s name and description, a Parameters Required chip if it needs filters, and Run and Schedule buttons.
UMS Reports page listing available pre-built reports

Standard report catalogue

The reports under Brokerage only appear when your role includes the brokerage module. Automation Activity needs the automations module.

Agreements

Connections and data health

Consumption

Invoices and spend

Brokerage

Automations

How a run reaches History

Every run is queued and generated in the background.
  • Some reports open a full page with the report’s own filters, Saved presets, and Generate report. Submitting it takes you straight to History.
  • Other reports open a Generate Report dialog with the report’s parameters. Invoice Batch Export opens its own form instead. Submitting closes the dialog.
Either way, the run appears on the History tab as Pending, then Completed or Failed. You get a notification when it’s ready.

Schedules

The Schedules tab lists recurring schedules in a grid: Click Create Schedule to add one. The form asks for:
  • Schedule Name and Report
  • Report Parameters, where any date field can Use Relative Date (for example Previous Month or Since last successful run) so each run covers a fresh period
  • Output Format: CSV, Excel (XLSX) or JSON
  • Recipients: the Email Addresses that receive the file
  • Schedule Configuration: Frequency, Time, and the Day of Week, Day of Month or Month the frequency needs
  • Enable Schedule
Clicking Schedule on a Library card opens the same form with the report already chosen. Scheduled runs of standard reports also land in History.

History

The History tab lists every run, newest first. Filter it with the search box (report name or user), Status (All, Completed, Pending, Failed) and From / To dates. Each row shows the report, who requested it and when, the file format, and its status. A failed run shows its reason. Row actions:
  • Download the file
  • View in browser (CSV only) to preview the rows, with a Download button
  • Retry this report, where a failed run can be retried

Custom reports

The Custom reports tab holds tabular reports you design and publish to your customers’ portal. The grid shows Name, Source, Status, Audience, Template and Updated, with Duplicate and Delete row actions. Status is Draft, Published, or Draft differs from published (published, with edits not yet published).
1

Create the report

Click New custom report, enter a Name, and choose Blank report with a Source (what one row of the report is) or Start from template. Click Create.
2

Add columns

Click Add column. Each column is a Source field, Measure, Attribute, Formula or Text template, with a Header label and Format. The Preview panel updates as you go.
3

Set the audience and filters

Choose the Audience accounts. Portal users of these accounts, and of every account beneath them, can run the report once published. Click Settings for Report filters, Filters viewers can change (Period, Account, Site, Connection, Utility, State, Site tag), grouping, sorting and totals.
4

Publish

Click Publish. After later edits, click Publish changes. Unpublish takes the report out of the portal straight away.
Export downloads the report as Excel (XLSX) or CSV. Once a report is published to at least one audience account, Schedule sends it to recipients on a schedule for one of those accounts.