In this post, I will go through how to set up a simple event stream from server-side Tag Manager directly to BigQuery. The idea is to keep the setup as simple as possible. That way, it’s suitable for different kinds of experimentation and debugging needs. Post updates Things to consider when sending data to BigQuery […]
Send events from Server-side Tag Manager to BigQuery Read More »
Server-side Tag Manager is essentially a proxy between the user’s device and the vendor or endpoint used to collect data. With server-side GTM in place, you have full control over anything sent forward from the server. For example, personal data such as IP addresses are not forwarded to the vendors unless you specifically choose to
IP Exclusion Filtering in Server-side Tag Manager Read More »
One of the significant improvements in GA4 over the old Universal Analytics is its event-based data model and the free data export to BigQuery. This article is a collection of some of the most common SQL formulas, plus a few extras, needed when working with the GA4 event data in BigQuery.
BigQuery SQL Cheat Sheet for GA4 Read More »
Unlike some other Google tools, Search Console lacks the free BigQuery data export. In this article I’ll guide you through in how to set up you own BigQuery export using Node.js and Google Cloud Functions.
Export Google Search Console data to BigQuery using Cloud Functions Read More »