Get Weekly Active Days

Get weekly active days distribution based on SIGNIN events.

Migration Note:

• Previously computed in frontend from users.data_tags
• Now calculated in PostgreSQL for consistency and performance
• Matches frontend logic exactly

Week Definition:

• Week starts: Monday 00:00:00 UTC
• Week ends: Sunday 23:59:59 UTC
• Weeks calculated from most recent SIGNIN event

Active Days Calculation:

• For each user per week: count DISTINCT UTC calendar days with at least one SIGNIN
• Only SIGNIN events counted (no WATCH, CREATECHARACTER, etc.)
• Ignore invalid timestamps (timestamp=0 or missing)
• Cap active days at 7

Buckets:

• bucket_1: Users who signed in on 1 distinct day this week
• bucket_2: Users who signed in on 2 distinct days this week
• ...
• bucket_7: Users who signed in on 7 distinct days this week (every day)

Query Parameters:

• num_weeks: Number of weeks to return (1-12), defaults to 4

Returns: Array of weekly bucket distributions: [ { "week_start": "2026-02-10", "week_end": "2026-02-16", "buckets": { "1": 382, "2": 34, "3": 12, "4": 8, "5": 3, "6": 1, "7": 0 } }, ... ]