How to group blended data by week or month in Looker Studio?

Looker Studio / Data Studio can be really exasperating sometimes. In particular when it comes to blended data. Until their tech teams decide to apply a fix to this very common issue, we'll review in this article how to group blended data by week or month in Looker Studio. Hope it helps!


Need help ? We offer Looker Studio Support for companies.

Looking for a connector ? Check Supermetrics.


Currently, grouping dates in blended data tables by week or month does not work

In this example, we'll be using a sample Google Ads data source blended on itself.

The important thing to consider here is that as a dimension in Table 1, we're using the date (called Day in Google Ads, which can be confusing).

Now, what happens if we create a simple table, use this date as a dimension, and group by month. Well, it just doesn't group:

looker studio blended data week month does not work

Data remains at the date level, and the month (here, April 2023) gets repeated on every single line. Same will apply to line charts, bar charts, ...


How can this be fixed? Well, we'll have to pre-aggregate in the Blended data directly.


Aggregating by week or month directly in the blended data

Please Edit your blended data, remove the date dimension, click Add dimension, and create a new one with the level of granularity you're looking for. In our case, we'll go for month, but same would apply to week, for instance writing something like:

  • MONTH(Day)
looker studio blended data week month create calculated field

And that's it, your data is now aggregated as you wanted it to!

Obviously, if you want to keep the year in as well, you might want to use the DATETIME_TRUNC() function instead. In our case, something along the line of:

  • DATETIME_TRUNC(Day,MONTH)


And you'll get year / month level. Sharp.

In this article, we've reviewed how to use a calculated field to group blended data by week or month in Looker Studio.

PROBLEM SOLVED !


Previous article: How to display Facebook Ads and Google Ads metrics in the same table in Looker Studio?

Next article: How to build a control that filters blended data in Looker Studio?

Looking for something else? All our articles can be found on our blog page