Creating Valuable Reports in Omnia

In this section we will share some inspiration, showing you how to create a few of the most popular and helpful reports made in Omnia.

Minimum Price in Market Below Purchase Price

One helpful report for buying teams in particular is a report that will produce the products being sold on the market for a price that is less than your own purchased price. This gives transparency across your organization as to how products are being priced by competitors in relation to the deals your buying team are getting from manufacturers or wholesalers.

DATA REQUIREMENTS:

1. EAN/GTIN
2. Purchase Price field
3. You must have a data source that gives a complete market view such as Google Shopping, comparison sites, Amazon, etc.
   You can also achieve a similar report for selected competitors via the use of direct scraping data
4. *Optional* ‘Supplier’ field to designate which supplier (if different than brand)

 

 

The most important output of this report is the field ‘Minimum price in the market price with 0% margin’ as this will then list the intended products you want to see.

For ‘Minimum price in the market < price with 0% margin’ you can see the formula used above, however the output can be changed to any text/number you want in this report, especially if you have a system that will pick up these values. If you need the field to say “yes” instead of “1” if true, then simply replace the intended outputs in that part of the formula similar to how you would in a formula in excel.

USE FILTERS TO GET PROPER DATA

In addition to field mapping, you’ll want to utilize the filter section to get the correct data outputs. Without the filter in this report, you will receive a full list of your EANs (which is also okay if you want to filter data in excel or your BI program).

Outlier report

A recommended report is an outlier report that monitors daily product price changes. The dynamic pricing module of Omnia constantly generates price advice. In this report, the price advice is benchmarked against yesterday's selling price of a product. Outliers or large price changes are identified, filtered, and sent in the report.

Since you do not want to automate pricing adjustments that differ largely from day to day, this report is useful to keep an eye on.

DATA REQUIREMENTS:

1. EAN/GTIN
2. Price Advice
3. Price difference formula

You need to apply a filter to only include the products with a price difference higher than a certain percentage. In the case below products with price differences larger than 20% compared to yesterday will be included in the report and could be monitored.

The IF-statement in the filter states that IF the price advice increased or decreased by 20% compared to the selling price of yesterday, THEN the product needs to be included in the report. All products with price differences lower than 20% will not be included in the report.

 

Mapping & Filter: 

 

 

Selling Price Above Average Price for products with a lot of other sellers

Another recommended report is one that monitors your selling price and the average of the market, especially for products with a lot of other sellers in the market. With this information you can decide to lower your selling price to achieve an competitive advantage. 

DATA REQUIREMENTS:

1. EAN/GTIN
2. Selling Price
3. Average Price
4. Number of Offers

The IF-statement will give a true of false in case your product is above average. 

 

Mapping & Filter: