126
Introduction:
Understanding the column headers in the Price Watch Macros report is crucial for interpreting the data accurately. This guide provides clear explanations of each column and its meaning within the report.
Price Watch Macros Column Headers and Their Meanings:
- No of transactions:
Indicates the total number of times the product has been observed across all invoices within the searched date range.
- Qty Purchased:
Represents the cumulative quantity purchased for this product.
- Min of Unit Price:
Displays the lowest price at which the product has been observed.
- Average Unit Price:
Reflects the average price of the product based on all observed prices.
- Max Unit Price:
Denotes the highest price at which the product has been observed.
- Total Value of Purchases:
Represents the total amount spent on this product based on the cumulative purchases.
- First Unit Price:
Displays the price of the product when it was first observed.
- Last Unit Price:
Indicates the price of the product during its most recent observation.
- Price Change from First Price to Average Price Per Unit:
Shows the difference between the First Unit Price and the Average Unit Price.
- Price Change from First Price to Last Price Per Unit:
Represents the difference between the First Unit Price and the Last Unit Price.
- Effect of Price Change from First Price to Average Price:
Illustrates the impact on your spending for this product if the price permanently changed from the First Price to the Average Price. The value can be negative (indicating overspending), positive (indicating savings), or zero (no effect).
- Effect of Price Change from First Price to Last Price:
Highlights the impact on your spending for this product if the price permanently changed from the First Price to the Last Price. The value can be negative (indicating overspending), positive (indicating savings), or zero (no effect).
Refer to the guide Using the Price Watch Macros Report for more information on how to utilise the Price Watch Macros report and combine it with the Price Watch report downloaded from Search & Reporting.
By understanding the meanings of these column headers, you can gain valuable insights into product pricing and its impact on your spending.
