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.
🎯 Drill This Card Now➔