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)进行计算。
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)作为展示标签。
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%),则动态生成预警卡片。
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 字段,标识该商品是否作为促销套装(如 手表+耳机)的一部分出售。此类商品会在底部清单表中独立追踪记录,以防止拉偏该商品的独立常规售价。