Created
June 18, 2021 08:16
-
-
Save Nooshu/6b70737a0397e811ec6285351e6fd31e to your computer and use it in GitHub Desktop.
Extracting iPhone versions from GA using DataStudio. Create a new field, use it as the breakdown dimension.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CASE | |
| when Screen Resolution IN ("320x480") THEN "iPhone 1-4" | |
| when Screen Resolution IN ("320x568") THEN "iPhone 5, SE, 5C, 5S" | |
| when Screen Resolution IN ("375x667") THEN "iPhone 6, 6S, 7, 8, SE 2020" | |
| when Screen Resolution IN ("414x736") THEN "iPhone 6+, 6S+, 7+, 8+" | |
| when Screen Resolution IN ("375x812") THEN "iPhone X, XS, 11 Pro" | |
| when Screen Resolution IN ("414x896") THEN "iPhone 11, XR, XS Max, 11 Pro Max" | |
| when Screen Resolution IN ("390x844") THEN "iPhone 12, 12 Pro" | |
| when Screen Resolution IN ("360x780") THEN "iPhone 12 Mini" | |
| when Screen Resolution IN ("428x926") THEN "iPhone 12 Pro Max" | |
| when Screen Resolution IN ("320x693") THEN "iPhone X, XS, 11, 11 Pro, 12 mini, 12, 12 Pro (in zoomed mode)" | |
| ELSE "Unknown" | |
| END |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment