Quick Summary
- Identify pins that achieve early traction by receiving at least two impressions within seven days of creation.
- Calculate the percentage of unique users who have ever interacted with any of these qualifying pins.
- Safely compute the final ratio while handling edge cases like empty datasets or zero denominators.
What This Tests
- Multi-stage data filtering and conditional aggregation
- Separating qualification logic from exposure counting across different time scopes
- Safe numerical rounding and division-by-zero protection
- Set-based user deduplication across joined datasets
Common Patterns
Inner Join
Aggregation
HAVING Filter
Date Arithmetic
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Test Cases
Input
-
Output
-
Expected
-