WHERE key = "duration_date" ) AS duration_date FROM `fa_events` ) SELECT duration_date, SUM(*) / SUM(DISTINCT user_id) AS average_count FROM `fa_events_with_duration_date` WHERE date = “2025/9/23” AND event_name = “view” AND platform = “app” GROUP BY duration_date インストールからの経過日数を user_propertyに入れているので どのFAイベントからも取得できる https://firebase.google.com/docs/analytics/user-properties