Metrics Design Glossary

数据看板指标设计与定义说明

Version 1.0
1

Current Price (聚合价格)

EN: The aggregated price of a product for a specific time period. To eliminate the impact of temporary pricing errors or extreme flash sales, the system calculates the Median of all observed prices within the selected time granularity.

ZH: 特定时间周期内产品的聚合价格。为了剔除临时标价错误或极端秒杀活动的影响,系统采用所选时间颗粒度内所有观察价格的中位数(Median)进行计算。

2

Time Granularity (时间颗粒度)

EN: The roll-up frequency for the data.
• Daily: Raw median price computed per day.
• Weekly: Aggregated median from Monday to Sunday. Plotted using Monday's date.
• Monthly: Aggregated median for the entire calendar month. Plotted using the Year-Month format.

ZH: 数据向上聚合的频率。
• 日 (Daily): 每日价格中位数。
• 周 (Weekly): 周一至周日的聚合中位数,以该周周一的日期作为展示标签。
• 月 (Monthly): 自然月的聚合中位数,以年月(YYYY-MM)作为展示标签。

3

Alert Threshold & Trend (价格预警与涨跌幅)

EN: Compares the aggregated price of the latest available period with the previous period. Formula: (Price_latest - Price_previous) / Price_previous. An alert card is generated dynamically if the absolute percentage change equals or exceeds the user-defined threshold (e.g., ±15%).

ZH: 对比最新周期与上一周期的数据。计算公式:(最新周期价格 - 上一周期价格) / 上一周期价格。如果绝对变化百分比大于或等于用户设定的阈值(如 ±15%),则动态生成预警卡片。

4

Bundled Products (捆绑商品判定)

EN: Identifies if a product listing is sold as part of a promotional bundle (e.g., Watch + Earbuds) based on the Is_Bundled flag. These items are tracked independently in the registry table to prevent skewing standalone product pricing.

ZH: 基于 Is_Bundled 字段,标识该商品是否作为促销套装(如 手表+耳机)的一部分出售。此类商品会在底部清单表中独立追踪记录,以防止拉偏该商品的独立常规售价。

← Back to Dashboard