Skip to content

Instantly share code, notes, and snippets.

@Nooshu

Nooshu/iphone-versions.txt

Created June 18, 2021 08:16
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Nooshu/6b70737a0397e811ec6285351e6fd31e to your computer and use it in GitHub Desktop.
Save Nooshu/6b70737a0397e811ec6285351e6fd31e to your computer and use it in GitHub Desktop.
Download ZIP
Extracting iPhone versions from GA using DataStudio. Create a new field, use it as the breakdown dimension.
Raw
iphone-versions.txt
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