Kadirhan Gozukoca, Author at Digi Data Lab

The New Era of Digital Marketing: Breaking the Walls Between AI and Data with MCP

In the digital marketing world, we spend half our day jumping between tabs. One moment you’re in GA4‘s complex reports, the next you’re checking Google Ads performance, and then diving into Search Console for SEO insights. But what if all this data flowed directly into your AI model (Claude, ChatGPT, etc.) in real-time? Enter MCP […]

The New Era of Digital Marketing: Breaking the Walls Between AI and Data with MCP Read More »

Deep-Dive User Retention Analysis: Mastering Growth with Adjust & GA4

In the world of mobile growth, there is only one metric that truly determines your app’s survival: Retention. However, not all “active users” are created equal. Counting a user as “retained” just because they accidentally opened your app is a vanity metric that can lead to expensive mistakes. Today, we’re going to build a high-precision

Deep-Dive User Retention Analysis: Mastering Growth with Adjust & GA4 Read More »

SQL Tips: User Segmentation and Analysis w BigQuery

Using GA4 data for user segmentation is crucial to understanding the behaviors of different groups and developing tailored strategies. In this article, I provide an example SQL query for user segmentation and a step-by-step explanation. Query: Session Behavior by City The following query segments users by their city (e.g., Istanbul, Ankara) and returns total session

SQL Tips: User Segmentation and Analysis w BigQuery Read More »

Session Based Funnel Using BigQuery with GA4 Data

Funnel analysis are very important for almost every web site and mobile apps. There are multiple funnel types available. Especially, funnel analysis take up a lot of space in digital marketing environment. You can easily identify areas where users abandon the journey and problems in your purchase flow. Today, We will discuss about the Session

Session Based Funnel Using BigQuery with GA4 Data Read More »

What is Yandex Metrica?

Today, it is extremely important to measure and understand the success of a website that exists on the internet. Monitoring the performance and user behavior of websites provides site owners with important information and helps them make improvements. There are many web analytics tools that arise out of this need. Yandex Metrica is one of

What is Yandex Metrica? Read More »

Query Detecting Duplicate Events in BigQuery for GA4

The Google Analytics 4 (GA4) data type provides comprehensive analytical data for websites and mobile applications. It is possible to use a powerful data storage and querying tool such as Google BigQuery to further analyze and customize this data. In this article, we will describe a query you can use to detect duplicate events in

Query Detecting Duplicate Events in BigQuery for GA4 Read More »

Audience Creation and Integration to Ad Platforms with Google Cloud BigQuery

Google Cloud BigQuery is a cloud-based database service for storing and analyzing large data sets. BigQuery’s powerful analytics capabilities help businesses make data-driven decisions, while being a valuable resource for advertisers. In this article, you’ll learn how to build an audience using Google Cloud BigQuery and integrate it into advertising platforms. Step 1: Data Collection

Audience Creation and Integration to Ad Platforms with Google Cloud BigQuery Read More »

Firebase Remote Config: Dynamically Manage Your App Properties

When developing mobile applications, the ability to quickly change application features and provide users with a customized experience is invaluable. At this point, Firebase Remote Config is a service that allows developers to dynamically manage application properties. In this article, we will explore what Firebase Remote Config is, how it works, and how it can

Firebase Remote Config: Dynamically Manage Your App Properties Read More »

How To Detect Duplicate Transactions with Using BigQuery

Google Analytics 4 (GA4) and Google BigQuery are powerful tools that increase e-commerce sites’ ability to understand and analyze user activity. However, in order to be able to analyze this data correctly, it is very important to maintain data integrity. In this blog post, we will see how to check for duplicate `transaction_id` values in

How To Detect Duplicate Transactions with Using BigQuery Read More »

The Importance of Migrating to GA4: Next-Gen Google Analytics

Google Analytics (GA) has been one of the most trusted tools by website owners for many years. However, as technology and user behavior have evolved, Google has introduced a new platform, Google Analytics 4 (GA4), to adapt to these changes. So, what is the significance of migrating to this new platform? Here are the reasons:

The Importance of Migrating to GA4: Next-Gen Google Analytics Read More »