Regular Expressions (RegEx) in Google Data Studio – Guide With Examples

Regular expressions are great helpers for every data analyst because they allows to transform dimensions applying quite complicated logic rules. In Google Data Studio I often use REGEXP text functions – so I decided to share with you some my most often use cases. In addition – we’ll find out the difference between REGEXP_REPLACE, REGEXP_EXTRACT Read more about Regular Expressions (RegEx) in Google Data Studio – Guide With Examples[…]

Markov Chain Attribution – Simple Explanation Of Removal Effect

“Markov Chain Attribution” is one of the most popular data driven attribution models. The most important concept behind this model is removal effect. In this article I`ll try to explain the math behind removal effect in a simple way without any formulas. As an example we will take a very simple use case – four Read more about Markov Chain Attribution – Simple Explanation Of Removal Effect[…]

5 Google Spreadsheet Formulas Which Every Web-Analyst Should Know

Google Spreadsheet formulas is a powerful tool which can make your life much more easier if you are working with data a lot. There are a lot of interesting extensions that can be very useful for a online marketeer, like Google Ads extension or Google Analytics extension for Google Spreadsheets, but output data which you`ll Read more about 5 Google Spreadsheet Formulas Which Every Web-Analyst Should Know[…]