Explain the logic behind a query you would use to calculate the daily active user (DAU) rate for a specific market on TikTok.
Assume an active user has at least one app_open or video_view event during the day. Calculate the rate for the US market from January 1 through January 5, 2025, using all registered US users as the denominator.
activity_date, daily_active_users, eligible_users, and dau_rate_percent.activity_date ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique TikTok user identifier |
| market | VARCHAR(10) | User market code |
| signup_date | DATE | Date the user registered |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| user_id | INT | User who generated the event |
| event_ts | TIMESTAMP | Timestamp when the event occurred |
| event_type | VARCHAR(30) | Recorded TikTok event type |