Enjoy all the articles in the section “All articles”. Here you can read about Google Sheets, Looker Studio, Data Visualization online course, Digital marketing and find template overviews and useful tutorials!
In this article I am going to overview an ecommerce report template created specially for e-commerce based on Google Analytics 4 demo account that you can easily replace with yours. Check out the video overview here: Page 1 That is …
Looker Studio GA4 e-commerce report template overview 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 the process of classifying data into different groups called cohorts. The groups have common traits and are defined by a fixed period. Let’s take a look at what the cohort types are, how cohort analysis works and …
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 »
In the dynamic and competitive landscape of today’s business world, an effective marketing strategy is essential for organizations to thrive. One of the fundamental frameworks that businesses rely on is the marketing mix. Consisting of four key elements—product, price, place, …
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 »
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 »
Imagine sitting in the office, manually inputting all the data, being over-careful because one single mistake may make the report completely inaccurate. Then updating all the information again and again… Does it sound familiar to you? There is a solution …
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 …
0 items in the cart (0 €)