SELECT AVG(trace_info.duration_us / 1000000) AS seconds_on_screen, AVG(trace_info.screen_info.slow_frame_ratio) AS slow_frame_ratio, AVG(trace_info.screen_info.frozen_frame_ratio) AS frozen_frame_ratio, event_name as screen, country FROM `friendly--pix.projectId.firebase_performance.YOUR_PACKAGE_NAME_ANDROID` WHERE _PARTITIONTIME > TIMESTAMP("2019-05-09") AND event_type = "SCREEN_TRACE" AND country = "FR" GROUP BY event_name, country ORDER BY frozen_frame_ratio desc;