Learn about additional filter options to refine reports ever more.
Contents
We want users to be able to create reports that are as specific to your needs as possible. For this reason we have additional filtering options that can be utilised to create bespoke reports. The below instructions will guide you through the different ways you can filter and refine your reports.
What you need:
-
Access to the Acuity Pricing Platform and reporting suite.
-
Knowledge on how to create a standard Acuity Pricing Report.
Refining by Attribute
If the category you have chosen from within the Categories selector is associated with any attributes (Acuity Pricing or client specific), these will show here. Attributes are only available in this feature when the selected categories share attributes.
Refining by Product
- If you wish to only look at a smaller section of SKUs, use the Product selector to pick the products required.
- The Product Name or EAN text box allows you to write in your desired item's barcode.
- Filter down the SKUs you are shown in the analysis by their product volume using the Volume Filter.
- You can filter SKUs shown in the analysis by their price using the Price Point boxes.
- Select ‘matches in all selected retailer’ to only show products available in all selected retailers within the analysis, or ‘matches in any selected retailers’ to show products that have a match in at least one retailer.
Refining by Price
- Price Measure Tab: refine by either Unit Price (the price for one item regardless of volume) or Volume Price (adjusted to show the equivalent price per litre or per kilo.)
- Ratio Adjustment: Options to show the pricing based on individual retailer volumes.
Off - prices as scraped from the website. Product Volume - prices adjusted to meet the volume of the parent product within a set tolerance. Retailer Product Volume - prices are adjusted to meet the volume of a specified retailer within a set tolerance. - Normalisation: Options to select how the winning datapoint is determined when a selected retailer contains multiple regions or data collection points.
Most Recent Mode uses last seen dates to ensure the most recent data is used in analysis.
Most Common establishes the most common price across all the regions.
Prioritise Default uses anonymous and national data collection points where a price is available.
Refining by Stock Status
- Choose whether to exclude products that were either in stock or out of stock on the last day of the analysis period.
- Use the For entire period option if you would rather not see out of stock items at all. For example, this means that even if the item was out of stock for just 1 week of a 4-week selection it will not show at all.
- The Stock Status Type hides data from a selected retailer that doesn't match the stock selection. Exclude product removes the entire product row from the report if the stock selection is not matched in one or more selected retailers.
Download Instructions
Download these instructions for future use by clicking here.