Meta's Product Growth team is analyzing activation in Messenger Calling as part of the AARRR funnel. Calculate the percentage of eligible callers who completed both voice and video calls during January 2025.
Write a PostgreSQL query that treats each caller as one unit. Do not count call events directly, and exclude calls from other Meta surfaces, failed calls, calls outside the period, and events with an unknown call type.
2025-01-01 through 2025-01-31.| Column | Type | Description |
|---|---|---|
| user_idPK | BIGINT | Meta user identifier |
| user_name | VARCHAR(100) | Illustrative user label |
| Column | Type | Description |
|---|---|---|
| call_event_idPK | BIGINT | Call event identifier |
| caller_id | BIGINT | User who initiated the call |
| product_surface | VARCHAR(50) | Meta product surface where the call occurred |
| call_type | VARCHAR(20) | Voice or video call format |
| call_status | VARCHAR(20) | Call lifecycle status |
| event_date | DATE | Date of the call event |