Noticeable calls
- https://copilot.clari.com/call/11644b50-8a66-4c36-a91b-e0ed635d3211
Metric Catalogue
- Base measures
- Recommended Retail Price (or RRP; synonym - Manufacturer Suggested Retail Price, MSRP): The price suggested by the manufacturer for retailers to sell a product.
- Total SKUs (or Total Products): Count of SKUs.
- Total Features (or Total Ad Items): Count of Features.
- Retailer Price (or Selling Price): The retailer’s non-promotional shelf price for a product (within that retailer).
- Promotional Price: The temporary, reduced price offered by a retailer for a product in a promotion.
- Metrics (are built from measures)
- Current Price: If promo applied,
current_price = promotional_price, elsecurrent_price = rrp- Current Price must track the Shelf Price because in mature retail markets (like Australia/UK/US), the “Standard Shelf Price” is often lower than RRP. If you default to RRP when no promo exists, you will artificially inflate the “Was Price,” making discounts look deeper than they are. The
current_priceshould always track the Shelf Price, not the RRP, unless they happen to be identical.
- Current Price must track the Shelf Price because in mature retail markets (like Australia/UK/US), the “Standard Shelf Price” is often lower than RRP. If you default to RRP when no promo exists, you will artificially inflate the “Was Price,” making discounts look deeper than they are. The
- Was Price:
retailer_price - Discount Percentage: Logic:
1 - (current_price / NULLIF(was_price, 0)) - Discount Amount:
was_price - current_price - Retailer Lowest Price: The lowest single price point detected for a Retailer within the specific Start Date and End Date of the selected Advertisement. Logic:
MIN(current_price) - Average Discount Percentage: Logic:
AVG(discount_pct) - Average RRP:
AVG(rrp) - Average Promotional Price:
AVG(promotional_price)
- Current Price: If promo applied,
- Base measures