All our Looker Studio hacks, in one place for easy access

We've been writing articles about Looker Studio for almost a year now, with no real plan nor strategy, just write, write, write. So it's time to put some order. Please find below all our Looker Studio hacks, in one place for easy access, and classified by category.

We'll keep it up-to-date, so remember to bookmark this page for later consultation (way better than our blog page to be honest, which lists articles by publishing dates...).

Dates

How to make a same day last year comparison in Looker Studio?

How to do a year to date, year over year comparison in Looker Studio?

How to build a date toggle to easily change date format (year, month, week) in Looker Studio?

How to use several date range controls on a same page in Looker Studio?

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


Controls & functionalities

How to build a control that filters across several data sources in Looker Studio?

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

How to add a download button in Looker Studio?

How to send a weekly report by email in Looker Studio?


Functions & formulas

How to add a link in a table using the HYPERLINK function in Looker Studio?

How to build a field using a CASE WHEN statement in Looker Studio?

How to build calculated fields in Looker Studio and what are the most useful formulas?

How to split a string that has comma or pipe delimiters using REGEXP_EXTRACT in Looker Studio?

How to replicate SUMIF, AVERAGEIF and COUNTIF functions in Looker Studio?


Data source & parameters

How to blend data in Looker Studio - part 1?

How to use parameters in Looker Studio?

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

How to pass URL parameters in Looker Studio?


Design

How to add a dynamic title (or any dynamic text) in Looker Studio?

How to build a responsive dashboard in Looker Studio?

Why you shouldn't use Pivot Tables in Looker Studio? (and what to replace them with)

How to show two comparisons at the same time on a scorecard in Looker Studio?

How to make the best of publishing and versioning in Looker Studio?

How to build good looking gauges in Looker Studio?

How to embed a Looker Studio dashboard on your website, a Notion page, a wiki page, anywhere...?

How to create a static header in Looker Studio?


Performances

Looker Studio encountered a system error check-list

How to make your reports run faster in Looker Studio?

Best practices to monitor your ads performances in Looker Studio

How to set-up Extract Data to make your dashboards faster in Looker Studio?


GA4 & Search Console

How to split Analytics conversion by Search Console keywords in Looker Studio?

How to use blended data to filter GA4 referral traffic in Looker Studio?

How to mix GA4 metrics and dimensions in Looker Studio? (Danger Zone!)


Third-party softwares

How to monitor website performances in Looker Studio with foo.software?

How to use Dataddo, the third-party app that offers free connectors for Looker Studio?

How to build a stocks portfolio tracker in Looker Studio using Google Sheets, Google Finance and Google Big Query?

How to build an advertising spends tracking tool in Looker Studio?

looker studio hacks