Predict customer churn using raw data from Yandex Clickhouse

predict-customer-churn-clickhouse-main-min

Google+TwitterFacebookLinkedinThough this post may preeminently interest my Russian-speaking readers using Yandex Clickhouse, I hope it could also be of service to those leveraging BigQuery for daily analytics needs. That is because I’m going to demonstrate all the techniques used in…

Use closures for custom JS variables in Google Tag Manager

use-js-closures-for-custom-js-variables-main (1)

Google+TwitterFacebookLinkedinYou do know what custom JS variables in Google Tag Manager are, don’t you? So I won’t waste neither your nor mine time providing a sprawling explanation for these fundamentals (see my previous post). If you don’t, then, probably, that’s…

Export query results data from Bigquery to Google Sheets

Google+TwitterFacebookLinkedinThis post will contain a simple JS function helping you to export data from Bigquery to Sheets. In fact, we’re going to export a resulting table after querying our GBQ tables. We’re going to need Google Bigquery API and Apps Script….

Encrypt users’ personally identifiable information using Google Tag Manager

encrypt-personally-identifiable-information-using-google-tag-manager-fields-main-min

Google+TwitterFacebookLinkedinIn this post I’ll show how to encrypt personally identifiable information using Google Tag Manager before sending it elsewhere (say, Google Bigquery or Google Sheets). Fairly speaking, you can encrypt any data you like using the solution described. But since web/app…

Plain math to make a forecast for a marketing plan based on Google Analytics data

make-marketing-plans-with-ga-data-and-math

Google+TwitterFacebookLinkedinThis post will demonstrate one of the possible solutions for creating a marketing plan with Google Analytics data using just Google Sheets and plain math. Hopefully, this is what you will get if you take on board the solution (a…

Track users’ interaction with YouTube videos using Google Tag Manager

Google+TwitterFacebookLinkedinYes, it has finally happened. Now we have a special trigger helping us to track YouTube videos in Google Tag Manager. Honestly, I don’t like writing a lot about ready-to-use features. What I love about GTM is that all tools…

Use Google Tag Manager for Yandex.Metrica: hitCallback for reachGoal method

use google tag manager for yandex metrica mainpic

Google+TwitterFacebookLinkedinHere’s a quick tip on how to use Google Tag Manager for Yandex Metrica (Яндекс.Метрика). In this post I’ll show you how to easily register goals (reachGoal method) and/or make use of dataLayer array in order to send e-commerce data…

3 custom variables for working with cookies and Web Storage API in Google Tag Manager

Google+TwitterFacebookLinkedinHere’s a quick tip on how to deal with browser storages (local and session storages) and/or cookies in Google Tag Manager. In this post I will show you three functions helping you to easily create, delete cookies in GTM and…