In this section you can find various articles both theoretical and tutorials about Google Sheets. Tricks & Tips, formula explanations, creating cohort analysis, add-ons overviews and many other useful things about Google Sheets are here!
Continuing reviewing the connectors, I would like to review Power My Analytics Facebook Ads connector that I’ve mentioned in my previous article. I’ve already connected my Google Sheets Account and I’ve already installed the add-on (read the article about it …
Power My Analytics Facebook Ads connector to Google Sheets Read more »
Continuing reviewing different Google Sheets add-ons, today I’d like to tell you about Power My Analytics Google Sheets add-on. I like this Google Sheets data connector and frequently use it in my work. I discovered it a couple of years …
Power My Analytics add-on to Google Sheets overview Read more »
Sometimes it’s better to pull and transform your data from Google Analytics to Google Sheets than to Looker Studio. Especially, if you want to merge the data from Universal Analytics and GA4, you can use add-ons that can help you. In …
Free Google Sheets add-on to pull Google Analytics 4 data Read more »
When talking about Google Sheets extensions, to pull up data from different platforms most likely we’ll need connectors to do it. Recently, I’ve discovered a Windsor.ai connector that I would like to review in this article. Check out the video …
Windsor.ai Google Sheets extension overview and my experience Read more »
Errors in Google Sheets… It happens every time! Breaks the charts in Looker Studio and is simply an eyesore while working with data! Read the article about Google Sheets errors handling! In this article I am going to teach you …
Mastering data in Google Sheets: ERRORS handling with these formula tricks Read more »
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 »
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 »
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 …
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 …
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 »
0 items in the cart (0 €)