Skip to content

Instantly share code, notes, and snippets.

@lfy79001

lfy79001/ga003-1.sql

Created April 29, 2024 02:02
Show Gist options
  • Save lfy79001/cae82e06691667559ca225f7f4b55a65 to your computer and use it in GitHub Desktop.
Save lfy79001/cae82e06691667559ca225f7f4b55a65 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ga003-1.sql
SELECT
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'board') AS board_type,
AVG((SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'value')) AS avg_score
FROM `firebase-public-project.analytics_153293282.events_20180915`
WHERE event_name = "level_complete_quickplay"
GROUP BY board_type
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment