Blog

We publish courses, articles, tutorials and guides about how-tos in Data Studio / Looker Studio at a very random schedule (aiming at once a week, not all weeks though...).

We do this because we love you and we want you to learn how to tame this marvelous tool. And mostly because according to on-line experts, it's good for SEO and personal branding. I forgot to write Looker Studio Bible again (previously known as Data Studio Bible), so here it is. Enjoy the reading

How to create a static header in Looker Studio?

Tired of not being able to build a static header in Looker Studio? No worries, we've got a solution for you !

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

Need to make incredible things in Looker Studio? Check our always up-to-date list of hacks. You're welcome !

looker studio embed a report on my notion page

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

Want to make an impression? Share your Looker Studio dashboard directy on your website, your Notion page, your wiki, here's how !

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

Want to build your own stocks portfolio tracker using Sheets, Google Finance, Big Query and Looker Studio? In this article we'll show you how !

looker studio url parameter big query connection

How to pass URL parameters in Looker Studio?

Struggling with URL parameters in Looker Studio? Good news, in this article you'll find everything you need to know to make it work !

looker studio google use blended data to filter GA4 referral traffic google sheet

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

Looking for a solution to filter GA4 referral traffic out in Looker Studio? We may have something that will work for you !

looker studio show 2 comparisons at the same time on a scorecard yoy and mom

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

Annoyed that you cannot show at the same time two comparisons on a scorecard in Looker Studio? No worries, we'll show you how to do it here !

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

Can't find the formula again? Same thing happens to us all the time, so we wrote this article to help you split strings using regexp_extract !

looker studio ads performances google ads

Best practices to monitor your ads performances in Looker Studio

Dashboarding is nice, making a good use of it is hard! We gathered for you a list of best practices to monitor your ads performances in Looker Studio, at your disposal !

looker studio how to use dataddo free connector list of sources

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

Looking for a free connector to retrieve data in Looker Studio? Search no more, we've just found the right service for you !

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

It took us time to figure it out, but we finally did it. Check out how we created a control that filters blended data in Looker Studio !

looker studio blended data week month does not work

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

Looker Studio blended data can sometimes be annoying. But no worries, if you want to group by week or month, we've got a solution for you !

looker studio blend facebook ads google ads same table blend

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

Tired of having different tables for Facebook Ads data, Google Ads data, ....? Here, we'll show how to display all metrics in the same table in Looker Studio

How to add a download button in Looker Studio?

Ever wondered if it was possible to add a download button directly into your Looker Studio reports? Yes it is, and that's very easy, check this out!

How to use parameters in Looker Studio?

Parameters can be very powerful in Looker Studio when it comes to querying databases, here's how to use them !

Looker Studio monitor performance lighthouse

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

Monitor your website performances in Looker Studio, act accordingly and improve your SEO ranking !

Looker Studio date range control one datavisualization is set to custom

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

Do you want to offer the best user experience in a Looker Studio dashboard? Consider using several date range control, makes reports look cool !

Looker Studio date toggle drill down year

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

What about having a button that allows you to switch year, month, week instantaneously in Looker Studio? Check this out and build yours!

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

Looker Studio pivot tables are nice, I know, but I believe you shouldn't use them. Here's why.

Looker Studio year to date year over year table with comparison

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

Learn how to do a proper year to date, year over year comparison in Looker Studio by just adding a couple of calculated fields, as easy as that !

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

Learn how to build calculated in Looker Studio so your dataset is not a limitation anymore, and use formulas to make the best use of your data

Looker Studio blend data part 1 join configuration

How to blend data in Looker Studio - part 1?

Learn how to blend data in Looker Studio and display fields from different sources into one single table!

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

Feeling like your Looker Studio dataset doesn't give you exactly what you want? Build your own metrics & dimensions using CASE WHEN!

How to make you reports run faster in Looker Studio?

Tired of waiting minutes if not hours for your Looker Studio dashboards to load? Check our best advices to make them run faster !

How to build a responsive dashboard in Looker Studio?

Nothing's more annoying than having a non responsive Looker Studio dashboard. But no worries, we've got a solution for you!

Looker Studio has encountered a system error

Looker Studio encountered a system error check-list in Looker Studio

Looker Studio is (yet again) giving you an error? I've built this ultimate check-list so you can spot what's going on and apply a solution. You're very welcome!

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

Adding a link to a table in Data Studio / Looker Studio using HYPERKINK is an underrated feature, please use it, I'll show you how!

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

Learn how to filter across several data sources using only one control in Google Looker Studio. One hint, it has to do with field ID...!

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

Add a dynamic title to your pages (but really, it could be any piece of text anywhere in your dashboard) so you reach the 100% automation you've always dreamt of!

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

Split your Analytics conversion by Search Console keywords in Google Looker Studio to optimize your SEO!

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

Facing a very classic issue with Google Looker Studio Year over Year analysis? No worries, we've got the solution for you!

Need help ? We offer Looker Studio Support for companies.

We are experts in the field, and partner with the best connectors in the market (affiliate links)

Power My Analytics, great for Shopify and/or Ads, 14-days free trial, no credit card required, try it!

Catchr.io, powerful alternative for Shopify and/or Ads, again 14-days free trial, no credit card required, try and compare!

Supermetrics, more expensive, way more connectors, more features like blending (and again again 14-days no card...), if your business is big, give it a go!