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[…]
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[…]
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 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” 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[…]
CASE statements allow you to create new dimensions in Google Data Studio based on existing ones. Syntax of CASE statement is pretty intuitively and reminds SQL a lot: In order to create a new calculated field – open your Data Studio report, and click “Create new field”: Give your new dimension a name, write your Read more about CASE Statements In Google Data Studio[…]
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[…]
Sometimes, while configuring tags in Google Tag Manager, we want to know if the user visiting our site for the first time or not. Variable like that can be very useful if we want to fire some of our tags only for new or returning users, or assign different conversion value of the same conversion Read more about New vs Returning Client-ID Variable In Google Tag Manager[…]
Vanity URL – is a short version of your site domain, that is easy to remember and enter in the browser. This picture from newspaper should explain you pretty well why publishing of usual links in your offline advertise is not a good idea. Let`s imagine I`m promoting my app – SKAGs Table Creator, which is Read more about Offline Campaigns Measuring With “Vanity URL”[…]
As you might know, people often doesn`t buy anything just after they have seen an advertisement. How many people you know, that have bought a car just after they`ve seen for the first time a banner (even very attractive), with that car? Yes, some cheap products can be bought impulsively, but before buying any kind Read more about Multi-Channel Analysis In Google Analytics[…]
Data sets in Google Analytics are allow to import external data into your account. An example of such data could be your costs, spend on SEO or Facebook campaign. Keeping all data in one analytical system allows for comprehensive analysis of all your advertising channels. So, that`s how to create a Data Set in Google Read more about How To Create A Data Set in Google Analytics[…]
AdWords editor lets you to import data for your campaign from other sources in table-like format. You can prepare that table in Microsoft Excel, Google Spreadsheets or any other similar tool. Preparing data for your campaign in that way will save your time and nerves. You can prepare table with data for your AdWirds Search Campaign Read more about How To Import Data To AdWords Editor[…]