Skip to content

Instantly share code, notes, and snippets.

@Nooshu
Created June 18, 2021 08:16
Show Gist options
  • Save Nooshu/6b70737a0397e811ec6285351e6fd31e to your computer and use it in GitHub Desktop.
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.
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