如何按规则为用户订阅相关事件分配subscription_id
2026-8-12
用户事件数据添加subscription_id字段处理
原始事件数据表
| user_id | event_name | event_time |
|---|---|---|
| Adam | subscribe | 1 |
| Adam | renewal | 4 |
| Adam | renewal | 5 |
| Adam | irrelevant event name | 6 |
| Adam | churn | 7 |
| Adam | subscribe | 10 |
| Adam | renewal | 20 |
注：event_time实际为毫秒值，此处已简化。
处理后目标数据表
| user | event_name | event_time | subscription_id |
|---|---|---|---|
| Adam | subscribe | 1 | 1 |
| Adam | renewal | 4 | 1 |
| Adam | renewal | 5 | 1 |
| Adam | irrelevant event name | 6 | null |
| Adam | churn | 7 | 1 |
| Adam | subscribe | 10 | 2 |
| Adam | renewal | 20 | 2 |
| Adam | renewal | 30 | 2 |
| Adam | churn | 40 | 2 |
字段赋值规则
- 当
event_name为subscribe时，subscription_id递增1 - 该
subscribe事件之后的renewal、churn事件统一使用当前的subscription_id - 若
event_name为无关事件，subscription_id设为null
内容的提问来源于stack exchange，提问作者ismailenes
相关产品推荐
相关产品推荐
