nth-event-tag-builder
Installation
SKILL.md
Nth Event Tag Builder
Computes "which Nth time a user triggered an event" as a SQL tag, then filters by that tag in event analysis / distribution analysis to answer two business questions:
| Scenario | Business question | Ordering | Time policy |
|---|---|---|---|
| Scenario 1: Nth occurrence | Which Nth time (since launch) a user triggered an event — e.g. time-to-reach distribution of 1st/2nd/3rd payment, lifecycle distribution of the 3rd payment | ascending (ORDER BY #event_time ASC) |
static (launch → today) |
| Scenario 2: Recent N | The most recent N occurrences within the last x days — e.g. average score over the last 30 games, win rate over the last N games | descending (ORDER BY #event_time DESC) |
dynamic (last x days) |
Source: Feishu doc《用户第几次触发xx事件》(docx: doxcnIJhFiUgKTqPrmnfc4ycGyh). This skill turns that doc's manual flow into an executable protocol and fills in the gaps the doc omits (view name, ID choice, timezone, entity reuse).
Decision Tree (confirm before acting)
Example inputs that trigger this skill: "第3次付费" (3rd payment), "最近30场场均分" (average score over the last 30 games), "第几次抽卡" (which draw).