You can click View Metric Definitions at any time to see full descriptions of the metrics detailed within each Oracle Commerce Cloud report. It is worth noting from the onset that the data displayed in the reports are run after a nightly refresh, therefore, orders for the current day are not included.

When viewing reporting data, you should be aware of the following:

Recurring charges

Recurring charges are not included within the reporting data. For example, if a customer has purchased a monthly phone tariff, those associated monthly charges are excluded from the reports.

Definition of Number of Orders Submitted metric

The orders that are defined within the Number of Orders Submitted metric definition include all payments for orders that have been subject to authorization and approval, and successfully processed.

This metric also relates to orders that have been submitted with a Payment Type of Invoice/Purchase Orders and have a status of Deferred.

Product search results are not shown after selecting parent collection filter in the Sales reports

Product results should be shown when a user searches for a product under the leaf collection in the Sales reports. (This is the last collection in the hierarchy of collections.) However, product results are shown only when the leaf collection itself is selected.

Reports reflect current database only

All reports reflect data as it is currently stored in the database. For example, if an order is submitted for Product A but the product name later changes to Product B, the Sales reports are attributed to Product B only.

Reporting Time Zone setting

All data retrieved in your reports is dependent on the Reporting Time Zone setting. This may differ from the time zone for your current location, or if you are running multiple sites from your Oracle Commerce Cloud instance. Once your site has gone live, any changes made to these settings may corrupt your report data.

Tax inclusive/exclusive prices

Reporting data for Full List Price/Gross Revenue can be exclusive or inclusive of tax depending on whether tax has been included in your product catalog. When your product catalog List/Sale prices are inclusive of tax then this is also reflected in your Gross Revenue and Full List Price reports. You will see a note relaying this information within the Gross Revenue and Full List Price Metric Definitions.

Activate tax account to determine tax information

Your tax information cannot be determined if your tax account has not been activated. You must enable your tax account via the Tax Processing menu option within the Settings page.

Multiple payment groups used for an order

Only orders that have had all payments authorised and approved, and successfully processed, are included in the report data.

Multiple billing addresses associated to an order

It is possible to add a single billing address to an order via the storefront.

If data from orders is manipulated in such a way as to have multiple billing addresses via the Agent Application/Order API, then the reporting data will use the first billing address created.

Multiple shipping addresses associated to an order

It is possible to add a single shipping address to an order via the storefront.

If data from orders is manipulated in such a way as to have multiple shipping addresses via the Order API, then the reporting data will use the first shipping address created.

Post-order submission transactions data

Sales data does not include information on any returns or exchanges made for an order. However, any other amendment will be included.

Deleted items

Deleting published items from the system can lead to lost orders and unexpected results.

Manual price override

Any manual price adjustments made within the Agent Application are included within the Sales reports.

Multicurrency

If your store is available in more than one currency (including loyalty points):