Glean·Data Scientist·Technical Phone Screen
- If a company rehashes all user IDs on a single day T, and your MAU window spans dates both before and after T, how does naively counting distinct user IDs distort the metric?
- What is the maximum possible MAU overestimate as a percentage, and what is the minimum, relative to the true distinct user count over the window?
- How would you redesign the tracking system or warehouse modeling so that MAU stays accurate even when user IDs change like this?
“This took me a second to visualize.”