Looker Studio Bible

How to calculate a break-even ROAS dynamically for your ads in Looker Studio

For every $1 spent on Google Ads, you make $1.25 on revenue, which maybe makes you happy... But if your product has less than 80% margin, you're…

Feb 25

How to make a calculated field using both GA4 event and session data in Looker Studio?

Want to calculate the rate of a GA4 event by sessions, but don't manage to make it work? Makes sense, you can't do it natively in Looker Studio, so…

Feb 23

How to persist freeze column settings across sessions in Looker Studio?

A question from LR12345 today, who wants to keep freezed columns persistent between sessions. Often, you need to find the right place to make the…

Feb 18

How to use Google Sheets & AI to build free connectors for Looker Studio dashboards

Want to build a Looker Studio dashboard, but don't want to pay for connectors? We've got a workaround for you. Not the best, takes time, sometimes…

Feb 11

How to connect LinkedIn Ads to Looker Studio

Want to better understand how your LinkedIn Ads are performing, but the native Business Manager isn't really helping? No worries, we've got you covered!

Feb 4

1

January 2026

How to easily cross filter data sources in Looker Studio (field ID workaround is dead!)

We wrote counteless articles about how to cross filter data sources in Looker Studio, but Google eventually released the killer feature. Thank you…

Jan 28

2

A review of Dataslayer.ai, a Looker Studio connector with an AI touch

Over time, we've talked about lots of connectors, but sometimes you need to get out your confort zone and keep discovering new players in the market…

Jan 21

How to properly track Shopify ROAS and LTV in Looker Studio

Want to calculate your Shopify ROAS and LTV, but not sure how to? No worries, we've got you covered, in this article we show you how to properly do it…

Jan 14

2

December 2025

How to properly compare a metric against its monthly target in Looker Studio?

So you've got a monthly target, and you need to make a quick calculations to know how you're tracking, and this for everyday of the month? No worries…

Dec 18, 2025

3

November 2025

How to add comments to your reports using newly released shapes in Looker Studio?

Want to add comments to your reports but are tired of yet another text box? Well, we'll keep using text boxes... but on top of newly released callout…

Nov 25, 2025

How to color bars in a bar chart using conditional formatting in Looker Studio?

Until very recently, this could be done using a dirty trick involving breakdown dimension and cumulative, but it was very limited. Now, you can do it…

Nov 19, 2025

How to filter data by e-mail in Looker Studio?

Working on sales data, but you don't want everyone in your team to be aware of who's doing what? Looker Studio has a great feature to allow you to do…

Nov 13, 2025

1