Cohort analysis in Looker Studio: how to track user retention over time

If you’ve ever wanted to go beyond simple metrics and really understand how user behaviour evolves over time, cohort analysis might be just what you’re looking for. In this post, we’ll explore how to set up cohort analysis in Looker Studio, from preparing your data to creating visualisations that highlight retention patterns and user engagement … Read more

How to use CASE statements in Looker Studio for smarter data segmentation

When building insightful reports in Looker Studio, one of the most powerful tools at your disposal is the humble CASE statement. Whether you’re categorising users, grouping campaign sources, or splitting branded and non-branded search traffic, CASE statements let you add logic-driven fields that bring clarity and nuance to your data. Let’s walk through what they … Read more

How to apply conditional formatting to your charts in Looker Studio

You can add conditional formatting to your charts in Looker Studio, so they display a specific style when certain conditions are met. Within a chart’s Style, you can add rules to apply conditional formatting. By clicking on Add Rule, a window will appear where you can input the conditional formatting and its conditions. In the … Read more