Case-When Example on Looker

Let’s say that your company run online operations in 5 countries and that’s why you have 5 different websites. Since the host name is same, all of them is stored in a single GA4 property. In this example, you have websites for Great Britain, South Africa, Australia, Germany and United States. There is “Site Country” variable and values are GB, ZA, AU, DE, US accordingly.

When you try to use Geo Map chart in Looker like the one below, you will see sessions from also other countries. The reason is the difference between geographic location and website country. Let’s give a related example. Assume that I am physically in Spain but I visit www.domain.com/en-gb. Google Analytics will use my IP address and guess that my location is Spain, but actually my site country variable is GB. Therefore we see more than 5 countries below.

However, it is possible to see sessions of only 5 countries. To do that, we are going to use Case-When formula. Click new field, select the data type as country and use the formula below.

Then, we see only sessions of website countries instead of all physicall locations.

Finally, I hope you get the idea of how to use Case-When formulas in Looker Studio. This article was a practical example to show you the usage.