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。

💬 开启对话式破冰 ➔
⚡
想检验本题的肌肉记忆?进入 3 阶闪卡主动回忆盲测
隐藏答案遮罩,自测:审题锚点 ➔ 数理公式机理 ➔ 工业标杆代码与连环追问。3 分钟攻破认知盲区!
🎯 立即在闪卡中盲测此题➔