Quick Summary
- Calculate the fraction of unique users who confirmed their signup relative to the total number of signups.
- Include users with no texts in the denominator and treat them as unconfirmed.
- Handle multiple text records per user by counting each user only once if they have at least one confirmation.
What This Tests
- Using left joins to maintain the full population of signups while linking to activity logs.
- Conditional aggregation to count distinct entities satisfying a specific condition.
- Managing one-to-many relationships and ensuring correct cardinality in metrics.
- Precision handling for decimal results and rounding requirements.
Common Patterns
Left Join
Aggregation
Deduplication
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Test Cases
Input
-
Output
-
Expected
-