Hey Reader! I've been building a Looker Data Studio dashboard for a client where we need to combine different pieces of data that are about the same location, but the location name is saved in two different custom dimensions or sometimes under neither, in which case I have to infer it from the page path (which itself is a giant CASE function). On top of that, BigQuery isn't an option for this data, so everything has to come straight from the GA4 connector. Here's what I ended up with: Ew. Is...