Defining 'active' is where I got a little tangled.
Clarify the metric definition and assumptions, then break down the calculation into numerator (users who made a video call yesterday) and denominator (users active on Messenger yesterday). Discuss how you would obtain these counts from data, considering edge cases like time zones and user overlap.
Pro tip: Show awareness of potential data discrepancies, such as users active on Messenger but not eligible for video calls (e.g., desktop users), and propose how to handle them.
Define what 'active on Messenger' and 'made a video call' mean precisely, including time frame (yesterday in which time zone?) and platform (mobile, desktop, web).
Determine which tables or logs contain user activity and video call events, such as Messenger activity logs and call logs.
Calculate the number of distinct users who made a video call yesterday and the number of distinct users active on Messenger yesterday.
Divide the numerator by the denominator and multiply by 100 to get the percentage.
Check for data quality issues, such as duplicate events, time zone mismatches, and users who are active but cannot make video calls (e.g., on unsupported devices).
AI-generated suggestions, not part of the candidate's original notes. May be inaccurate — verify before relying on them.