Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seyhunak/9c9ffd4e6c1f05b94f4084bcd143525f to your computer and use it in GitHub Desktop.
Save seyhunak/9c9ffd4e6c1f05b94f4084bcd143525f to your computer and use it in GitHub Desktop.
[BigQuery + Firebase Performance Monitoring] Find app screens with frozen frames impacting French users
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 `ibam-d6cd2.firebase_performance.iba_mobilbank_IOS`
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment