M5-011Medium漏斗与留存 · Funnels & retention
如何找出“首次购买”的用户,并统计新客占比?
How do you identify each user's first purchase and compute the new-buyer share?
💡 考场高分一句话答案:
按用户取 MIN(购买时间) 作为首购时间,与当期比较判断是否新客;用 COUNTIF 算占比。
Take MIN(purchase time) per user as the first purchase, compare it with the period to classify new buyers, and COUNTIF for the share.
📌 核心考察要点 (Key Points)
- 首购定义:该用户历史上第一次 purchase 事件的时间
- 新客判定:首购时间落在统计期内
- 陷阱:如果数据只有近 90 天,首购可能发生在窗口之前(左删失),会高估新客
- 处理:加“用户注册时间在窗口内”或延长回溯窗口
- Definition: the earliest purchase event in the user's history
- New buyer: the first purchase falls inside the reporting period
- Trap: with only 90 days of data the first purchase may predate the window (left censoring), overstating new buyers
- Fix: restrict to users registered inside the window, or extend the lookback
🔍 大厂面试官连环追问 (Follow-ups)
- 如何避免左删失导致的新客高估?
- 如何计算复购率?
嫌字多看太累?进入苏格拉底式对话推演实验室
零打字负担,以大厂考官真实困境切入,通过点选直觉选项暴露思维盲区,手把手推导 Why。
⚡
Test muscle memory on this topic via 3-Layer Flashcards
Active Recall: Mentally formulate Prompt ➔ Math Derivation ➔ Benchmark Implementation in 3 minutes.