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.
- Purchase Price field
- 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
- *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).
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.
- Price Advice
- 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:
Out of stock products with pageviews report
Another recommended report is one that monitors pageviews of a product in combination with your stock level and sales. When you set up a Google Analytics API connection with Omnia, data on unique page views per product detail page can be imported into Omnia. In combination with the stock level data and unit(s) sold of a product that you can import into Omnia, this report can be used to identify high runners you might not be aware of, as they are not actually generating sales.
As a commercial organization, you don’t want to miss out on sales due to missing stock, especially when this product receives unique pageviews, has been sold often in the last weeks, and consumers are interested to buy. Therefore, this report can be used to keep an eye on products that are out of stock, though they receive pageviews. These specific products can then be prioritized internally to predict sales, keep stock levels up to date or to increase the speed of supply.
- Pageviews - [number of unique page views of product detail page last 4 weeks]
- Sales - [Omni-channel units sold in the last 4 weeks]
The IF-statement in the filter states that IF the stock of a product is equal to zero, THEN include this product in the report.
Mapping & Filter: