Overview
Cloudmore gives you two ways to get at your data: reports you export or have delivered on a schedule, and charts you read on the platform.
This guide covers each report, where it lives in 5.0, and what it tells you.
Overview of Available Reports
|
Report and level |
What it tells you |
|---|---|
|
Billing Report Broker Organization Seller |
Total billing across services and organizations for a period. |
|
Subscriptions Report Broker |
A snapshot of subscriptions as they stand. |
|
Renewals Report Broker |
Upcoming renewals across all subscriptions. |
|
Consumption Report Organization |
Azure consumption usage over a period, per organization. |
|
Microsoft Reconciliation Broker |
What Microsoft billed against what Cloudmore recorded. |
|
Audit Log Broker Organization Seller |
What happened on the platform, and when. |
Reporting Permissions
Running an export
Anyone who can open a report page can create a new export immediately. There is no separate permission for exporting.
The file is emailed to the recipients you choose, and it also appears on the Export history tab of the same report, where you can download it straight away without waiting for the email.
Every export is an .xlsx file. Every report has an Export history tab.
What each role receives
A report is not the same file for everyone. What a recipient gets depends on their own role, not on the role of the person who created the export.
|
Role |
Fields |
Organizations |
|---|---|---|
|
Broker admin roles |
All fields |
All organizations, unless the sender selected specific organizations |
|
Key Account Manager |
All fields |
All assigned organizations, unless the sender selected specific organizations |
|
Sales Agent |
All fields except Cost and Margin |
Assigned organizations only, unless the sender selected specific organizations |
Organization selection rule: Each recipient receives data according to their own role. A broker admin receives the full broker report, and a Key Account Manager receives all organizations assigned to them. If the sender, in any role, selects specific organizations for the export, that selection narrows the organization scope for every recipient.
Why one export can produce several files
When an export goes to recipients who receive different versions of the report, each version is generated as its own file, and each file gets its own row in the Export history. Nothing is generated that cannot be accounted for.
Because Key Account Manager and Sales Agent files are limited to their assigned organizations, two recipients in the same role can still receive different files. Recipients who receive an identical file share one row.
Who sees which exports
-
Key Account Managers and Sales Agents see only their own exports in the Export history. That includes exports someone else created for them, which do appear.
-
A Key Account Manager or Sales Agent can create an export for a broker admin, but will not see that file in their own Export history. The broker admin still receives the full report, according to their own permissions.
-
Broker admin roles see every export.
This keeps the reduced versions of a report separate from the full ones, so a role without access to cost prices and margins cannot reach a file that contains them.
Downloading from the email
The download link in the email requires signing in to Cloudmore first.
Recipients do not have to be Cloudmore users to be sent a report, but they do need an account before they can open the link. If you are sending to someone outside the platform, create their account first.
Billing Report
The total billing across all services and organizations for a selected period. This is the report most brokers run most often.
Navigation and permissions
Broker level: Reports > Billing Report
Organization level: Reports > Billing Report
Seller level: Reports > Billing Report
-
Full access: Super Admin, Global Admin, Global Billing Admin
-
Full access (assigned organizations): Key Account Manager, Limited Key Account Manager, Sales Agent
-
Read only: Global View Only Admin
-
Read only (assigned organizations): Key Account View Only Manager
In 5.0 this is one page with four tabs, rather than the separate screens it used to be.
|
Tab |
What it does |
|---|---|
|
View |
The billing lines on screen, filtered by date range, organization and service. Export them from here. At broker level this tab also carries Import billing lines. |
|
Export |
Build a one-off report and send it by email with Send billing report. Reset clears the selection. |
|
Schedule |
Recurring delivery. Create schedule sets up a report that arrives by email on its own, without anyone running it. |
|
Charts |
The same billing data as a visual overview, with its own filters and a download control. |
At seller level the Billing Report has two tabs only, View and Export. There is no Schedule or Charts tab.
[SCREENSHOT] Reports > Billing Report, the View tab with filters applied.
Subscriptions Report
A snapshot of your subscriptions at the moment you run it, across services and organizations.
Broker level: Reports > Subscriptions Report
Not yet rebuilt in 5.0. The menu entry is in place and opens the report on the previous platform.
[SCREENSHOT] Reports > Subscriptions Report.
Renewals Report
The upcoming renewals across all your subscriptions, so you can see what is due and when.
Broker level: Reports > Renewals Report
Not yet rebuilt in 5.0. The menu entry is in place and opens the report on the previous platform.
[SCREENSHOT] Reports > Renewals Report.
Consumption Report
A detailed summary of Azure consumption usage over a period, for one organization. Previously called the Azure Usage Report.
Organization level: Reports > Consumption Report
Not yet rebuilt in 5.0. The menu entry is in place and opens the report on the previous platform.
[SCREENSHOT] Reports > Consumption Report inside an organization.
Microsoft Reconciliation
Reconciles what Microsoft billed against what Cloudmore recorded, so you can find and explain the differences.
Broker level: Reports > Microsoft Reconciliation
[SCREENSHOT] Reports > Microsoft Reconciliation.
Audit Log
Where you check what happened on the platform and when. Each tab filters by date range and exports.
Broker level: Reports > Audit Log
Organization level: Reports > Audit Log
Seller level: Reports > Audit Log
-
Events Log - platform activity, filtered by event category, level, service and the user who acted.
-
Provisioning Log - what was provisioned against which service.
-
Message Log - notifications sent, with status and notification type. This is where a billing report you sent or scheduled shows up.
-
Feedback Log - seller level only. It does not appear at broker or organization level.
[SCREENSHOT] Reports > Audit Log, the Events Log tab.
Charts and dashboards
The Billing Report Charts tab is the visual view of your billing data, with the same filters as the rest of the page.
The broker Dashboard has charts for total active subscriptions, created subscriptions, and active versus inactive organizations.
The Subscriptions Report and the Renewals Report are two separate reports under Reports. The Renewals Report can be scheduled.
At seller level, Invoices and Credit Card Transactions are being retired rather than migrated. See Known Issues and Bugs.