Buttons feature in Looker Studio
May 2023 was a prosperous month of innovations in Looker Studio hence now we can see many new features in the tool. One of them is a buttons feature in Looker Studio. Let’s see how can we use it but …
Category: Tutorials
Check out all the tutorials of the blog here! There are various of them about Looker Studio and Google Sheets. Formulas, report creation, tricks & tips – everything is in this section.
How to create a cohort analysis in Google Sheets – part 2
Welcome back to the second part of the tutorial of creating a cohort analysis in Google Sheets. In the previous chapter we’ve seen what kind of data we need to input and started doing the calculations. I’ve filmed a video …
How to create a cohort analysis in Google Sheets – part 2 Read more »
How to create cohort analysis in Google Sheets? Part 1
Cohort analysis is a type of analysis when we split the users by groups and observe the behavior of these groups based on certain characteristics. In this article we will start doing all the settings and calculations for cohort analysis …
How to create cohort analysis in Google Sheets? Part 1 Read more »
Correct ROAS calculation in Google Sheets pivot tables
Do you know that you can (and should!) write custom formulas inside pivot tables in Google Sheets? Calculated fields is, actually, one of my favorite topics, I’ve written a couple of articles about it. By this link you can read …
Correct ROAS calculation in Google Sheets pivot tables Read more »
Looker Studio Calculated Fields. Extracting week from date
When you create a weekly report in Looker Studio you can use the ISO Week field type. But it is super long and often you can’t see the full week’s name. Keep up with the article to see how to …
Looker Studio Calculated Fields. Extracting week from date Read more »
REGEXMATCH multiple criteria in Google Sheets
If you work in the area of data visualization in Looker Studio, for sure you have to work in Google Sheets to prepare your data. Today I would like to share a case with the REGEXMATCH Google Sheets formula. Task …
How to use ARRAYFORMULA in Google Sheets?
Google Sheets is a great tool that I use everyday in my work and as we all know it has plenty of formulas that easen our routine tasks and one of the formulas that I find really interesting and useful …
How to use the VLOOKUP function in Google Sheets?
When working with interrelated data, one of the foremost common challenges is finding data over different sheets. You frequently perform such tasks in everyday life, for example when checking a flight plan board for your flight number to induce the …
How to use the VLOOKUP function in Google Sheets? Read more »
How to convert currency in Google Sheets by a specific date using Googlefinance formula?
Have you ever faced an issue while working in Google Sheets when you need to convert cost or revenue from one currency to another? It is much easier than you may think because Google Sheets has a special function for …
How to convert currency in Google Sheets by a specific date using Googlefinance formula? Read more »
How to customize the navigation menu of your dashboard in Looker Studio
Customizing the navigation menu of your dashboard in Looker Studio can help you better organize your reports and make it easier for users to find the information they need. Here are some steps to help you get started. Here is …
How to customize the navigation menu of your dashboard in Looker Studio Read more »