暂无
任务描述
需求描述
需求地址：https://alidocs.dingtalk.com/i/nodes/Gl6Pm2Db8D3kB579t7qDZ0rGJxLq0Ee4?utm_scene=team_space
文档链接：https://alidocs.dingtalk.com/i/nodes/YndMj49yWjPBKdL0crdnwnlbJ3pmz5aA
参考：标签匹配智能策略（定稿） sheet 字段维度，做成可配置的，支持业务自行调整值来更改标签定义
给每个产品打上标签，确保全部的产品都有标签
具体的字段及取值逻辑，可对接智能团队杨宁海或陈楚如，目前线下已经在导表跟进
验收标准
158Create
单元测试
查询销量SQL
SELECT
tasd.asin,
tasd.country_code,
tasd.delivery_type,
sum( tasa.seven_day_sale_num_beijing ) sevenDaySaleNumBeijing,
sum( tasa.fourteen_day_sale_num_beijing ) fourteenDaySaleNumBeijing,
sum( tasa.thirty_day_sale_num_beijing ) thirtyDaySaleNumBeijing,
sum( tasa.sixty_day_sale_num_beijing ) sixtyDaySaleNumBeijing,
sum( tasa.ninety_day_sale_num_beijing ) ninetyDaySaleNumBeijing
FROM
t_amazon_sales_aggregate tasa
LEFT JOIN t_amazon_sales_dim tasd ON tasa.msku = tasd.msku
AND tasa.source_id = tasd.source_id
WHERE
( tasd.asin, tasd.country_code ) IN ( ( 'B0BG52SJ5N', 'US' ) )
GROUP BY
tasd.asin,
tasd.country_code,
tasd.delivery_type