How To Start Using PySpark On Your BigQuery Data Using Google Dataproc

Google BigQuery is a great big data storage – it is simple, fast, and highly scalable. BigQuery’s SQL allows you to satisfy most of the needs that usually buisness may have – join tables, data transformation, calculations and so on. But sometimes you may need more complicated cases of data transformation when SQL does not Read more about How To Start Using PySpark On Your BigQuery Data Using Google Dataproc[…]

How To Get Google Analytics 4 Property Report to Pandas Dataframe Using API

If your work is even slightly related to online marketing – you probably have heard already about new version of Google Analytics – Google Analytics 4 Property. Everybody are talking about it now because Google Analytics is the most popular web analytics tool, so a lot of businesses worldwide are depend on it. One of Read more about How To Get Google Analytics 4 Property Report to Pandas Dataframe Using API[…]

How To Import Cost Data Into Google Analytics Using API and Python

Google Analytics have different built-in integrations with other Google advertising platforms like Google Ads or Campaign Manager (in case of GA360) in order to import data from those platforms and present more complete reports. But in case of non-Google ad platforms like Facebook Ads – there are no built-in solutions within Google Analytics. It can Read more about How To Import Cost Data Into Google Analytics Using API and Python[…]

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[…]