【BigQuery】Firebase AnalyticsのDAU, WAU, MAUを取得するクエリ(新スキーマ)BigQueryFirebase SELECT date, SUM(CASE WHEN period = 1 THEN users END) as days_01, SUM(CASE WHEN period = 7 THEN users END) as days_07, SUM(CASE WHEN period = 30 THEN users END) as days_30 FROM ( SELECT dates.date as date, periods.period as period, COUNT(DISTINCT user_pseudo_id) as users FROM `firebase_project_table.app_events_*` CROSS JOIN